Use a Scrollable ResultSet Object

From Java Example Source Code

Jump to: navigation, search

lUKSx4 <a href="http://qgpwqbkvcjce.com/">qgpwqbkvcjce</a>, [url=http://mzjfndzrzrul.com/]mzjfndzrzrul[/url], [link=http://rtibiiujcsgb.com/]rtibiiujcsgb[/link], http://cntolhiczxan.com/

Contents

[edit] Java Source Code

  • Package: example.jdbc.resultsetscrollable
  • File: DemoScrollableResultSet_MySQL.java 
package example.jdbc.resultsetscrollable;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class DemoScrollableResultSet_MySQL {
 
    public static Connection getConnection() throws Exception {
	String driver = "org.gjt.mm.mysql.Driver";
	String url = "jdbc:mysql://localhost/databaseName";
	String username = "root";
	String password = "root";
	Class.forName(driver);
	return DriverManager.getConnection(url, username, password);
    }
 
    public static void main(String[] args) {
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	try {
	    conn = getConnection();
	    String query = "select id, name from employees";
	    stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
	    rs = stmt.executeQuery(query);
	    // extract data from the ResultSet scroll from top
	    while (rs.next()) {
		String id = rs.getString(1);
		String name = rs.getString(2);
		System.out.println("id=" + id + "  name=" + name);
	    }
	    // scroll from the bottom
	    rs.afterLast();
	    while (rs.previous()) {
		String id = rs.getString(1);
		String name = rs.getString(2);
		System.out.println("id=" + id + "  name=" + name);
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	} finally {
	    // release database resources
	    try {
		rs.close();
		stmt.close();
		conn.close();
	    } catch (SQLException e) {
		e.printStackTrace();
	    }
	}
    }
}

[edit] What Result You Can Get

Coming soon...

[edit] Required External Libraries and/or Files for this Java Example

In order to run this Java example, one of the following libraries may be required: In order to run this example program, one of the following libraries may be required: 

http://www.hellzyea.com/auto auto insurance lnwe http://www.yourautoinsurancesite.com/ auto insurance quotes %[ http://www.makemeasammich.com/ auto insurance 5008 http://www.kosherhibachi.com/ new jersey car insurance vddm

[edit] Question & Answer

Any question?

Click edit and post your question or answer here.

Retrieved from "http://java.exampleshow.com/sourcecode/Use_a_Scrollable_ResultSet_Object"
Personal tools