JDBC－Java数据库编程接口12.1JDBC概述12.1JDBC概述JDBC驱动程序类型JDBC驱动程序类型JDBC的工作过程数据库连接JDBC功能结构图JDBCAPI(类）12.2JDBC开发一般步骤12.2JDBC开发一般步骤12.2JDBC开发一般步骤12.2JDBC开发一般步骤12.2JDBC开发一般步骤12.2JDBC开发一般步骤12.3JDBC开发实例1．查询数据库（续）2．插入记录2．插入记录（续）3．修改记录try{Connectioncon=DriverManager.getConnection("jdbc:odbc:myDB","li","1234");Statementstmt=con.createStatement();Stringsql="updateemployeesetno='3000'"+"wherename='翟建设'";stmt.executeUpdate(sql);sql="updateemployeesetsalary=900"+"whereno=‘2001'";stmt.executeUpdate(sql);stmt.close();con.close();}catch(SQLExceptione){System.out.println("SQLException:"+e.getMessage());}}}4.删除记录4.删除记录（续）5.建立表5.建立表（续）6.删除表try{Connectioncon=DriverManager.getConnection("jdbc:odbc:myDB","li","1234");Statementstmt=con.createStatement();Stringsql="droptablestudent";stmt.executeUpdate(sql);stmt.close();con.close();}catch(SQLExceptione){System.out.println("SQLException:1"+e.getMessage());}}}7．取表中各列名称try{Connectioncon=DriverManager.getConnection("jdbc:odbc:myDB","li","1234");Statementstmt=con.createStatement();Stringsqlstr="SELECT*FROMstudent";ResultSetrs=stmt.executeQuery(sqlstr);ResultSetMetaDatarsmd=rs.getMetaData();for(inti=1;i<=rsmd.getColumnCount();i++){if(i==1)System.out.print(rsmd.getColumnName(i));elseSystem.out.print(","+rsmd.getColumnName(i));}rs.close();stmt.close();con.close();}catch(SQLExceptione){System.out.println("SQLException:1"+e.getMessage());}}}12.4JDBC中的主要接口和类1.DriverManager类2.Connection接口2.Connection接口（续）3.Statement接口3.Statement接口4.PreparedStatement接口5.CallableStatement接口5.CallableStatement接口（续）5.CallableStatement接口（续）CallableStatementcallStmt=conn.prepareCall("{callQuery_Student(?,?,?)}”);callStmt.setString(1,"20001");//设置传入的第一个输入参数(?)值是20001callStmt.registerOutParameter(2,java.sql.Types.VARCHAR)callStmt.registerOutParameter(3,java.sql.Types.VARCHAR);callStmt.execute();Stringb1=callStmt.getString(2);Stringb2=callStmt.getString(3);System.out.println(b1);System.out.println(b2);callStmt.close();conn.close()