JAVA入门[8]-测试mybatis-白红宇

上一节通过mybatis-generator自动生成了CategoryMapper接口，pojo等类，接下来我们写几个简单的测试来进行调用。

一、添加依赖


     
      
       com.alibaba
          
      
       druid
          
      
       ${druid.version}
      
     
         
      
       junit
          
      
       junit
          
      
       ${junit.version}
          
      
       test

二、测试SqlSessionFactroy

首先我们看下怎样实例化sqlSessionFactory，然后获取CategoryMapper。

1.新建文件resources/properties/config.property，用来保存数据库连接串和账号。

data_source_url=jdbc:mysql://localhost:3306/storedata_source_username=rootdata_source_password=root

2.在resources/spring目录新建spring的配置文件applicationContext.xml

3.配置数据连接。在applicationContext.xml中添加bean节点dataSource，详细配置参考：

4.然后配置bean sqlSessionFactory和sqlSession。

4.测试

有了上面的配置，就可以直接以注解的方式实例化SqlSessionFactory.

@ContextConfiguration(locations = "classpath:spring/applicationContext.xml")@RunWith(SpringJUnit4ClassRunner.class)public class SqlSessionTests {    @Autowired    private SqlSession sqlSession;    @Test    public void testSqlSession(){        CategoryMapper categoryMapper= sqlSession.getMapper(CategoryMapper.class);        Category category= categoryMapper.selectByPrimaryKey(1);        if(category==null){            System.out.println("Do not exist");        }        else{            System.out.println(category.getName());        }    }}

三、测试直接实例化CategoryMapper

更加简洁的方式是直接通过注解实例化CategoryMapper

1.在applicationContext.xml新增bean节点

2.直接给CategoryMapper添加@Resource注解，来进行实例化。

@ContextConfiguration(locations = "classpath:spring/applicationContext.xml")@RunWith(SpringJUnit4ClassRunner.class)

public class CategoryDaoTests {
   @Resource CategoryMapper categoryMapper; @Test public void test_selectById(){
   Category category=categoryMapper.selectByPrimaryKey(1); System.out.println(category.getName());//Fish } @Test public void test_count(){
   CategoryExample example=new CategoryExample(); long result=categoryMapper.countByExample(example); System.out.println(result); } @Test public void test_insert(){
   System.out.println("before insert:count "+categoryMapper.countByExample(new CategoryExample())); Category category=new Category(); category.setName("Test"); categoryMapper.insert(category); System.out.println("after insert:count "+categoryMapper.countByExample(new CategoryExample())); } @Test public void test_delete(){
   System.out.println("before insert:count "+categoryMapper.countByExample(new CategoryExample())); CategoryExample example=new CategoryExample(); example.createCriteria().andNameEqualTo("Test"); int result=categoryMapper.deleteByExample(example); System.out.println("删除条数："+result); System.out.println("after insert:count "+categoryMapper.countByExample(new CategoryExample())); } }

http://www.cnblogs.com/janes/p/6433295.html