<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):一天整理一點(diǎn)東西。。雖然簡單。。但記下來還是有好處的。。
    

    
	
    
	


    
	    
    




    





    


    

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


    

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


		
    	
		
    
			 
		
    
		
    
			
		
    
		
    
			
				
		
    		
	
    	

    



    

				
			
    
		    		
	
    
	
    
		
			


		
	
    

    


    







    
        
	



主站蜘蛛池模板：
日本永久免费a∨在线视频|
美女视频黄免费亚洲|
最近高清中文字幕免费|
亚洲av日韩av综合|
亚洲精品无码你懂的网站|
无码少妇精品一区二区免费动态
|
激情综合亚洲色婷婷五月APP|
麻豆国产人免费人成免费视频|
亚洲阿v天堂在线2017免费|
亚洲人成网址在线观看|
日本免费人成视频播放|
黄色网址在线免费|
亚洲综合无码无在线观看|
亚洲人成图片小说网站|
人禽杂交18禁网站免费|
中文字幕免费视频精品一|
亚洲AV无码乱码麻豆精品国产|
国外亚洲成AV人片在线观看|
欧美大尺寸SUV免费|
国产黄色片免费看|
亚洲欧洲日产国码久在线|
亚洲阿v天堂在线|
国产三级免费电影|
最近免费视频中文字幕大全|
人妖系列免费网站观看|
亚洲人成电影网站色www|
亚洲AV天天做在线观看|
亚洲乱码中文字幕综合234|
国产免费毛不卡片|
免费高清国产视频|
a一级毛片免费高清在线|
亚洲精品成a人在线观看夫|
亚洲美免无码中文字幕在线|
国产成人99久久亚洲综合精品|
成在人线AV无码免费|
少妇人妻偷人精品免费视频|
一个人免费播放在线视频看片|
亚洲大尺度无码无码专线一区|
亚洲码在线中文在线观看|
亚洲AV永久无码精品成人|
亚洲高清无码专区视频|