jdbc.java

这是java 2应用开发指南这本书上所有例子的源代码

import java.sql.*;
public class jdbc{
  public static void main(String args[]) throws SQLException{
    ResultSet rs = null;
    PreparedStatement ps = null;
    String url = "jdbc:odbc:student";
    Connection con;
    Statement stmt;
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(java.lang.ClassNotFoundException e) {
      System.err.print("ClassNotFoundException: ");
      System.err.println(e.getMessage());
    }
    con = DriverManager.getConnection(url,"Login", "myPassword");
    con.setAutoCommit(false);
    stmt = con.createStatement();
    rs = stmt.executeQuery("SELECT * FROM table1");
    System.out.println("Table before insertion:");
    while (rs.next()){
      String number = rs.getString("Number");
      String name = rs.getString("Name");
      String addr = rs.getString("Address");
      System.out.println(number + "   " + name + "   " + addr);
    }
    stmt.addBatch("INSERT INTO table1 " +"VALUES('10006', '李天梅','国防科技大学')");
    int [] updateCounts = stmt.executeBatch();
    con.commit();
    con.setAutoCommit(true);
    rs = stmt.executeQuery("SELECT * FROM table1");
    System.out.println("Table  after insertion:");
    while (rs.next()){
      String number = rs.getString("Number");
      String name = rs.getString("Name");
      String addr = rs.getString("Address");
      System.out.println(number + "   " + name + "   " + addr);
    }
    rs.close();
    stmt.close();
    con.close();
  }
}