<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url, user, password);
//不带参数的存储过程
CallableStatement stmt = conn.prepareCall("{call ghy_proc}");
stmt.execute();
ResultSet rs = stmt.getResultSet();
while (rs.next()) {
out.println(rs.getString(1) + "<br>");
}
rs.close();
stmt.close(); //具有返回值的存储过程-ghy_proc_var
stmt = conn.prepareCall("{call ghy_proc_return(?,?)}");
stmt.registerOutParameter(1, Types.INTEGER);
stmt.registerOutParameter(2, Types.INTEGER);
stmt.execute();
rs = stmt.getResultSet();
while (rs.next()) {
out.println("max=" + rs.getInt(0));
out.println("min=" + rs.getInt(1));
}
%>
</body>
</html>--------------------------
org.apache.jasper.JasperException: Exception in JSP: /test.jsp:1714: CallableStatement stmt = conn.prepareCall("{call ghy_proc}");
15: stmt.execute();
16: ResultSet rs = stmt.getResultSet();
17: while (rs.next()) {
18: out.println(rs.getString(1) + "<br>");
19: }
20: rs.close();
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:467)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.lang.NullPointerException
org.apache.jsp.test_jsp._jspService(test_jsp.java:72)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
各位帮忙没有分了,
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user = "sa";
String password = "";
Connection conn = DriverManager.getConnection(url, user, password);
//不带参数的存储过程
CallableStatement stmt = conn.prepareCall("{call ghy_proc}");
stmt.execute();
ResultSet rs = stmt.getResultSet();
while (rs.next()) {
out.println(rs.getString(1) + "<br>");
}
rs.close();
stmt.close(); //具有返回值的存储过程-ghy_proc_var
stmt = conn.prepareCall("{call ghy_proc_return(?,?)}");
stmt.registerOutParameter(1, Types.INTEGER);
stmt.registerOutParameter(2, Types.INTEGER);
stmt.execute();
rs = stmt.getResultSet();
while (rs.next()) {
out.println("max=" + rs.getInt(0));
out.println("min=" + rs.getInt(1));
}
%>
</body>
</html>--------------------------
org.apache.jasper.JasperException: Exception in JSP: /test.jsp:1714: CallableStatement stmt = conn.prepareCall("{call ghy_proc}");
15: stmt.execute();
16: ResultSet rs = stmt.getResultSet();
17: while (rs.next()) {
18: out.println(rs.getString(1) + "<br>");
19: }
20: rs.close();
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:467)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.lang.NullPointerException
org.apache.jsp.test_jsp._jspService(test_jsp.java:72)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
各位帮忙没有分了,
解决方案 »
- jbuilder运行问题
- 如何根据日期获得这个日期所在周的最后一天?
- 关于inputStream的read(byte [])
- 请问学哪种语言好 菜鸟
- 谁能告诉我,怎样设置jbuilder9.0的代码风格.
- 50分求Jbuilder7.0 Enterprise Trial注册码~~~
- 如何将image对象转成二进制数据流或数组?再线等待
- 我是学pb的,判断闰年的是isdate("2-28"),但在java里怎么判断呢?
- 我正在用JAVA开发CLIENT/SERVER程序,有许多网络/操作系统知识要理解,我该看些什么内容的书呢?
- 如何用JAVA的开发工具SDK1.2.1编程?
- 不能初始化内部类,请大家看看是怎么回事?
- JDBC连接oracle时环境变量的配置
AS
select * from jobs
GO
//具有返回值的存储过程-ghy_proc_var
stmt = conn.prepareCall("{call ghy_proc_return(?,?)}");
stmt.registerOutParameter(1, Types.INTEGER);
stmt.registerOutParameter(2, Types.INTEGER);
stmt.execute();
rs = stmt.getResultSet();
while (rs.next()) {
out.println("max=" + rs.getInt(0));
out.println("min=" + rs.getInt(1));
}有就出错,为什么啊,帮忙