MyBatis_映射文件_增删改查

在EmployeeMapper.java中加入

    public Long addEmp(Employee employee);

    public boolean updateEmp(Employee employee);

    public void deleteEmpById(Integer id);

然后到SQL映射文件(EmployeeMapper.xml)中实现

    <!-- parameterType：参数类型，可以省略-->
    <insert id="addEmp" parameterType="com.atguigu.mybatis.bean.Employee">
        insert into tbl_employee(last_name,email,gender) 
        values(#{lastName},#{email},#{gender})
    </insert>

    <update id="updateEmp">
        update tbl_employee 
        set last_name=#{lastName},email=#{email},gender=#{gender}
        where id=#{id}
    </update>

    <delete id="deleteEmpById">
        delete from tbl_employee where id=#{id}
    </delete>

测试:

    /**
     * 测试增删改
     * 1、mybatis允许增删改直接定义以下类型返回值
     *      Integer、Long、Boolean、void
     * 2、我们需要手动提交数据
     *      sqlSessionFactory.openSession();===》手动提交
     *      sqlSessionFactory.openSession(true);===》自动提交
     * @throws IOException 
     */
    @Test
    public void test03() throws IOException{

        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        //1、获取到的SqlSession不会自动提交数据
        SqlSession openSession = sqlSessionFactory.openSession();

        try{
            EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);
            //测试添加
//          Employee employee = new Employee(null, "jerry4",null, "1");
//          mapper.addEmp(employee);
//          System.out.println(employee.getId());

            //测试修改
            Employee employee = new Employee(1, "NMM", "jerry@atguigu.com", "0");
//          mapper.updateEmp(employee);
            boolean updateEmp = mapper.updateEmp(employee);
            //System.out.println(updateEmp);
            //测试删除
            //mapper.deleteEmpById(2);
            //2、手动提交数据
            openSession.commit();
        }finally{
            openSession.close();
        }

    }

openSession.commit();手动提交数据别忘了!!