1、package com.auto.java;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;/*** JDBC之分页技术*@Title *@Description TODO*@param *@return EmpPaging* @author chenchao*@Date 2017-9-12下午5:14:05**/
3、//总记录数 int total=-1; //总页数 int pages=-1; try {con=DBUtil.getConnection();//查询总记录数String sql_toatl="select count(*) from emp"; //分页String sql="select * from emp order by empno limit ?,?"; //执行sql语句pstm=con.prepareStatement(sql_toatl);rs=pstm.executeQuery(); //获取总记录数if (rs.next()) {total=rs.getInt(1);}
5、//执行分页sql语句 pstm= con.prepareStatement(sql); pstm.setInt(1, page); pstm.setInt(2, pageSize);rs=pstm.executeQuery();//处理结果集while(rs.next()){ System.out.println("ename"+rs.getString("ename")+",sal"+rs.getDouble("sal"));}
