jsp查询ORACLE数据时，怎麽在页面上显示，帮忙分析我的错误原因？

mbl 2004-08-24 01:20:20

代码
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:mbl";
String user="system";
String password="manager";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
a<%=rs.getString(1)%>
b<%=rs.getString(2)%>
<%}%>
<%out.println("AAA");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>

在WEBLOGIC61运行时错误
Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

...全文

118 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

dafei0320 2004-09-15

打赏
举报

OK!我也谢谢先！~^@^

csq66 2004-08-24

打赏
举报

Statement stmt=conn.createStatement
变成:
Statement stmt=conn.createStatement();

kunchengking 2004-08-24

打赏
举报

连接没问题的话，试一试

while(rs.next()) {%>
a<%=rs.getString(1)%>
b<%=rs.getString(2)%>
<%}%>

==>
String a="";
String b="";
while(rs.next()) {
a=rs.getString(1);
b=rs.getString(2);
%>
a=<%=a%>
b=<%=b%>
<%}%>

mbl 2004-08-24

打赏
举报

是不是JDBC没设定
在PATH中的
原因

huangbang 2004-08-24

打赏
举报

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:mbl";
String user="system";
String password="manager";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
a<%=rs.getString(1)%>
b<%=rs.getString(2)%>
<%}%>
<%out.println("AAA");%>
<%rs.close();
stmt.close();
conn.close();
}catch(Execption e)
{
out.print(e);
}%>
</body>
</html>
要加异常处理
加分:)

xuyang821225 2004-08-24