黑马程序员技术交流社区

标题: 【广州校区】+【原创】MyBatis的测试 [打印本页]
作者: Mylo    时间: 2018-7-12 14:52
标题: 【广州校区】+【原创】MyBatis的测试
本帖最后由 Mylo 于 2018-8-24 20:53 编辑


核心配置文件：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);
}




欢迎光临 黑马程序员技术交流社区 (http://bbs.itheima.com/) 黑马程序员IT技术论坛 X3.2