jsp连接postgre数据库?妈的 用这种数据库 连不上 急
<?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)
<!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)
...全文
相关推荐
MinhaListaAnimes:计算工具III项目-使用jsp,js,servlet和postgre
JSP作为视图层,Servlet作为控制层,而数据库模型则对应模型层。通过这种方式,项目可以保持良好的结构和可维护性。
Linux平台jsp环境搭建(Tomcat4+jdk+postgreS)
'your_password';GRANT ALL PRIVILEGES ON DATABASE your_database_name TO your_username;\q```为了在JSP应用中连接到
alfresco-community-4.0.e安装配置
- db.username=postgre - db.password=root1234 - db.driver=org.postgresql.Driver - db.url=jdbc:postgresql
用postgresSQL实现的数据库library系统
**JDBC(Java Database Connectivity)**:JDBC是Java访问数据库的标准接口,用于建立Java应用程序和数据库之间的连接。
Alfresco安装说明.docx
选择程序安装位置,包括存储数据和数据库文件。6. 输入 Postgre 数据库使用端口, 默认为 5432。7.


Web 开发
