- 论坛徽章:
- 0
|
Java 调用存储过程
MS Sql Server 环境
CallableStatement cs = connection
.prepareCall("{call setOrdersLimit(?,?)}");
cs.setInt(1, this.periodID);
cs.registerOutParameter(2, Types.VARCHAR);//输出参数
cs.executeUpdate();//OR cs.execute();
if (cs.getString(2).substring(0, 4).equals("true"))
r = true;
cs.close();
/*如果需要返回结果集*/
CallableStatement cs= connection.prepareCall("{call usp_MyProc(?) }");
cs.setInt(1,100);
cs.executeQuery();
ResultSet rs = cs.getResultSet();
Oracle 环境(from
http://www.phpchina.com/755/viewspace_8054.html
)
CallableStatement stmt = null;
conn = DBManager.getConnection();
stmt = conn.prepareCall("{call SP_WJDSCX_GET_WSBMX(?,to_date(?,'yyyy/mm/dd'),?,?)}");
stmt.setString(1, id_jg + "%");
stmt.setString(2, sssq);
stmt.registerOutParameter(3,OracleTypes.CURSOR);
stmt.registerOutParameter(4, java.sql.Types.VARCHAR);
stmt.execute();
rs = ((OracleCallableStatement)stmt).getCursor(3);
allCount = new Integer(stmt.getString(4)).intValue() + 1;
(待继续补充)
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/18156/showart_440306.html |
|