Spring基础10-Dao

1、测试代码

package com.company.controller;

import com.company.entity.User;
import com.company.service.UserService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.List;

/**
 * @古·梦
 * @1.0
 */
public class UserController {
    public static void main(String[] args) throws Exception {
        ApplicationContext ac = new ClassPathXmlApplicationContext("ApplicationContext.xml");
        UserService userService = (UserService) ac.getBean("UserServiceImp");
//        User user = new User();
        user.setUid("u008");
        user.setName("悟空");
        user.setPsw("123456");
        user.setImg("default.jpg");
        userService.updataUser(user);
        userService.deleteUser(user.getUid());
        List<User> userList = userService.selectUser();
        for(User user : userList) {
            System.out.println("uid: " + user.getUid() + "\tname: " + user.getName() + "\tpsw: " + user.getPsw() + "\timg: " + user.getImg());
        }
    }
}

2、服务层接口实现代码

package com.company.service;

import com.company.dao.UserDao;
import com.company.entity.User;

import java.util.List;

/**
 * @古·梦
 * @1.0
 * 用户服务层接口实现
 *
 */
public class UserServiceImp implements UserService{
    private UserDao userDao;

    public UserDao getUserDao() {
        return userDao;
    }

    public void setUserDao(UserDao userDao) {
        this.userDao = userDao;
    }

    @Override
    public void addUser(User user) throws Exception {
        userDao.addUser(user);
    }

    @Override
    public void updataUser(User user) throws Exception {
        userDao.updateUser(user);
    }

    @Override
    public void deleteUser(String uid) throws Exception {
        userDao.deleteUser(uid);
    }

    @Override
    public List<User> selectUser() throws Exception {
        return userDao.selectUser();
    }
}

3、持久层接口实现代码

package com.company.dao;

import com.company.entity.User;
import com.company.entity.UserMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;

/**
 * @古·梦
 * @1.0
 * 用户持久层接口实现
 */
public class UserDaoImp implements UserDao{
    private JdbcTemplate jdbcTemplate;

    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }

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

    @Override
    public void addUser(User user) throws Exception {
        //创建sql语句
        String sql = " insert into user values (?, ?, ?, ?) ";
        //执行sql语句
        jdbcTemplate.update(sql, user.getUid(), user.getName(), user.getPsw(), user.getImg());
    }

    @Override
    public void updateUser(User user) throws Exception {
        //创建sql语句
        String sql = " update user set uid = ? where name = ? ";
        //执行sql语句
        jdbcTemplate.update(sql, user.getUid(), user.getName());
    }

    @Override
    public void deleteUser(String uid) throws Exception {
        //创建sql语句
        String sql = " delete from user where uid = ? ";
        //执行sql语句
        jdbcTemplate.update(sql, uid);
    }

    @Override
    public List<User> selectUser() throws Exception {
        //创建sql语句
        String sql = " select * from user ";
        //执行sql语句
        List<User> userList = jdbcTemplate.query(sql, new UserMapper());
        return userList;
    }

}

4、UserMapper.java   实现 RowMapper

package com.company.entity;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * @古·梦
 * @1.0
 */
public class UserMapper implements RowMapper<User> {
    @Override
    public User mapRow(ResultSet resultSet, int i) throws SQLException {
        //创建映射关系
        User user = new User();
        //获取数据库信息
        String uid = resultSet.getString("uid");
        String name = resultSet.getString("name");
        String psw = resultSet.getString("psw");
        String img = resultSet.getString("img");
        //映射规则
        user.setUid(uid);
        user.setName(name);
        user.setPsw(psw);
        user.setImg(img);
        return user;
    }
}

5、用户

package com.company.entity;

/**
 * @古·梦
 * @1.0
 */
public class User {
    private String uid;
    private String name;
    private String psw;
    private String img;

    public String getUid() {
        return uid;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPsw() {
        return psw;
    }

    public void setPsw(String psw) {
        this.psw = psw;
    }

    public String getImg() {
        return img;
    }

    public void setImg(String img) {
        this.img = img;
    }
}

6、ApplicationContext.xml

<?xml version="1.0" encoding="UTF-8" ?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx.xsd">
    <!-- 创建DriverManagerDataSource(驱动管理数据源) -->
    <bean id="datasourceid" class="org.springframework.jdbc.datasource.DriverManagerDataSource" scope="singleton">
        <property name="url" value="jdbc:mysql://localhost:3306/mydb"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
    </bean>
    <bean id="jdbcTemplateid" class="org.springframework.jdbc.core.JdbcTemplate" scope="singleton">
        <property name="dataSource" ref="datasourceid"/>
    </bean>
    <bean id="UserDaoImpId" class="com.company.dao.UserDaoImp" scope="singleton">
        <property name="jdbcTemplate" ref="jdbcTemplateid"/>
    </bean>
    <bean id="UserServiceImp" class="com.company.service.UserServiceImp" scope="singleton">
        <property name="userDao" ref="UserDaoImpId"/>
    </bean>
</beans>