1.新增员工
/*** 处理SQL异常* @param sqlIntegrityConstraintViolationException* @return*/@ExceptionHandlerpublic Result exceptionHandler(SQLIntegrityConstraintViolationException sqlIntegrityConstraintViolationException){//String message = sqlIntegrityConstraintViolationException.getMessage();if (message.contains("Duplicate entry")){String[] split = message.split(" ");String username = split[2];String msg = username + MessageConstant.ALREADY_EXISTS;return Result.error(msg);}else {return Result.error(MessageConstant.UNKNOWN_ERROR);}}
新增员工的代码
2.员工分页查询
2.1需求分析
2.2代码开发
在这里已经把当前的page对象存储到线程里，
然后后续将页码和每页记录数动态拼接到sql语句中
2.3代码完善
/*** 扩展sqringmvc的消息转换器* @param converters*/protected void extendMessageConverters(List<HttpMessageConverter<?>> converters) {//创建一个消息转换器MappingJackson2CborHttpMessageConverter converter = new MappingJackson2CborHttpMessageConverter();//需要为消息转换器设置一个对象转换器，对象转换器可以将Java对象序列化为Json数据converter.setObjectMapper(new JacksonObjectMapper());//将自己的消息转换器加入到容器里converters.add(0,converter);}
<?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.sky.mapper.EmployeeMapper"><select id="pageQuery" resultType="com.sky.entity.Employee">select *from employee<where><if test="name !=null and name !='' ">and name like concat('%',#{name} ,'%')</if></where>order by create_time desc</select>
</mapper>
mybatis:#mapper配置文件mapper-locations: classpath:mapper/*.xmltype-aliases-package: com.sky.entityconfiguration:#开启驼峰命名map-underscore-to-camel-case: true
员工分页查询代码
3.启用禁用员工账号
3.1需求分析
3.2代码开发
启用禁用账号代码
4.编辑员工信息
4.1需求分析
4.2代码开发
/*** 根据id查询员工信息* @param id* @return*/@GetMapping("/{id}")@ApiOperation("根据id查询员工信息")public Result<Employee> queryById(@PathVariable Long id){Employee employee=employeeService.queryById(id);return Result.success(employee);}
/*** 根据id查询员工信息* @param id* @return*/@Select("select * from employee where id =#{id}")Employee queryById(Long id);
编辑员工信息代码
