Guest User

Untitled

a guest
Aug 31st, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. Spring3 - @Autowired
  2. <bean id="JdbcUserDao" class="controller.User.JdbcUserDao">
  3. <property name="dataSource" ref="dataSource"/>
  4. </bean>
  5.  
  6.  
  7. <bean id="dataSource"
  8. class="org.springframework.jdbc.datasource.DriverManagerDataSource"
  9. p:driverClassName="org.apache.derby.jdbc.ClientDriver"
  10. p:url="jdbc:derby://localhost:1527/TodoDb"
  11. p:username="root"
  12. p:password="root" />
  13.  
  14. @Repository
  15. public class JdbcUserDao implements IUserDao {
  16.  
  17. private JdbcTemplate jt;
  18. @Autowired
  19. private DataSource dataSource;
  20.  
  21. public DataSource getDataSource() {
  22. return dataSource;
  23. }
  24.  
  25. public void setDataSource(DataSource dataSource) {
  26. this.dataSource = dataSource;
  27. jt = new JdbcTemplate(this.dataSource);
  28. }
  29.  
  30. public JdbcTemplate getJt() {
  31. return jt;
  32. }
  33.  
  34. public void setJt(JdbcTemplate jt) {
  35. this.jt = jt;
  36. }
  37.  
  38.  
  39. @Override
  40. public List<User> getUsers(final String username, final String password) {
  41. List<User> users = this.jt.query("SELECT username, password FROM USERS",
  42. new RowMapper<User>() {
  43.  
  44. @Override
  45. public User mapRow(ResultSet rs, int i) throws SQLException {
  46. User user = new User();
  47. user.setUsername(rs.getString("username"));
  48. user.setPassword(rs.getString("password"));
  49. return user;
  50. }
  51. });
  52. return users;
  53. }
  54. }
  55.  
  56. <context:annotation-config />
  57.  
  58. <context:component-scan base-package="org.springframework.jdbc.datasource" />
  59.  
  60. <bean class="org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor">
  61. </bean>
Add Comment
Please, Sign In to add comment