Java课件_LESSON 10 - Database.ppt

LESSON 10: Database 吴砥 wudi@ Department of Electronics Information Engineering, Huazhong University of Science Technology, Wuhan, P.R.C. The eight core packages of Java java.awt java.awt.event java.io java.sql java.util java.lang java.applet Outline Relational database SQL The package java.sql JDBC-ODBC bridge JDBC Data type conversion Summary Relational Database RDBMS Relational Database Management Systems (RDBMSs), such as SQL Server and Oracle, are the primary engines of information systems worldwide, particularly Internet/Intranet applications and distributed client/server computing systems. An RDBMS is defined as a system whose users view data as a collection of tables related to each other through common data values. Principles of RDBMS 1 Codd’s twelve rules: 1. Information is represented logically in tables. 2. Data must be logically accessible by table, primary key, and column. 3. Null values must be uniformly treated as “missing information,” not as empty strings, blanks, or zeros. 4. Metadata (data about the database) must be stored in the database just as regular data is. Principles of RDBMS 2 Codd’s twelve rules: 5. A single language must be able to define data, views, integrity constraints, authorization, transactions, and data manipulation. 6. Views must show the updates of their base tables and vice versa. 7. A single operation must be able to retrieve, insert, update, or delete data. 8. Batch and end-user operations are logically separate from physical storage and access methods. Principles of RDBMS 3 Codd’s twelve rules: 9. Batch and end-user operations can change the database schema without having to recreate it or the applications built upon it. 10. Integrity constraints must be available and stored in the RDB metadata, not in an application program. 11. The data manipulation language of the relational system should not care where or how the physical data is distributed and should not require alteration if the physical data is centralized