jsp怎么和数据库相连??
我用的是tomcat,jdk是1.2.2版本,JDBC是BEA公司的WEBLOGIC5.1,数据库是SQL2000
但是现在和数据库连不上,但是我的JSP能运行,不知道是什么原因,请各位专家帮小弟一个帮,拜托拉
weblogic没有发挥作用,请问怎么能让它运行(我的classth已经设置好)???
<%@ page
language="java"
errorPage="bookStoreErr.jsp"
import="java.sql.*,
java.io.*,
java.text.*,
java.util.*,
xbook.common.*,
xbook.bookstore.*;"
contentType="text/html; charset=Big5" %>
<jsp:useBean id="connPool" scope="application"
class="xbook.common.ConnPool">
<jsp:setProperty name="connPool" property="driverName"
value="weblogic.jdbc.mssqlserver4.Driver" />
<jsp:setProperty name="connPool" property="jdbcURL"
value="jdbc:weblogic:mssqlserver4:bookstoreDB@NTWORKSTATION:1433" />
<jsp:setProperty name="connPool" property="userName"
value="Admin" />
<jsp:setProperty name="connPool" property="password"
value="Admin" />
<jsp:setProperty name="connPool" property="connectionSwitch"
value="on" />
</jsp:useBean>
<jsp:useBean id="sqlBridge" scope="page"
class="xbook.common.SQLBridge" >
<jsp:setProperty name="sqlBridge" property="connPool"
value="<%=connPool%>" />
<jsp:setProperty name="sqlBridge" property="connectionSwitch"
value="on" />
</jsp:useBean>