jsp连接db2数据库问题 jbuilder的lib下或加入到项目的request library下 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 很奇怪的问题的,在class里能连接数据库,在jsp文件中居然连不上! 你用的什么服务器?他的lib里也许没有db2的jdbc。 请把DB2的驱动jar文件放到你的服务器的lib目录下,谢谢,这样你的jsp引擎才能编译执行你的jsp文件! 我用的是jbuilder7自带的tomcat做服务器的,我把db2的驱动(zip格式)加入到了这个项目需要的类库中了,这个应该没有问题,奇怪的是在class中能连上数据库,但jsp里就死活都连不上 DB2的JDBC 2.0要手动激活的,你做了吗?在sqllib\java12\usejdbc2.bat,运行这个批处理,在此之前把DB2的服务都停掉。 db2java.zip包,有没有?在lib中。说清楚点! import java.sql.*;import COM.ibm.db2.jdbc.app.DB2Driver;public class DB2Test { public static void main(String[] args){ System.out.println("Hello World!"); try{ Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); java.sql.Connection conn=java.sql.DriverManager.getConnection("jdbc:db2:test","administrator","19781103"); java.sql.Statement stmt=conn.createStatement(); java.sql.ResultSet rs=stmt.executeQuery("select * from users"); while(rs.next()){ System.out.println(rs.getString(2)); } rs.close(); stmt.close(); conn.close(); }catch(Exception e){ System.out.println("Error!can't connect the database!"); } }}上面这个class运行没有问题,但下面的jsp文件运行有问题!<%@ page contentType="text/html; charset=GB2312" %><%@ page import="java.sql.*"%><%@ page import="COM.ibm.db2.jdbc.app.DB2Driver"%><html><head><title>dbtest</title></head><body><% Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); java.sql.Connection conn=java.sql.DriverManager.getConnection("jdbc:db2:test","administrator","19781103"); java.sql.Statement stmt=conn.createStatement(); java.sql.ResultSet rs=stmt.executeQuery("select * from users"); while(rs.next()){ System.out.println(rs.getString(2)); } rs.close(); stmt.close(); conn.close();%></body></html>db2java.zip已经放到lib目录下,并在project的required libraries中加入了这个类!提示的出错信息:Error: 500 Location: /dbtest.jspInternal Servlet Error:org.apache.jasper.JasperException: Unable to compile at org.apache.tomcat.facade.JasperLiaison.javac(JspInterceptor.java:898) at org.apache.tomcat.facade.JasperLiaison.processJspFile(JspInterceptor.java:733) at org.apache.tomcat.facade.JspInterceptor.requestMap(JspInterceptor.java:506) at org.apache.tomcat.core.ContextManager.processRequest(ContextManager.java:968) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:875) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833) at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516) at java.lang.Thread.run(Unknown Source) 请各位帮忙看看?多谢! 一个关于调用的问题 求页面中APPLET弹出窗口解决方案 getResourceAsStream 问题大家来看看, java带数据库企业应用软件用什么发布最合适?? 怎样才能把多个界面连在一起使用? JTABLE中如何让数字右对齐? Java初学者,单位头头出难题了,请帮帮忙! 关于 Java Applet 的几个问题 关于Java语言规范(JLS) 小弟新来乍到,请各位给一点学习java的方法,谢谢了 paintComponent有什么用? JAVA有没有方法操作扫描仪?高分求救
说清楚点!
import COM.ibm.db2.jdbc.app.DB2Driver;public class DB2Test {
public static void main(String[] args){
System.out.println("Hello World!");
try{
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
java.sql.Connection conn=java.sql.DriverManager.getConnection("jdbc:db2:test","administrator","19781103");
java.sql.Statement stmt=conn.createStatement();
java.sql.ResultSet rs=stmt.executeQuery("select * from users");
while(rs.next()){
System.out.println(rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
System.out.println("Error!can't connect the database!");
}
}
}
上面这个class运行没有问题,但下面的jsp文件运行有问题!
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*"%>
<%@ page import="COM.ibm.db2.jdbc.app.DB2Driver"%>
<html>
<head>
<title>
dbtest
</title>
</head>
<body>
<%
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
java.sql.Connection conn=java.sql.DriverManager.getConnection("jdbc:db2:test","administrator","19781103");
java.sql.Statement stmt=conn.createStatement();
java.sql.ResultSet rs=stmt.executeQuery("select * from users");
while(rs.next()){
System.out.println(rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
db2java.zip已经放到lib目录下,并在project的required libraries中加入了这个类!
提示的出错信息:
Error: 500 Location: /dbtest.jspInternal Servlet Error:org.apache.jasper.JasperException: Unable to compile
at org.apache.tomcat.facade.JasperLiaison.javac(JspInterceptor.java:898)
at org.apache.tomcat.facade.JasperLiaison.processJspFile(JspInterceptor.java:733)
at org.apache.tomcat.facade.JspInterceptor.requestMap(JspInterceptor.java:506)
at org.apache.tomcat.core.ContextManager.processRequest(ContextManager.java:968)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:875)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
at java.lang.Thread.run(Unknown Source)
请各位帮忙看看?多谢!