jdbc resultset 結(jié)果集范例

jdbc resultset 通過移動光標(biāo)的方法瀏覽結(jié)果集。

1. resultset 移動光標(biāo)的方法

2. resultset 瀏覽結(jié)果集范例

//step 1. import required packages
import java.sql.*;

public class navigatingresultset {
    // jdbc driver name and database url
    static final string jdbc_driver = "com.mysql.jdbc.driver";  
    static final string db_url = "jdbc:mysql://localhost/emp";

    //  database credentials
    static final string user = "root";
    static final string pass = "123456";

    public static void main(string[] args) {
        connection conn = null;
        statement stmt = null;
        try{
            //step 2: register jdbc driver
            class.forname("com.mysql.jdbc.driver");

            //step 3: open a connection
            system.out.println("connecting to database...");
            conn = drivermanager.getconnection(db_url,user,pass);

            //step 4: execute a query to create statment with
            // required arguments for rs example.
            system.out.println("creating statement...");
            stmt = conn.createstatement(
                                resultset.type_scroll_insensitive,
                                resultset.concur_read_only);
            string sql;
            sql = "select id, first, last, age from employees";
            resultset rs = stmt.executequery(sql);

            // move cursor to the last row.
            system.out.println("moving cursor to the last...");
            rs.last();

            //step 5: extract data from result set
            system.out.println("displaying record...");
            //retrieve by column name
            int id  = rs.getint("id");
            int age = rs.getint("age");
            string first = rs.getstring("first");
            string last = rs.getstring("last");

            //display values
            system.out.print("id: " + id);
            system.out.print(", age: " + age);
            system.out.print(", first: " + first);
            system.out.println(", last: " + last);

            // move cursor to the first row.
            system.out.println("moving cursor to the first row...");
            rs.first();

            //step 6: extract data from result set
            system.out.println("displaying record...");
            //retrieve by column name
            id  = rs.getint("id");
            age = rs.getint("age");
            first = rs.getstring("first");
            last = rs.getstring("last");

            //display values
            system.out.print("id: " + id);
            system.out.print(", age: " + age);
            system.out.print(", first: " + first);
            system.out.println(", last: " + last);
            // move cursor to the first row.

            system.out.println("moving cursor to the next row...");
            rs.next();

            //step 7: extract data from result set
            system.out.println("displaying record...");
            id  = rs.getint("id");
            age = rs.getint("age");
            first = rs.getstring("first");
            last = rs.getstring("last");

            //display values
            system.out.print("id: " + id);
            system.out.print(", age: " + age);
            system.out.print(", first: " + first);
            system.out.println(", last: " + last);

            //step 8: clean-up environment
            rs.close();
            stmt.close();
            conn.close();
        }catch(sqlexception se){
            //handle errors for jdbc
            se.printstacktrace();
        }catch(exception e){
            //handle errors for class.forname
            e.printstacktrace();
        }finally{
            //finally block used to close resources
            try{
                if(stmt!=null)
                stmt.close();
            }catch(sqlexception se2){
            }// nothing we can do
            try{
                if(conn!=null)
                conn.close();
            }catch(sqlexception se){
                se.printstacktrace();
            }//end finally try
        }//end try
        system.out.println("goodbye!");
    }//end main
}//end jdbcexample

3. 編譯運(yùn)行

f:\worksp\jdbc>javac -djava.ext.dirs=f:\worksp\jdbc\libs navigatingresultset.java

f:\worksp\jdbc>java -djava.ext.dirs=f:\worksp\jdbc\libs navigatingresultset

運(yùn)行上面代碼，得到以下結(jié)果：