JavaWeb 数据源总结

最新推荐文章于 2023-10-25 19:54:04 发布

weixin_44129498

最新推荐文章于 2023-10-25 19:54:04 发布

阅读量1.9k

点赞数 1

分类专栏：后端 JavaWeb 数据源文章标签： JavaWeb 数据源

JavaWeb 同时被 3 个专栏收录

42 篇文章 1 订阅

订阅专栏

后端

12 篇文章 1 订阅

订阅专栏

数据源

1 篇文章 0 订阅

订阅专栏

<link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
<title>Tomcat数据源总结 - xiazdong - CSDN博客</title>

    
                <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-e58e15efab.min.css">
        
        <script type="application/ld+json">{"@context":"https:\/\/ziyuan.baidu.com\/contexts\/cambrian.jsonld","@id":"https:\/\/blog.csdn.net\/xiazdong\/article\/details\/6904506","appid":"1563894916825412","title":"Tomcat\u6570\u636e\u6e90\u603b\u7ed3 - xiazdong","images":["http:\/\/hi.csdn.net\/attachment\/201110\/25\/0_1319532694Z3ku.gif"],"pubDate":"2019-06-18T07:52:25"}</script>
    
        <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
    <script type="text/javascript">
    var username = "xiazdong";
    var blog_address = "https://blog.csdn.net/xiazdong";
    var static_host = "https://csdnimg.cn/release/phoenix/";
    var currentUserName = "weixin_44129498";
    var isShowAds = true;
    var isOwner = false;
    var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/xiazdong/article/details/6904506"
    var blogUrl = "https://blog.csdn.net/";

    var curSkin = "skin3-template";
    // 第四范式所需数据
    var articleTitles = "Tomcat数据源总结 - xiazdong";
    
    var nickName = "xiazdong";
    var isCorporate = false;
    var subDomainBlogUrl = "https://blog.csdn.net/"
    var digg_base_url = "https://blog.csdn.net/xiazdong/phoenix/comment";
    var articleDetailUrl = "https://blog.csdn.net/xiazdong/article/details/6904506";
</script>
<script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
<script src="https://csdnimg.cn/rabbit/exposure-click/main-1.0.6.js"></script>
<script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,track/1.2.6/track.js" type="text/javascript"></script>
<link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
<style>
    .MathJax, .MathJax_Message, .MathJax_Preview{
        display: none
    }
</style>

原

Tomcat数据源总结

2011年10月25日 16:49:35 xiazdong 阅读数 5224

一、数据源的由来

JDBC操作主要由以下几步组成：

(1)Class.forName();

(2)Connection con = DriverManager.getConnection();

(3)PreparedStatement stat = con.prepareStatement(sql);

(4)stat.executeQuery();

(5)con.close();

很显然，(1)(2)(5)步是每次JDBC操作都要执行的，重复执行是非常耗时的，因此为了解决重复操作的问题，引入了数据源。

二、数据源介绍

存在一个数据库连接池，在池中存在多个数据库连接，用户对数据库操作时取出一个，用完放回连接池中。

考虑因素：

(1)最小连接数：连接池中最小的连接个数；

(2)最大连接数：连接池中最大连接个数；

(3)最大等待时间：不能连接时最长等待时间；

Tomcat对数据库连接池支持；

三、JNDI（Java Naming Directory Interface）

1.通过DataSource的名字查找对应的DataSource；

2.通过一个DataSource在连接池中获得一个Connection；

四、配置步骤

A 全局数据源的配置

全局数据源意思是配置了一个数据源后任何web应用都能够访问。

(1)将数据库的驱动程序复制到tomcat\lib中；

(2)在server.xml中加入：

<Context path="/Test" docBase="E:\JAVA WEB" reloadable="true"> 
<Resource name="jdbc/xiazdong" 
auth="Container"
type="javax.sql.DataSource"
maxActive="100" 
maxIdle="30" 
maxWait="10000" 
username="root"
password="123456"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/xiazdong"/>
</Context>

(3)在web.xml中加入：

<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/xiazdong</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

B 局部数据源配置

(1)将驱动器复制到tomcat/lib中;

(2)在conf/catalina/localhost/test.xml中添加：

	<Resource name="jdbc/test" auth="Container"
		type="javax.sql.DataSource"
		driverClassName="com.mysql.jdbc.Driver"
		url="jdbc:mysql://localhost:3306/javaee"
		username="root" password="12345" maxActive="5"
		maxIdle="2" maxWait="10000"/>

作为<Context>的子元素;

五、主要操作步骤

import javax.naming.*;

import javax.sql.*;

