public String AgentCanJs(int agentId,final String date) {
final String sqlString = " { ?=call fun_power_js_check(?)}";
return this.getJdbcTemplate().execute(new ConnectionCallback(){
@Override
public Object doInConnection(Connection conn) throws SQLException,DataAccessException {
CallableStatement call = conn.prepareCall(sqlString);
call.registerOutParameter(1, OracleTypes.NVARCHAR);
call.setString(2,date);
call.execute();
String string = call.getString(1);
call.close();
return string;
}});
}
springjdbc 调用oracle函数返回对象
最新推荐文章于 2021-04-03 08:14:16 发布