Spring实现DAO模块

来源：互联网发布：惠州市公安局网络问政编辑：程序博客网时间：2024/05/29 03:26

实现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}

0 0