JSP是如何调用存储过程的（在线等）

单位用的jsp，但是我不知道jsp怎么调用存储过程

能给出例子代码最好啦~

还有就是调用的是存储过程名称呢？还是调用存储过程里面定义的变量呢？

---

在线等回复哦

---

别沉了。。着急哩

---

参考如下代码：
javax.sql.DataSource ds = (javax.sql.DataSource) ctx
.lookup("mslv/oms/oms1/internal/jdbc/DataSource");
conn = ds.getConnection();
String sql = "{call PAL_ACTIVATION_ADAPT.GET_97_USERID_SERIALID(?,?,?,?,?)}";
cstmt = conn.prepareCall(sql);
cstmt.setString(1, this.serialNoRA);
cstmt.registerOutParameter(2, Types.VARCHAR);
cstmt.registerOutParameter(3, Types.VARCHAR);
cstmt.registerOutParameter(4, Types.INTEGER);
cstmt.registerOutParameter(5, Types.VARCHAR);
cstmt.execute();
this.userId = (cstmt).getString(2);
this.serialNo97 = (cstmt).getString(3);
this.nerr_Statement = (cstmt).getInt(4);
this.serr_Statement = (cstmt).getString(5);

---

http://blog.csdn.net/moonsbird/archive/2007/10/11/1819513.aspx

---

引用

参考如下代码：
javax.sql.DataSource ds = (javax.sql.DataSource) ctx
.lookup("mslv/oms/oms1/internal/jdbc/DataSource");
conn = ds.getConnection();
String sql = "{call PAL_ACTIVATION_ADAPT.GET_97_USERID_SERIALID(?,?,?,?,?)}";
cstmt = conn.prepareCall(sql);
cstmt.setString(1