连接postgre数据库,不成功,为什么?

cuihao 2003-08-21 04:40:00

<?xml version="1.0" encoding="gb2312"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<html>
<title>
用户信息
</title>
<body>
<p align="left">

<%@ page import="java.sql.*"%>

<%
Statement sqlStmt;
ResultSet sqlRst;
String strSQL;
Connection conn=null;
Class.forName("org.postgresql.Driver");
conn=DriverManager.getConnection(
"jdbc:postgresql://211.99.13.53:5432/test","postgre","");
sqlStmt=conn.createStatement();
strSQL="select * from mobile";
sqlRst = sqlStmt.executeQuery(strSQL);

while(sqlRst.next()){
%>
<tr>
<td>id：<%=sqlRst.getInt(1) %> </td>
</tr>
<tr>
<td> name：<%=sqlRst.getString(2) %> </td>
</tr>
<tr>
<td>memo：<%=sqlRst.getString(3) %></td>
</tr>
<% } %>
</p>
</body>
</html>

JB8编译
错误信息:

Apache Tomcat/4.0.6 - HTTP Status 500 - Internal Server Errortype Exception reportmessage Internal Server Errordescription The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.
exception

javax.servlet.ServletException: org.postgresql.Driver
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
at org.apache.jsp.condb$jsp._jspService(condb$jsp.java:113)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

root
cause java.lang.ClassNotFoundException: org.postgresql.Driver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1406)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1254)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:198)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:132)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)

...全文