Java教材_LESSON 10 - Database.pptVIP

Sample code import java.sql.*; /** * @author Wu Di * */ public class DeleteTester { public static void main(String[] args) throws Exception { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection connection = DriverManager.getConnection(jdbc:odbc:employee); Statement statement = connection.createStatement(); statement.execute(DELETE FROM Employees WHERE name=吴砥); statement.close(); connection.close(); }//main() }/* DeleteTester */ Update statement.execute(sql) statement.executeUpdate(sql) Sample code import java.sql.*; /** * @author Wu Di * */ public class UpdateTester { public static void main(String[] args) throws Exception { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); Connection connection = DriverManager.getConnection(jdbc:odbc:employee); Statement statement = connection.createStatement(); statement.execute(UPDATE Employees SET email=javaclass@ WHERE name=吴砥); statement.close(); connection.close(); }//main() }/* UpdateTester */ * 华中科技大学 智能互联网技术湖北省重点实验室 网络教育技术研究室 /ELWG Java Programming Language / Wu Di / 2005 * 华中科技大学 智能互联网技术湖北省重点实验室 网络教育技术研究室 /ELWG 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 3 Codd’s twelve rules: 9. Batch and