dbtest5.java

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

import java.sql.*;
public class DbTest5
{public static void main(String args[])
   {Connection conn = null;
   Statement stmt = null;
   boolean defaultCommit = false;
   String strSQL1 = "INSERT INTO grade(学号) VALUES(9001)";
   String strSQL2 = "UPDATE grade SET 姓名='张三' WHERE 学号=9001";
   try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
   catch(ClassNotFoundException ce){
	 System.out.println(ce.getMessage());
    }
   try {
	conn = DriverManager.getConnection("jdbc:odbc:grade");
	defaultCommit = conn.getAutoCommit();
	conn.setAutoCommit(false);
	stmt = conn.createStatement();
	stmt.executeUpdate(strSQL1);
	stmt.executeUpdate(strSQL2);
	conn.commit();
	conn.setAutoCommit(defaultCommit);
	if (stmt != null) {
		stmt.close();
	   }
	if (conn != null) {
		conn.close();
	  }
   }
   catch (Exception e) {e.printStackTrace();}
  }
}