如何jsp中调用存储过程 最好是完整的,及拿了就能用的谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <%@ page contentType="text/html; charset=gb2312"%><%@ page language="java" import="java.sql.*" %><%// 变量定义String jgID;String jgName;String conn;%><h2>存储过程应用</h2><table border="2" cellspacing="2" cellpadding="5"><%// 数据库参数定义String sdbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";String sdbUrl = "jdbc:odbc:sqlsql";String sdbUsername = "sa";String sdbPassword = "";// 连接数据库Class.forName(sdbDriver);Connection Conn = DriverManager.getConnection(sdbUrl, sdbUsername, sdbPassword);CallableStatement Prepare = null;PreparedStatement Stmt = null;//返回参数存储过程String Query = "{call JG_INFO(?, ?)}";Prepare = Conn.prepareCall(Query);Prepare.setString(1,"02");Prepare.registerOutParameter(2, java.sql.Types.CHAR,10);Prepare.execute();out.println(Prepare.getString(2));//返回结果集存储过程String QQuery = "{call JG_GE(?)}";Stmt = Conn.prepareStatement(QQuery);Stmt.setString(1,"02");Stmt.execute();ResultSet rs = Stmt.getResultSet();if(rs.next()){ out.println("<tr><td><b>籍贯编号</b></td><td><b>籍贯名称</b></td></tr>"); jgID = rs.getString(1); jgName = rs.getString(2); out.println("<tr><td>" + jgID + "</td><td>" + jgName + "</td></tr>"); while(rs.next()) { jgID = rs.getString(1); jgName = rs.getString(2); out.println("<tr><td>" + jgID + "</td><td>" + jgName + "</td></tr>"); } rs.close();}//关闭数据库对象Conn.close();%> 有存储过程吗,我是想看看参数调用过程 关于spring 的security启动报错 一个棘手的邮件回复问题!望各位献智献策啊(看错了,还有分,重新发帖) 关于类的简单问题,看了再说!急!!! 如何用java实现给传真机发传真? struts2 jsp 传递中文到action乱码,报错 求用JSP写一个请假管理系统的大概方向 【JB+WebLogic 7.0】配置问题,文件weblogic_sp.jar找不到! 关于类库 比较简单的问题,但就是有点怪,不想在纠缠了,容易拉分!!!!!!!! 高分奉送!!!!关于WebSphyere3.5!!! IIS+tomcat4.0整合的问题, 看这个错误!!!数组应用的错误吗?
<%@ page language="java" import="java.sql.*" %>
<%
// 变量定义
String jgID;
String jgName;
String conn;
%><h2>存储过程应用</h2>
<table border="2" cellspacing="2" cellpadding="5"><%
// 数据库参数定义
String sdbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sdbUrl = "jdbc:odbc:sqlsql";
String sdbUsername = "sa";
String sdbPassword = "";// 连接数据库
Class.forName(sdbDriver);
Connection Conn = DriverManager.getConnection(sdbUrl, sdbUsername, sdbPassword);
CallableStatement Prepare = null;
PreparedStatement Stmt = null;
//返回参数存储过程
String Query = "{call JG_INFO(?, ?)}";
Prepare = Conn.prepareCall(Query);
Prepare.setString(1,"02");
Prepare.registerOutParameter(2, java.sql.Types.CHAR,10);
Prepare.execute();
out.println(Prepare.getString(2));
//返回结果集存储过程
String QQuery = "{call JG_GE(?)}";
Stmt = Conn.prepareStatement(QQuery);
Stmt.setString(1,"02");
Stmt.execute();
ResultSet rs = Stmt.getResultSet();
if(rs.next()){
out.println("<tr><td><b>籍贯编号</b></td><td><b>籍贯名称</b></td></tr>");
jgID = rs.getString(1);
jgName = rs.getString(2);
out.println("<tr><td>" + jgID + "</td><td>" + jgName + "</td></tr>");
while(rs.next()) {
jgID = rs.getString(1);
jgName = rs.getString(2);
out.println("<tr><td>" + jgID + "</td><td>" + jgName + "</td></tr>");
}
rs.close();
}
//关闭数据库对象
Conn.close();
%>