| | |
|---|
| | | " 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.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ?)";
|
|---|
| | | baseSql+=userSql;
|
|---|
| | | //排序
|
|---|
| | | String endSql=" order by db_battinf.tb_battinf.battgroupid asc ";
|
|---|
| | |
|---|
| | | sql=baseSql+endSql+limitSql;
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | List<BattInf> list=DAOHelper.executeQueryLimit(sql,conn, new Object[]{
|
|---|
| | | binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%",
|
|---|
| | | binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%","%"+binf.getStationName2()+"%",
|
|---|
| | | (page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | |
|---|
| | | " 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.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ?)";
|
|---|
| | | baseSql+=userSql;
|
|---|
| | | //充电放电选择
|
|---|
| | | String test_typeA="";//全部
|
|---|
| | |
|---|
| | | //System.out.println(sql);
|
|---|
| | | List<BattInf> list=DAOHelper.executeQuery(sql,DBUtil.getConn(), new Object[]{
|
|---|
| | | tinf.getRecord_time(),tinf.getRecord_time1()
|
|---|
| | | ,binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%"
|
|---|
| | | ,binf.getBattGroupId(),uinf.getUId(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%","%"+binf.getStationName2()+"%"
|
|---|
| | | }, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
