Use RowMapper in JdbcTemplate in spring

Use RowMapper in JdbcTemplate in spring Blog Category:

• Spring

Java code

2. Package Com.cxl.demo.dao;
6. Import Java.sql.ResultSet;
8. Import java.sql.SQLException;
10. Import java.util.List;
12. Import Org.springframework.jdbc.core.JdbcTemplate;
14. Import Org.springframework.jdbc.core.RowMapper;
16. Import Com.cxl.demo.entity.User;
18. Public class Userdaoimpl {
20. private JdbcTemplate JdbcTemplate;
24. public void Setjdbctemplate (JdbcTemplate jdbctemplate) {
26. this.jdbctemplate = JdbcTemplate;
28. }
32. Public list<user> Getuserbyname (String username) {
34. String sql = "SELECT * from t_user where username =?";
36. object[] params = new object[] {username};
38. list<user> users = null;
40. /** 
42. * Using the interface implementation class
44. */
46. Users = jdbctemplate.query (sql, params, new Userrowmapper ());
48. /** 
50. * Use anonymous inner class
52. * If the Userrowmapper class is used only once, creating a separate class for it is redundant, you can use the anonymous class
54. * Omitted to write an implementation class
56. */
58. Users = jdbctemplate.query (sql, params,
60. New Rowmapper<user> () {
62. @Override
64. Public User Maprow (ResultSet rs, int rowNum) throws SQLException {
66. User user = new user ();
68. User.setid (Rs.getint ("id"));
70. User.setusername (rs.getstring ("username"));
72. User.setpassword (rs.getstring ("password"));
74. return user;
76. }
78. });
80. return (users ! = null && users.size () > 0)? users: null;
82. }
86. public class Userrowmapper implements rowmapper<user> {
90. @Override
92. Public User Maprow (ResultSet rs, int rowNum) throws SQLException {
94. User user = new user ();
96. User.setid (Rs.getint ("id"));
98. User.setusername (rs.getstring ("username"));
100. User.setpassword (rs.getstring ("password"));
102. return user;
104. }
108. }
110. }

Use RowMapper in JdbcTemplate in spring