Summary of RowMapper implementation in Spring JdbcTemplate Query method

The RowMapper in sping can encapsulate each row of data in the data into a user-defined class.

In database queries, if the type returned is a user-defined type (in fact, most of the classes we return in a database query are custom-defined), we need to wrap it if it is a Java-custom type, such as a string.

If Sping is combined with hibernate, it is basically not available, and most of them are used when spring is used alone.

The RowMapper interface can be implemented by establishing an internal class, and there is a Maprow method in the RowMapper, so the RowMapper interface must implement the Maprow method, and the wrapper of the custom class is implemented in the Maprow method.

Here is a simple example:

public class Testdao {
Private JdbcTemplate JT;
public void Setjt (JdbcTemplate JT) {
THIS.JT = JT;
}
Public list<tnpc> GetAll () {
String sql = "SELECT * from T_NPC";
Use
List List = Jt.query (sql, New Npcrowmapper ());
return list;
}
/**
* Define inner class implementation RowMapper interface
*/
public class Npcrowmapper implements rowmapper{
Implementing the Maprow Method
Public Object Maprow (ResultSet rs, int num) throws SQLException {
To encapsulate a class
TNPC NPC = new TNpc ();
Npc.setid (Rs.getlong ("id"));
Npc.setname (rs.getstring ("name"));
return NPC;
}
}
}

Java Code

2. Implement the RowMapper interface by building an inline class internally
4. Package Hysteria.contact.dao.impl;
8. Import Java.sql.ResultSet;
10. Import java.sql.SQLException;
12. Import Java.sql.Types;
14. Import java.util.List;
18. Import Org.springframework.jdbc.core.JdbcTemplate;
20. Import Org.springframework.jdbc.core.RowMapper;
24. Import Hysteria.contact.dao.ItemDAO;
26. Import Hysteria.contact.domain.Item;
30. Public class Itemdaoimpl implements Itemdao {
32. private JdbcTemplate JdbcTemplate;
36. public void Setjdbctemplate (JdbcTemplate jdbctemplate) {
38. this.jdbctemplate = JdbcTemplate;
40. }
44. Public Item Insert (item item) {
46. String sql = "INSERT into items (user_id,name,phone,email) VALUES (?,?,?,?)";
48. object[] params = new Object[]{item.getuserid (), Item.getname (), Item.getphone (), Item.getemail ()};
50. int[] types = new Int[]{types.integer,types.varchar,types.char,types.varchar};
52. Jdbctemplate.update (sql,params,types);
54. return item;
56. }
60. Public Item Update (item item) {
62. String sql = "UPDATE items SET name =?, phone =?, email =?" WHERE id =? ";
64. object[] params = new object[] {item.getname (), Item.getphone (), Item.getemail (), Item.getid ()};
66. int[] types = new int[] {Types.varchar,types.char,types.varchar,types.varchar,types.integer};
68. Jdbctemplate.update (sql,params,types);
72. return item;
74. }
78. public void Delete (item item) {
80. String sql = "DELETE from items WHERE id =?";
82. object[] params = new object[] {item.getid ()};
84. int[] types = new Int[]{types.integer};
86. Jdbctemplate.update (sql,params,types);
88. }
92. Public Item FindByID (int id) {
94. String sql = "SELECT * from items WHERE id =?";
96. object[] params = new object[] {ID};
98. int[] types = new int[] {Types.integer};
100. List items = jdbctemplate.query (sql,params,types,new Itemmapper ());
102. if (Items.isempty ()) {
104. return null;
106. }
108. return (Item) Items.get (0);
110. }
114. Public list<item> FindAll () {
116. String sql = "SELECT * from Items";
118. return jdbctemplate.query (SQL,new Itemmapper ());
120. }
126. Public list<item> findallbyuser (int user_id) {
128. String sql = "SELECT * from items WHERE user_id =?";
130. object[] params = new object[]{user_id};
132. int[] types = new Int[]{types.integer};
134. List items = jdbctemplate.query (sql,params,types,new Itemmapper ());
136. return items;
138. }
142. protected class Itemmapper implements RowMapper {
146. Public Object Maprow (ResultSet rs, int rowNum) throws SQLException {
148. Item item = new Item ();
150. Item.setid (Rs.getint ("id"));
152. Item.setuserid (Rs.getint ("user_id"));
154. Item.setname (rs.getstring ("name"));
156. Item.setphone (rs.getstring ("Phone"));
158. Item.setemail (rs.getstring ("email"));
162. return item;
164. }
168. }
174. }