MySql分页

use information_schema

select table_name from tables limit 4, 10;
-- 从第5行开始,查询10条记录

package com.ankangqiao.jdbc;

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

/**
 * 
 * @author Kevin
 * 
 */
public class ConnectionTest {


	/**
	 * @param args
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		
		Connection connection = null;
		PreparedStatement preparedStatetment = null;
		ResultSet resultSet = null;

		try {
			Class.forName("com.mysql.jdbc.Driver");
			connection = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/information_schema", "root", "root");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			throw e;
		} catch (SQLException e) {
			e.printStackTrace();
			throw e;
		}
		
		try {
			int pageNumber = 2;
			int pageSize = 2;
			StringBuilder sql = new StringBuilder();
			
			sql.append("select table_name from tables ")
					.append("limit ?, ?");

			preparedStatetment = connection.prepareStatement(sql.toString());
			preparedStatetment.setInt(1, pageSize * (pageNumber - 1));
			preparedStatetment.setInt(2, pageSize);
			
			resultSet = preparedStatetment.executeQuery();
			
			while (resultSet.next()) {
				System.out.println(resultSet.getObject(1));
			}
		} catch (SQLException e) {
			e.printStackTrace();
			throw e;
		} finally {
			if (preparedStatetment != null) {
				try {
					preparedStatetment.close();
				} catch (SQLException e) {
					e.printStackTrace();
					throw e;
				} finally {
					if (connection != null) {
						try {
							connection.close();
						} catch (SQLException e) {
							e.printStackTrace();
							throw e;
						} finally {
							if (resultSet != null) {
								try {
									resultSet.close();
								} catch (SQLException e) {
									e.printStackTrace();
									throw e;
								}
							}
						}
					}
				}
			}
		}

	}
	

}
/*
*/