第一次提交

lxw

2020-06-27 8aee9dfec05e1a9333abf03f1bd35dd7cfa9d352

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
package com.fgkj.dao;
 
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
 
import com.fgkj.db.DBUtil;
 
public class LimitNumberFactory {
     //得到分页查询的总记录数目
     public static int GetLimtitNumber(Connection conn,String sql){
         List listN=DAOHelper.executeQuery(sql, conn,null, new CallBack() {    
             public List getResults(ResultSet rs) {
                 List list=new ArrayList();
                 try {
                     while(rs.next()){
                         list.add(rs.getInt("number"));
                     }
                 } catch (SQLException e) {
                     // TODO Auto-generated catch block
                     e.printStackTrace();
                 }
                 return list;
             }
         });
         int number=0;
         if(listN!=null&&listN.size()>0){
             number=(Integer) listN.get(listN.size()-1);
         }
         //System.out.println("number: "+number);
        return number;
     }
}