WORKING WITH DATABASE AND SECURITY IN JAVA
GIỚI THIỆU
At the end of this course, students will be able to:
- Explain JDBC.
- Explain the architecture of JDBC.
- Describe the different JDBC drivers.
- List the steps to create a JDBC application.
- Explain the loading of the JDBC-ODBC bridge driver and establishing connection
- Explain the methods and possible exceptions that may occur while creating and executing SQL queries.
- Explain the purpose of this step, methods to display the record and close the database connection.
- State the syntax of connecting to a database using Type 4 driver.
- Describe parameterized queries and state the syntax of creating parameterized queries.
- Describe database metadata.
- Explain DatabaseMetaData interface and its methods.
- Explain ResultSetMetaData interface and its methods.
- Describe stored procedures and its benefits.
- Explain a stored procedure using Statement.
- Explain a stored procedure using CallableStatement.
- Describe scrollable resultsets.
- List ResultSet constant values.
- Describe Updatable ResultSet.
- State the various methods of creating an Updatable ResultSet.
- Describe Batch Update and list its benefits.
- Explain the steps of implementing batch updates using Statement interface.
- Describe how to implement batch updates using PreparedStatement Interface.
- Describe how to implement batch updates using CallableStatement Interface.
- Describe transactions and state its need.
- Explain the steps of implementing transactions using JDBC.
- Describe RowSet.
- List the benefits of RowSet.
- Describe the types of RowSet. (JDBCRowSet and CachedRowSet)
- Describe JDBCRowSet object.
- Explain how to use JDBCRowSet instance to insert, update, delete and retrieve records.
- Describe CachedRowSet.
- Explain how to use CachedRowSet instance to insert, update, delete and retrieve records.
- Describe the concept of security.
- Describe the goals of Java Security.
- Explain how Java security model helps to achieve the goal.
- Describe the security restrictions on applets.
- Describe the use of policy file to grant permissions to applets.
- Explain the effects of policy file on security restrictions.
- Explain why applications do not have security restrictions.
- xplain how to impose security restrictions on applications.
- Describe the use of policy file to grant permissions to an application.
- Explain the behavior of application after applying policies.
- Describe authentication.
- Describe authorization.
- Describe JAAS.
- Explain how to implement authentication and
- Authorization using java Security API.
- Describe cryptography.
- Explain Cipher class.
- Explain the steps to encrypt data.
- Explain PBEKeySpec class.
- Explain PBEParameterSpec class.
- Explain SecretKeyFactory class.
- Explain how to encrypt data using password.
- Describe digital signature and state its need.
- Explain the working of digital signature.
- Describe the drawbacks of digital signature.
- Explain how digital certificates enable the receiver to verify the authenticity of sender.
- Describe digital keys.
- Explain how to sign a jar file and the steps involved in it.
- Explain how to verify digital certificate and the steps involved in it.
- Explain the steps involved in generating public and private keys.
- Explain the steps involved in signing data using Signature class.
- Explain how to save signature and public key.
- Explain how to construct public key, construct the signature and then verify the signature.
THỜI GIAN
18 giờ (Lý thuyết + Thực hành)
NỘI DUNG
| STT |
Nội dung |
| 1 |
JDBC |
| 2 |
RowSets |
| 3 |
Java Security |
| 4 |
Cryptography |
| 5 |
Digital Signatures |
TÀI LIỆU
Lý thuyết :
Thực hành :
PHẦN MỀM
Mọi thắc mắc, vui lòng liên hệ: haianh_neu@yahoo.com
