博客

spring单元测试—注解法

1、junit单元测试包

	<dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>

2、spring测试包

	<dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>4.1.3.RELEASE</version>
        </dependency>

3、测试类

	@RunWith(SpringJUnit4ClassRunner.class)
	@ContextConfiguration({"classpath:spring/applicationContext-*.xml"})
	public class TestPageHelper {...}

spring单元测试—手动装载

1、junit测试包

	<dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>

2、测试类

@Test
    public void testPageHelper1(){
    //获得mapper代理对象
    ApplicationContext context = new ClassPathXmlApplicationContext("classpath:spring/applicationContext-*.xml");
    TbItemMapper itemMapper = context.getBean(TbItemMapper.class); ...}

PageHelper分页

1、分页jar包

 	<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>4.0.2</version>
        </dependency>

2、mybatis配置（SqlMapConfig.xml）

    <!--配置分页插件-->
    <plugins>
        <plugin interceptor="com.github.pagehelper.PageHelper">
            <!--指定数据库方言-->
            <property name="dialect" value="mysql"/>
        </plugin>
    </plugins>

3、java代码

	@Autowired
    private TbItemMapper tbItemMapper;
    //注解加载配置问价
    @Test
    public void testPageHelper(){
        //设置分页
        PageHelper.startPage(1,30);
        //执行查询
        TbItemExample example = new TbItemExample();
        List<TbItem> list = tbItemMapper.selectByExample(example);
        //取分页结果
        PageInfo<TbItem> pageInfo = new PageInfo<>(list);
        long total = pageInfo.getTotal();
        System.out.println("total:"+total);
        int pages = pageInfo.getPages();
        System.out.println("pages:"+pages);
        int pageSize = pageInfo.getPageSize();
        System.out.println("pageSize:"+pageSize);
    }

OK！