3_sqlSession完成DML所有操作

Myth丶恋晨 2023-09-27 15:51 85阅读 0赞

Mapper映射文件

<?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">
    <mapper namespace="EmpMapper3">
        
        
        <insert id="addEmp" parameterType="emp">
            insert into emp values(#{empno},#{ename},#{job},#{mgr},#{hiredate},#{sal},#{comm},#{deptno})
        </insert>
        
        <update id="updateEmp" parameterType="emp">
            update emp set ename = #{ename} where empno=#{empno}
        </update>
        
        <delete id="deleteEmp" parameterType="int">
            delete from emp where empno >= #{empno}
        </delete>
    </mapper>

![6b55a3a1d18c8f43bb50ef64134ed125.gif][]

![6ff6595502f1fe1b58a2cc26bc093473.gif][]

测试代码

package com.msb.test;
    import com.msb.pojo.Emp;
    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 org.junit.After;
    import org.junit.Before;
    import org.junit.Test;
    import java.io.IOException;
    import java.io.InputStream;
    import java.util.Date;
    import java.util.HashMap;
    import java.util.List;
    import java.util.Map;
    /**
     * @Author: Ma HaiYang
     * @Description: MircoMessage:Mark_7001
     */
    public class Test4 {
        private SqlSession sqlSession;
        @Before
        public void init(){
            SqlSessionFactoryBuilder ssfb =new SqlSessionFactoryBuilder();
            InputStream resourceAsStream = null;
            try {
                resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
            } catch (IOException e) {
                e.printStackTrace();
            }
            SqlSessionFactory factory=ssfb.build(resourceAsStream) ;
            sqlSession=factory.openSession(true);
        }
        @Test
        public void testInsert(){
            Emp emp =new Emp(null,"按住啦Baby","SALESMAN",7839,new Date(),3100.0, 200.0,10 );
            int rows = sqlSession.insert("addEmp", emp);
            System.out.println(rows);
            // 手动提交事务
            //sqlSession.commit();
            /*增删改 要提交事务
            * sqlSession.commit();手动提交事务
            * sqlSession=factory.openSession(true); 设置事务自动提交
            * */
        }
        @Test
        public void testUpdate(){
            Emp emp =new Emp( );
            emp.setEname("晓明");
            emp.setEmpno(7937);
            int rows = sqlSession.update("updateEmp", emp);
            System.out.println(rows);
        }
        @Test
        public void testDelete(){
            int rows = sqlSession.delete("deleteEmp", 7936);
            System.out.println(rows);
        }
        @After
        public void release(){
            // 关闭SQLSession
            sqlSession.close();
        }
    }

![ac9e29ac31cf44b3be70e24760265494.gif][]

![fb8259c6af177b39a8e639bfd1f9a85b.gif][]

[6b55a3a1d18c8f43bb50ef64134ed125.gif]: https://img-blog.csdnimg.cn/img_convert/6b55a3a1d18c8f43bb50ef64134ed125.gif
[6ff6595502f1fe1b58a2cc26bc093473.gif]: https://img-blog.csdnimg.cn/img_convert/6ff6595502f1fe1b58a2cc26bc093473.gif
[ac9e29ac31cf44b3be70e24760265494.gif]: https://img-blog.csdnimg.cn/img_convert/ac9e29ac31cf44b3be70e24760265494.gif
[fb8259c6af177b39a8e639bfd1f9a85b.gif]: https://img-blog.csdnimg.cn/img_convert/fb8259c6af177b39a8e639bfd1f9a85b.gif