WORKING WITH DATABASE AND SECURITY IN JAVA
Ấn vào đây để xem thông tin các khóa học khác 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 :
Assignment 1 Assignment 2 StudentManagement có giao diện như sau:
Assignment 3 Assignment 4 Đề bài tập thực hành có lời giải (DBSJ lab exercises & source code): Sẽ cung cấp trong giờ Lab 1
Bài kiểm tra (Assignment 1, 2, 3)
PHẦN MỀM
Mọi thắc mắc, vui lòng liên hệ: haianh_neu@yahoo.com
