From c4bf85cb536e3c2fd8c951bd60049329f08db840 Mon Sep 17 00:00:00 2001
From: wuxw7 <wuxw7@asiainfo.com>
Date: 星期一, 23 四月 2018 10:17:27 +0800
Subject: [PATCH] 加入sign签名，insert update 动态配置
---
java110-service/src/main/java/com/java110/service/dao/impl/QueryServiceDAOImpl.java | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 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..cbf97c3 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
@@ -23,6 +23,10 @@
return sqlSessionTemplate.selectList("queryServiceDAOImpl.executeSql",sql);
}
+ public int updateSql(String sql){
+ return sqlSessionTemplate.update("queryServiceDAOImpl.updateSql",sql);
+ }
+
@Override
public String executeProc(Map<String,Object> paramsInfo) {
String paramsInfoStr = "";
@@ -45,6 +49,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