import java.sql.*;
public class UseCursor {
  public static void main(String agrs[]) {
    String driver   = "org.gjt.mm.mysql.Driver";
    String url      = "jdbc:mysql://compaq:3306/jxgl";
    String user     = "sb";
    String password = "songbo";
    try {
      Class.forName(driver);
    }   
    catch(Exception e) {
      System.out.println("不能加載驅(qū)動程序:" + driver);
    }
    try {
      Connection con = DriverManager.getConnection(url,user,password);
      Statement  smt = con.createStatement();  
      ResultSet  rst = smt.executeQuery("SELECT * FROM student");
      rst.beforeFirst();     //把記錄指針移動到第1個記錄之前
      System.out.println("修改前學生表中的記錄:");
      while(rst.next())      //把記錄指針移動到下一個記錄
      {
        System.out.print(rst.getString(1) + " " + rst.getString(2) + " ");
        System.out.print(rst.getString(3) + " " + rst.getString(4) + " ");
        System.out.println(rst.getDate(5) + " " + rst.getFloat(6));
      }
      rst.absolute(4);      //把記錄指針移動到第4個記錄
      System.out.println("第4個記錄:");
      System.out.print(rst.getInt(1) + " " + rst.getString(2) + " ");
      System.out.print(rst.getString(3) + " " + rst.getString(4) + " ");
      System.out.println(rst.getDate(5) + " " + rst.getFloat(6));
      rst.absolute(2);      //把記錄指針移動到第2個記錄
      rst.deleteRow();     //刪除第2個記錄
      rst.moveToInsertRow();     //插入一個新的記錄
      rst.updateString(1,"981103"); 
      rst.updateString(2,"js981"); 
      rst.updateString(3,"吳小麗"); 
      rst.updateString(4,"女"); 
      rst.updateDate(5,Date.valueOf("1980-10-12"));
      rst.updateDouble(6,610.0); 
      rst.insertRow();
      rst.moveToCurrentRow();
      rst.absolute(2);     //修改字段內(nèi)容
      rst.updateString(1,"971201");
	  rst.updateString(2,"js972");
      rst.updateString(3,"許一民"); 
      rst.updateString(4,"男"); 
      rst.updateDate(5,Date.valueOf("1979-09-6"));
      rst.updateDouble(6,572.0); 
	  rst.updateRow(); 
      rst.beforeFirst();     //把記錄指針移動到第一個記錄之前
      System.out.println("修改后學生表中的記錄:");
      while(rst.next())      //移動記錄指針到下一筆記錄
      {
         System.out.print(rst.getString(1) + " " + rst.getString(2) + " ");
         System.out.print(rst.getString(3) + " " + rst.getString(4) + " ");
         System.out.println(rst.getDate(5) + " " + rst.getFloat(6));
      }      
      smt.close();
      con.close();    
    }
    catch(SQLException ee) {
      System.out.println("數(shù)據(jù)庫連接失敗!");
    }
  }
}