<rt id="bn8ez"></rt>
<label id="bn8ez"></label>
  • 

    • <span id="bn8ez"></span>
    

    <label id="bn8ez"><meter id="bn8ez"></meter></label>
    

    
    

    




    







												


        



    
	
    
		
			

    

    
	
    
		
			
        明月松間照 清泉石上流
    
			
                                            ——— 兵臨城下   貓科動物
		    		
	
    

    

    

    
	
    

    posts - 70, comments - 137, trackbacks - 0, articles - 23
    
	
 
BlogJava ::
首頁 ::
新隨筆 ::
聯(lián)系 ::
聚合
 ::
管理


    
		    		
	
    
	
    
		
			
    
			
    
		    		
		
			
    
				
					
	
    
		
		
    
		
		
    
				
    ?
    
				
    1.在server.xml中加入。
    這可以登陸后臺配置。。
    
				
    
						
						?
						<!--
						??configure?DataSource.?Add?the?following?code?into?server.xml??
						-->
						?
    ?
    ?    
						<
						?Context?
						path?
						=?"?/test?"
						??docBase?
						=?"test?"
						??debug?
						=?"?0?"
						?
    reloadable?    
						=?"?true?"
						???
						>
						?
    ?
    ?
    ???    
						<
						?Resource?
						name?
						=?"?jdbc/first?"
						?
    ???????????????auth?    
						=?"?Container?"
						?
    ???????????????type?    
						=?"?javax.sql.DataSource?"
						???
						/>
						?
    ?
    ???    
						<
						?ResourceParams?
						name?
						=?"?jdbc/first?"
						?
						>
						?
    ?????    
						<
						?parameter?
						>
						?
    ???????    
						<
						?name?
						>
						?factory?
						</
						?name?
						>
						?
    ???????    
						<
						?value?
						>
						?org.apache.commons.dbcp.BasicDataSourceFactory?
						</
						?value?
						>
						?
    ?????    
						</
						?parameter?
						>
						?
    ?
    ?????    
						<!--
						??Maximum?number?of?dB?connections?in?pool.?Make?sure?you
    ?????????configure?your?mysqld?max_connections?large?enough?to?handle
    ?????????all?of?your?db?connections.?Set?to??0???for??no?limit.
    ??????????    
						-->
						?
    ?????    
						<
						?parameter?
						>
						?
    ???????    
						<
						?name?
						>
						?maxActive?
						</
						?name?
						>
						?
    ???????    
						<
						?value?
						>
						?100?
						</
						?value?
						>
						?
    ?????    
						</
						?parameter?
						>
						?
    ?
    ?????    
						<!--
						??Maximum?number?of?idle?dB?connections?to?retain?in?pool.
    ?????????Set?to??0???for??no?limit.
    ??????????    
						-->
						?
    ?????    
						<
						?parameter?
						>
						?
    ???????    
						<
						?name?
						>
						?maxIdle?
						</
						?name?
						>
						?
    ???????    
						<
						?value?
						>
						?30?
						</
						?value?
						>
						?
    ?????    
						</
						?parameter?
						>
						?
    ?
    ?????    
						<!--
						??Maximum?time?to?wait??for??a?dB?connection?to?become?available
    ?????????in?ms,?in??this??example??10??seconds.?An?Exception?is?thrown??if?
    ??????????this??timeout?is?exceeded.??Set?to??-?1??to?wait?indefinitely.
    ????????Maximum?time?to?wait??for??a?dB?connection?to?become?available
    ?????????in?ms,?in??this??example??10??seconds.?An?Exception?is?thrown??if?
    ??????????this??timeout?is?exceeded.??Set?to??-?1??to?wait?indefinitely.
    ??????????    
						-->
						?
    ?????    
						<
						?parameter?
						>
						?
    ???????    
						<
						?name?
						>
						?maxWait?
						</
						?name?
						>
						?
    ???????    
						<
						?value?
						>
						?10000?
						</
						?value?
						>
						?
    ?????    
						</
						?parameter?
						>
						?
    ?
    ?????    
						<!--
						??MySQL?dB?username?and?password??for??dB?connections???
						-->
						?
    ?????    
						<
						?parameter?
						>
						?
    ??????    
						<
						?name?
						>
						?username?
						</
						?name?
						>
						?
    ??????    
						<
						?value?
						>
						?dbuser?
						</
						?value?
						>
						?
    ?????    
						</
						?parameter?
						>
						?
    ?????    
						<
						?parameter?
						>
						?
    ??????    
						<
						?name?
						>
						?password?
						</
						?name?
						>
						?
    ??????    
						<
						?value?
						>
						?1234?
						</
						?value?
						>
						?
    ?????    
						</
						?parameter?
						>
						?
    ?
    ?????    
						<!--
						??Class?name??for??mm.mysql?JDBC?driver??
						-->
						?
    ?????    
						<
						?parameter?
						>
						?
    ????????    
						<
						?name?
						>
						?driverClassName?
						</
						?name?
						>
						?
    ????????    
						<
						?value?
						>
						?com.mysql.jdbc.Driver?
						</
						?value?
						>
						?
    ?????    
						</
						?parameter?
						>
						?
    ?
    ?????    
						<!--
						??The?JDBC?connection?url??for??connecting?to?your?MySQL?dB.
    ?????????The?autoReconnect?=?true??argument?to?the?url?makes?sure?that?the
    ?????????mm.mysql?JDBC?Driver?will?automatically?reconnect??if??mysqld?closed?the
    ?????????connection.??mysqld?by??default??closes?idle?connections?after??8??hours.
    ??????????    
						-->
						?
    ?????    
						<
						?parameter?
						>
						?
    ???????    
						<
						?name?
						>
						?url?
						</
						?name?
						>
						?
    ???????    
						<
						?value?
						>
						?jdbc:mysql:?//?localhost:3306/test?autoReconnect=true
						</
						value
						>
						?
    ??????    
						</
						?parameter?
						>
						?
    ???    
						</
						?ResourceParams?
						>
						?
    ?
    ?    
						</
						?Context?
						>
						?
    
				
    
				
    在工程web-xml中加入以下代碼

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


    jsp 訪問。。

    導(dǎo)包
    <%@?page?import="java.util.*"%>
    <%@?page?import="java.sql.*"%>
    <%@?page?import="javax.sql.*"%>
    <%@?page?import="javax.naming.*"%>
    <%@?page?import="com.mysql.jdbc.Connection"%>

    訪問代碼


    //建立數(shù)據(jù)庫連接
    Context?ctx?=?new?InitialContext();
    DataSource?ds?    =(DataSource)ctx.lookup("java:comp/env/jdbc/test");
    con?    =?ds.getConnection();
    //創(chuàng)建一個JDBC聲明
    stmt?=?con.createStatement();

    //有了連接。。就可以做很多事了。。


    注意把mysql驅(qū)動拷到comcat common/lib下面..


    目標(biāo):一天整理一點東西。。雖然簡單。。但記下來還是有好處的。。
    

    
	
    
	


    
	    
    




    





    


    

	
    
		
    
				
		
	
		
    
		
		
    只有注冊用戶登錄后才能發(fā)表評論。
    
		
    
			
		
    
			
		
    
		
		
    
		


    

		    		
		
    
		
    			
		
		
		
		
    
		
    
		
		
    
		
    
			網(wǎng)站導(dǎo)航:
		
		
    
		
    
			


		
    	
		
    
			 
		
    
		
    
			
		
    
		
    
			
				
		
    		
	
    	

    



    

				
			
    
		    		
	
    
	
    
		
			


		
	
    

    


    







    
        
	