import java.sql*;

Context ctx = new InitialContext();

DataSource ds = ctx.lookup("java:comp/env/jdbc/xiazdong");

Connection con = ds.getConnection();

可以很清楚的看出，从以上代码完全看不出操作的是哪个数据库，配置都在配置文件中；

展开阅读全文

<div class="comment-edit-box d-flex">
	<a id="commentsedit"></a>
	<div class="user-img">
		<a href="//me.csdn.net/weixin_44129498" target="_blank">
			<img class="" src="https://avatar.csdn.net/A/A/B/3_weixin_44129498.jpg">
		</a>
	</div>
	<form id="commentform">
		<input type="hidden" id="comment_replyId">
		<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
		<div class="opt-box"> <!-- d-flex -->
			<div id="ubbtools" class="add_code">
				<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
			</div>
			<input type="hidden" id="comment_replyId" name="comment_replyId">
			<input type="hidden" id="article_id" name="article_id" value="6904506">
			<input type="hidden" id="comment_userId" name="comment_userId" value="">
			<input type="hidden" id="commentId" name="commentId" value="">
			<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-mod="popu_384"><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
			<div class="dropdown" id="myDrap">
				<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
				<div class="txt-selected text-truncate">添加代码片</div>
				<svg class="icon d-block" aria-hidden="true">
					<use xlink:href="#csdnc-triangledown"></use>
				</svg>
				</a>
				<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
					<li><a data-code="html">HTML/XML</a></li>
					<li><a data-code="objc">objective-c</a></li>
					<li><a data-code="ruby">Ruby</a></li>
					<li><a data-code="php">PHP</a></li>
					<li><a data-code="csharp">C</a></li>
					<li><a data-code="cpp">C++</a></li>
					<li><a data-code="javascript">JavaScript</a></li>
					<li><a data-code="python">Python</a></li>
					<li><a data-code="java">Java</a></li>
					<li><a data-code="css">CSS</a></li>
					<li><a data-code="sql">SQL</a></li>
					<li><a data-code="plain">其它</a></li>
				</ul>
			</div>  
			<div class="right-box">
				<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
				<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
			</div>
		</div>
	</form>
</div>

	<div class="comment-list-container">
	<a id="comments"></a>
	<div class="comment-list-box">
	</div>
	<div id="commentPage" class="pagination-box d-none"></div>
	<div class="opt-box text-center">
		<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
	</div>
</div>

<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-78","con":",,"}' data-track-click='{"mod":"kp_popu_59-78","con":",,"}'><script type="text/javascript">
(function() {
    var s = "_" + Math.random().toString(36).slice(2);
    document.write('<div style="" id="' + s + '"></div>');
    (window.slotbydup = window.slotbydup || []).push({
        id: "u3491668",
        container:  s
    });
})();

<div class="recommend-item-box  recommend-download-box clearfix"  data-track-click='{"mod":"popu_387","con":",https://download.csdn.net/download/tangxiucai2/1327990,BlogCommendFromQuerySearch_5"}'>
	<a href="https://download.csdn.net/download/tangxiucai2/1327990" target="_blank">
		<div class="content clearfix">
			<div class="">
				<h4 class="text-truncate oneline clearfix">
					<em>Tomcat</em> jndi 配置<em>数据源</em>过程					</h4>
				<span class="data float-right">05-19</span>
			</div>
			<div class="desc oneline">
					Tomcat jndi 配置数据源过程

Tomcat jndi 配置数据源过程
Tomcat jndi 配置数据源过程
Tomcat jndi 配置数据源过程
下载

<div class="recommend-item-box  recommend-download-box clearfix"  data-track-click='{"mod":"popu_387","con":",https://download.csdn.net/download/lichongda/4212202,BlogCommendFromQuerySearch_6"}'>
	<a href="https://download.csdn.net/download/lichongda/4212202" target="_blank">
		<div class="content clearfix">
			<div class="">
				<h4 class="text-truncate oneline clearfix">
					java连接池的配置					</h4>
				<span class="data float-right">04-09</span>
			</div>
			<div class="desc oneline">
					java连接池的配置 里面有C3P0连接池在tomcat中的详细配置

Java反射机制总结，tomcat下配置数据库连接池DBCP、C3P0、Proxool
总结spring下配置dbcp,c3p0,proxool数据源链接池
下载

