Spring之基于注解实现IOC配置（四）

一、添加依赖

 <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.2.8.RELEASE</version>
        </dependency>

       <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.2.8.RELEASE</version>
        </dependency>
        
        <dependency>
            <groupId>commons-dbutils</groupId>
            <artifactId>commons-dbutils</artifactId>
            <version>1.7</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>

        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.1.2</version>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13</version>
        </dependency>
    </dependencies>

二、准备数据

create table user(
	id int primary key auto_increment,
	name varchar(20),
	age int
)character set utf8 collate utf8_general_ci;

insert into user(name,age) values('大白',23);
insert into user(name,age) values('小白',33);
insert into user(name,age) values('黑白',22);

三、编写代码

1.编写实体类

/**
 * 用户实体类
 */
public class User implements Serializable {

    private Integer id;
    private String name;
    private Integer age;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }
    
    
    public Integer getAge() {
        return age;
    }
    
    public void setAge(Integer age) {
        this.age = age;
    }
    
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                '}';
    }
}

2.编写持久层

/**
 * 用户持久层接口
 */
public interface IUserDao {

    /**
     * 查询所有
     * @return
     */
    List<User> findAllUser();

    /**
     * 查询某一个
     * @param  userId
     * @return User
     */
    User findUserById(Integer userId);

    /**
     * 保存用户信息
     * @param user
     */
    void saveUser(User user);

    /**
     * 更新用户信息
     * @param user
     */
    void updateUser(User user);

    /**
     * 删除某个用户
     * @param userId
     */
    void deleteUser(Integer userId);
}


/**
 * 用户持久层实现类
 */
@Repository(value = "userDao")
public class UserDaoImpl implements IUserDao {

    @Autowired
    private QueryRunner runner;

    @Override
    public List<User> findAllUser() {
        try{
            return runner.query("select * from user",new BeanListHandler<User>(User.class));
        }catch (Exception e) {
            throw new RuntimeException(e);
        }
    }

    @Override
    public User findUserById(Integer userId) {
        try{
            return runner.query("select * from user where id = ? ",new BeanHandler<User>(User.class),userId);
        }catch (Exception e) {
            throw new RuntimeException(e);
        }
    }

    @Override
    public void saveUser(User user) {
        try{
            runner.update("insert into user(name,age)values(?,?)", user.getName(), user.getAge());
        }catch (Exception e) {
            throw new RuntimeException(e);
        }
    }

    @Override
    public void updateUser(User user) {
        try{
            runner.update("update user set name=?,age=? where id=?", user.getName(), user.getAge(), user.getId());
        }catch (Exception e) {
            throw new RuntimeException(e);
        }
    }

    @Override
    public void deleteUser(Integer userId) {
        try{
            runner.update("delete from user where id=?",userId);
        }catch (Exception e) {
            throw new RuntimeException(e);
        }
    }
}

3.编写业务层

/**
 * 用户业务层接口
 */
public interface IUserService {

    /**
     * 查询所有
     * @return
     */
    List<User> findAllUser();

    /**
     * 查询某个
     * @param userId
     * @return User
     */
    User findUserById(Integer userId);

    /**
     * 保存用户信息
     * @param user
     */
    void saveUser(User user);

    /**
     * 更新用户信息
     * @param user
     */
    void updateUser(User user);

    /**
     * 删除某个
     * @param userId
     */
    void deleteUser(Integer userId);


}
/**
 * 用户业务层实现类
 */
@Service(value = "userService")
public class UserServiceImpl implements IUserService {

    @Autowired
    //@Qualifier("userDao1")
    private IUserDao userDao;

  // @Resource
  // private UserDao userDao2;
    
    @Override
    public List<User> findAllUser() {
        return userDao.findAllUser();
    }

    @Override
    public User findUserById(Integer userId) {
        return userDao.findUserById(userId);
    }

    @Override
    public void saveUser(User user) {
        userDao.saveUser(user);
    }

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

    @Override
    public void deleteUser(Integer userId) {
        userDao.deleteUser(userId);
    }
}

四、配置bean.xml文件

添加名称为context名称空间和约束（有所需要的标签）

  xmlns:context="http://www.springframework.org/schema/context"
  http://www.springframework.org/schema/context/spring-context.xsd">

<?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"
       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">

    <!-- 配置扫描的包 -->
    <context:component-scan base-package="cn.ybzy"></context:component-scan>
    <!--配置QueryRunner-->
    <bean id="runner" class="org.apache.commons.dbutils.QueryRunner" scope="prototype">
        <!--注入数据源-->
        <constructor-arg name="ds" ref="dataSource"></constructor-arg>
    </bean>

    <!-- 配置数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <!--配置数据库的信息-->
        <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/demo"></property>
        <property name="user" value="root"></property>
        <property name="password" value="123456"></property>
    </bean>
</beans>

五、编写测试

/**
 * Junit单元测试
 */
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:bean.xml")
public class UserServiceTest {

    @Autowired
    private IUserService userService;

   @Test
    public void testFindAll() {
        List<User> users = userService.findAllUser();
        for(User user : users){
            System.out.println(user);
        }
    }

    @Test
    public void testFindOne() {
        User user = userService.findUserById(1);
        System.out.println(user);
    }

    @Test
    public void testSave() {
        User user = new User();
        user.setName("小红");
        user.setAge(12);
        userService.saveUser(user);

    }

    @Test
    public void testUpdate() {
        User user = userService.findUserById(1);
        user.setAge(55);
        userService.updateUser(user);
    }

    @Test
    public void testDelete() {
        userService.deleteUser(1);
    }
}