| | |
|---|
| | | " from web_site.tb_batt_endurance,db_battinf.tb_battinf " +
|
|---|
| | | " where tb_batt_endurance.stationid=db_battinf.tb_battinf.stationid " ;
|
|---|
| | | //机房筛选
|
|---|
| | | String stationSql=" and tb_batt_endurance.stationid like ?";
|
|---|
| | | String stationSql=" and db_battinf.tb_battinf.StationName like ?";
|
|---|
| | | sql+=stationSql;
|
|---|
| | | //续航状态
|
|---|
| | | String enduranceSqlT=" and endurance_state=? ";
|
|---|
| | |
|---|
| | | //排序时间
|
|---|
| | | String orderSql=" order by endurance_timelong asc";
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+bendurance.getStationid()+"%",bendurance.getEndurance_state(),bendurance.getEndurance_timelong()}, new CallBack() {
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{"%"+bendurance.getNote()+"%",bendurance.getEndurance_state(),bendurance.getEndurance_timelong()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
| | |
|---|
| | | public static void main(String[] args) {
|
|---|
| | | Batt_enduranceImpl bimpl=new Batt_enduranceImpl();
|
|---|
| | | Batt_endurance ben=new Batt_endurance();
|
|---|
| | | ben.setStationid("");
|
|---|
| | | ben.setNote("");
|
|---|
| | | ben.setEndurance_state(0);
|
|---|
| | | ben.setEndurance_timelong(0);
|
|---|
| | | List list=bimpl.serchByCondition(ben);
|
|---|
