架構技術--spring JdbcTempalte 執行預存程序

標籤：spring   jdbctempalte   

public Map<String, String> push(final PushBean pb) throws Exception {StringBuffer sql = new StringBuffer();sql.append("{call adUmwPush_mac(?,?,?,?,?,?,?,?,?,?,?)}");Map<String, String> map = new HashMap<String, String>();map = jdbcTemplateUAS.execute(sql.toString(),new CallableStatementCallback<Map<String, String>>() {public Map<String, String> doInCallableStatement(final CallableStatement cs) throws SQLException,DataAccessException {cs.setInt(1, pb.getUid());cs.setInt(2, pb.getAdid());cs.setInt(3, pb.getTemp());cs.setString(4, pb.getMac());cs.setString(5, pb.getUrl());cs.setString(6, pb.getHurlaction());cs.setString(7, pb.getAdcontentType());cs.setString(8, pb.getStartime());cs.setString(9, pb.getEnd());cs.registerOutParameter(10, java.sql.Types.INTEGER);cs.registerOutParameter(11, java.sql.Types.INTEGER);cs.execute();Map<String, String> map = new HashMap<String, String>();map.put("RESULT", cs.getString(10));map.put("F_PRICE", cs.getString(11));return map;}});return map;}

參考：http://blog.csdn.net/hu_shengyang/article/details/7896782