dbtest3.java

来自「这是一张java应用教程的随书光盘」· Java 代码 · 共 28 行

import java.sql.*;
public class DbTest3
{public static void main(String args[])
  { Connection conn = null;
    PreparedStatement pst = null; 
        try{
	   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       }
    catch(ClassNotFoundException ce){
	  System.out.println(ce.getMessage());
      }
    try{
	   conn = DriverManager.getConnection("jdbc:odbc:grade");
	   pst = conn.prepareStatement("INSERT INTO grade(学号) VALUES (?)");
	   for (int i = 101; i < 103; i++) {
		 pst.setInt(1, i);
		 pst.addBatch();
        }
     pst.executeBatch();
     pst.close();
	 conn.close();
     }
catch(SQLException e){
	System.out.println(e.getMessage());
     }
   }
}