请问tomcat 下如何用sqlserver2000 for jdbc实现连接池? tomcat没有连接池的。需要第三方连接池工具,如poolman 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你所说的是连接池管理工具,我是通过sqlserver2000的jdbc进行连接,jdbc2.0扩展api中提供了扩展的jar 这是我的server.xml与BlueSite下的web.xml部分配置1.server.xml <Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" docBase="H:/XSchool/BlueSite" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/BlueSite" privileged="true" reloadable="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper"> <Resource name="jdbc/SQLServerDB" auth="Container" type="javax.sql.DataSource" /> <ResourceParams name="jdbc/SQLServerDB"> <parameter> <name>user</name> <value>sa</value> </parameter> <parameter> <name>password</name> <value></value> </parameter> <parameter> <name>driverClassName</name> <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value> </parameter> <parameter> <name>driverName</name> <value>jdbc:microsoft:sqlserver://william:1433;databaseName=cicerp</value> </parameter> </ResourceParams> </Context>2.web.xml <resource-ref> <description> Resource reference to a factory for java.sql.Connection instances that may be used for talking to a particular database that is configured in the server.xml file. </description> <res-ref-name> jdbc/TestJDBC </res-ref-name> <res-type> javax.sql.DataSource </res-type> <res-auth> Container </res-auth> </resource-ref> 3.测试代码<%@ page import="javax.naming.Context" %> <%@ page import="javax.sql.DataSource"%> <%@ page import="javax.naming.InitialContext"%> <%@ page import="java.sql.*"%> <% DataSource ds = null; try{ Context initCtx = new InitialContext(); Context envCtx = (Context) initCtx.lookup("java:comp/env"); ds = (DataSource)envCtx.lookup("jdbc/SQLServerDB"); if(ds!=null) { out.println("Connection is OK!"); Connection dbconn = ds.getConnection(); Statement stmt = dbconn.createStatement(); ResultSet rs = stmt.executeQuery("Select chnname,engname From bd_color"); while (rs.next()) { out.println("ChineseName :"+rs.getString(1)+" EnglishName :"+rs.getString(2)); } rs.close(); stmt.close(); dbconn.close(); } else { out.println("Fail!"); } } catch(Exception ne){ out.println(ne); } %> 注意要将msutil.jar,mssqlserver.jar,msbase.jar拷贝到tomcat\common\lib目录下面,4.0好象找不到web-inf\lib下面的jar java 正则表达式 新浪微博@加链接 JApplet JLable作用域问题 求short转byte[]方法?为啥有的可以,有的不可以? 跪求拉``偶想不出```急死偶了``高手帮帮忙啊```在线等`` 请教如何在spinner中显示十六进制的数?急! 该怎样连接SQL数据库???? 刚开始学java,按照网上的说明,添加了环境变量,配置了UltraEdit-32,出现以下错误…… 各位好,请教关于等号运算符的问题 困惑一整天了 ~~~~~~~ 求助~~~~~~~~ 新手请教 Tocat4.0如何配置数据库连接池? 请问这段初始化代码为什么出错??谢谢
1.server.xml
<Context className="org.apache.catalina.core.StandardContext" cachingAllowed="true" charsetMapperClass="org.apache.catalina.util.CharsetMapper" cookies="true" crossContext="false" debug="0" docBase="H:/XSchool/BlueSite" mapperClass="org.apache.catalina.core.StandardContextMapper" path="/BlueSite" privileged="true" reloadable="false" useNaming="true" wrapperClass="org.apache.catalina.core.StandardWrapper">
<Resource name="jdbc/SQLServerDB" auth="Container" type="javax.sql.DataSource" />
<ResourceParams name="jdbc/SQLServerDB">
<parameter>
<name>user</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:microsoft:sqlserver://william:1433;databaseName=cicerp</value>
</parameter>
</ResourceParams>
</Context>
2.web.xml
<resource-ref>
<description>
Resource reference to a factory for java.sql.Connection
instances that may be used for talking to a particular
database that is configured in the server.xml file.
</description>
<res-ref-name>
jdbc/TestJDBC
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>
3.测试代码
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.sql.*"%> <%
DataSource ds = null;
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource)envCtx.lookup("jdbc/SQLServerDB");
if(ds!=null) {
out.println("Connection is OK!");
Connection dbconn = ds.getConnection();
Statement stmt = dbconn.createStatement();
ResultSet rs = stmt.executeQuery("Select chnname,engname From bd_color");
while (rs.next()) {
out.println("ChineseName :"+rs.getString(1)+" EnglishName :"+rs.getString(2));
}
rs.close();
stmt.close();
dbconn.close();
} else {
out.println("Fail!");
}
} catch(Exception ne){
out.println(ne);
}
%>
注意要将msutil.jar,mssqlserver.jar,msbase.jar拷贝到tomcat\common\lib目录下面,4.0好象找不到web-inf\lib下面的jar