From 2f9691b8de0e2800f22ce96768aacfd129f02b3c Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 19 七月 2024 17:08:50 +0800
Subject: [PATCH] zjh 2024/07/19-2
---
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java | 77 ++++++++++++++++++++------------------
1 files changed, 41 insertions(+), 36 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
index 24c35cf..946e51a 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
@@ -5,6 +5,7 @@
import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
import com.ltkj.hosp.service.LtkjExamJcsqdService;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
+import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.jdbc.core.JdbcTemplate;
@@ -28,6 +29,7 @@
* @date 2023-08-30
*/
@Service
+@Slf4j
public class LtkjExamJcsqdServiceImpl extends ServiceImpl<LtkjExamJcsqdMapper, LtkjExamJcsqd> implements LtkjExamJcsqdService {
@Resource
@@ -58,43 +60,46 @@
mapper.saveLtkjExamJcsqd(tjh);
}
-// @Override
-// public AjaxResult getTjJcProByHisCall(String ksmc,String strIn,String brid,int pagecount,int page,String status) {
-// List<Map<String, Object>> tjJcProByHisCall = mapper.getTjJcProByHisCall(ksmc,strIn,brid,pagecount,page,status);
-// return AjaxResult.success().put("data",tjJcProByHisCall);
-// }
-
-
@Override
public AjaxResult getTjJcProByHisCall(String ksmc,String strIn,String brid,int pagecount,int page,String status) {
- String sql="{exec usp_his_getexamreportinfo(?,?,?,?,?,?)}";
- Connection connection = null;
- List<Map<String,Object>> list=new ArrayList<>();
- try {
- connection = dataSource.getConnection();
- CallableStatement call = connection.prepareCall(sql);
- call.setString(1,ksmc);
- call.setString(2,strIn);
- call.setString(3,brid);
- call.setInt(4,pagecount);
- call.setInt(5,page);
- call.setString(6,status);
- call.execute();
- ResultSet query = call.executeQuery();
- ResultSetMetaData data = query.getMetaData();
- int count = data.getColumnCount();
- while (query.next()) {
- Map<String,Object>map=new HashMap<>();
- for (int i = 0; i < count; i++) {
- String s = data.getColumnLabel(i);
- Object object = query.getObject(i);
- map.put(s,object);
- }
- list.add(map);
- }
- } catch (SQLException throwables) {
- throwables.printStackTrace();
- }
- return AjaxResult.success().put("data",list);
+ List<Map<String, Object>> tjJcProByHisCall = mapper.getTjJcProByHisCall(ksmc,strIn,brid,pagecount,page,status);
+ return AjaxResult.success().put("data",tjJcProByHisCall);
}
+
+
+// @Override
+// public AjaxResult getTjJcProByHisCall(String ksmc,String strIn,String brid,int pagecount,int page,String status) {
+// String sql="{exec usp_his_getexamreportinfo(?,?,?,?,?,?)}";
+// Connection connection = null;
+// List<Map<String,Object>> list=new ArrayList<>();
+// try {
+// connection = dataSource.getConnection();
+// CallableStatement call = connection.prepareCall(sql);
+// call.setString(1,ksmc);
+// call.setString(2,strIn);
+// call.setString(3,brid);
+// call.setInt(4,pagecount);
+// call.setInt(5,page);
+// call.setString(6,status);
+// call.execute();
+// ResultSet query = call.executeQuery();
+// log.info("鏌ヨ妫�鏌ユ姤鍛� ResultSet: "+query.toString());
+// ResultSetMetaData data = query.getMetaData();
+// log.info("鏌ヨ妫�鏌ユ姤鍛� ResultSetMetaData: "+data.toString());
+// int count = data.getColumnCount();
+// while (query.next()) {
+// Map<String,Object>map=new HashMap<>();
+// for (int i = 0; i < count; i++) {
+// String s = data.getColumnLabel(i);
+// Object object = query.getObject(i);
+// map.put(s,object);
+// }
+// list.add(map);
+// }
+// } catch (SQLException throwables) {
+// throwables.printStackTrace();
+// }
+// log.info("鏌ヨ妫�鏌ユ姤鍛婅繑鍥炲��: "+list.toString());
+// return AjaxResult.success().put("data",list);
+// }
}
--
Gitblit v1.8.0