共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 n1x3q/~
-f'&JwE0=
1、spring容器自带连接池 0W
1bZPM
!;t6\Z8&
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> pgUjje>#
<property name="driverClassName"> ^c}kVQ\g3
<value>com.mysql.jdbc.Driver</value> Eb'M< ZY
</property> OgK' ~j
<property name="url"> }Oe4wEYN)
<value>jdbc:mysql://127.0.0.1:3306/test</value> HKC&grp
</property> oh:.iL}j
<property name="username"> xNJ*TA[+
<value>admin</value>
J6
A3Hrg
</property> V2yX;u
<property name="password"> {p$X*2ReB
<value/> ;iN[du
</property> ErQGVE;zk
</bean> wgQx.8 h>
L8pKVr
2、项目中创建连接池(一般利用开源项目) NwKj@ Jos
fG@]G9Z
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> M"Y,kA|+
<property name="driverClassName"> pCeCR
<value>com.mysql.jdbc.Driver</value> T0o0_R
</property> +wGvYr
<property name="url"> 7 $Cv=8
<value>jdbc:mysql://127.0.0.1:3306/test</value> fndH]Yp
</property> (AG((eV
<property name="username"> FZ FPzH
<value>admin</value> (F#2z\$;
</property> x45F-w{
<property name="password"> Vc8w[oS
<value/> 5z.Y}
</property> <`BDN
</bean> usU6,
5^{2g^jH6
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 pe!"!xJE
k5X-*^U=V}
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> r+a0.
<property name="jndiName"> 0.~s>xXp
<value>java:comp/env/jdbc/TestDB</value> 0c&DSL}6
</property> $b) k
</bean> U_wIx
*b`1+~p_2
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB TOx@Y$_9Q8
!#4b#l(e6
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常