就是一段jsp代码,直接访问数据库,在tomcat下部署成功,但是部署到weblogic6.1会报上面的错误:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<!--导入结束--> <html>
<head>
<title>数据库连接实验</title>
</head>
<body>
<%
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@zhh:1521:zhhdb";
Statement Stmt=null;
Connection conn=null;
try
{
String user="qqq";
String password="qqq";
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn= DriverManager.getConnection(sConnStr,user,password);
Stmt=conn.createStatement(); /*创建JDBC声明*/
}
catch (Exception e) {out.println("失败");} out.println("恭喜,表连接创建成功!");
ResultSet rs=Stmt.executeQuery("select * from jcmd");
while(rs.next())
{
out.println(rs.getString("name"));}
rs.close(); %> </body>
</html>
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<!--导入结束--> <html>
<head>
<title>数据库连接实验</title>
</head>
<body>
<%
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin:@zhh:1521:zhhdb";
Statement Stmt=null;
Connection conn=null;
try
{
String user="qqq";
String password="qqq";
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn= DriverManager.getConnection(sConnStr,user,password);
Stmt=conn.createStatement(); /*创建JDBC声明*/
}
catch (Exception e) {out.println("失败");} out.println("恭喜,表连接创建成功!");
ResultSet rs=Stmt.executeQuery("select * from jcmd");
while(rs.next())
{
out.println(rs.getString("name"));}
rs.close(); %> </body>
</html>
我发现问题是在ResultSet rs=Stmt.executeQuery("select * from jcmd");
这句话,因为如果只是连接数据库是成功的,只是取数据的时候失败