继承NamedParameterJdbcDaoSupportpublic int addOrUpdateStatisticRule() {
String procedure = "{call sp_getdatabypage(?,?,?)}";// 参数用?替代(包含输出参数)
@SuppressWarnings("unchecked")
int cur_id=this.getNamedParameterJdbcTemplate().execute(procedure, new CallableStatementCallback() { // 内部类
@Override
public Object doInCallableStatement(CallableStatement cs)
throws SQLException, DataAccessException {
// 初始化返回值
int current_id=3;
// 设置输入参数
cs.setString(1, "SELECT ddh,zt,chddm, ddje,convert(varchar(12),ydsj,111) as ydrq from tCPYDD");
cs.setInt(2, 10);
cs.setInt(3, 4);
// 注册输出参数
//cs.registerOutParameter(3, Types.INTEGER);
//cs.execute();
//current_id=cs.getInt(5); // 获得非结果集的返回值
ResultSet rs=cs.executeQuery(); // 获得结果集的返回值
while(rs.next()){
String ddd =rs.getString(1);
System.out.println("订单号:"+ddd);
}
return current_id;
}
});
System.out.println("我显示的是:"+cur_id);
return cur_id;
}
String procedure = "{call sp_getdatabypage(?,?,?)}";// 参数用?替代(包含输出参数)
@SuppressWarnings("unchecked")
int cur_id=this.getNamedParameterJdbcTemplate().execute(procedure, new CallableStatementCallback() { // 内部类
@Override
public Object doInCallableStatement(CallableStatement cs)
throws SQLException, DataAccessException {
// 初始化返回值
int current_id=3;
// 设置输入参数
cs.setString(1, "SELECT ddh,zt,chddm, ddje,convert(varchar(12),ydsj,111) as ydrq from tCPYDD");
cs.setInt(2, 10);
cs.setInt(3, 4);
// 注册输出参数
//cs.registerOutParameter(3, Types.INTEGER);
//cs.execute();
//current_id=cs.getInt(5); // 获得非结果集的返回值
ResultSet rs=cs.executeQuery(); // 获得结果集的返回值
while(rs.next()){
String ddd =rs.getString(1);
System.out.println("订单号:"+ddd);
}
return current_id;
}
});
System.out.println("我显示的是:"+cur_id);
return cur_id;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货