Mybatis使用xml配置下，实现的CRUD操作

Dao中IUserDao中的代码

package com.itheima.dao;

import com.itheima.domain.QueryVo;
import com.itheima.domain.User;

import java.util.List;

public interface IUserDao {
    /**
     * 查询所有
     * @return
     */
    List<User> findAll();

    /**
     * 通过id用户
     * @return
     */
    User findOneById(Integer id);

    /**
     * 添加用户
     * @param user
     */
    void addUser(User user);

    /**
     * 删除用户
     * @param id
     */
    void delUser(Integer id);

    /**
     * 通过名字模糊查询
     * @param name
     * @return
     */
    List<User> findUserByName(String name);

    /**
     * 更新用户
     * @param user
     */
    void UpdatUset(User user);

    /**
     * 根据queryVo中的条件查询用户
     * @param vo
     * @return
     */
    List<User> findUserByVo(QueryVo vo);
}

domain中User代码

package com.itheima.domain;

import java.io.Serializable;
import java.util.Date;

public class User implements Serializable {
    private Integer id;
    private String username;
    private Date birthday;
    private String sex;
    private String address;

    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

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

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", birthday=" + birthday +
                ", sex='" + sex + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

domain中QueryVo代码

package com.itheima.domain;

/**
 * @author 黑马程序员
 * @Company http://www.ithiema.com
 */
public class QueryVo {

    private User user;

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }
}

jdbcConfig.properties配置信息

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/eesy
jdbc.username=root
jdbc.password=root

主配置信息SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<!--              以上是约束                -->
<!--mybatis的主配置文件-->
<configuration>
   <!-- 配置properties可以在标签内部配置连接数据库的信息。也可以通过属性引用外部配置文件信息-->
    <properties resource="jdbcConfig.properties"></properties>
    <!--<properties url="file:///E:/IdeaProjects/mybatis/day02_mybatis_CRUD/src/main/resources/jdbcConfig.properties"></properties>-->
    <typeAliases>
        <!-- 用于指定要配置别名的包，当指定之后，该包下的实体类都会注册别名，并且类名就是别名，不再区分大小写-->
        <package name="com.itheima.domain"></package>
    </typeAliases>
    <!--配置环境-->
    <environments default="mysql"><!--default选择使用的环境-->
        <!--配置mysql的环境-->
        <environment id="mysql">
            <!--配置事物的类型-->
            <transactionManager type="JDBC"></transactionManager>
            <!--配置数据源(连接池)-->
            <dataSource type="POOLED">
                <!--配置数据库的四个基本信息,key与jdbc配置文件中的key保持一致-->
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>

    <!--指定映射配置文件的位置-->
    <mappers>
        <!-- package标签是用于指定dao接口所在的包,当指定了之后就不需要在写mapper以及resource或者class了 -->
        <package name="com.itheima.dao"></package>
    </mappers>
</configuration>

IuserDao.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="com.itheima.dao.IUserDao">
    <!--查询所有，resultType返回值类型为user-->
    <select id="findAll" resultType="user">
        SELECT * FROM user;
    </select>

    <select id="findOneById" resultType="user">
        SELECT * FROM user WHERE id = #{id};
    </select>
    <!--添加用户，参数类型为user-->
    <insert id="addUser" parameterType="user">
        /*查询添加用户的id(自增)，keyProperty对应domain的属性名，keyColumn对应数据库列名，order在操作完成之后还是以前*/
        <selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">
            SELECT last_insert_id()
        </selectKey>
        INSERT INTO user(username,birthday,sex,address) VALUES (#{username},#{birthday},#{sex},#{address})
    </insert>

    <delete id="delUser" parameterType="int">
        DELETE FROM user where id = #{uid};
    </delete>

    <select id="findUserByName" parameterType="string" resultType="user">
        SELECT * FROM user where username LIKE #{username};
    </select>

    <update id="UpdatUset" parameterType="user">
        UPDATE user SET username=#{username},address=#{address},sex=#{sex},birthday=#{birthday} where id=#{id};
    </update>

    <!-- 根据queryVo的条件查询用户 -->
    <select id="findUserByVo" parameterType="QueryVo" resultType="user">
        select * from user where username like #{user.username}
    </select>
</mapper>

测试：
package com.itheima.test;

import com.itheima.dao.IUserDao;
import com.itheima.domain.QueryVo;
import com.itheima.domain.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 Mybatis {
private InputStream is;
private SqlSession session;
private IUserDao userDao;

@Before
public void init() throws IOException {
    //读取配置文件
    is = Resources.getResourceAsStream("SqlMapConfig.xml");
    //创建创建者
    SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    //创建工厂
    SqlSessionFactory factory = builder.build(is);
    //打开session
    session = factory.openSession();
    //创建实例化
    userDao = session.getMapper(IUserDao.class);
}

@After
public void destroy() throws IOException {
    //提交事务，默认不提交，执行会回滚
    session.commit();
    //释放资源
    session.close();
    is.close();;
}


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

@Test
public void testFindOne(){
    User user = userDao.findOneById(46);
    System.out.println(user);
}

@Test
public void testAddUser(){
    User user = new User();
    user.setUsername("张三");
    user.setBirthday(new Date());
    user.setSex("男");
    user.setAddress("济南");
    System.out.println(user);
    userDao.addUser(user);
    System.out.println(user);
}

@Test
public void testDelUser(){
    userDao.delUser(49);
}

@Test
public void testFindUserByName(){
    List<User> users = userDao.findUserByName("%王%");
    for (User user : users) {
        System.out.println(user);
    }
}
@Test
public void testUpdatUser(){
    User user = new User();
    user.setId(41);
    user.setUsername("张三");
    user.setBirthday(new Date());
    user.setSex("男");
    user.setAddress("济南");
    userDao.UpdatUset(user);
}

/**
 * 测试使用QueryVo作为查询条件
 */
@Test
public void testFindByVo(){
    QueryVo vo = new QueryVo();
    User user = new User();
    user.setUsername("%王%");
    vo.setUser(user);
    //5.执行查询一个方法
    List<User> users = userDao.findUserByVo(vo);
    for(User u : users){
        System.out.println(u);
    }
}

}