4.MyBatis实现增删改查

MyBatis实现增删改查

创建SqlSessionUtils类

通过SqlSessionUtils.java工具类获取SqlSession对象

package com.atguigu.mybatis.utils;

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 java.io.IOException;
import java.io.InputStream;

public class SqlSessionUtils {
    public static SqlSession getSqlSession(){
        try {
            //读取MyBatis的核心配置文件的输入流
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            //获取SqlSessionFactoryBuilder对象
            SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
            //根据核心配置文件的输入流创建工厂类SqlSessionFactory,来生产sql的会话对象SqlSession对象
            SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);
            //生产SqlSession对象-->是mybatis提供的操作数据库的对象
            SqlSession sqlSession = sqlSessionFactory.openSession(true);//这里参数填"true"就可以实现自动提交事务
            return sqlSession;
        } catch (IOException e) {
            e.printStackTrace();
        }
        return null;
    }
}

增加

增加语句在前面搭建MyBatis时有进行测试和使用，这里就不赘述

<insert id="insertUser">
        insert into t_user values (null,'admin','123456',23,'男','1312@qq.com')
</insert>

删除和修改

删除和修改流程和增加流程是一样的

UserMapper.java

package com.atguigu.mybatis.mapper;

import com.atguigu.mybatis.pojo.User;

import java.util.List;

public interface UserMapper {
    /**
     * 增加用户信息
     * @return
     */
    int insertUser();

    /**
     * 删除用户信息
     * @return
     */
    void deleteUser();

    /**
     * 修改用户信息
     * @return
     */
    void updateUser();

    /**
     * 查找用户信息，查询单个用户返回User即可
     * @return
     */
    List<User> AllUser();
}

UserMapper.xml

	<!--void deleteUser()-->
    <delete id="deleteUser">
        delete from t_user where id = '2'
    </delete>

    <!--void updateUser()-->
    <update id="updateUser">
        update t_user set gender = '女' where id = '1'
    </update>

	<!--
        resultType：设置结果类型，即查询数据所需要转换的java类型，为一对一映射
        resultMap：自定义映射，处理多对一或一对多的映射
    -->
    <!--List<User> AllUser()-->
    <select id="AllUser" resultType="com.atguigu.mybatis.pojo.User">
        select * from t_user
    </select>

查询

查询需要在标签处声明结果映射

resultType：设置结果类型，即查询数据所需要转换的java类型，为一对一映射
resultMap：自定义映射，处理多对一或一对多的映射

测试类

    @Test
    public void testDelete(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        userMapper.deleteUser();
    }

    @Test
    public void testUpdate(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        userMapper.updateUser();
    }

    @Test
    public void testAllUser(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        List<User> list = userMapper.AllUser();
        list.forEach(System.out::println);
    }