基于Mybatis-Plus代码生成的项目
Employee.java
package com.huazai.b2c.aiyou.entity;
import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.extension.activerecord.Model;
import com.baomidou.mybatisplus.annotation.TableId;
import java.io.Serializable;
import com.baomidou.mybatisplus.annotations.Version;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
/**
* Company: b2c哎呦商城
* Department: 研发一组
* Title: [aiyou — Employee模块]
* Description: [Employee类信息的实体类]
* Created on: 2017-06-15
* Contacts: [who.seek.me@java98k.vip]
*
* @author huazai
* @version V1.1.0
*/
@Data
@ToString
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("aiyou_employee")
public class Employee extends Model<Employee>
{
private static final long serialVersionUID = 1L;
/**
* 主建ID
*/
@TableId(value = "id", type = IdType.AUTO)
private Integer id;
/**
* 姓名
*/
private String name;
/**
* 电话号码
*/
private String phone;
/**
* 住址
*/
private String address;
/**
* 部门ID
*/
private Integer deptId;
/**
* 身份证
*/
private String idCard;
/**
* 状态,0:删除,1:启用,2:停用
*/
private Integer status;
@Override
protected Serializable pkVal()
{
return this.id;
}
}
EmployeeMapper.java
package com.huazai.b2c.aiyou.mapper;
import com.huazai.b2c.aiyou.entity.Employee;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
/**
* Company: b2c哎呦商城
* Department: 研发一组
* Title: [aiyou — Employee模块]
* Description: [Employee类信息的dao层接口]
* Created on: 2017-06-15
* Contacts: [who.seek.me@java98k.vip]
*
* @author huazai
* @version V1.1.0
*/
public interface EmployeeMapper extends BaseMapper<Employee>
{
}
EmployeeMapper.xml
<?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.huazai.b2c.aiyou.mapper.EmployeeMapper">
<!-- 通用查询映射结果 -->
<resultMap id="BaseResultMap"
type="com.huazai.b2c.aiyou.entity.Employee">
<id column="id" property="id" />
<result column="name" property="name" />
<result column="phone" property="phone" />
<result column="address" property="address" />
<result column="dept_id" property="deptId" />
<result column="id_card" property="idCard" />
<result column="status" property="status" />
</resultMap>
<!-- 通用查询结果列 -->
<sql id="Base_Column_List">
id, name, phone, address, dept_id, id_card, status
</sql>
</mapper>
EmployeeService.java
package com.huazai.b2c.aiyou.service;
import com.huazai.b2c.aiyou.entity.Employee;
import com.baomidou.mybatisplus.extension.service.IService;
import com.baomidou.mybatisplus.plugins.Page;
/**
* Company: b2c哎呦商城
* Department: 研发一组
* Title: [aiyou — Employee模块]
* Description: [Employee类信息的service层接口]
* Created on: 2017-06-15
* Contacts: [who.seek.me@java98k.vip]
*
* @author huazai
* @version V1.1.0
*/
public interface EmployeeService extends IService<Employee>
{
Page<Employee> selectPageWithParam(Page<Employee> page, Employee param);
}
EmployeeServiceImpl.java
package com.huazai.b2c.aiyou.service.impl;
import com.huazai.b2c.aiyou.entity.Employee;
import com.huazai.b2c.aiyou.mapper.EmployeeMapper;
import com.huazai.b2c.aiyou.service.EmployeeService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
/**
* Company: b2c哎呦商城
* Department: 研发一组
* Title: [aiyou — Employee模块]
* Description: [Employee类信息的service层实现类]
* Created on: 2017-06-15
* Contacts: [who.seek.me@java98k.vip]
*
* @author huazai
* @version V1.1.0
*/
@Service
public class EmployeeServiceImpl extends ServiceImpl<EmployeeMapper, Employee> implements EmployeeService
{
@Override
public Page<Employee> selectPageWithParam(Page<Employee> page, Employee param)
{
EntityWrapper<Employee> entityWrapper = new EntityWrapper<>(param);
Page<Employee> pageEmployee = selectPage(page, entityWrapper);
return pageEmployee;
}
}
EmployeeController.java
package com.huazai.b2c.aiyou.controller;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.beans.factory.annotation.Autowired;
import com.baomidou.mybatisplus.plugins.Page;
import com.huazai.b2c.aiyou.service.EmployeeService;
import com.swcares.sqc.common.ResponseData;
import com.huazai.b2c.aiyou.entity.Employee;
import lombok.extern.slf4j.Slf4j;
import io.swagger.annotations.*;
/**
* Company: b2c哎呦商城
* Department: 研发一组
* Title: [aiyou — Employee模块]
* Description: [Employee类信息的controller层接口]
* Created on: 2017-06-15
* Contacts: [who.seek.me@java98k.vip]
*
* @author huazai
* @version V1.1.0
*/
@Slf4j
@RestController
@Api(value = "/employee", description = "Employee 控制器")
@RequestMapping("/employee")
public class EmployeeController
{
@Autowired
public EmployeeService employeeService;
/**
* Description:[单表分页查询]
*
* @param param
* [实体]
* @param length
* [单页大小]
* @param pageNo
* [页数]
* @return ResponseData
*/
@GetMapping("/getEmployeeList")
@ApiOperation(value = "/getEmployeeList", notes = "获取分页列表")
public ResponseData getEmployeeList(@ApiParam(name = "Employee", value = "Employee 实体类") Employee param,
@RequestParam(name = "length") @ApiParam(name = "length", value = "页大小", defaultValue = "10") Integer length,
@RequestParam(name = "pageNo") @ApiParam(name = "pageNo", value = "页数", defaultValue = "1") Integer pageNo)
{
Page<Employee> pageEmployee;
try
{
Page<Employee> page = new Page<>(pageNo, length);
pageEmployee = employeeService.selectPageWithParam(page, param);
} catch (Exception e)
{
log.info("异常信息:{}", e.getMessage());
return ResponseData.error(500, e.getMessage());
}
return ResponseData.ok().put("List<Employee>", pageEmployee);
}
/**
* Description:[通过id获取实体信息]
*
* @param id
* [id]
* @return ResponseData
*/
@GetMapping("/getEmployeeById")
@ApiOperation(value = "/getEmployeeById", notes = "通过id获取Employee")
public ResponseData getEmployeeById(
@RequestParam(name = "id") @ApiParam(name = "id", value = "EmployeeID", required = true) Long id)
{
Employee param;
try
{
param = employeeService.selectById(id);
} catch (Exception e)
{
log.info("异常信息:{}", e.getMessage());
return ResponseData.error(500, e.getMessage());
}
return ResponseData.ok().put("+Employee+", param);
}
/**
* Description:[通过id删除实体信息]
*
* @param id
* [id]
* @return ResponseData
*/
@DeleteMapping("/deleteEmployeeById")
@ApiOperation(value = "/deleteEmployeeById", notes = "通过id删除Employee")
public ResponseData deleteEmployeeById(
@RequestParam(name = "id") @ApiParam(name = "id", value = "EmployeeID", required = true) Long id)
{
try
{
employeeService.deleteById(id);
} catch (Exception e)
{
log.info("异常信息:{}", e.getMessage());
return ResponseData.error(500, e.getMessage());
}
return ResponseData.ok();
}
/**
* Description:[通过实体ID修改信息]
*
* @param param
* [实体信息]
* @return ResponseData
*/
@PutMapping("/updateEmployeeById")
@ApiOperation(value = "/updateEmployeeById", notes = "通过id更新Employee")
public ResponseData updateEmployeeById(@ApiParam(name = "Employee", value = "Employee 实体类") Employee param)
{
try
{
employeeService.updateById(param);
} catch (Exception e)
{
log.info("异常信息:{}", e.getMessage());
return ResponseData.error(500, e.getMessage());
}
return ResponseData.ok();
}
/**
* Description:[通过实体添加新的数据]
*
* @param param
* [实体信息]
* @return ResponseData
*/
@PutMapping("/addEmployee")
@ApiOperation(value = "/addEmployee", notes = "添加Employee")
public ResponseData addEmployee(@ApiParam(name = "Employee", value = "Employee 实体类") Employee param)
{
try
{
employeeService.insert(param);
} catch (Exception e)
{
log.info("异常信息:{}", e.getMessage());
return ResponseData.error(500, e.getMessage());
}
return ResponseData.ok();
}
}