mybatis映射文件之基本的增删改查

概述借之前配置好的环境： 1、首先在Employee .java中加上有参的构造器和无参的构造器。 2、采用mapper中的class属性配置映射文件。 <mappers> <mappe

借之前配置好的环境：

1、首先在Employee .java中加上有参的构造器和无参的构造器。

2、采用mapper中的class属性配置映射文件。

    <mappers>        mapper class="com.gong.mybatis.dao.EmployeeMapper" />            </>

3、EmployeeMapper.java

package com.gong.mybatis.dao;import com.gong.mybatis.bean.Employee;public interface EmployeeMapper {    public Employee getEmpByID(Integer ID);        boolean addEmp(Employee employee);        voID updateEmp(Employee employee);         deleteEmp(Integer ID);}

4、EmployeeMapper.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="com.gong.mybatis.dao.EmployeeMapper">    select ID="getEmpByID" resultType="com.gong.mybatis.bean.Employee">        select ID,last_name lastname,email,gender from tbl_employee where ID = #{ID}    selectinsert ="addEmp" parameterType        insert into tbl_employee(last_name,gender,email)        values(#{lastname},#{gender},#{email})     insertupdate ="updateEmp"         update tbl_employee set last_name=#{lastname},gender=#{gender},email=#{email}        where ID = #{ID}    updatedelete ="deleteEmp"        delete from tbl_employee where ID=#{ID}    delete>mapper>

说明：接口中的增删改方法可以有Integer、long、boolean返回值。在EmployeeMapper.xml中parameterType为输入的参数类型，resultType为返回的参数类型。

5、在TestMybatis.java中进行单元测试

 com.gong.mybatis.test; java.io.IOException; java.io.inputStream; org.apache.ibatis.io.Resources; org.apache.ibatis.session.sqlSession; org.apache.ibatis.session.sqlSessionFactory; org.apache.ibatis.session.sqlSessionFactoryBuilder; org.junit.Test; com.gong.mybatis.bean.Employee; com.gong.mybatis.dao.EmployeeMapper; com.gong.mybatis.dao.EmployeeMapperAnnotation; TestMybatis {        public sqlSessionFactory getsqlSessionFactory() throws IOException {        String resource = "mybatis-config.xml";        inputStream is = Resources.getResourceAsstream(resource);        return new sqlSessionFactoryBuilder().build(is);    }        @Test    voID test03()  IOException {        sqlSessionFactory sqlSessionFactory = getsqlSessionFactory();        //不会自动提交数据        sqlSession openSession = sqlSessionFactory.openSession();        try {            EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.);            /*            //添加员工            Employee employee = new Employee(null,"bob","1","[email protected]");            mapper.addEmp(employee);                        /*            //修改员工            Employee employee = new Employee(1,"xiximayou","[email protected]");            mapper.updateEmp(employee);            */                        //删除员工            Integer ID = 3;            mapper.deleteEmp(ID);            手动提交数据            openSession.commit();                                } finally {             Todo: handle finally clause            openSession.close();        }    }}

原本数据库中存在的数据：

 结果：

（1）添加

（2）修改

（3） 删除

继查找功能之后，本节实现的增删改功能均已正确实现。 

总结

以上是内存溢出为你收集整理的mybatis映射文件之基本的增删改查全部内容，希望文章能够帮你解决mybatis映射文件之基本的增删改查所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。