MySql分页

use information_schemaselect 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;}}}}}}}}}/**/