一、出错信息如下:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /j2.jsp at line 18Connection con=DriverManager.getConnection("jdbc:oracle:thin:@ly:1521:testdb","system","success");javax.servlet.ServletException: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection二、说明:本人已经创建了数据库。在Oracle的SQL Plus显示如下:SQL> startup open testdb
ORACLE 例程已经启动。Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
数据库装载完毕。
数据库已经打开。
SQL> describe customer;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
CUSTID VARCHAR2(10)
CUSTNAME VARCHAR2(22)
CUSTADD VARCHAR2(20)
CUSTPHONE VARCHAR2(12)
CUSTFAX VARCHAR2(12)SQL> 三、本人的JSP源代码如下:
<%@ page contentType="text/html;charset=gb2312"
import="java.sql.*" %>
<html>
<head>
<title>利用Connection对象的Execute方法执行Select语句</title>
</head>
<body>
<center>
<font size=5 color=blue>
使用JSP方法连接至Oracle数据库
</font>
</center>
<hr>
<p></p>
<center>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@ly:1521:testdb","system","ziyou");Statement stmt=con.createStatement();ResultSet rs=stmt.executeQuery("select * from customer");%><TABLE bgcolor=LightYellow>
<TR bgcolor=DeepSkyBlue>
<TD>no.</TD></TR><%
while(rs.next())
{%>
<TR>
<TD><%=rs.getString("CustID") %></TD>
<%}rs.close();
stmt.close();
con.close();
%></TABLE>
</CENTER></BODY>
</HTML>
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /j2.jsp at line 18Connection con=DriverManager.getConnection("jdbc:oracle:thin:@ly:1521:testdb","system","success");javax.servlet.ServletException: java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection二、说明:本人已经创建了数据库。在Oracle的SQL Plus显示如下:SQL> startup open testdb
ORACLE 例程已经启动。Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
数据库装载完毕。
数据库已经打开。
SQL> describe customer;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
CUSTID VARCHAR2(10)
CUSTNAME VARCHAR2(22)
CUSTADD VARCHAR2(20)
CUSTPHONE VARCHAR2(12)
CUSTFAX VARCHAR2(12)SQL> 三、本人的JSP源代码如下:
<%@ page contentType="text/html;charset=gb2312"
import="java.sql.*" %>
<html>
<head>
<title>利用Connection对象的Execute方法执行Select语句</title>
</head>
<body>
<center>
<font size=5 color=blue>
使用JSP方法连接至Oracle数据库
</font>
</center>
<hr>
<p></p>
<center>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@ly:1521:testdb","system","ziyou");Statement stmt=con.createStatement();ResultSet rs=stmt.executeQuery("select * from customer");%><TABLE bgcolor=LightYellow>
<TR bgcolor=DeepSkyBlue>
<TD>no.</TD></TR><%
while(rs.next())
{%>
<TR>
<TD><%=rs.getString("CustID") %></TD>
<%}rs.close();
stmt.close();
con.close();
%></TABLE>
</CENTER></BODY>
</HTML>
<%@ page contentType="text/html;charset=gb2312"
import="java.sql.*" %>
<html>
<head>
<title>利用Connection对象的Execute方法执行Select语句</title>
</head>
<body>
<center>
<font size=5 color=blue>
使用JSP方法连接至Oracle数据库
</font>
</center>
<hr>
<p></p>
<center>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@ly:1521:testdb","system","success");Statement stmt=con.createStatement();ResultSet rs=stmt.executeQuery("select * from customer");%><TABLE bgcolor=LightYellow>
<TR bgcolor=DeepSkyBlue>
<TD>no.</TD></TR><%
while(rs.next())
{%>
<TR>
<TD><%=rs.getString("CustID") %></TD>
<%}rs.close();
stmt.close();
con.close();
%></TABLE>
</CENTER></BODY>
</HTML>
2.试着把jdbc:oracle:thin:@ly:1521:testdb中的ly修改成数据库服务器的IP地址。
答:
E:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\ROOT\WEB-INF\lib
文件夹里有classes12.jar2.试着把jdbc:oracle:thin:@ly:1521:testdb
答:ly换成了localhost
The Connection descriptor used by the client was:
localhost:1521:testdb为什么SID--"testdb"不能识别呢?