From 43727df73e52cc00a1f1aee3c20a1aec8db1b92f Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 27 二月 2025 08:45:25 +0800
Subject: [PATCH] 修改查询

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java |   87 ++++++++++++++++++++++++-------------------
 1 files changed, 49 insertions(+), 38 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..6182d21 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
@@ -4,7 +4,9 @@
 import com.ltkj.common.core.domain.AjaxResult;
 import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
 import com.ltkj.hosp.service.LtkjExamJcsqdService;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
 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 +30,7 @@
  * @date 2023-08-30
  */
 @Service
+@Slf4j
 public class LtkjExamJcsqdServiceImpl extends ServiceImpl<LtkjExamJcsqdMapper, LtkjExamJcsqd> implements LtkjExamJcsqdService {
 
     @Resource
@@ -44,8 +47,8 @@
     }
 
     @Override
-    public void deletedLtkjJcsqdByTjhAndTmh(String tjh, String tmh) {
-            mapper.deletedLtkjJcsqdByTjhAndTmh(tjh,tmh);
+    public void deletedLtkjJcsqdByTjhAndTmh(String tjh) {
+            mapper.deletedLtkjJcsqdByTjhAndTmh(tjh);
     }
 
     @Override
@@ -54,47 +57,55 @@
     }
 
     @Override
+    public List<LtkjExamJcbgd> queryLtkjExamJcsqdByTjh(String tjh) {
+        return mapper.queryLtkjExamJcsqdByTjh(tjh);
+    }
+
+    @Override
     public void saveLtkjExamJcsqd(String tjh) {
         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