| | |
|---|
| | | Page page=binf.getPage();
|
|---|
| | | Connection conn=DBUtil.getConn();
|
|---|
| | | String numberSql=" SELECT FOUND_ROWS() number";
|
|---|
| | | String sql=" select SQL_CALC_FOUND_ROWS distinct dev_id,battgroup_id,battgroup_index,battgroup_mon_cnt " +
|
|---|
| | | String sql=" select SQL_CALC_FOUND_ROWS distinct dev_id,battgroup_id,battgroup_index,battgroup_mon_cnt,battgroup_float_vol,battgroup_float_curr,battgroup_register_code " +
|
|---|
| | | " ,stationName,stationName1,stationName2,stationName3,stationName5,StationId " +
|
|---|
| | | " from db_app_sys.tb_app_bts_battgroup " +
|
|---|
| | | " left outer join db_battinf.tb_battinf on db_app_sys.tb_app_bts_battgroup.dev_id=db_battinf.tb_battinf.fBSDeviceId " +
|
|---|
| | |
|---|
| | | }else{
|
|---|
| | | sql+=dev_idT;
|
|---|
| | | }
|
|---|
| | | String orderSql=" order by dev_id limit ?,? ";
|
|---|
| | | String orderSql=" order by dev_id,battgroup_index asc limit ?,? ";
|
|---|
| | | sql+=orderSql;
|
|---|
| | | //System.out.println(sql); //"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationId()+"%","%"+binf.getStationName5()+"%",binf.getNum()
|
|---|
| | | List<App_bts_comm_task> list=DAOHelper.executeQueryLimit(sql, conn,new Object[]{binf.getFBSDeviceId(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | | List<App_bts_battgroup> list=DAOHelper.executeQueryLimit(sql, conn,new Object[]{binf.getFBSDeviceId(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
| | |
|---|
| | | abattgroup.setBattgroup_id(rs.getInt("battgroup_id"));
|
|---|
| | | abattgroup.setBattgroup_index(rs.getInt("battgroup_index"));
|
|---|
| | | abattgroup.setBattgroup_mon_cnt(rs.getInt("battgroup_mon_cnt"));
|
|---|
| | | abattgroup.setBattgroup_float_vol(rs.getFloat("battgroup_float_vol"));
|
|---|
| | | abattgroup.setBattgroup_float_curr(rs.getFloat("battgroup_float_curr"));
|
|---|
| | | abattgroup.setBattgroup_register_code(rs.getString("battgroup_register_code"));
|
|---|
| | | abattgroup.setStationId(rs.getString("stationId"));
|
|---|
| | | abattgroup.setStationName(rs.getString("stationName"));
|
|---|
| | | abattgroup.setStationName1(rs.getString("stationName1"));
|
|---|
