亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

mybatis-config配置全局屬性

未在配置文件中配置

mybatis-config配置文件

使用java代碼配置datasource

使用java代碼

配置sqlsessionfactory

異常處理

insert update get

package?com.forsaken.mina.web;

import?com.forsaken.mina.entity.Area;
import?com.forsaken.mina.service.AreaService;
import?org.springframework.beans.factory.annotation.Autowired;
import?org.springframework.web.bind.annotation.RequestBody;
import?org.springframework.web.bind.annotation.RequestMapping;
import?org.springframework.web.bind.annotation.RequestMethod;
import?org.springframework.web.bind.annotation.RestController;

import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;

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

????@RequestMapping(value?=?"/listarea",?method?=?RequestMethod.GET)
????private?Map<String,?Object>?listArea()?{
????????Map<String,?Object>?modelMap?=?new?HashMap<>();
????????List<Area>?list?=?areaService.getAreaList();
????????modelMap.put("areaList",?list);
????????return?modelMap;
????}

????@RequestMapping(value?=?"/getareabyid",?method?=?RequestMethod.GET)
????private?Map<String,?Object>?getAreaById(Integer?areaId)?{
????????Map<String,?Object>?modelMap?=?new?HashMap<>();
????????Area?area?=?areaService.getAreaById(areaId);
????????modelMap.put("area",?area);
????????return?modelMap;
????}

????@RequestMapping(value?=?"/addarea",?method?=?RequestMethod.POST)
????private?Map<String,?Object>?addArea(@RequestBody?Area?area)?{
????????Map<String,?Object>?modelMap?=?new?HashMap<>();
????????modelMap.put("success",?areaService.addArea(area));
????????return?modelMap;
????}

????@RequestMapping(value?=?"/modifyarea",?method?=?RequestMethod.POST)
????private?Map<String,?Object>?modifyArea(@RequestBody?Area?area)?{
????????Map<String,?Object>?modelMap?=?new?HashMap<>();
????????//修改區域信息
????????modelMap.put("success",?areaService.modifyArea(area));
????????return?modelMap;
????}

????@RequestMapping(value?=?"/removearea",?method?=?RequestMethod.GET)
????private?Map<String,?Object>?removeArea(Integer?areaId)?{
????????Map<String,?Object>?modelMap?=?new?HashMap<>();
????????modelMap.put("success",?areaService.deleteArea(areaId));
????????return?modelMap;
????}
}

package?com.forsaken.mina.service.impl;

import?com.forsaken.mina.dao.AreaDao;
import?com.forsaken.mina.entity.Area;
import?com.forsaken.mina.service.AreaService;
import?org.springframework.beans.factory.annotation.Autowired;
import?org.springframework.stereotype.Service;
import?org.springframework.transaction.annotation.Transactional;

import?java.util.Date;
import?java.util.List;

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

????@Override
????public?List<Area>?queryArea()?{
????????return?areaDao.queryArea();
????}

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

????/**
?????*?當拋出RuntimeException時事務Transactional才會回滾
?????*?@param?area
?????*?@return
?????*/
????@Transactional
????@Override
????public?boolean?addArea(Area?area)?{
????????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.getMessage());
????????????}
????????}?else?{
????????????throw?new?RuntimeException("區域信息不能為空!");
????????}
????}

????@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.getMessage());
????????????}
????????}?else?{
????????????throw?new?RuntimeException("區域信息不能為空!");
????????}
????}

????@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.getMessage());
????????????}
????????}?else?{
????????????throw?new?RuntimeException("區域ID不能為空!");
????????}
????}
}

package?com.forsaken.mina.dao;

import?com.forsaken.mina.entity.Area;
import?org.junit.Ignore;
import?org.junit.Test;
import?org.junit.runner.RunWith;
import?org.springframework.beans.factory.annotation.Autowired;
import?org.springframework.boot.test.context.SpringBootTest;
import?org.springframework.test.context.junit4.SpringRunner;

import?java.util.Date;
import?java.util.List;

import?static?org.junit.Assert.*;

@RunWith(SpringRunner.class)
@SpringBootTest
public?class?AreaDaoTest?{
????@Autowired
????private?AreaDao?areaDao;

????@Test
????@Ignore
????public?void?queryArea()?{
????????List<Area>?areaList?=?areaDao.queryArea();
????????assertEquals(2,?areaList.size());
????}

????@Test
????@Ignore
????public?void?queryAreaById()?{
????????Area?area?=?areaDao.queryAreaById(1);
????????assertEquals("東苑",?area.getAreaName());
????}

????@Test
????@Ignore
????public?void?insertArea()?{
????????Area?area?=?new?Area();
????????area.setAreaName("南苑");
????????area.setPriority(1);
????????int?effectedNum?=?areaDao.insertArea(area);
????????assertEquals(1,?effectedNum);
????}

????@Test
????@Ignore
????public?void?updateArea()?{
????????Area?area?=?new?Area();
????????area.setAreaName("西苑");
????????area.setAreaId(3);
????????area.setLastEditTime(new?Date());
????????int?effectedNum?=?areaDao.updateArea(area);
????????assertEquals(1,?effectedNum);
????}

????@Test
????@Ignore
????public?void?deleteArea()?{
????????int?effectedNum?=?areaDao.deleteArea(3);
????????assertEquals(1,?effectedNum);
????}
}

@MapperScan("包名")：類上加這個注解表示要讓spring自動掃描這個包下的mapper

獲取配置文件中屬性的值時不僅僅需要在要賦值的屬性上加上@Value注解還要在類上加上@Configuration注解

getter and setter idea快捷鍵為 alt+insert

https://gitee.com/xiangze/areadisplay
https://gitee.com/xiangze/demo

git：

https://gitee.com/xiangze/areadisplay
https://gitee.com/xiangze/demo