存储过程
调用无参存储过程
1.获得连接
Connertion conn = DBUtil.getConnection();
2.获得CallableStatement
CallableStatement cs = conn.prepareCall("{call sp_select_nofilter()}");
3.执行存储过程
cs.execute();
4.处理返回的结果:结果集,出参
ResultSet rs = cs.getResultSet();
调用带输入参数的存储过程
1.获得连接
Connertion conn = DBUtil.getConnection();
2.获得CallableStatement
CallableStatement cs = conn.prepareCall("{call sp_select_filter(?)}");
cs.setString(1,sp_name);
3.执行存储过程
cs.execute();
4.处理返回的结果:结果集,出参
ResultSet rs = cs.getResultSet();
调用带输出参数的存储过程
1.获得连接
Connertion conn = DBUtil.getConnection();
2.获得CallableStatement
CallableStatement cs = conn.prepareCall("{call sp_select_count(?)}");
cs.registerOutParameter(1,Types.INTEGER);
3.执行存储过程
cs.execute();
4.处理返回的结果:结果集,出参
Integer count = 0;
count = cs.getInt(1);
return count;