java参数绑定分页查询方法_Java的分页查询方法

package com.student.impl;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.student.dao.StuInfoDao;

import com.student.entity.StuInfo;

public class StuInfoDaoImpl extends BaseDaoImpl implements StuInfoDao{

public int deleteStuInfo(int[] ids) {

Connection con=null;

con=this.getConnection();

PreparedStatement ps=null;

String sql="delete from StuInfo where stuId=?";

try {

ps=con.prepareStatement(sql);

for(int i=0;i

{

ps.setInt(1,ids[i]);

ps.addBatch();

}

ps.executeBatch();

} catch (SQLException e) {

e.printStackTrace();

}

finally

{

this.closeConnection(con);

}

return 0;

}

public List getStuInfoPage(int page, int pageSize) {

List stus=new ArrayList();

Connection con=null;

PreparedStatement ps=null;

ResultSet rs=null;

con=this.getConnection();

String sql="select top (?) * from StuInfo where stuid not in(select top (?) stuid from StuInfo )";

try {

ps=con.prepareStatement(sql);

ps.setInt(1, pageSize);

ps.setInt(2, (page-1)*pageSize);

rs=ps.executeQuery();

while(rs.next())

{

StuInfo stu=new StuInfo();

stu.setStuid(rs.getInt("stuId"));

stu.setStuName(rs.getString("stuName"));

stu.setStuAddress(rs.getString("stuAddress"));

stu.setStuSex(rs.getInt("stuSex"));

stus.add(stu);

}

} catch (SQLException e) {

e.printStackTrace();

}

finally

{

this.closeConnection(con);

}

return stus;

}

/*

*  查询总页数

*/

public int getSumPage(int pageSize) {//参数是每页显示的条数

int count=0;//总条数

Connection con=null;

PreparedStatement ps=null;

ResultSet rs=null;

con=this.getConnection();//获得连接

try {

String sql="select count(*) from StuInfo";

ps=con.prepareStatement(sql);

rs=ps.executeQuery();

while(rs.next())

{

count=rs.getInt(1);//总条数---获得总条数

}

return count%pageSize==0?count/pageSize:count/pageSize+1;

} catch (SQLException e) {

e.printStackTrace();

}

finally

{

this.closeConnection(con);

}

return count;

}

// public static void main(String[] args) {

//  StuInfoDao sid=new StuInfoDaoImpl();

//  int pageNum=sid.getSumPage(5);

//  System.out.println(pageNum);

//

// }

}