Spring's Namedparameterjdbctemplate

The Namedparameterjdbctemplate class is based on the JdbcTemplate class and encapsulates it to support named parameter attributes.

Namedparameterjdbctemplate provides the following three main methods: Execute method, Query and Queryforxxx method, update and BatchUpdate method.

First, let's look at an example:

Java code:Java Code

2. @Test
4. Public void TestNamedParameterJdbcTemplate1 () {
6. Namedparameterjdbctemplate namedparameterjdbctemplate = null;
8. Namedparameterjdbctemplate =
10. New Namedparameterjdbctemplate (DataSource);
12. Namedparameterjdbctemplate =
14. New Namedparameterjdbctemplate (JdbcTemplate);
16. String insertsql = "INSERT into test (name) VALUES (: Name)";
18. String selectsql = "SELECT * from Test where name=:name";
20. String deletesql = "Delete from Test where name=:name";
22. map<string, object> parammap = new hashmap<string, object> ();
24. Parammap.put ("name", "Name5");
26. Namedparameterjdbctemplate.update (Insertsql, Parammap);
28. final list<integer> result = new arraylist<integer> ();
30. Namedparameterjdbctemplate.query (Selectsql, Parammap,
32. New RowCallbackHandler () {
34. @Override
36. public void Processrow (ResultSet rs) throws SQLException {
38. Result.add (Rs.getint ("id"));
40. }
42. });
44. Assert.assertequals (1, result.size ());
46. Sqlparametersource Paramsource = new Mapsqlparametersource (PARAMMAP);
48. Namedparameterjdbctemplate.update (Deletesql, Paramsource);
50. }

Now let's analyze the code:

1) namedparameterjdbctemplate initialization : can use DataSource or JdbcTemplate object as constructor parameter initialization;

2) insert into test (name) values: where ": Name" is the named parameter;

3) Update (Insertsql, Parammap): where Parammap is a map type that contains key-value pairs with the key "name" and a value of "Name5", which is the data that sets the value for the named parameter;

4) query (Selectsql, Parammap, New RowCallbackHandler () ...) : similar to the one described in JdbcTemplate, the only difference is the need to pass in Parammap to set a value for a named parameter;

5) Update (Deletesql, Paramsource): similar to "Update (Insertsql, Parammap)", but use the Sqlparametersource parameter to set a value for the named parameter, This is implemented here using the Mapsqlparametersource, which is the simple encapsulation java.util.Map.

The Namedparameterjdbctemplate class has two ways of setting values for named parameters: Java.util.Map and Sqlparametersource:

1) Java.util.Map: Use the map key data for named parameters, while map value data is used to set values;

2) Sqlparametersource: You can use the Sqlparametersource implementation as a parameter to set values for named parameters, The default is Mapsqlparametersource and Beanpropertysqlparametersource implementations; the Mapsqlparametersource implementation is very simple, Just encapsulates the JAVA.UTIL.MAP; Beanpropertysqlparametersource encapsulates a JavaBean object that determines the value of a named parameter by JavaBean object properties.

Java code:Java Code

1. Package cn.javass.spring.chapter7;
2. Public class Usermodel {
3. private int id;
4. private String MyName;
5. //Omit getter and setter
6. }

Java code:Java Code

2. @Test
4. Public void TestNamedParameterJdbcTemplate2 () {
6. Namedparameterjdbctemplate namedparameterjdbctemplate = null;
8. Namedparameterjdbctemplate = new Namedparameterjdbctemplate (JdbcTemplate);
10. Usermodel model = new Usermodel ();
12. Model.setmyname ("Name5");
14. String insertsql = "INSERT into test (name) VALUES (: MyName)";
16. Sqlparametersource Paramsource = new Beanpropertysqlparametersource (model);
18. Namedparameterjdbctemplate.update (Insertsql, Paramsource);
20. }

You can see that beanpropertysqlparametersource use can reduce a lot of effort, but the named parameter must correspond to the JavaBean property name.

Spring namedparameterjdbctemplate (ext.)