sqlserver分页转mysql
以前的项目用sqlserver做的数据库,现在变到mysql,关于分页的改动请指教?
以前sqlserver:
public class PageBean {
private int pagesize; //页大小
private int allcount; //总记录数
private int currpage; //当前页码
private int allpage; //总页数
private ArrayList data; //页面数据
public int getAllcount() {
return allcount;
}
public void setAllcount(int allcount) {
this.allcount = allcount;
}
public int getAllpage() { //总页数
return (allcount % pagesize == 0)?
allcount/pagesize : allcount/pagesize+1;
}
public void setAllpage(int allpage) {
this.allpage = allpage;
}
public int getCurrpage() {
return currpage;
}
public void setCurrpage(int currpage) {
this.currpage = currpage;
}
public ArrayList getData() {
return data;
}
public void setData(ArrayList data) {
this.data = data;
}
public int getPagesize() {
return pagesize;
}
public void setPagesize(int pagesize) {
this.pagesize = pagesize;
}
}
//分页查找全部商品信息的方法
public PageBean selectgs(int nowPage){
PageBean pb=new PageBean();
ArrayList list=new ArrayList();
try {
conn=new ConnectDB().getConn();
String sql="select count(*) from goodscon";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
if(rs.next()){
pb.setAllcount(rs.getInt(1)); // 总纪录数
}
int pagesize = 6;
String sql1="select top " + pagesize + " * from goodscon where steid not in(select top " + pagesize * (nowPage - 1) +" steid from goodscon)";
pstmt=conn.prepareStatement(sql1);
rs=pstmt.executeQuery();
while(rs.next()){
goodscon gs=new goodscon();
gs.setSteid(rs.getInt("steid"));
gs.setStename(rs.getString("stename"));
gs.setStephoto(rs.getString("stephoto"));
gs.setStevalue(rs.getFloat("stevalue"));
gs.setCpgnjieshao(rs.getString("cpgnjieshao"));
gs.setStedesc(rs.getString("stedesc"));
gs.setStetime(rs.getString("stetime"));
gs.setSteversion(rs.getString("steversion"));
gs.setSteversionjs(rs.getString("steversionjs"));
list.add(gs);
}
pb.setCurrpage(nowPage); // 当前页
pb.setData(list); // 数据
pb.setPagesize(pagesize); // 页大小
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(rs!=null)
rs.close();
if( pstmt != null )
pstmt.close();
if( conn != null )
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return pb;
}
ACTION里:
public ActionForward selectsp(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
Opergoodscon oper=new Opergoodscon();
// 页码
int pagecode = request.getParameter("page")==null? 1 :
Integer.parseInt(request.getParameter("page"));
PageBean pb=oper.selectgs(pagecode);
request.setAttribute("list", pb);
return mapping.findForward("selectsp");
}
请问变到mysql怎么改?