example10_3.java

书中的例题

/* 修改数据 */
import java.sql.*;
public class Example10_3
{ 
  public static void main(String[ ] args)
  {
    String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
    String conURL="jdbc:odbc:TestDB";
    String[ ] id={"0002","0003"};
    int[ ] score={89,60};
    try {
         Class.forName(JDriver);
       }
    catch(java.lang.ClassNotFoundException e) {
        System.out.println("ForName :" + e.getMessage( ));
      }
    try { 
       Connection con=DriverManager.getConnection(conURL);
       //修改数据库中数据表的内容
       PreparedStatement ps=con.prepareStatement(
           "UPDATE student set score=? where id=? ");
       int i=0,idlen=id.length;
    do{ ps.setInt(1,score[i]);
          ps.setString(2,id[i]);
          ps.executeUpdate( );//执行SQL修改命令
          ++i;
      }while(i<id.length);
      ps.close( );      
      //查询数据库并把数据表的内容输出到屏幕上
      Statement s=con.createStatement( );
      ResultSet rs=s.executeQuery("select * from student");
      while(rs.next( )) {
          System.out.println(rs.getString("id") +
                     "\t" + rs.getString("name")+
                     "\t" + rs.getInt("score"));
        }
      s.close( );
      con.close( );
    }
    catch(SQLException e) {
      System.out.println("SQLException: " +e.getMessage( ));
    }
  }
}