From d7717df0f80aac77eec9ba0345ea7f4487143f75 Mon Sep 17 00:00:00 2001
From: wuxw7 <wuxw7@asiainfo.com>
Date: 星期日, 25 十一月 2018 01:05:24 +0800
Subject: [PATCH] 修改域名bug

---
 java110-service/src/main/java/com/java110/service/dao/impl/QueryServiceDAOImpl.java |  118 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 112 insertions(+), 6 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 8798af5..51067c0 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
@@ -7,9 +7,8 @@
 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,10 +16,95 @@
 @Service("queryServiceDAOImpl")
 @Transactional
 public class QueryServiceDAOImpl extends BaseServiceDao implements IQueryServiceDAO {
+
+    /**
+     *  闃叉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);
+    }
+
+    /**
+     * 闃叉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
@@ -45,6 +129,28 @@
         return paramsInfo.get("resMsg") ==null ?"" :paramsInfo.get("resMsg").toString();
     }
 
+    @Override
+    public String updateProc(Map<String,Object> paramsInfo) {
+        String paramsInfoStr = "";
+        for (String key : paramsInfo.keySet()){
+            if("procName".equals(key)){
+                paramsInfoStr += (paramsInfo.get("procName") + "(");
+            }else{
+                if(StringUtil.isNullOrNone(paramsInfo.get(key))){
+                    paramsInfoStr += "'',";
+                }else{
+                    paramsInfoStr += "'"+paramsInfo.get(key)+"',";
+                }
+            }
+        }
+
+        paramsInfo.put("paramsInfo",paramsInfoStr);
+
+        sqlSessionTemplate.update("queryServiceDAOImpl.updateProc",paramsInfo);
+
+        return paramsInfo.get("resMsg") ==null ?"" :paramsInfo.get("resMsg").toString();
+    }
+
     /**
      * 鏌ヨ ServiceSql
      * @return

--
Gitblit v1.8.0