movecursor.java

基于数据库的基本应用问题

import java.sql.*;

public class MoveCursor{
  public static void main(String args[]){
    String url="jdbc:odbc:mydata";
    String sql="SELECT * FROM student";
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }catch(java.lang.ClassNotFoundException e){
       System.err.println(e.getMessage());
    }
    try{
      Connection con=DriverManager.getConnection(url,"",null);
      Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
      ResultSet rs=stmt.executeQuery(sql);
      rs.last();
      int num=rs.getRow();
      System.out.println("The total number of students is "+num);
      rs.beforeFirst();
      while(rs.next()){
        String s1=rs.getString("name");
        String s2=rs.getString("sex");
        Date d=rs.getDate("birthday");
        boolean v=rs.getBoolean("leave");
        int n=rs.getInt("stnumber");
        System.out.println(s1+","+s2+","+d+","+v+","+n);
      }      
      stmt.close();
      con.close();
    }catch(SQLException ex){
       System.out.println("Message:"+ex.getMessage());
    }    
  }
}