<div class="recommend-item-box  recommend-download-box clearfix"  data-track-click='{"mod":"popu_387","con":",https://download.csdn.net/download/cyg2039/741821,BlogCommendFromQuerySearch_8"}'>
	<a href="https://download.csdn.net/download/cyg2039/741821" target="_blank">
		<div class="content clearfix">
			<div class="">
				<h4 class="text-truncate oneline clearfix">
					<em>TOMCAT</em> 中的<em>数据源</em>配置					</h4>
				<span class="data float-right">11-01</span>
			</div>
			<div class="desc oneline">
					用于在tomcat中配置java数据源用于在tomcat中配置java数据源用于在tomcat中配置java数据源用于在tomcat中配置java数据源用于在tomcat中配置java数据源。				</div>
			<span class="type-show type-show-download">下载</span>
		</div>
	</a>
</div>

<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-894","con":"4031363307469455793,https://edu.csdn.net/course/detail/8606,"}' data-track-click='{"mod":"kp_popu_60-894","con":"4031363307469455793,https://edu.csdn.net/course/detail/8606,"}'><link rel="stylesheet" href="https://www.csdn.net/company/css/edu-recommend-1.0.1.css">

		<div class="recommend-item-box blog-expert-recommend-box">
		<div class="d-flex">
			<div class="blog-expert-recommend">
				<div class="blog-expert">
					<div class="blog-expert-flexbox"></div>
				</div>
			</div>
		</div>
	</div>

<div class="recommend-item-box recommend-ad-box"><script type="text/javascript" src="//rabc1.iteye.com/production/res/rxjg.js?pkcgstj=jm"></script></div>

<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-1062","con":",,"}' data-track-click='{"mod":"kp_popu_62-1062","con":",,"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/237?positionId=62&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>

<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>

<div class="recommend-item-box  recommend-download-box clearfix"  data-track-click='{"mod":"popu_387","con":",https://download.csdn.net/download/y1170328179s/9742461,BlogCommendFromQuerySearch_25"}'>
	<a href="https://download.csdn.net/download/y1170328179s/9742461" target="_blank">
		<div class="content clearfix">
			<div class="">
				<h4 class="text-truncate oneline clearfix">
					<em>tomcat</em><em>数据源</em>配置文档					</h4>
				<span class="data float-right">01-20</span>
			</div>
			<div class="desc oneline">
					tomcat数tomcat数据源配置文档				</div>
			<span class="type-show type-show-download">下载</span>
		</div>
	</a>
</div>

<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-1060","con":",,"}' data-track-click='{"mod":"kp_popu_64-1060","con":",,"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/235?positionId=64&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>

<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-1061","con":",,"}' data-track-click='{"mod":"kp_popu_65-1061","con":",,"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/236?positionId=65&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>

<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-881","con":",,"}' data-track-click='{"mod":"kp_popu_66-881","con":",,"}'><script src="https://nbrecsys.4paradigm.com/resource/cus/csdn/sdk-csdn-render.js"></script>

<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-882","con":",,"}' data-track-click='{"mod":"kp_popu_67-882","con":",,"}'><script src="https://nbrecsys.4paradigm.com/resource/cus/csdn/sdk-csdn-render.js"></script>

<div class="recommend-item-box  recommend-download-box clearfix"  data-track-click='{"mod":"popu_387","con":",https://download.csdn.net/download/a0984/10634294,BlogCommendFromQuerySearch_45"}'>
	<a href="https://download.csdn.net/download/a0984/10634294" target="_blank">
		<div class="content clearfix">
			<div class="">
				<h4 class="text-truncate oneline clearfix">
					<em>tomcat</em>8 JNDI<em>数据源</em>加密					</h4>
				<span class="data float-right">08-29</span>
			</div>
			<div class="desc oneline">
					TOMCAT8

JNDI对用户名和密码加密
下载

<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-883","con":",,"}' data-track-click='{"mod":"kp_popu_68-883","con":",,"}'><!-- T48 位置 -->

<div class="recommend-item-box  recommend-download-box clearfix"  data-track-click='{"mod":"popu_387","con":",https://download.csdn.net/download/xixitj/10230852,BlogCommendFromQuerySearch_49"}'>
	<a href="https://download.csdn.net/download/xixitj/10230852" target="_blank">
		<div class="content clearfix">
			<div class="">
				<h4 class="text-truncate oneline clearfix">
					<em>tomcat</em>8设置MySQL<em>数据源</em>					</h4>
				<span class="data float-right">01-30</span>
			</div>
			<div class="desc oneline">
					Tomcat8配置数据源的方法有三种，以MySQL数据库为例说明				</div>
			<span class="type-show type-show-download">下载</span>
		</div>
	</a>
</div>

http://www.pythonware.com/products/pil/

2.解压后，进入到目录下

cd /Users/jianan/Dow…

