| | |
|---|
| | | 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 " +
|
|---|
| | |
|---|
| | | 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"));
|
|---|
