pagetest.java

来自「经典的java初学者的材料里面有最基本的java的应用」· Java 代码 · 共 52 行

package addressbook.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import addressbook.model.DBUtils;

public class PageTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		PreparedStatement pstmt=null;
		try {
			Connection conn = DBUtils.getConnection();
			Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
			ResultSet rs = stmt.executeQuery("select * from addressbook_table");
			
			rs.last();
			rs.absolute(3);
			/**
			while(rs.next()) {
				System.out.println(rs.getString(1));
			}
			*/
			
			PageExample pe = new PageExampleImpl(stmt.executeQuery("select * from addressbook_table"));
			pe.setPageSize(2);//每页20个记录
			pe.gotoPage(2);//跳转到第2页
			//System.out.println(pe.getPageRowsCount());
			for(int i=0; i < pe.getPageRowsCount(); i++){//循环处理
				//int id = pe.getRs().getInt("ID");
				System.out.println(pe.getRs().getString(1));
				pe.getRs().next();
				//继续处理
			}  
			
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}

	}

}