example10_4.java

来自「书中的例题」· Java 代码 · 共 38 行

import java.sql.*;
public class Example10_4
{  
  public static void main(String[ ] args)
   {
    String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
    String conURL="jdbc:odbc:TestDB";
    try {
      Class.forName(JDriver);
    }
    catch(java.lang.ClassNotFoundException e) {
       System.out.println("ForName :" + e.getMessage( ));
    }
    try {
      Connection con=DriverManager.getConnection(conURL);
      Statement s=con.createStatement( );
       //删除第二条记录
      PreparedStatement ps=con.prepareStatement(
                "delete from student where id=?");
      ps.setString(1,"0002");
      ps.executeUpdate( ); //执行删除
        //查询数据库并把数据表的内容输出到屏幕上
      ResultSet rs=s.executeQuery("select * from student");    
      while(rs.next( ))
       {  System.out.println(rs.getString("id")+"\t"+
                rs.getString("name")+"\t" + rs.getString("score"));
      }
      s.close( );
      con.close( );
    }
    catch(SQLException e){
      System.out.println("SQLException: " +e.getMessage( ));
    }
  }
}