校园商铺-2项目设计和框架搭建-7验证Dao

以最简单的地区表为例

1.插入数据

insert into tb_area (area_name, priority) values('东苑', 1),('南苑', 7),('北苑', 5);
select * from tb_area;

2.创建接口

src/main/java/com.csj2018.o2o.dao/AreaDao.java

package com.csj2018.o2o.dao;
import com.csj2018.o2o.entity.Area;
import java.util.List;
public interface AreaDao {
    /**
     * 列出区域列表
     * @return areaList
     */
    List<Area> queryArea();
}

3. 创建mapper文件

src/main/resources/mapper/AreaDao.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
 PUBLIC "-//mybatis.org/DTD Mapper 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
 <mapper namespace="com.csj2018.o2o.dao.AreaDao">
    <select id="queryArea" resultType="com.csj2018.o2o.entity.Area" >
    select * from tb_area order by priority desc;
    </select>
 </mapper>

4. 创建基类BaseTest.java

package com.csj2018.o2o;

import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
/**
 * 配置spring和junit整合，junit启动式加载springIOC容器
 */
@RunWith(SpringJUnit4ClassRunner.class)
//告诉junit spring配置文件的位置
@ContextConfiguration({"classpath:spring/spring-dao.xml"})
public class BaseTest {

}

5. 创建测试类

package com.csj2018.o2o.dao;

import static org.junit.Assert.assertEquals;

import java.util.Arrays;
import java.util.List;

import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;

import com.csj2018.o2o.BaseTest;
import com.csj2018.o2o.entity.Area;

public class AreaDaoTest extends BaseTest{
    @Autowired
    private AreaDao areaDao;
    @Test
    public void testQueryArea() {
        List<Area> areaList = areaDao.queryArea();
        assertEquals(3, areaList.size());
    }
}

运行测试类 Run As -> JUnit Test

执行成功，说明已经成功连接数据库

转载于:https://www.cnblogs.com/csj2018/p/11559526.html