scrollingdemo.java

此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作

package results;

import java.sql.*;
import java.io.*;
import connections.*;

public class ScrollingDemo {
  public static void main(String[] args) {
    Connection conn = null;
    Statement stmt = null;
    ResultSet rset = null;

    try {
      conn = ConnectionFactory.getConnection();
      stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, 
                                  ResultSet.CONCUR_READ_ONLY);
      String sql = "SELECT * FROM tracks " 
                   + "ORDER BY recordingid, tracknumber";
      rset = stmt.executeQuery(sql);

      if (rset.next()) {
        rset.beforeFirst();
        boolean done = false;
        BufferedReader in = 
          new BufferedReader(new InputStreamReader(System.in));
        while (!done) {
          System.out.print("\nType F (first), N (next), P (previous), " 
                           + "L (last), Q (quit) : ");
          String s = in.readLine();
          boolean result = false;
          if (s.equalsIgnoreCase("F")) {
            result = rset.first();
          } else if (s.equalsIgnoreCase("N")) {
            result = rset.next();
          } else if (s.equalsIgnoreCase("P")) {
            result = rset.previous();
          } else if (s.equalsIgnoreCase("L")) {
            result = rset.last();
          } else if (s.equalsIgnoreCase("Q")) {
            done = true;
          } 
          if (done) {
            break;
          } 
          if (result) {
            System.out.println("cursor moved to row " + rset.getRow());
            System.out.println("Record Id : " + rset.getInt(1) 
                               + ", Track Number : " + rset.getInt(2) 
                               + ", Track Title : " + rset.getString(3));
          } else {
            System.out.println("Could not move cursor");
          } 
        } 
        in.close();
      } else {
        System.out.println("ResultSet contained no rows");
      } 
    } catch (Exception e) {
      e.printStackTrace();
    } 
    finally {
      ConnectionFactory.close(rset);
      ConnectionFactory.close(stmt);
      ConnectionFactory.close(conn);
    }
  }
}