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;
     }
}