usecursor.java

不错..................是java的源码

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("不能加载驱动程序:" + 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);     //修改字段内容
      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("数据库连接失败!");
    }
  }
}