Spring DBCP is configured in XML and Properties2 formats DataSource

Spring provides database connection pooling: Dbcp configures DataSource and obtains connection completion database operations: Address of the Spring Help document: http://static.springsource.org/spring/docs/2.5.6/ reference/beans.html#  Beans-value-element the jar package that needs to be imported: Commons-dbcp.jarcommons-pool.jarmysql-connector-java-5.0-nightly-20071116-bin.jar 1. First configure the data source within the container [HTML] View plain copy

1. <!--configuring data sources-
2. <bean id= "myDataSource" class= "Org.apache.commons.dbcp.BasicDataSource" destroy-method= "Close" >
3. <property name= "Driverclassname" value= "Com.mysql.jdbc.Driver"/>
4. <property name= "url" value= "Jdbc:mysql://localhost:3306/sms"/>
5. <property name= "username" value= "root"/>
6. <property name= "Password" value= "root"/>
7. </bean>

2. Get the injected data source and write operations on the database [Java] View plain copy

2. @Component ("UserService")
4. public class Userserviceimpl implements userservice{
6. Private Userdao Userdao;
8. public void Setuserdao (Userdao Userdao) {
10. This.userdao = Userdao;
12. }
14. @Resource//resource Injection
16. Private DataSource myDataSource;
18. Public DataSource Getmydatasource () {
20. return mydatasource;
22. }
24. public void Setmydatasource (DataSource mydatasource) {
26. This.mydatasource = myDataSource;
28. }
30. In the preceding method, add the logical
32. public void Save () {
34. try{
36. Get the connection to perform the operation
38. Connection conn = Mydatasource.getconnection ();
40. Conn.createstatement (). Execute ("INSERT INTO dept values (' 6 ', ' Bumen2 ')");
42. }catch (Exception e) {
44. E.printstacktrace ();
46. }
48. }
50. }

3. Test run [Java] View plain copy

1. @Test
2. public void test01 () {
3. Beanfactory ApplicationContext = new Classpathxmlapplicationcontext (
4. "Beans.xml");
5. UserService user = (UserService) applicationcontext.getbean ("UserService");
6. User.save ();
7. }

--------------------------------------------------------------------------------------------------------------- -------------------Configure the Datasource:1 of XML by the properties, write the properties file: [HTML] View plain copy

1. Jdbc.driverclassname=com.mysql.jdbc.driver
2. Jdbc.url=jdbc:mysql://localhost:3306/sms
3. Jdbc.username=root
4. Jdbc.password=root

2. Writing XML container configuration: [HTML] View plain copy

2. <!--placeholder Placeholder--
4. <bean
6. class= "Org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" >
8. <property name= "Locations" >
10. <value>classpath:jdbc.properties</value>
12. </property>
14. </bean>
18. <bean id= "DataSource" destroy-method= "Close"
20. class= "Org.apache.commons.dbcp.BasicDataSource" >
22. <property name= "Driverclassname" value= "${jdbc.driverclassname}"/>
24. <property name= "url" value= "${jdbc.url}"/>
26. <property name= "username" value= "${jdbc.username}"/>
28. <property name= "Password" value= "${jdbc.password}"/>
30. </bean>

Spring DBCP is configured in XML and Properties2 formats DataSource