JavaÖÐJNDIµÄÅäÖÃ
·½°¸Ò»²½Ö裺
1¡¢ÅäÖÃTomcat\conf\context.xmlÌí¼Ó <Resource>
<Resource name="jdbc/books" auth="Container"
type="javax.sql.DataSource" maxActive="100" maxIdle="30"
maxWait="10000" username="sa" password=""
driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;DatabaseName=books" />
name Ö¸¶¨ResourceµÄJNDIÃû³Æ
auth Ö¸¶¨¹ÜÀíResourceµÄManager£¨Container:ÓÉÈÝÆ÷´´½¨ºÍ¹ÜÀí|Application£ºÓÉWebÓ¦Óô´½¨ºÍ¹ÜÀí£©
type Ö¸¶¨ResourceËùÊôµÄJavaÀà
maxActive Ö¸¶¨Á¬½Ó³ØÖд¦Óڻ״̬µÄÊý¾Ý¿âÁ¬½ÓµÄ×î´óÊýÄ¿
maxIdle Ö¸¶¨Á¬½Ó³ØÖд¦ÓÚ¿ÕÏÐ״̬µÄÊý¾Ý¿âÁ¬½ÓµÄ×î´óÊýÄ¿
maxWait Ö¸¶¨Á¬½Ó³ØÖеÄÁ¬½Ó´¦ÓÚ¿ÕÏеÄ×ʱ¼ä£¬³¬¹ýÕâ¸öʱ¼ä»áÅ׳öÒì³££¬È¡ÖµÎª-1£¬±íʾ¿ÉÒÔÎÞÏÞÆÚµÈ´ý
2¡¢¿½±´ÏàÓ¦µÄjar°üµ½Tomcat\common\libÖÐ
/server/libĿ¼ÏµÄjarÎļþÖ»Äܱ»Tomcat·þÎñÆ÷·ÃÎÊ
/shared/libĿ¼ÏµÄjarÎļþ¿ÉÒÔ±»ËùÓеÄwebÓ¦ÓóÌÐò·ÃÎÊ£¬µ«²»Äܱ»Tomcat·þÎñÆ÷·ÃÎÊ
/common/libĿ¼ÏµÄjarÎļþ¿ÉÒÔ±»Tomcat·þÎñÆ÷ºÍËùÓеÄwebÓ¦ÓóÌÐò·ÃÎÊ¡£
3¡¢ÅäÖÃwebÏîÄ¿ÖеÄweb.xmlÌí¼Ó <resourc-ref>
<resource-ref>
<res-ref-name>jdbc/books</res-ref-name> Ö¸¶¨JNDIµÄÃû×Ö£¬Óë<Resource>ÔªËØÖеÄnameÒ»ÖÂ
<res-type>javax.sql.DataSource</res-type> Ö¸¶¨ÒýÓÃ×ÊÔ´µÄÀàÃû£¬Óë<Resource>ÔªËØÖеÄtypeÒ»ÖÂ
<res-auth>Container</res-auth> Ö¸¶¨¹ÜÀíËùÒýÓÃ×ÊÔ´µÄManagerÓë<Resource>ÔªËØÖеÄauthÒ»ÖÂ
</resource-ref>
4¡¢java´úÂë
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
//»ñÈ¡Co
Ïà¹ØÎĵµ£º
ÏÈÉùÃ÷һϣ¬ÌâĿԳöÓÚ£ºhttp://gocom.primeton.com/modules/newbb/item60284_60284.htm
JVMÊÇJava³ÌÐòµÄÔËÐл·¾³£¬Òò´Ë¶ÔÓÚJVMµÄÕÆÎÕÓÐÖúÓÚÀí½âJava³ÌÐòµÄÖ´ÐÐÒÔ¼°±àд£¬ÓÈÆäÊÇÔËÐÐʱÅöµ½µÄһЩ¹îÒìÎÊÌ⣬ÄÇôÔõôÑùÄÜ¿¼²ì×Ô¼º¶ÔÓÚJVM¹Ø¼ü֪ʶµãµÄÕÆÎÕÇé¿ö£¬°ïÖúѧϰJVM»úÖÆÄØ£¬ÔÚÕâÆªblogÖÐÀ´Ì½ÌÖÏ¡£
¶ÔÓÚJava³ÌÐò¶øÑ ......
Òë×¢
£º±¾ÎÄÀ´×Ôstraight_talking_java@yahoogroups.comÌÖÂÛ×飬ÒѾÊÇÒ»Äê¶àǰ
µÄÎÄÕ¡£Alan WilliamsonÊÇJava Developers
JournalµÄ±à¼£¬ÏÂÎÄÀ´×ÔËûÔÚIBMµÄÒ»¸öÏûÏ¢À´Ô´¡£SWTºÍSwingµÄÂÛÕùÎÒ¼û¹ý²»ÉÙ£¬NetbeansºÍEclipseµÄҲͬÑù¶à¡£ÒëÕß·Òë
´ËÎIJ¢²»ÊÇÒª¼¤ÆðʲôÕùÖ´£¬Ò²²»ÊÇÖ§³ÖÄÄÒ»·½£¨ËäÈ»ÎÒµÄÈ·ÊÇÕ¾ÔÚSWTÒ»±ßµ ......
package com.huawei.globe;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
public class CrossConectionContextSheet
{
CrossCalition cc = new CrossCalition();
&nbs ......