共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 b7~Jl+m
H.'9]*
1、spring容器自带连接池 1r}i[5
I9>vm]
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> Haekr*1%
<property name="driverClassName"> ~_ZK93o(
<value>com.mysql.jdbc.Driver</value> ge6S_"
</property> =N{?ll6x7g
<property name="url"> :l!sKT?:d!
<value>jdbc:mysql://127.0.0.1:3306/test</value> l>pB\<LL
</property> xRhGBb{@s
<property name="username"> oq!\100
<value>admin</value> K\XQE50
</property> :(m, 06K
<property name="password"> ]y=U"g
<value/> ?Fny_{&^H
</property> 9lR6:}L7
</bean> V;"2=)X
V:J|shRo
2、项目中创建连接池(一般利用开源项目) 'q |"+;
c$2kR:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> z~3ubta8(@
<property name="driverClassName"> Ax;?~v4Z
<value>com.mysql.jdbc.Driver</value> 4dCXBTT
</property> I]+
zG
<property name="url"> .FgeAxflP
<value>jdbc:mysql://127.0.0.1:3306/test</value> )j~{P
</property> K{/i2^4
<property name="username"> 8~R.iqLoX
<value>admin</value> e@0|fB%2
</property> knG:6tQ
<property name="password"> O TlqJ
<value/> 1+N'cB!y
</property> i7r)9^y
</bean> 8Nyz{T[
'iZwM>l\
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 [ij) k@.
JQ0Z%;"
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> LTo!DUi`
<property name="jndiName"> stUv!
<value>java:comp/env/jdbc/TestDB</value> hLgX0QV
</property> [m
h>N$
</bean> `^hA &/1
:.XlAQR~b
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB
~,&8)1
f>C+ l(
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常