如何在jsp中调用Oracle存储过程? PreparedCall 参数方式同PreparedStatement 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 采用CallStatement类处理如: CallableStatement cs = null; try { cs = (CallableStatement) conn.prepareCall( "{call PKG_BASEINFO.PRO_CREATEVERIFYCODE(?,?,?)}"); cs.setString(1,info.getSESSIONID()); cs.setString(2,info.getVERIFYCODE()); cs.registerOutParameter(3, Types.VARCHAR); cs.executeUpdate(); String flag = cs.getString(3); } catch (Exception ex) { throw ex; } finally { //clean db } 我这有SYBASE希望对你有所帮助<% DataSource ds = null; InitialContext ctx=new InitialContext(); ds=(DataSource)ctx.lookup("java:comp/env/jdbc/sybase"); Connection conn = ds.getConnection(); CallableStatement stmt=conn.prepareCall("{call p_report(?,?,?,?,?)}"); stmt.setString(1,"200401"); stmt.setString(2,"200401"); stmt.setString(3,"0000"); stmt.setString(4,"12345678AB"); stmt.setString(5,"FP"); ResultSet rs=stmt.executeQuery();%> spring配置文件applicationContext.xml问题 liferay连数据库的问题 spring aop 方面的问题 JSP中登陆密码错误不能超过3次 jsp与数据库连接问题 怎样实现在jsp中超级连接到下一个页面时,还能保持原来页面不被关闭?高手指点,小妹初学 寻会JAVA朋友帮做个小东东,所有分相送,谢谢 捕获js表单提交事件 初学者的疑惑:...... 呵!:) 如何打开一个页面显示一个excel文件。 jsp中能不能写函数
如:
CallableStatement cs = null;
try {
cs = (CallableStatement) conn.prepareCall(
"{call PKG_BASEINFO.PRO_CREATEVERIFYCODE(?,?,?)}");
cs.setString(1,info.getSESSIONID());
cs.setString(2,info.getVERIFYCODE());
cs.registerOutParameter(3, Types.VARCHAR);
cs.executeUpdate();
String flag = cs.getString(3);
}
catch (Exception ex) {
throw ex;
}
finally {
//clean db
}
<%
DataSource ds = null;
InitialContext ctx=new InitialContext();
ds=(DataSource)ctx.lookup("java:comp/env/jdbc/sybase");
Connection conn = ds.getConnection();
CallableStatement stmt=conn.prepareCall("{call p_report(?,?,?,?,?)}");
stmt.setString(1,"200401");
stmt.setString(2,"200401");
stmt.setString(3,"0000");
stmt.setString(4,"12345678AB");
stmt.setString(5,"FP");
ResultSet rs=stmt.executeQuery();
%>