JDBC 实效数据分页查询

来源：互联网发布：三星备份数据怎样恢复编辑：程序博客网时间：2024/05/20 13:09

本案例使用到的Oracle数据库和数据表为Oracle自带

示例代码：

package com.hcq.main;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class Main2 {private static class DBProperties {// IP地址static final String IP = "127.0.0.1";// 端口static final String PORT = "1521";// 数据库名static final String DB_NAME = "test";// 用户名static final String USER = "scott";// 密码static final String PSW = "tiger";// 连接static final String URL = "jdbc:oracle:thin:@" + IP + ":" + PORT + ":" + DB_NAME;}// 得到连接public static Connection getConn() {Connection conn = null;try {conn = DriverManager.getConnection(DBProperties.URL, DBProperties.USER, DBProperties.PSW);return conn;} catch (SQLException e) {e.printStackTrace();}return null;}// 分页方法 pageNUm表示查询单页数，pageSize表示每页显示的条数public static void page(int pageNum, int pageSize) {Connection conn = Main2.getConn();PreparedStatement ps = null;String sql = "SELECT * FROM (SELECT empno,ename,sal,deptno,ROWNUM rn FROM emp WHERE ROWNUM<=?) temp WHERE"+ " temp.rn BETWEEN ? AND ?";try {ps = conn.prepareStatement(sql);ps.setInt(1, pageNum * pageSize);ps.setInt(2, (pageNum - 1) * pageSize + 1);ps.setInt(3, pageNum * pageSize);ResultSet rs = ps.executeQuery();while (rs.next()) {int empno = rs.getInt(1);String ename = rs.getString(2);double sal = rs.getDouble(3);int deptno = rs.getInt(4);int rn = rs.getInt(5);System.out.println("编号：" + empno + "\t姓名：" + ename + "\t薪水:" + sal + "\t部门:" + deptno + "\tROWNUM:" + rn);}rs.close();} catch (SQLException e) {e.printStackTrace();} finally {if (ps != null) {try {ps.close();} catch (SQLException e) {e.printStackTrace();}}if (conn != null) {try {conn.close();} catch (SQLException e) {e.printStackTrace();}}}}public static void main(String[] args) {// 查询第二页数据，每页显示3条数据page(2, 3);}}

结果截图：

阅读全文

0 0