| | |
| | | //40-BattmonTestcapService.java;50行 |
| | | public List<BattmonTestcap> getTestCapList(BattmonStandardcurve curve){ |
| | | String sql="select monvolstd,moncapstd,battproducer,battmodel,test_cap,ROUND(avg(mon_vol),3) as mon_vol from " + |
| | | " `db_battinf`.`tb_battmon_testcap_"+curve.getMonVolStd()+"_"+curve.getMonCapStd()+"_"+curve.getNote()+"` " + |
| | | " db_battinf.tb_battmon_testcap_"+curve.getMonVolStd()+"_"+curve.getMonCapStd()+"_"+curve.getNote()+" " + |
| | | " where monvolstd= "+curve.getMonVolStd()+" " + |
| | | " and moncapstd="+curve.getMonCapStd()+" " + |
| | | " and battproducer='"+curve.getBattproducer()+"' " + |
| | | " and battmodel='"+curve.getBattmodel()+"' " + |
| | | " group by test_cap " + |
| | | " order by num"; |
| | | " group by monvolstd,moncapstd,battproducer,battmodel,test_cap "; |
| | | //" order by num"; |
| | | List<BattmonTestcap> list = sqlExecuteService.executeQuery_call(sql, new CallBack() { |
| | | @Override |
| | | public List getResults(ResultSet rs) throws SQLException { |