1.
@Override
public RespBean addEmp(Employee employee) {
LocalDate beginContract = employee.getBeginContract();
LocalDate endContract = employee.getEndContract();
//LocalDate 类型的util方法 计算和第一个参数的相差的天数 第二个 计量单位
long days = beginContract.until(endContract, ChronoUnit.DAYS);
DecimalFormat decimalFormat = new DecimalFormat("##.00");
employee.setContractTerm(Double.parseDouble(decimalFormat.format(days/365.00)));
if (1==employeeMapper.insert(employee)){
return RespBean.success("添加成功");
}
return RespBean.error("添加失败");
}
2.后台读取数据库中的最大值函数
@Override
public RespBean maxWorkID() {
List<Map<String, Object>> maps = employeeMapper.selectMaps(new QueryWrapper<Employee>().select("max(workID)"));
//%08d 前边不足8位的用0补齐
return RespBean.success(null,String.format("%08d",
Integer.parseInt(maps.get(0).get("max(workID)").toString())+1));
}