我是用xml实现了单表的增删改查之后才改用接口的，所以我这里就不把那些配置拷贝过来了，其实东西都一样。

1:接口

　　这个更有意思了。把具体的操作写在了注解里面。

package com.zhao.mapper;import java.util.List;import org.apache.ibatis.annotations.Delete;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import com.zhao.entity.Student;public interface StudentMapper {    @Select(value="select * from student")    public List
     
       queryStudent();    @Select(value="select * from student where stu_id=#{stu_id}")    public Student selectStudentById(int stu_id);    @Delete(value="delete from student where stu_id=#{stu_id}")    public void deleteStudentById(int stu_id);    @Insert(value="insert into student(stu_name,stu_gender) values(#{stu_name},#{stu_gender})")    public void insertStudent(Student student);    @Update(value="update student set stu_name=#{stu_name},stu_gender=#{stu_gender} where stu_id=#{stu_id}")    public void updateStudentById(Student student);}
     

2：测试代码

　　依旧是增删改查，接口实现是session获取接口对象，然后调用接口相应的方法。至于底层的东西 mybatis就帮我们解决了，我们不需要在这里用具体的实现类，具体的实现类也不好用。这样多方法，只写法方法签名，然后把数据表的操作写注解了，直接用就可以了。

package com.zhao.mapper;import static org.junit.Assert.*;import java.io.InputStream;import java.util.List;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 com.zhao.entity.Student;import com.zhao.entity.StudentTest;public class StudentMapperTest {    private SqlSessionFactory factory;    @Before    public void before() {        try {            /*             * 1: Reader reader             * =Resources.getResourceAsReader("Configuration.xml"); factory =             * new SqlSessionFactoryBuilder().build(reader);             */            // 2:            InputStream inputStream = StudentTest.class.getClassLoader().getResourceAsStream("Configuration.xml");            factory = new SqlSessionFactoryBuilder().build(inputStream);        } catch (Exception e) {            e.printStackTrace();        }    }    @Test    public void testQueryStudent() {        SqlSession session = factory.openSession();        try {            StudentMapper mapper = session.getMapper(StudentMapper.class);            List
     
       students = mapper.queryStudent();            for (Student student : students) {                System.out.println(student);            }            session.commit();        } finally {            session.close();        }    }    @Test    public void testSelectStudentById() {        SqlSession session = factory.openSession();        try {            StudentMapper mapper = session.getMapper(StudentMapper.class);            Student student = mapper.selectStudentById(2);            System.out.println(student);            session.commit();        } finally {            session.close();        }    }    @Test    public void testDeleteStudentById() {        SqlSession session = factory.openSession();        try {            StudentMapper mapper = session.getMapper(StudentMapper.class);            mapper.deleteStudentById(2);            session.commit();        } finally {            session.close();        }    }    @Test    public void testInsertStudent() {        SqlSession session = factory.openSession();        try {            StudentMapper mapper = session.getMapper(StudentMapper.class);            Student student = new Student("zaza", "男");            mapper.insertStudent(student);            session.commit();        } finally {            session.close();        }    }    @Test    public void testUpdateStudentById() {        SqlSession session = factory.openSession(true);        try {            StudentMapper mapper = session.getMapper(StudentMapper.class);            Student student = new Student(7,"zaza", "m");            mapper.updateStudentById(student);            session.commit();        } finally {            session.close();        }    }}