一段SpringBoot送给大家

SpringBoot实现增删改查

大家需要提前下好postman工具哦！

Controller层实现

@RestController
@RequestMapping('/superadmin')
public class AreaController {
 @Autowired
 private AreaService areaService;

 /**
  * 获取所有的区域信息
  *
  * @return
  */
 @RequestMapping(value = '/listarea', method = RequestMethod.GET)
 private MapString, Object> listArea() {
   MapString, Object> modelMap = new HashMapString, Object>();
   List list = new ArrayList();
   // 获取区域列表
   list = areaService.getAreaList();
   modelMap.put('areaList', list);
   return modelMap;
 }

 /**
  * 通过区域Id获取区域信息
  *
  * @return
  */
 @RequestMapping(value = '/getareabyid', method = RequestMethod.GET)
 private MapString, Object> getAreaById(Integer areaId) {
   MapString, Object> modelMap = new HashMapString, Object>();
   // 获取区域信息
   Area area = areaService.getAreaById(areaId);
   modelMap.put('area', area);
   return modelMap;
 }

 /**
  * 添加区域信息
  *
  * @param areaStr
  * @param request
  * @return
  * @throws IOException
  * @throws JsonMappingException
  * @throws JsonParseException
  */
 @RequestMapping(value = '/addarea', method = RequestMethod.POST)
 private MapString, Object> addArea(@RequestBody Area area)
     throws JsonParseException, JsonMappingException, IOException {
   MapString, Object> modelMap = new HashMapString, Object>();
   // 添加区域信息
   modelMap.put('success', areaService.addArea(area));
   return modelMap;
 }

 /**
  * 修改区域信息，主要修改名字
  *
  * @param areaStr
  * @param request
  * @return
  * @throws IOException
  * @throws JsonMappingException
  * @throws JsonParseException
  */
 @RequestMapping(value = '/modifyarea', method = RequestMethod.POST)
 private MapString, Object> modifyArea(@RequestBody Area area)
     throws JsonParseException, JsonMappingException, IOException {
   MapString, Object> modelMap = new HashMapString, Object>();
   // 修改区域信息
   modelMap.put('success', areaService.modifyArea(area));
   return modelMap;
 }

 @RequestMapping(value = '/removearea', method = RequestMethod.GET)
 private MapString, Object> removeArea(Integer areaId) {
   MapString, Object> modelMap = new HashMapString, Object>();
   // 修改区域信息
   modelMap.put('success', areaService.deleteArea(areaId));
   return modelMap;
 }

}

Service层实现

@Service
public class AreaServiceImpl implements AreaService {
 @Autowired
 private AreaDao areaDao;

 @Override
 public List getAreaList() {
   // 返回所有的区域信息
   return areaDao.queryArea();
 }

 @Override
 public Area getAreaById(int areaId) {
   return areaDao.queryAreaById(areaId);
 }

 @Transactional
 @Override
 public boolean addArea(Area area) {
   // 空值判断，主要是判断areaName不为空
   if (area.getAreaName() != null && !''.equals(area.getAreaName())) {
     // 设置默认值
     area.setCreateTime(new Date());
     area.setLastEditTime(new Date());
     try {
       int effectedNum = areaDao.insertArea(area);
       if (effectedNum > 0) {
         return true;
       } else {
         throw new RuntimeException('添加区域信息失败!');
       }
     } catch (Exception e) {
       throw new RuntimeException('添加区域信息失败:' + e.toString());
     }
   } else {
     throw new RuntimeException('区域信息不能为空！');
   }
 }

 @Transactional
 @Override
 public boolean modifyArea(Area area) {
   // 空值判断，主要是areaId不为空
   if (area.getAreaId() != null && area.getAreaId() > 0) {
     // 设置默认值
     area.setLastEditTime(new Date());
     try {
       // 更新区域信息
       int effectedNum = areaDao.updateArea(area);
       if (effectedNum > 0) {
         return true;
       } else {
         throw new RuntimeException('更新区域信息失败!');
       }
     } catch (Exception e) {
       throw new RuntimeException('更新区域信息失败:' + e.toString());
     }
   } else {
     throw new RuntimeException('区域信息不能为空！');
   }
 }

 @Transactional
 @Override
 public boolean deleteArea(int areaId) {
   if (areaId > 0) {
     try {
       // 删除区域信息
       int effectedNum = areaDao.deleteArea(areaId);
       if (effectedNum > 0) {
         return true;
       } else {
         throw new RuntimeException('删除区域信息失败!');
       }
     } catch (Exception e) {
       throw new RuntimeException('删除区域信息失败:' + e.toString());
     }
   } else {
     throw new RuntimeException('区域Id不能为空！');
   }
 }
}

Mapper.xml

<>xml version='1.0' encoding='UTF-8'?>
   PUBLIC '-//mybatis.org//DTD Mapper 3.0//EN'
   'http://mybatis.org/dtd/mybatis-3-mapper.dtd'>
mapper namespace='com.imooc.demo.dao.AreaDao'>
 select id='queryArea' resultType='com.imooc.demo.entity.Area'>
   SELECT area_id, area_name,
   priority, create_time, last_edit_time
   FROM tb_area
   ORDER BY priority
   DESC
 select>
 select id='queryAreaById' resultType='com.imooc.demo.entity.Area'>
   SELECT area_id, area_name,
   priority, create_time, last_edit_time
   FROM tb_area
   WHERE
   area_id=#{areaId}
 select>
 insert id='insertArea' useGeneratedKeys='true' keyProperty='areaId'
   keyColumn='area_id' parameterType='com.imooc.demo.entity.Area'>
   INSERT INTO
   tb_area(area_name,priority,
   create_time,last_edit_time)
   VALUES
   (#{areaName},#{priority},
   #{createTime},#{lastEditTime})
 insert>
 update id='updateArea' parameterType='com.imooc.demo.entity.Area'>
   update tb_area
   set>
     if test='areaName != null'>area_name=#{areaName},if>
     if test='priority != null'>priority=#{priority},if>
     if test='lastEditTime != null'>last_edit_time=#{lastEditTime}if>
   set>
   where area_id=#{areaId}
 update>
 delete id='deleteArea'>
   DELETE FROM
   tb_area
   WHERE
   area_id =
   #{areaId}
 delete>
mapper>

整体架构展示