From 9973d6e1314f03bca58ebff35d331de4651bbea5 Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期二, 05 十一月 2024 09:13:06 +0800
Subject: [PATCH] 调整语法不兼容
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index 426e716..9b6126d 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -1289,13 +1289,13 @@
//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 {
--
Gitblit v1.9.1