mybatisCRUD操作 入门

1.先写接口

//查询全部用户
    List<User> getUserList();

2.在mapper.xml里写select update insert delete 标签

<?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 = 绑定一个对应的 dao / mapper 接口-->
<mapper namespace="com.lm.dao.UserMapper">

<!--    select 查询  id = namespace 接口方法名 resultType sql语句返回值  parameterType 参数类型-->
    <select id="getUserList" resultType="com.lm.pojo.User" >
    select * from user
  </select>

    <select id="getUserById" resultType="com.lm.pojo.User" parameterType="int">
    select * from user where id = #{id}
  </select>

    <insert id="addUser" parameterType="com.lm.pojo.User" >
      insert into user values (#{id},#{name},#{pwd})
    </insert>

    <update id="updateUser" parameterType="com.lm.pojo.User">
        update user set name = #{name},pwd = #{pwd} where id = #{id}
    </update>

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

然后进行测试

   @Test
    public void deleteUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int del = mapper.deleteUser(4);
        if(del>0){
            System.out.println("删除成功");
        }
        //提交事务
        sqlSession.commit();
        sqlSession.close();
    }

注意 ：在增删改中必须提交事务

在maven中xml文件找不到解决方案

在pom.xml里加入

    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>