Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Spring3 - @Autowired
- <bean id="JdbcUserDao" class="controller.User.JdbcUserDao">
- <property name="dataSource" ref="dataSource"/>
- </bean>
- <bean id="dataSource"
- class="org.springframework.jdbc.datasource.DriverManagerDataSource"
- p:driverClassName="org.apache.derby.jdbc.ClientDriver"
- p:url="jdbc:derby://localhost:1527/TodoDb"
- p:username="root"
- p:password="root" />
- @Repository
- public class JdbcUserDao implements IUserDao {
- private JdbcTemplate jt;
- @Autowired
- private DataSource dataSource;
- public DataSource getDataSource() {
- return dataSource;
- }
- public void setDataSource(DataSource dataSource) {
- this.dataSource = dataSource;
- jt = new JdbcTemplate(this.dataSource);
- }
- public JdbcTemplate getJt() {
- return jt;
- }
- public void setJt(JdbcTemplate jt) {
- this.jt = jt;
- }
- @Override
- public List<User> getUsers(final String username, final String password) {
- List<User> users = this.jt.query("SELECT username, password FROM USERS",
- new RowMapper<User>() {
- @Override
- public User mapRow(ResultSet rs, int i) throws SQLException {
- User user = new User();
- user.setUsername(rs.getString("username"));
- user.setPassword(rs.getString("password"));
- return user;
- }
- });
- return users;
- }
- }
- <context:annotation-config />
- <context:component-scan base-package="org.springframework.jdbc.datasource" />
- <bean class="org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor">
- </bean>
Add Comment
Please, Sign In to add comment