| | |
|---|
| | | Connection conn=DBUtil.getConn();
|
|---|
| | | String numberSql=" SELECT FOUND_ROWS() number";
|
|---|
| | | String sql="";
|
|---|
| | | String baseSql="select SQL_CALC_FOUND_ROWS distinct(db_battinf.tb_battinf.BattgroupId),db_battinf.tb_battinf.stationid,StationName1,StationName,stationip,BattGroupName,BattGroupName1,battgroupnum,moncount,moncapstd,monvolstd,battproducer,battproductdate,battinusedate "
|
|---|
| | | String baseSql="select SQL_CALC_FOUND_ROWS distinct(db_battinf.tb_battinf.BattgroupId),db_battinf.tb_battinf.stationid,StationName1,StationName2,StationName5,StationName,stationip,BattGroupName,BattGroupName1,battgroupnum,moncount,moncapstd,monvolstd,battproducer,battproductdate,battinusedate "
|
|---|
| | | + " from db_battinf.tb_battinf "
|
|---|
| | | + " where ";
|
|---|
| | | //选取蓄电池组条件
|
|---|
| | |
|---|
| | | " and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
|
|---|
| | | " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
|---|
| | | " and db_user.tb_user_inf.uid=? " +
|
|---|
| | | " and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? )";
|
|---|
| | | " and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? and db_battinf.tb_battinf.stationname5 like ? )";
|
|---|
| | | baseSql+=userSql;
|
|---|
| | | String endSql=" order by StationName1 asc,db_battinf.tb_battinf.BattgroupId asc ";
|
|---|
| | | sql=baseSql+endSql;
|
|---|
| | | String limitSql=" limit ?,? ";
|
|---|
| | | sql+=limitSql;
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | List<BattInf> list = DAOHelper.executeQueryLimit(sql,conn,new Object[] {binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%","%"+binf.getStationName2()+"%",(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()},
|
|---|
| | | List<BattInf> list = DAOHelper.executeQueryLimit(sql,conn,new Object[] {binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName5()+"%",(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()},
|
|---|
| | | new CallBack() {
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
| | |
|---|
| | | binf.setStationId(rs.getString("stationId"));
|
|---|
| | | binf.setStationName(rs.getString("stationName"));
|
|---|
| | | binf.setStationName1(rs.getString("stationName1"));
|
|---|
| | | binf.setStationName2(rs.getString("stationName2"));
|
|---|
| | | binf.setStationName5(rs.getString("stationName5"));
|
|---|
| | | binf.setStationIp(rs.getString("stationIp"));
|
|---|
| | | binf.setBattGroupName(rs.getString("battGroupName"));
|
|---|
| | | binf.setBattGroupName1(rs.getString("battGroupName1"));
|
|---|
