example10_2.java

书中的例题

import java.sql.*;
public class Example10_2
{  
  public static void main(String[ ] args)
   {
    String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
    String conURL="jdbc:odbc:TestDB";
    try {
      Class.forName(JDriver);
    }
   catch(java.lang.ClassNotFoundException e) {
      System.out.println("ForName :" + e.getMessage( ));
    }
   try {
      Connection con=DriverManager.getConnection(conURL);
      Statement s=con.createStatement( );      
      String r1="insert into student values(" + " '0001','王明',80) ";
      String r2="insert into student values(" + " '0002','高强',94) ";
      String r3="insert into student values(" + " '0003','李莉',82) ";
      //使用SQL 命令insert插入三条学生记录到表中
      s.executeUpdate(r1);
      s.executeUpdate(r2);
      s.executeUpdate(r3);
      s.close( );
      con.close( );
    }
   catch(SQLException e) 
    {
      System.out.println("SQLException: " +e.getMessage( ));
    }
  }
}