DAO中调用oracle存储过程方法
@Override
public String insertPrizeNumInfo(String msisdn , String prizeID ,String prizeName) {
log.info("PrizeNumInfoDaoImpl insertPrizeNumInfo:sql:{call p_get_prize(?,?,?,?)}");
log.info("PrizeNumInfoDaoImpl insertPrizeNumInfo:parameters:" + msisdn + "," +
prizeID + "," + prizeName );
final String pmsisdn = msisdn;
final String pprizeID = prizeID;
final String pprizeName = prizeName;
String res = (String) this.execute(
new CallableStatementCreator() {
public CallableStatement createCallableStatement(Connection con) throws SQLException {
String storedProc = "{call p_get_prize(?,?,?,?)}";// 调用的sql
CallableStatement cs = con.prepareCall(storedProc);
cs.setString(1, pmsisdn);// 设置输入参数的值
cs.setString(2, pprizeID);// 设置输入参数的值
cs.setString(3, pprizeName);// 设置输入参数的值
cs.registerOutParameter(4, OracleTypes.VARCHAR);// 注册输出参数的类型
return cs;
}
}, new CallableStatementCallback
public String insertPrizeNumInfo(String msisdn , String prizeID ,String prizeName) {
log.info("PrizeNumInfoDaoImpl insertPrizeNumInfo:sql:{call p_get_prize(?,?,?,?)}");
log.info("PrizeNumInfoDaoImpl insertPrizeNumInfo:parameters:" + msisdn + "," +
prizeID + "," + prizeName );
final String pmsisdn = msisdn;
final String pprizeID = prizeID;
final String pprizeName = prizeName;
String res = (String) this.execute(
new CallableStatementCreator() {
public CallableStatement createCallableStatement(Connection con) throws SQLException {
String storedProc = "{call p_get_prize(?,?,?,?)}";// 调用的sql
CallableStatement cs = con.prepareCall(storedProc);
cs.setString(1, pmsisdn);// 设置输入参数的值
cs.setString(2, pprizeID);// 设置输入参数的值
cs.setString(3, pprizeName);// 设置输入参数的值
cs.registerOutParameter(4, OracleTypes.VARCHAR);// 注册输出参数的类型
return cs;
}
}, new CallableStatementCallback
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25903968/viewspace-1674960/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
