public String portalShoppingNoCheckRstListCheck(final Map<String, String> queryMap){
String psql = "{call portal_shopping_check(?,?,?,?)}";
try{
Object obj = JdbcUtil.getJdbcTemplate(SpringBeanUtil.Config.DATA_SOURCE_TML_BEAN_ID).execute(psql,new CallableStatementCallback(){
public Object doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
cs.setString(1,queryMap.get("shoppingNo"));
cs.setString(2,queryMap.get("userId"));
cs.registerOutParameter(3, Types.NUMERIC);
cs.registerOutParameter(4, Types.VARCHAR);
cs.execute();
int rtnCode = cs.getInt(3);
String outInfo = cs.getString(4);
String returnStr = "检测成功!";
if(0!=rtnCode){
returnStr = outInfo;
}
return returnStr;
}
});
return obj.toString();
}catch (Exception e) {
logger.error("问题检测异常!");
e.printStackTrace();
return "0";
}
}
String psql = "{call portal_shopping_check(?,?,?,?)}";
try{
Object obj = JdbcUtil.getJdbcTemplate(SpringBeanUtil.Config.DATA_SOURCE_TML_BEAN_ID).execute(psql,new CallableStatementCallback(){
public Object doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
cs.setString(1,queryMap.get("shoppingNo"));
cs.setString(2,queryMap.get("userId"));
cs.registerOutParameter(3, Types.NUMERIC);
cs.registerOutParameter(4, Types.VARCHAR);
cs.execute();
int rtnCode = cs.getInt(3);
String outInfo = cs.getString(4);
String returnStr = "检测成功!";
if(0!=rtnCode){
returnStr = outInfo;
}
return returnStr;
}
});
return obj.toString();
}catch (Exception e) {
logger.error("问题检测异常!");
e.printStackTrace();
return "0";
}
}