JSP如何与DB2数据库连接!
我们公司现在用的是IBM公司的DB2数据库。小可不知如何与JSP相连。
不知有没有高人做过。请指点指点。
问题点数：100、回复次数：6Top
1 楼zhaoweiemail（剑心）回复于 2002-07-25 08:31:10 得分 0
testdb2.jsp如下：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();
String url="jdbc:db2://localhost:5000/sample";
//sample为你的数据库名
String user="admin";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
Top
2 楼zhenyang2002（珍阳）回复于 2002-07-25 08:32:24 得分 0
你看看这个，希望对你有帮助（转载）
import java.sql.*;
import java.util.Properties;
public class ConnectionExample {
public static void main(java.lang.String[] args)
{
try {
// This will register the driver with DriverManager. Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
// Declare the connection information.
String system = "system_name";
String userId = "user_id";
String password = "password";
String url = "jdbc:db2://" + system;
// Connect using a user id and password.
Connection connection1 = DriverManager.getConnection(url,userId, password);
// Connect using a properties object.
Properties properties = new Properties ();
properties.put ("user", userId);
properties.put ("password", password);
Connection connection2 = DriverManager.getConnection(url, properties);
// You can also just pass your propertes on the URL.
String connURL = url + ";user=" + userId + ";password=" + password;
Connection connection3 = DriverManager.getConnection(connURL);
// Do processing with your connections....
// Always close your connections when done with them.
connection1.close();
connection2.close();
connection3.close();
} catch (Exception e) {
System.out.println("There was an error...");
e.printStackTrace();
}
}
}Top
3 楼dclfoxman（foxmandcl）回复于 2002-07-25 09:02:24 得分 0
楼上的那位(心）我按的test程序运行，出现了以下错误是什么意思呢？
Error: 500
Location: /temp/DB2/testdb2.jsp
Internal Servlet Error:
javax.servlet.ServletException: com/ibm/db2/jdbc/app/DB2Driver
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:459)
at DB_00032._0002fDB_00032_0002ftestdb_00032_0002ejsptestdb2_jsp_1._jspService(_0002fDB_00032_0002ftestdb_00032_0002ejsptestdb2_jsp_1.java:115)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
Root cause:
java.lang.ClassNotFoundException: com/ibm/db2/jdbc/app/DB2Driver
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120)
at DB_00032._0002fDB_00032_0002ftestdb_00032_0002ejsptestdb2_jsp_1._jspService(_0002fDB_00032_0002ftestdb_00032_0002ejsptestdb2_jsp_1.java:65)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
Top
4 楼dclfoxman（foxmandcl）回复于 2002-07-25 09:04:06 得分 0
珍阳。我看不懂你的程序。程序中的system_name是什么？能不能加点注解。我是新手。Top
5 楼cabin_xp（烈风）回复于 2002-07-25 09:45:58 得分 0
各位大虾谁帮我看看
http://www.csdn.net/expert/topic/898/898876.xml
我快疯了，一定给分！！！
Top
6 楼unicornindeed（柯察金）回复于 2002-09-05 08:29:22 得分 100
我告诉你吧：Top
