Mybatis(二)

一、目录结构

二、代码

1、UserDao

package cn.bijian.dao;

import cn.bijian.model.User;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserDao {
    /*
    查询所有User
     */
//    @Select("select * from user")
    List<User> findAll();
    /*
    根据id查User
     */
    User findById(Integer id);
    /*
    保存用户
     */
    int saveUser(User user);
    /*
    更新用户
     */
    int updateUser(User user);
    /*
    删除用户
     */
    int deleteUser(Integer id);
    /*
    模糊查询用户
     */
    List<User> findByName(String username);
    /*
    查询总记录条数
     */
    int findTotal();
}

2、UserDao.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="cn.bijian.dao.UserDao">
    <select id="findAll" resultType="cn.bijian.model.User">
        select * from User;
    </select>

    <select id="findById" parameterType="int" resultType="cn.bijian.model.User">
        select * from User where id = #{id}
    </select>

    <insert id="saveUser" parameterType="cn.bijian.model.User">
        insert into user(username,birthday,sex,address) values (#{username},#{birthday},#{sex},#{address})
        <selectKey keyColumn="id" keyProperty="id" resultType="int">select last_insert_id();</selectKey>
    </insert>

    <update id="updateUser" parameterType="cn.bijian.model.User">
        update user set username=#{username},birthday=#{birthday},sex=#{sex},address=#{address} where id=#{id}
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from user where id=#{id}
    </delete>

    <select id="findByName" parameterType="string" resultType="cn.bijian.model.User">
        select * from user where username like #{username}
        <!--select * from user where username like '%${value}%'-->
    </select>

    <select id="findTotal" resultType="int">
        select count(*) from user;
    </select>
</mapper>

3、MybatisCURDTest

package cn.bijian.test;

import cn.bijian.dao.UserDao;
import cn.bijian.model.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.Date;
import java.util.List;

public class MybatisCURDTest {
    private InputStream in;
    private SqlSessionFactory sessionFactory;
    private SqlSession session;
    private UserDao userDao;

    @Test
    public void testFindById(){
        User user = userDao.findById(43);
        System.out.println(user);
    }

    @Test
    public void testSaveUser(){
        User user = new User();
        user.setUsername("李四");
        user.setBirthday(new Date());
        user.setSex("男");
        user.setAddress("兰州");
        userDao.saveUser(user);
        Integer id = user.getId();
        System.out.println(id);
    }

    @Test
    public void testUpdateUser(){
        User user = userDao.findById(64);
        user.setAddress("兰州123");
        int res = userDao.updateUser(user);
        System.out.println(res);
    }

    @Test
    public void testDeleteUser(){
        int res = userDao.deleteUser(64);
        System.out.println(res);
    }

    @Test
    public void testFindByName(){
        List<User> users = userDao.findByName("%王%");
//        List<User> users = userDao.findByName("王");
        for (User user:users) {
            System.out.println(user);
        }
    }

    @Test
    public void testFindTotal(){
        int total = userDao.findTotal();
        System.out.println(total);
    }

    @Before
    public void init() throws IOException {
        in = Resources.getResourceAsStream("SqlMapConfig.xml");
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        sessionFactory = builder.build(in);
        session = sessionFactory.openSession();
        userDao = session.getMapper(UserDao.class);
    }

    @After
    public void destroy() throws IOException {
        session.commit();
        session.close();
        in.close();
    }
}