数据源的配置

以SQL SERVER2005为例，首先把驱动包添加到tomcat目录下的common下的lib，然后在项目目录下的lib也添加进去。写一个配置文件，文件名为context.xml放到META-INF目录下。context.xml文件的内容为：

<?xml version='1.0' encoding='utf-8'?>
<!--
? Licensed to the Apache Software Foundation (ASF) under one or more
? contributor license agreements.? See the NOTICE file distributed with
? this work for additional information regarding copyright ownership.
? The ASF licenses this file to You under the Apache License,Version 2.0
? (the "License"); you may not use this file except in compliance with
? the License.? You may obtain a copy of the License at

????? http://www.apache.org/licenses/LICENSE-2.0

? Unless required by applicable law or agreed to in writing,software
? distributed under the License is distributed on an "AS IS" BASIS,
? WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND,either express or implied.
? See the License for the specific language governing permissions and
? limitations under the License.
-->
<!-- The contents of this file will be loaded for each web application -->
<Context>

??? <!-- Default set of monitored resources -->
??? <WatchedResource>WEB-INF/web.xml</WatchedResource>
?
??? <!-- Uncomment this to disable session persistence across Tomcat restarts -->
??? <!--
??? <Manager pathname="" />
??? -->

??? <!-- Uncomment this to enable Comet connection tacking (provides events
???????? on session expiration as well as webapp lifecycle) -->
??? <!--
??? <Valve className="org.apache.catalina.valves.CometConnectionManagerValve" />
??? -->
<Resource name="jdbc/test"
???????? auth="Container"?????
???????? type="javax.sql.DataSource"?????
???????? driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"?????
???????? url="jdbc:sqlserver://localhost:1433;DatabaseName/=test"?????
???????? username="lp"?????
???????? password="lp"?????
???????? maxActive="2"?????
???????? maxIdle="2"?????
???????? maxWait="30" />
</Context>

?

然后写一个测试类来测试一下，当然了，这个测试类要运行在tomcat服务器下了，所以只能是servlet咯。

在这我就只学主要代码咯：try {
??????????? Context ctx = new InitialContext();
??????????? DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/test");
??????????? Connection conn = ds.getConnection();
??????????? System.out.println("连接获取成功："+conn);
??????? } catch (NamingException e) {
??????????? e.printStackTrace();
??????? } catch (SQLException e) {
??????????? e.printStackTrace();
??????? }

就这么简单咯！加油咯！

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!