package com.artisan.o2o.dao;
import java.util.List;
import com.artisan.o2o.entity.Area;
public interface AreaDao {
  List<Area> queryArea();
}

<?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.artisan.o2o.dao.AreaDao">
  <select id="queryArea" resultType="Area">
    SELECT
      area_id,
      area_name,
      area_desc,
      priority,
      create_time,
      last_edit_time
    FROM
      tb_area
    ORDER BY
      priority DESC
  </select>
</mapper>   

package com.artisan.o2o.dao;
import static org.junit.Assert.assertEquals;
import java.util.List;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import com.artisan.o2o.BaseTest;
import com.artisan.o2o.entity.Area;
/**
 * 
 * 
 * @ClassName: AreaDaoTest
 * 
 * @Description: 集成SSM后对DAO层进行验证
 * 
 * @author: Mr.Yang
 * 
 * @date: 2018年5月14日 下午5:21:49
 */
public class AreaDaoTest extends BaseTest {
  @Autowired
  AreaDao areaDao;
  @Test
  public void testQueryArea() {
    List<Area> areaList = areaDao.queryArea();
    // 插入了2条测试数据,期望list中有2条
    assertEquals(2, areaList.size());
    // SQL中按照权重排序,上海priority 99 ,期望第一条数据是 上海
    System.out.println(areaList.get(0));
    assertEquals("上海", areaList.get(0).getAreaName());
  }
}

JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@a1f72f5] will not be managed by Spring
==>  Preparing: SELECT area_id, area_name, area_desc, priority, create_time, last_edit_time FROM tb_area ORDER BY priority DESC 
==> Parameters: 
<==    Columns: area_id, area_name, area_desc, priority, create_time, last_edit_time
<==        Row: 2, 上海, 魔都, 99, 2018-05-13 21:00:36.0, 2018-05-14 21:00:41.0
<==        Row: 1, 北京, 帝都, 0, 2018-05-13 21:00:26.0, 2018-05-14 21:00:33.0
<==      Total: 2
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@61710c6]
Area [areaId=2, areaName=上海, areaDesc=魔都, priority=99, createTime=Sun May 13 21:00:36 BOT 2018, lastEditTime=Mon May 14 21:00:41 BOT 2018]

package com.artisan.o2o.service;
import java.util.List;
import com.artisan.o2o.entity.Area;
public interface AreaService {
  /**
   * 
   * 
   * @Title: getAreaList
   * 
   * @Description: 获取区域列表
   * 
   * @return
   * 
   * @return: List<Area>
   */
  List<Area> getAreaList();
}

package com.artisan.o2o.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.artisan.o2o.dao.AreaDao;
import com.artisan.o2o.entity.Area;
import com.artisan.o2o.service.AreaService;
/**
 * 
 * 
 * @ClassName: AreaServiceImpl
 * 
 * @Description: @Service标注的服务层
 * 
 * @author: Mr.Yang
 * 
 * @date: 2018年5月14日 下午9:06:45
 */
@Service
public class AreaServiceImpl implements AreaService {
  @Autowired
  AreaDao areaDao;
  @Override
  public List<Area> getAreaList() {
    return areaDao.queryArea();
  }
}

package com.artisan.o2o.service;
import java.util.List;
import org.junit.Assert;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import com.artisan.o2o.BaseTest;
import com.artisan.o2o.entity.Area;
public class AreaServiceTest extends BaseTest {
  @Autowired
  AreaService areaService;
  @Test
  public void testGetAreaList() {
    List<Area> areaList = areaService.getAreaList();
    Assert.assertEquals("上海", areaList.get(0).getAreaName());
  }
}

package com.artisan.o2o.web;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import com.artisan.o2o.entity.Area;
import com.artisan.o2o.service.AreaService;
@Controller
@RequestMapping("/superadmin")
public class AreaController {
  @Autowired
  AreaService areaService;
  @RequestMapping(value = "/listArea", method = RequestMethod.GET)
  @ResponseBody
  public Map<String, Object> getAreas() {
    Map<String, Object> map = new HashMap<String, Object>();
    List<Area> areaList = new ArrayList<Area>();
    try {
      areaList = areaService.getAreaList();
      map.put("total", areaList.size());
      map.put("rows", areaList);
      for (Area area : areaList) {
        System.out.println("区域:" + area);
      }
    } catch (Exception e) {
      e.printStackTrace();
      map.put("success", false);
      map.put("errMsg", e.getMessage().toString());
    }
    return map;
  }
}