[Turn] Several different usages of SPRINGJDBC

Transferred from: http://vsp.iteye.com/blog/1182887

Spring has made a good encapsulation of JDBC, and I have tried to do the following in my study
Home first to create a DAO interface

Java code

1. Package Com.wys.dao;
3. Public interface Iuserdao {
4. void Save ();
5. }

The first way to get jdbctemplate by inheriting Jdbcdaosupport is to inject jdbctemplate

Java code

2. Package Com.wys.dao.impl;
6. Import Java.util.Map;
10. Import Org.springframework.jdbc.core.support.JdbcDaoSupport;
16. Import Com.wys.dao.IUserDao;
20. Public class Userdaoimpl extends Jdbcdaosupport implements Iuserdao {
26. @Override
28. public Void Save () {
30. String sql = "**********";
32. map<string,?> map = this.getjdbctemplate (). queryForMap (SQL);
34. System.out.println ("Success!");
38. }
46. }

The configuration file is as follows:

Java code

1. <bean id= "JdbcTemplate"   class= "Org.springframework.jdbc.core.JdbcTemplate" >  
2.         <property name= "DataSource"  ref= "DataSource" &NBSP;/>&NBSP;&NBSP;
3.     </bean>  
4.     <bean id=< Span class= "string" > "Userimpdao"  class= " Com.wys.dao.impl.UserDaoImpl ">&NBSP;&NBSP;
5.          <property name= "JdbcTemplate"  ref= " JdbcTemplate "&NBSP;/>&NBSP;&NBSP;
6. </bean>  

JdbcTemplate provides a number of ways to manipulate the database
The second method is to combine the JdbcTemplate, because JdbcTemplate is created to inject datasource, so it only needs to be injected directly into the datasource to

Java code

2. Package Com.wys.dao.impl;
6. Import Java.util.Map;
10. Import Javax.sql.DataSource;
14. Import Org.springframework.context.ApplicationContext;
16. Import Org.springframework.context.support.ClassPathXmlApplicationContext;
18. Import Org.springframework.jdbc.core.JdbcTemplate;
20. Import Org.springframework.jdbc.core.simple.SimpleJdbcTemplate;
22. Import Org.springframework.jdbc.core.support.JdbcDaoSupport;
28. Import Com.wys.dao.IUserDao;
32. Public class Userdao2impl implements Iuserdao {
36. private JdbcTemplate JdbcTemplate;
42. @Override
44. public Void Save () {
48. String sql = "******";
50. map<string,?> map = this.jdbcTemplate.queryForMap (SQL);
54. System.out.println ("Success!");
62. }
64. //Injection DataSource
66. public void Setdatasource (DataSource DataSource) {
68. JdbcTemplate = new JdbcTemplate (DataSource);
70. }
80. }

Configuration file

Java code

1. <bean id="Userimpl2dao" class="Com.wys.dao.impl.UserDao2Impl" >
2. <property name="DataSource" ref="DataSource"/>
3. </bean>

The third approach is to inherit the Simplejdbcdaosupport, which can be obtained through Simplejdbcdaosupport Simplejdbctemplate,simplejdbctemplate also provides a large number of methods to manipulate the database, Because Simplejdbcdaosupport inherits the Jdbcdaosupport, all the methods that can get jdbctemplate,jdbctemplate relative simplejdbctemplate provide more and more advanced operations, As needed, this only needs to be injected directly into the JdbcTemplate, because Simplejdbctemplate is created by JdbcTemplate.

Java code

2. Package Com.wys.dao.impl;
6. Import Java.util.Map;
10. Import Javax.sql.DataSource;
14. Import Org.springframework.context.ApplicationContext;
16. Import Org.springframework.context.support.ClassPathXmlApplicationContext;
18. Import Org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport;
20. Import Org.springframework.jdbc.core.simple.SimpleJdbcTemplate;
22. Import Org.springframework.jdbc.core.support.JdbcDaoSupport;
28. Import Com.wys.dao.IUserDao;
32. Public class Userdao3impl extends Simplejdbcdaosupport implements Iuserdao {
40. @Override
42. public Void Save () {
46. String sql = "* * *";
48. map<string,object> map = this.getsimplejdbctemplate (). queryForMap (SQL); Simplejdbctemplate
50. map<string,object> map2 = this.getjdbctemplate (). queryForMap (SQL); JdbcTemplate
56. System.out.println ("Success!");
60. }
70. }

The configuration is as follows:

Java code

1. <bean id="Userimpl3dao" class="Com.wys.dao.impl.UserDao3Impl" >
2. <property name="JdbcTemplate" ref="JdbcTemplate"/>
3. </bean>

The fourth is a direct combination of simplejdbctemplate, because Simplejdbctemplate is created to be datasource, so it needs to be injected datasource

Java code

2. Package Com.wys.dao.impl;
6. Import Java.util.Map;
10. Import Javax.sql.DataSource;
14. Import Org.springframework.context.ApplicationContext;
16. Import Org.springframework.context.support.ClassPathXmlApplicationContext;
18. Import Org.springframework.jdbc.core.JdbcTemplate;
20. Import Org.springframework.jdbc.core.simple.SimpleJdbcTemplate;
22. Import Org.springframework.jdbc.core.support.JdbcDaoSupport;
28. Import Com.wys.dao.IUserDao;
32. Public class Userdao4impl implements Iuserdao {
36. private simplejdbctemplate JdbcTemplate;
42. @Override
44. public Void Save () {
48. String sql = "******";
50. map<string,?> map = this.jdbcTemplate.queryForMap (SQL);
54. System.out.println ("Success!");
62. }
66. public void Setdatasource (DataSource DataSource) {
68. JdbcTemplate = new Simplejdbctemplate (DataSource);
70. }
80. }

Configuration file:

Java code

1. <bean id="Userimpl4dao" class="Com.wys.dao.impl.UserDao4Impl" >
2. <property name="DataSource" ref="DataSource"/>
3. </bean>

The fifth method is also a group full jdbctemplate, directly injected JdbcTemplate, rather than DataSource, because in JdbcTemplate has been injected datasource

Java code

2. Package Com.wys.dao.impl;
6. Import Java.util.Map;
10. Import Javax.sql.DataSource;
14. Import Org.springframework.context.ApplicationContext;
16. Import Org.springframework.context.support.ClassPathXmlApplicationContext;
18. Import Org.springframework.jdbc.core.JdbcTemplate;
20. Import Org.springframework.jdbc.core.simple.SimpleJdbcTemplate;
22. Import Org.springframework.jdbc.core.support.JdbcDaoSupport;
28. Import Com.wys.dao.IUserDao;
32. Public class Userdao5impl implements Iuserdao {
36. private JdbcTemplate JdbcTemplate;
42. public void Setjdbctemplate (JdbcTemplate jdbctemplate) {
44. this.jdbctemplate = JdbcTemplate;
46. }
54. @Override
56. public Void Save () {
60. String sql = "* * * * *";
62. map<string,?> map = this.jdbcTemplate.queryForMap (SQL);
64. System.out.println ("Success!");
68. }
74. }

Configured as follows

Java code

1. <bean id="JdbcTemplate" class="Org.springframework.jdbc.core.JdbcTemplate" >
2. <property name="DataSource" ref="DataSource"/>
3. </bean>
4. <bean id="Userimpl5dao" class="Com.wys.dao.impl.UserDao5Impl" >
5. <property name="JdbcTemplate" ref="JdbcTemplate"/>
6. </bean>

In fact, there are many methods, the key is to see whether you need to inherit or combination, need to inject the object is what!

[Go] springjdbc several different uses