核心配置文件：mapperConfig.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"         "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration>     <!-- 运行环境配置 -->     <environments default="development">         <environment id="development">             <transactionManager type="JDBC" />             <dataSource type="POOLED">                 <property name="driver" value="com.mysql.jdbc.Driver" />                 <property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis" />                 <property name="username" value="root" />                 <property name="password" value="root" />             </dataSource>         </environment>     </environments>     <mappers>         <package name="test.mylo.mapper"></package>     </mappers> </configuration>

Person

public class Person {     private int pid;     private String pname;     private int page; //省略getter / setter }

接口

package test.mylo.mapper; import test.mylo.entity.Person; import java.util.List; public interface PersonMapper {     public void addPerson(Person person);     public void deletePersonById(int id);     public void updatePerson(Person person);     public Person findPersonById(int id);     public List<Person> findAllPersons(); }

测试：

SqlSession sqlSession = null; public void before() throws IOException {     Reader reader = Resources.getResourceAsReader("mapperConfig.xml");     SqlSessionFactory build = new SqlSessionFactoryBuilder().build(reader);     SqlSession sqlSession = build.openSession(); } @Test public void test addPerson(){      PersonMapper mapper = session.getMapper(PersonMapper.class);       Person p = new Person();       p.setPname(“mylo1”);       p.setPage(18);       mapper.addPerson(p);      //必须手动提交事务     session.commit(); } @Test public void test upatePerson(){      PersonMapper mapper = session.getMapper(PersonMapper.class);       Person p = new Person();       p.setPid(1);       p.setPname(“mylo2”);       p.setPage(18);       mapper.updatePerson(p);      //必须手动提交事务     session.commit(); } @Test public void test deletePerson(){      PersonMapper mapper = session.getMapper(PersonMapper.class);      mapper.deletePersonById(1);     session.commit(); } @Test public void test findPersonById(){      PersonMapper mapper = session.getMapper(PersonMapper.class);      Person p  = mapper.findPersonById(2);     System.out.println(p); } @Test public void test findAllPersons(){      PersonMapper mapper = session.getMapper(PersonMapper.class);      List<Person>list  = mapper.findAllPersons();     System.out.println(list); }

核心配置文件：mapperConfig.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"         "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration>     <!-- 运行环境配置 -->     <environments default="development">         <environment id="development">             <transactionManager type="JDBC" />             <dataSource type="POOLED">                 <property name="driver" value="com.mysql.jdbc.Driver" />                 <property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis" />                 <property name="username" value="root" />                 <property name="password" value="root" />             </dataSource>         </environment>     </environments>     <mappers>         <package name="test.mylo.mapper"></package>     </mappers> </configuration>

Person

public class Person {     private int pid;     private String pname;     private int page; //省略getter / setter }

接口

package test.mylo.mapper; import test.mylo.entity.Person; import java.util.List; public interface PersonMapper {     public void addPerson(Person person);     public void deletePersonById(int id);     public void updatePerson(Person person);     public Person findPersonById(int id);     public List<Person> findAllPersons(); }

测试：

SqlSession sqlSession = null; public void before() throws IOException {     Reader reader = Resources.getResourceAsReader("mapperConfig.xml");     SqlSessionFactory build = new SqlSessionFactoryBuilder().build(reader);     SqlSession sqlSession = build.openSession(); } @Test public void test addPerson(){      PersonMapper mapper = session.getMapper(PersonMapper.class);       Person p = new Person();       p.setPname(“mylo1”);       p.setPage(18);       mapper.addPerson(p);      //必须手动提交事务     session.commit(); } @Test public void test upatePerson(){      PersonMapper mapper = session.getMapper(PersonMapper.class);       Person p = new Person();       p.setPid(1);       p.setPname(“mylo2”);       p.setPage(18);       mapper.updatePerson(p);      //必须手动提交事务     session.commit(); } @Test public void test deletePerson(){      PersonMapper mapper = session.getMapper(PersonMapper.class);      mapper.deletePersonById(1);     session.commit(); } @Test public void test findPersonById(){      PersonMapper mapper = session.getMapper(PersonMapper.class);      Person p  = mapper.findPersonById(2);     System.out.println(p); } @Test public void test findAllPersons(){      PersonMapper mapper = session.getMapper(PersonMapper.class);      List<Person>list  = mapper.findAllPersons();     System.out.println(list); }