Spring实现DAO模块

实现dao模块

1、 编写实体类
2、 在配置文件中bean.xml添加配置信息。
3、 添加数据库驱动jar包
4、 编写dao类
5、 将jdbcTemplate注入到dao中即配置bean.xml
6、 编写测试类

public class AdminUser {
    private int uid;
    private String username;
    private String password;

    public AdminUser() {
    }

    public AdminUser(int uid, String username, String password) {
        this.uid = uid;
        this.username = username;
        this.password = password;
    }

    public int getUid() {
        return uid;
    }

    public void setUid(int uid) {
        this.uid = uid;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "AdminUser{" + "uid=" + uid + ", username=" + username + ", password=" + password + '}';
    }

}

添加配置

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://node1:3306/temp" />
        <property name="username" value="hive" />
        <property name="password" value="hive" />
    </bean>

    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource" />
    </bean>

DAO类

public class AdminUserDAO {
    private JdbcTemplate jdbcTemplate;

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public AdminUser findAdminUserNameAndPassword(String username, String password) {
        AdminUser adminUser = null;
        String sql = "select uid, username, password from adminuser where username = ? and password = ?";
        Object[] obs = new Object[]{username, password};
        List<Map<String, Object>> list = jdbcTemplate.queryForList(sql, obs);
        if(!list.isEmpty()) {
            Map<String, Object> map = list.get(0);
            adminUser= new AdminUser((Integer)map.get("uid"), username, password);
        } 
        return adminUser;
    }
}

添加配置

    <bean id="adminUserDAO" class="dao.AdminUserDAO">
        <property name="jdbcTemplate" ref="jdbcTemplate" />
    </bean>

测试类

    public static void main(String[] args) {
        ApplicationContext context = new ClassPathXmlApplicationContext("/config/beans.xml");
        AdminUserDAO adminUserDAO = (AdminUserDAO)context.getBean("adminUserDAO");
        AdminUser user = adminUserDAO.findAdminUserNameAndPassword("q", "123");
        System.out.println(user);
    }

结果

AdminUser{uid=1, username=xiaoming, password=123}