博文
来自：专注于cocos+unity+服务器全栈

DirectX修复工具最新版：DirectX Repair V3.8 增强版NEW!

版本号：V3.8.0.11638

大小: 107MB/7z格式压缩，189MB…

博文
来自： VBcom的专栏

看到网上基本没有最新的chromedriver与chrome的对应关系表，便兴起整理…

博文
来自：灰蓝

本文承接之前发布的博客《微信支付V3微信公众号支付PHP教程/thinkPHP5公众号支付》必须阅读上篇文章后才可以阅读这篇文章。由于最近一段时间工作比较忙，…

博文
来自： Marswill

分享一个大神的人工智能教程。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到人工智能的队伍中来！http://www.captainbed.net/strongerhuang

推荐…

博文
来自： strongerHuang的专栏

最近需要网页添加多个倒计时. 查阅网络,基本上都是千遍一律的不好用. 自己按需写了个.希望对大家有用. 有用请赞一个哦!

//js
…

博文
来自： Websites

需要安装手机端跟电脑端，手机端跟电脑端必须处于同一网络，在windows系统下运行。

电脑端下载地址：下载地址1 下载地址2 下载地址…

博文

使用tarjan算法在嵌套的多个环中优先得到最大环( 最小环就是每个孤立点）

定义：
int Ti…

博文
来自：九野的博客

测试集和训练集3、7分组
australian …

博文
来自： Tiaaaaa的博客

            <div class="recommend-item-box type_hot_word">
                            <div class="content clearfix">
                <div class="word float-left">
                                                        <span>
                    <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                    机器学习教程                    </a></span>
                                                                            <span>
                    <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                    Objective-C培训                    </a></span>
                                                                            <span>
                    <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                    交互设计视频教程                    </a></span>
                                                                            <span>
                    <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                    颜色模型                    </a></span>
                                                                            <span>
                    <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                    设计制作学习                    </a></span>
                                                        </div>
            </div>
                                            </div>
                        <div class="recommend-loading-box">
            <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
        </div>
        <div class="recommend-end-box">
            <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
        </div>
    </div>
</main>

<aside>
<div id="asideProfile" class="aside-box">
<!-- <h3 class="aside-title">个人资料</h3> -->
<div class="profile-intro d-flex">
    <div class="avatar-box d-flex justify-content-center flex-column">
        <a href="https://blog.csdn.net/xiazdong">
          <img src="https://avatar.csdn.net/1/3/6/3_xiazdong.jpg" class="avatar_pic">
                          <img src="https://g.csdnimg.cn/static/user-reg-year/1x/9.png" class="user-years">
                      </a>
        
    </div>
    <div class="user-info d-flex justify-content-center flex-column">
        <p class="name csdn-tracking-statistics tracking-click" data-mod="popu_379">
            <a href="https://blog.csdn.net/xiazdong" target="_blank" class="" id="uid">xiazdong</a>
        </p>
                </div>
            <div class="opt-box d-flex justify-content-center flex-column">
        <span  class="csdn-tracking-statistics tracking-click" data-mod="popu_379">
            <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
        </span>
    </div>
        </div>
<div class="data-info d-flex item-tiling">
            <dl class="text-center" title="443">
                    <dt><a href="https://blog.csdn.net/xiazdong?t=1">原创</a></dt>
        <dd><a href="https://blog.csdn.net/xiazdong?t=1"><span class="count">443</span></a></dd>
                </dl>
    <dl class="text-center" id="fanBox" title="2398">
        <dt>粉丝</dt>
        <dd><span class="count" id="fan">2398</span></dd>
    </dl>
    <dl class="text-center" title="159">
        <dt>喜欢</dt>
        <dd><span class="count">159</span></dd>
    </dl>
    <dl class="text-center" title="764">
        <dt>评论</dt>
        <dd><span class="count">764</span></dd>
    </dl>
</div>
<div class="grade-box clearfix">
    <dl>
        <dt>等级：</dt>
        <dd>
            <a href="https://blog.csdn.net/home/help.html#level" title="8级,点击查看等级说明" target="_blank">
                <svg class="icon icon-level" aria-hidden="true">
                    <use xlink:href="#csdnc-bloglevel-8"></use>
                </svg>
            </a>
        </dd>
    </dl>
    <dl>
        <dt>访问：</dt>
        <dd title="4231230">
            423万+            </dd>
    </dl>
    <dl>
        <dt>积分：</dt>
        <dd title="32435">
            3万+            </dd>
    </dl>
    <dl title="259">
        <dt>排名：</dt>
        <dd>259</dd>
    </dl>
</div>
</div>