mybatis实现（增删改查）CRUD

以下是一套完整的mybatis的增删改查，亲测可用

1.mybatis工具类

public class MybatisUtil {
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            InputStream inputStream = MybatisUtil.class.getResourceAsStream("/mybatis-config.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        }catch (Exception e){
            e.printStackTrace();
        }
    }

    public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession();
    }


}

2.mapper接口

public interface UserMapper {


    List<User> getuserlist();

    User queryUser(int id);

    int addUser(User user);

    int updateUser(User user);

    int deleteUser(String username);
}

3.接口对应的mapper.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">
<!--namespace:指向sql是属于那个Mapper的接口-->
<mapper namespace="com.wei.Mapper.UserMapper">
    <select id="getuserlist" resultType="com.wei.entity.User">
        select * from user
    </select>
    
    <select id="queryUser" resultType="com.wei.entity.User">
        select * from user where id=#{id}
    </select>

    <insert id="addUser" parameterType="com.wei.entity.User">
    insert into user (username,password,phone)values (#{username},#{password},#{phone})
    </insert>

    <update id="updateUser" parameterType="com.wei.entity.User">
        update user set username =#{username},password=#{password},phone=#{phone} where username="溜溜球"
    </update>

    <delete id="deleteUser" parameterType="String">
        delete from user where username=#{username}
    </delete>
</mapper>

4.配置文件

<?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="development">
        <environment id="development">
            <!--     事务管理-->
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <!--     数据库驱动，用户名，url，密码等-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/user?serverTimezone=UTC&amp;useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value=""/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
<!--        <package name="com.wei.Mapper"/>-->
        <mapper resource="com/wei/Mapper/UserMapper.xml"/>
    </mappers>
</configuration>

5.代码测试

public class UserTest {
    @Test   //获取用户列表
    public void getuserlisttest(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> getuserlist = mapper.getuserlist();
        for (User user:getuserlist){
            System.out.println(user);
        }
        sqlSession.close();
    }

    @Test  //获取单个用户
    public void getuser(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user = mapper.queryUser(1);
        System.out.println(user);
        sqlSession.close();
    }

    @Test   //增加用户
    public void addUser(){
        //增删改需要提交事务
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user =new User();
        user.setUsername("溜溜球");
        user.setPassword("5dsnjkj");
        user.setPhone("145265354789");
        int i = mapper.addUser(user);
        System.out.println(i>0);
        //必须提交事务!!!!!!
        sqlSession.commit();
        sqlSession.close();
    }
    @Test   //修改用户
    public void updateUser(){
        //增删改需要提交事务
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        User user =new User();
        user.setUsername("张大炮");
        user.setPassword("64dssgj");
        user.setPhone("546156354789");
        int i = mapper.updateUser(user);
        System.out.println(i>0);
        //必须提交事务!!!!!!
        sqlSession.commit();
        sqlSession.close();
    }
    @Test   //删除用户
    public void deleteUser(){
        //增删改需要提交事务
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        int i = mapper.deleteUser("张大炮");
        System.out.println(i>0);
        //必须提交事务!!!!!!
        sqlSession.commit();
        sqlSession.close();
    }
}