加入sign签名，insert update 动态配置

wuxw7

2018-04-23 c4bf85cb536e3c2fd8c951bd60049329f08db840

 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