try {
conn = SessionFactoryUtils.getDataSource(getHibernateTemplate().getSessionFactory()).getConnection();
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
RechargeHistoryCount rc = new RechargeHistoryCount();
rc.setMerchant_id(rs.getLong("sjbh"));
rc.setMerchant_name(rs.getString("mc"));
rc.setMerchant_czje(rs.getDouble("total_je"));
rc.setMerchant_czjf(rs.getDouble("total_jf"));
list.add(rc);
}
} catch (Exception e) {
e.printStackTrace();
}finally{