共分spring容器自带连接池、项目中创建连接池、服务器创建连接池三种 yF(9=z"?
i'li;xUhZ
1、spring容器自带连接池 _y[C52,
5kw
K%
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> `{!A1xKZ
<property name="driverClassName"> `[5xncZ-
<value>com.mysql.jdbc.Driver</value> LHA^uuBN}
</property> n#x_da-m]
<property name="url"> vU,7Y|t`
<value>jdbc:mysql://127.0.0.1:3306/test</value> X1(ds*'Kv
</property> K +vD&Z^
<property name="username"> 'Hx#DhiFz
<value>admin</value> "b`#RohCi
</property> dP_QkO
<property name="password"> w>j5oz}
<value/> d]e36Dwk
</property> 1rZ E2
</bean> 6ioj!w<N
w{DU<e:
2、项目中创建连接池(一般利用开源项目) LSc^3=X
6"G(Iq'2t3
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> &*OwoTgk+
<property name="driverClassName"> Oh1U=V2~
<value>com.mysql.jdbc.Driver</value> `3\U9ZH23
</property> 5
NYS@76o7
<property name="url"> >KuNHuHu
<value>jdbc:mysql://127.0.0.1:3306/test</value> #).^k-
</property> o4p5`jOG@
<property name="username"> ivgX o'=
<value>admin</value> f?.VVlD
</property> M
_<
|n
<property name="password"> 5V/&4$.U!
<value/> NW6;7nWb
</property> lVT*Ev{&.
</bean> k_}$d{X
dY}5Kmt
3、应用服务器创建数据源,项目中通过jndi访问,以tomcat为例 A[m?^vk q
>I@&"&d
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> tZ[9qms^_
<property name="jndiName"> 0x~+=GUN
<value>java:comp/env/jdbc/TestDB</value> CrI<rD%'
</property> t`Bk2Cc)+
</bean> mh"PA p
,]0BmlD
注意每种容器的jndi写法不同,所以java:comp/env/jdbc/TestDB为其全称,但在配置jndi时可能会是其中一部分,如tomcat配置jdbc/TestDB %TFsk
;U4O` pZ
配置错误会报javax.naming.NameNotFoundException: Name jdbc is not bound in this Context异常