From 20a3d53c00627d2d76cb78ab361e5ed555f8617d Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期日, 28 四月 2019 10:47:30 +0800
Subject: [PATCH] 建表规范中加入 审核状态 单独处理

---
 java110-service/src/main/java/com/java110/service/dao/impl/QueryServiceDAOImpl.java |  110 +++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 102 insertions(+), 8 deletions(-)

diff --git a/java110-service/src/main/java/com/java110/service/dao/impl/QueryServiceDAOImpl.java b/java110-service/src/main/java/com/java110/service/dao/impl/QueryServiceDAOImpl.java
index cbf97c3..4b8e1c3 100644
--- a/java110-service/src/main/java/com/java110/service/dao/impl/QueryServiceDAOImpl.java
+++ b/java110-service/src/main/java/com/java110/service/dao/impl/QueryServiceDAOImpl.java
@@ -2,14 +2,16 @@
 
 import com.java110.common.util.StringUtil;
 import com.java110.core.base.dao.BaseServiceDao;
+import com.java110.entity.order.ServiceBusiness;
 import com.java110.entity.service.ServiceSql;
 import com.java110.service.dao.IQueryServiceDAO;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 
-import java.util.List;
-import java.util.Map;
-import java.util.TreeMap;
+import java.sql.*;
+import java.util.*;
 
 /**
  * Created by wuxw on 2018/4/20.
@@ -17,14 +19,97 @@
 @Service("queryServiceDAOImpl")
 @Transactional
 public class QueryServiceDAOImpl extends BaseServiceDao implements IQueryServiceDAO {
+
+    private final static Logger logger = LoggerFactory.getLogger(QueryServiceDAOImpl.class);
+
+    /**
+     *  闃叉sql娉ㄥ叆 鏀归�犳垚鐩存帴鐢╬repareStatement 棰勫鐞唖ql
+     * @param sql
+     * @param params
+     * @return
+     */
     @Override
-    public List<Map> executeSql(String sql) {
-        logger.debug("----銆恞ueryServiceDAOImpl.executeSql銆戝叆鍙� : "+sql);
-        return sqlSessionTemplate.selectList("queryServiceDAOImpl.executeSql",sql);
+    public List<Map<String,Object>> executeSql(String sql,Object[] params) {
+        logger.debug("----銆恞ueryServiceDAOImpl.executeSql銆戝叆鍙� : "+sql+" params= "+params);
+        Connection conn = null;
+        ResultSet rs = null;
+        PreparedStatement ps = null;
+        List<Map<String,Object>> mapList = new ArrayList<Map<String,Object>>();
+        try {
+            conn = sqlSessionTemplate.getConnection();
+            ps = conn.prepareStatement(sql);
+            if(params != null){
+                for(int i = 0 ; i < params.length ; i++){
+                    ps.setObject(i+1, params[i]);
+                }
+            }
+            rs = ps.executeQuery();
+            //绮鹃珦鐨勫湴鏂瑰氨鍦ㄨ繖閲岋紝绫籖esultSet鏈塯etMetaData()浼氳繑鍥炴暟鎹殑鍒楀拰瀵瑰簲鐨勫�肩殑淇℃伅锛岀劧鍚庢垜浠皢鍒楀悕鍜屽搴旂殑鍊间綔涓簃ap鐨勯敭鍊煎瓨鍏ap瀵硅薄涔嬩腑...
+            ResultSetMetaData rsmd = rs.getMetaData();
+            while(rs.next()){
+                Map<String,Object> map = new HashMap<String,Object>();
+                for(int i = 0 ; i < rsmd.getColumnCount() ; i++){
+                    String col_name = rsmd.getColumnLabel(i+1);
+                    Object col_value = rs.getObject(col_name);
+                    if(col_value == null){
+                        col_value = "";
+                    }
+                    map.put(col_name, col_value);
+                }
+                mapList.add(map);
+            }
+            return mapList;
+        } catch (SQLException e) {
+            logger.error("鎵цsql寮傚父锛�" + sql +params,e);
+            return null;
+        }finally{
+            try {
+                //conn.close();
+                if( ps!=null) {
+                    ps.close();
+                }
+                if(rs != null) {
+                    rs.close();
+                }
+            } catch (SQLException e) {
+                e.printStackTrace();
+            }
+        }
+        //return sqlSessionTemplate.selectList("queryServiceDAOImpl.executeSql",sql);
     }
 
-    public int updateSql(String sql){
-        return sqlSessionTemplate.update("queryServiceDAOImpl.updateSql",sql);
+    /**
+     * 闃叉sql娉ㄥ叆 鏀归�犳垚鐩存帴鐢╬repareStatement 棰勫鐞唖ql
+     * @param sql
+     * @param params
+     * @return
+     */
+    public int updateSql(String sql,Object[] params){
+        logger.debug("----銆恞ueryServiceDAOImpl.updateSql銆戝叆鍙� : "+sql+" params= "+params);
+        Connection conn = null;
+        PreparedStatement ps = null;
+        try {
+            conn = sqlSessionTemplate.getConnection();
+            ps = conn.prepareStatement(sql);
+            if(params != null){
+                for(int i = 0 ; i < params.length ; i++){
+                    ps.setObject(i+1, params[i]);
+                }
+            }
+            return ps.executeUpdate();
+            //绮鹃珦鐨勫湴鏂瑰氨鍦ㄨ繖閲岋紝绫籖esultSet鏈塯etMetaData()浼氳繑鍥炴暟鎹殑鍒楀拰瀵瑰簲鐨勫�肩殑淇℃伅锛岀劧鍚庢垜浠皢鍒楀悕鍜屽搴旂殑鍊间綔涓簃ap鐨勯敭鍊煎瓨鍏ap瀵硅薄涔嬩腑...
+        } catch (SQLException e) {
+            logger.error("鎵цsql寮傚父锛�" + sql +params,e);
+            return 0;
+        }finally{
+            try {
+                //conn.close();
+                ps.close();
+            } catch (SQLException e) {
+                e.printStackTrace();
+            }
+        }
+        //return sqlSessionTemplate.update("queryServiceDAOImpl.updateSql",sql);
     }
 
     @Override
@@ -79,4 +164,13 @@
     public List<ServiceSql> qureyServiceSqlAll() {
         return sqlSessionTemplate.selectList("queryServiceDAOImpl.qureyServiceSqlAll");
     }
+
+
+    /**
+     * 鏌ヨ鏈嶅姟涓氬姟淇℃伅
+     * @return
+     */
+    public List<ServiceBusiness> qureyServiceBusiness(){
+        return sqlSessionTemplate.selectList("queryServiceDAOImpl.queryServiceBusiness");
+    }
 }

--
Gitblit v1.8.0