利用sql serve语句进行分页

package com.chen.dbTest; import java.util.List; import java.sql.*; import java.util.ArrayList; public class UserDAO { public List seachUser(Connection con,String name,String user_id,int start, int end) { List<UserInfo> list=new ArrayList<UserInfo>(); PreparedStatement pstm=null; ResultSet rs=null; String sql="select rownum rowcount, userinfo.* from userinfo "; boolean i=false; if(name!=null&&!name.equals("")) { sql=sql+"where username like ?"; i=true; } if(user_id!=null&&!user_id.equals("")) { if(i) sql=sql+"and user_id=?"; else sql=sql+"user_id=?"; } sql="select * from("+sql+") where rowcount>="+start+"and rowcount<="+end; System.out.println("sql="+sql); try { pstm=con.prepareStatement(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("public List seachUser==="+e.toString()); } if(name!=null&&!name.equals("")) { try { pstm.setString(1, name); if(user_id!=null&&!user_id.equals("")) { int id=Integer.parseInt(user_id); pstm.setInt(2, id); } } catch (SQLException e) { // TODO Auto-generated catch block System.out.println("public List seachUser=========11"+e.toString()); } } try { rs=pstm.executeQuery(); while(rs.next()) { UserInfo ui=new UserInfo(); ui.setName(rs.getString("username")); ui.setId(rs.getInt("user_id")); list.add(ui); } } catch (SQLException e) { // TODO Auto-generated catch block System.out.println("public List seachUser===222222222222"+e.toString()); } finally { try { if(con!=null) { con.close(); } if(pstm!=null) { pstm.close(); } if(rs!=null) { rs.close(); } } catch (SQLException e) { e.printStackTrace(); } } return list; } public boolean login(Connection con,String name,String password) { ResultSet rs=null; PreparedStatement pstm=null; boolean result=false; try { pstm=con.prepareStatement("select * from userinfo where username=? and password=?"); pstm.setString(1, name); pstm.setString(2, password); rs=pstm.executeQuery(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if(rs.next()) { result=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return result; } public int count(Connection con,String name,String id) { ResultSet rs=null; PreparedStatement pstm=null; int result=0; try { String sql="select count(*) allcount from userinfo where 1=1"; if(name!=null&&!name.equals("")) { sql=sql+"and username=?"; } if(id!=null&&!id.equals("")) { sql=sql+"and user_id=?"; } pstm=con.prepareStatement(sql); if(name!=null&&!name.equals("")) { pstm.setString(1, name); if(id!=null&&!id.equals("")) { int int_id=Integer.parseInt(id); pstm.setInt(2, int_id); } } rs=pstm.executeQuery(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { if(rs.next()) { result=rs.getInt("allcount"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return result; } }