Mybatis的增删改查操作举例1

数据库连接池和映射配置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">
<configuration>
    <!-- 配置环境 -->
    <environments default="mysql">
        <!-- 配置mysql的环境-->
        <environment id="mysql">
            <!-- 配置事务的类型-->
            <transactionManager type="JDBC"></transactionManager>
            <!-- 配置数据源（连接池） -->
            <dataSource type="POOLED">
                <!-- 配置连接数据库的4个基本信息 -->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/test_2?characterEncoding=utf-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>

    <!-- 指定映射配置文件的位置，映射配置文件指的是每个dao独立的配置文件 -->
    <mappers>
        <mapper resource="ypy/dao/IUserDao.xml"/>
    </mappers>
</configuration>

用户表:

用户类（后期用户标准化用户信息）：

package ypy.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 + '\'' +
                '}';
    }
}

用户dao接口：

package ypy.dao;

import ypy.domain.User;
import java.util.List;

public interface IUserDao {
    /**
     * 功能描述:查询所有用户信息
     * @Param:null
     * @return :
     * @author : yupeiyang
     * @date : 2020/3/10 17:17
     */
    List<User> findAll();
    
    /**
     * 功能描述:保存用户信息
     * @Param: user
     * @return : 
     * @author : yupeiyang
     * @date : 2020/3/10 17:35
     */
    void saveUser(User user);

    /**
     * 功能描述:更新用户信息
     * @Param: user
     * @return :
     * @author : yupeiyang
     * @date : 2020/3/10 18:30
     */
    void updateUser(User user);

    /**
     * 功能描述:删除用户信息
     * @Param: useid
     * @return :
     * @author : yupeiyang
     * @date : 2020/3/10 18:30
     */
    void deleteUser(Integer id);
}

用户dao接口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="ypy.dao.IUserDao">
    <!--配置查询所有-->
    <select id="findAll" resultType="ypy.domain.User">
        select * from user
    </select>

    <!-- 添加用户信息 -->
    <insert id="saveUser" parameterType="ypy.domain.User">
        insert into user(username,address,sex,birthday)values(#{username},#{address},#{sex},#{birthday});
    </insert>

    <!-- 更新用户 -->
    <update id="updateUser" parameterType="ypy.domain.User">
        update user set username=#{username},address=#{address},sex=#{sex},birthday=#{birthday} where id=#{id}
    </update>

    <!-- 删除用户信息 -->
    <delete id="deleteUser" parameterType="java.lang.Integer">
        delete from user where id=#{userid};
    </delete>
</mapper>

Mybatis测试代码：

package ypy.test;

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 ypy.dao.IUserDao;
import ypy.domain.User;
import java.io.InputStream;
import java.util.Date;
import java.util.List;

public class MybatiesTest {
    private InputStream in = null;
    private SqlSession session = null;
    private IUserDao userDao = null;

    @Before
    public void init() throws Exception{
        //读取配置文件
        in = Resources.getResourceAsStream("SqlMapConfig.xml");
        //创建SqlSessionFactory工厂
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
        //使用工厂生产SqlSession对象
        session = factory.openSession();
        //使用SqlSession创建Dao接口的代理对象
        userDao = session.getMapper(IUserDao.class);
    }

    @After
    public void destory() throws Exception{
        session.close();
        in.close();
    }

    /**
     * 功能描述:测试查询所有
     * @Param:
     * @return :
     * @author : yupeiyang
     * @date : 2020/3/10 17:25
     */
    @Test
    public void testfindAll(){
        //使用代理对象执行方法
        List<User> users = userDao.findAll();
        for(User user:users){
            System.out.println(user);
        }
    }

    @Test
    public void testSave(){
        User user = new User();
        user.setUsername("王文娟");
        user.setAddress("安徽利辛");
        user.setSex("女");
        user.setBirthday(new Date());

        //使用代理对象保存数据
        userDao.saveUser(user);
        //提交事务
        session.commit();
    }

    @Test
    public void testUpdate(){
        User user = new User();
        user.setId(46);
        user.setUsername("李白");
        user.setAddress("小亚细亚");
        user.setSex("男");
        user.setBirthday(new Date());

        //使用代理对象保存数据
        userDao.updateUser(user);
        //提交事务
        session.commit();
    }

    @Test
    public void testDelete(){
        //使用代理对象保存数据
        userDao.deleteUser(46);
        //提交事务
        session.commit();
    }
}