根据项目里分页实例，，带有注解。
1 package org.tarena.netctoss.dao.impl; java.sql.Connection; 4 import java.sql.PreparedStatement; 5 import java.sql.ResultSet; 6 import java.util.ArrayList; 7 import java.util.List; org.tarena.netctoss.dao.AccountDAO; 10 import org.tarena.netctoss.pojo.Account; 11 import org.tarena.netctoss.util.DBUtil;AccountDAOImpl implements AccountDAO {List<Account> findByParameters( 16int page,int pageSize, 17 String idCartNo, String realName, 18String loginName, String status) throws Exception { 19StringBuffer sql = new StringBuffer( 20″select * from ACCOUNT “);(“-1″.equals(status)){ 23sql.append(” where 1=1 “); 24}else{ 25sql.append(” where STATUS = ? “); 26 }(idCartNo != null && !””.equals(idCartNo)) { 29sql.append(” and IDCARD_NO like ? “); 30 }(realName != null && !””.equals(realName)) { 33sql.append(” and REAL_NAME like ? “); 34 }(loginName != null && !””.equals(loginName)) { 37sql.append(” and LOGIN_NAME like ? “); 38 } 39 //System.out.println(sql);StringBuffer pageSQL = new StringBuffer(“”); 42pageSQL.append(“select * from “); 43pageSQL.append(” ( “); 44pageSQL.append(” select a.*,rownum rn “); 45pageSQL.append(” from ( “);pageSQL.append(” ) a “); 48pageSQL.append(” where rownum<=? “); 49pageSQL.append(” ) “); 50pageSQL.append(” where rn>=? “); 51 System.out.println(pageSQL); 52try {Connection con = DBUtil.openConnection(); 55PreparedStatement pst = con.prepareStatement(pageSQL.toString());List<Object> params = new ArrayList<Object>();(!”-1″.equals(status)){ 60 params.add(status); 61 }(idCartNo != null && !””.equals(idCartNo)) { 64params.add(“%”+idCartNo+”%”); 65 }(realName != null && !””.equals(realName)) { 68params.add(“%”+realName+”%”); 69 }(loginName != null && !””.equals(loginName)) { 72params.add(“%”+loginName+”%”); 73 } begin = (page-1)*pageSize+1; 76int end = page*pageSize;params.add(begin);System.out.println(params);(int i = 0; i < params.size(); i++) { 82pst.setObject(i + 1, params.get(i)); 83 }ResultSet rs = pst.executeQuery(); 86List<Account> list = new ArrayList<Account>(); 87while (rs.next()) { 88Account account = new Account(); 89account.setId(rs.getInt(“ID”)); 90account.setIdCardNo(rs.getString(“IDCARD_NO”)); 91account.setRealName(rs.getString(“REAL_NAME”)); 92account.setLoginName(rs.getString(“LOGIN_NAME”)); 93account.setStatus(rs.getString(“STATUS”)); 94 list.add(account); 95 } 96return list; 97} catch (Exception ex) { 98 ex.printStackTrace(); 99throw ex;100} finally {101 DBUtil.closeConnection();102 }103 }main(String[] args) throws Exception{106AccountDAO dao = new AccountDAOImpl();107List<Account> list = dao.findByParameters(1082,3,null, null, null, “1”);109for(Account account : list){110System.out.println(account.getId()+” “+account.getIdCardNo()+” “+account.getRealName());111 }112 }113114 }如果我们想要更多的玫瑰花，就必须种植更多的玫瑰树。
