第15讲 Java数据库连接技术JDBC详解.ppt

* import java.sql.*; class Insert { public static void main(String args[]) { try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); } catch (ClassNotFoundException ce) { System.out.println(SQLException:+ce.getMessage()); } try { Connection con = DriverManager.getConnection(jdbc:odbc:mydb,li,1234); Statement stmt = con.createStatement(); String sqlstr = insert into mytable values(2001, 邢雪花,女,650); stmt.executeUpdate(sqlstr); stmt.executeUpdate(insert into mytable values(2020,翟建设,男,746)); stmt.close(); con.close(); } catch (SQLException e) { System.out.println(SQLException:+e.getMessage()); } } } * import java.sql.*; class Delete { public static void main(String args[]) { try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); } catch (ClassNotFoundException ce) { System.out.println(SQLException:+ce.getMessage()); } try { Connection con = DriverManager.getConnection(jdbc:odbc:mydb,li,1234); Statement stmt = con.createStatement(); String sql = delete from mytable where name=王五; stmt.executeUpdate(sql); stmt.close(); con.close(); } catch (SQLException e) { System.out.println(SQLException:+e.getMessage()); } } } * import java.sql.*; class Create { public static void main(String args[]) { try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); } catch (ClassNotFoundException ce) { System.out.println(SQLException:+ce.getMessage()); } try { Connection con = DriverManager.getConnection(jdbc:odbc:mydb,li,1234); Statement stmt = con.createStatement(); String sql= create table student (s_num char(4), s_name char(6) null, score int); stmt.executeUpdate(sql); sql = insert in