dbtest8.java

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

import java.sql.*;
public class DbTest8
{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 (?,?,?)");
	pst.setInt(1,1001);
	pst.setString(2,"王非");
	pst.setInt(3,88);	
    pst.executeUpdate();
    pst.close();
	conn.close();
    }
catch(SQLException e){
	System.out.println(e.getMessage());
     }
   }
}