共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 `r"+644
4*n#yVb/
1、spring容器自带连接池 6fo3:P*O
'@|_OmcY
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> uA tV".
<property name="driverClassName"> zE T^T5>:
<value>com.mysql.jdbc.Driver</value> C$h<Wt=<
</property> %M
F;`; 1
<property name="url"> B Xms;[
<value>jdbc:mysql://127.0.0.1:3306/test</value> \W5O&G-C
</property> {PP9$>4`l
<property name="username"> .T<=z
<value>admin</value> z
/KK)u(q
</property> GYxM0~:$k
<property name="password"> h0--B]f@
<value/> z}QwP~Z
</property> 8I20*#
</bean> qU2~fNY
Xaz o9J
2、项目中创建连接池(一般利用开源项目) N[]Hc
='ZRfb&
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> zLs|tJOVp
<property name="driverClassName"> "I?Am&>'
<value>com.mysql.jdbc.Driver</value> n9w9JXp;!
</property> 6fH@wQ"wN
<property name="url"> kE>0M9EdH
<value>jdbc:mysql://127.0.0.1:3306/test</value> #4MBoN(3
</property> .;y#
<property name="username"> oF9
-&
<value>admin</value> [ylsz?
</property> oVA?J%EK
<property name="password"> >^q7c8]~g
<value/> 1wzqGmjmt
</property> [${
QzO
</bean> ;{i'#rn{
]V %.I_
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 K8n4oz#z
H1<>NWm!v7
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> 0iULCK
<property name="jndiName"> mK+IEZV<3
<value>java:comp/env/jdbc/TestDB</value> #_lt~^6
</property> N8qDdr9p?c
</bean> GoA4f3
IdYzgDH
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB gmIqT
f
?88[|;b3
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常