校园商铺-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

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