利用Mybeatis框架进行数据库的增删改查 mybatis入门操作

配置好mybatis-config.xml以及mybatis-mapper文件后  开始在mapper文件中编写sql语句：

<?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">

    <select id="selectAll" resultType="wg.study.entity.Teacher">
        select * from teacher
    </select>
<!--#{} 获取参数  参数的占位? 避免sql的注入-->
    <select id="selectOne" resultType="wg.study.entity.Teacher" parameterType="integer">
        select * from teacher where id =#{id}
    </select>

    <insert id="addOne" parameterType="wg.study.entity.Teacher">
        insert into teacher (id,tea_name,profession) values (#{id},#{teaName},#{profession})
    </insert>

    <update id="updateOne" parameterType="wg.study.entity.Teacher" >
update teacher set tea_name = #{teaName} where id =#{id}
    </update>

    <delete id="deleteOne" parameterType="integer" >
delete from teacher  where id =#{id}
    </delete>
</mapper>

再建立接口文件，写好方法

package wg.study.mapper;

import wg.study.entity.Teacher;

import java.util.List;

public interface TeacherMapper {
    List<Teacher> selectAll();
    Teacher selectOne(Integer id);
    Integer updateOne(Teacher teacher);
    Integer addOne(Teacher teacher);
    Integer deleteOne(Integer id);
}

mapper文件与接口连接的前提：
1.mapper配置文件中的namespace的值为接口的包名+接口名、
2.mapper.xml文件中的SQL语句的id与接口中的方法名对应

最后写好Test类实现对SQL语句功能的测试

package wg.study.test;

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.Before;
import org.junit.Test;
import wg.study.entity.Teacher;
import wg.study.mapper.TeacherMapper;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class TeacherMapperTest {

    private SqlSessionFactory factory;

    @Before
    public void init() {
        //加载mybatis配置文件
        try {
            InputStream resourceAsStream = Resources.getResourceAsStream("config/mybatis-config.xml");
            factory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }


    @Test
    public void selectAll(){
        SqlSession sqlSession = factory.openSession();
//        sqlSession获取teacherMapper的代理对象 类似之前实现接口类的对象
        TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
        List<Teacher> teachers = mapper.selectAll();
        for (Teacher teacher :teachers){
            System.out.println("teacher = " + teacher);
        }
    }

    @Test
    public void selectOne(){
        SqlSession sqlSession = factory.openSession();
//        sqlSession获取teacherMapper的代理对象 类似之前实现接口类的对象
        TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
        Teacher teacher = mapper.selectOne(1);
        System.out.println("teacher = " + teacher);


    }


    @Test
    public void deleteOne(){
        SqlSession sqlSession = factory.openSession();
//        sqlSession获取teacherMapper的代理对象 类似之前实现接口类的对象
        TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
        Integer integer = mapper.deleteOne(30);
        sqlSession.commit();
        System.out.println(integer>0 ? "true":"false");

    }

    @Test
    public void updateOne(){
            SqlSession sqlSession = factory.openSession();
            //创建教师对象
        TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
            Teacher teacher = new Teacher("jack","java架构师",30);
            int update = mapper.updateOne( teacher);
            sqlSession.commit();
            System.out.println(update >0?"true" :"false");
        }

    }