主站蜘蛛池模板：
亚洲精品亚洲人成人网|
国产自产拍精品视频免费看|
亚洲人成图片小说网站|
西西人体大胆免费视频|
又黄又爽的视频免费看|
男女猛烈无遮掩视频免费软件|
国产一区二区视频免费|
一道本在线免费视频|
国产亚洲av人片在线观看|
h视频在线观看免费|
亚洲VA中文字幕无码一二三区
|
久久精品亚洲AV久久久无码|
青青视频观看免费99|
亚洲午夜精品久久久久久app|
国产精品va无码免费麻豆|
人禽伦免费交视频播放|
亚洲熟女少妇一区二区|
91高清免费国产自产拍2021|
亚洲人成影院在线高清|
日韩免费在线观看|
久久免费视频一区|
亚洲欧洲校园自拍都市|
永久免费bbbbbb视频|
一二三区免费视频|
亚洲无圣光一区二区|
日本一道一区二区免费看
|
亚洲中文无码av永久|
香蕉高清免费永久在线视频|
色婷婷综合缴情综免费观看
|
国产亚洲福利一区二区免费看|
fc2成年免费共享视频网站|
亚洲国产一区二区三区青草影视|
毛片a级毛片免费观看品善网|
无遮挡国产高潮视频免费观看|
久久久影院亚洲精品|
免费网站看v片在线香蕉|
两个人日本WWW免费版
|
亚洲精品无码久久久久牙蜜区|
亚洲夜夜欢A∨一区二区三区
|
亚洲精品国产摄像头|
国产AV无码专区亚洲AWWW|