| | |
|---|
| | | String sql="select SQL_CALC_FOUND_ROWS distinct tb_batt_endurance.num,tb_batt_endurance.deviceid,tb_batt_endurance.stationid,real_cap,tb_batt_endurance.moncapstd,real_curr,endurance_theory_timelong,endurance_actual_timelong,is_out_stand " +
|
|---|
| | | ",db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.StationName1,db_battinf.tb_battinf.StationName2 " +
|
|---|
| | | " from web_site.tb_batt_endurance,db_battinf.tb_battinf " +
|
|---|
| | | " where tb_batt_endurance.stationid=db_battinf.tb_battinf.stationid " ;
|
|---|
| | | " where tb_batt_endurance.stationid=db_battinf.tb_battinf.stationid "+
|
|---|
| | | " and tb_batt_endurance.stationid in (" +
|
|---|
| | | " select distinct db_battinf.tb_battinf.stationid " +
|
|---|
| | | " from db_battinf.tb_battinf " +
|
|---|
| | | " left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid " +
|
|---|
| | | " left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
|
|---|
| | | " left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
|---|
| | | " where db_user.tb_user_inf.uid=? ) " ;
|
|---|
| | | //机房筛选
|
|---|
| | | String stationSql=" and db_battinf.tb_battinf.StationName like ? and db_battinf.tb_battinf.StationName1 like ? and db_battinf.tb_battinf.StationName2 like ?";
|
|---|
| | | sql+=stationSql;
|
|---|
| | |
|---|
| | |
|
|---|
| | |
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | List<Batt_endurance> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{"%"+bendurance.getStationName()+"%","%"+bendurance.getStationName1()+"%","%"+bendurance.getStationName2()+"%",bendurance.getEndurance_actual_timelong(),bendurance.getIs_out_stand()
|
|---|
| | | List<Batt_endurance> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{bendurance.getNum(),"%"+bendurance.getStationName()+"%","%"+bendurance.getStationName1()+"%","%"+bendurance.getStationName2()+"%",bendurance.getEndurance_actual_timelong(),bendurance.getIs_out_stand()
|
|---|
| | | ,(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | |
|---|
| | | public static void main(String[] args) {
|
|---|
| | | Batt_enduranceImpl bimpl=new Batt_enduranceImpl();
|
|---|
| | | Batt_endurance ben=new Batt_endurance();
|
|---|
| | | ben.setNum(1002);
|
|---|
| | | ben.setStationName("");
|
|---|
| | | ben.setStationName1("");
|
|---|
| | | ben.setStationName2("");
|
|---|
