EmployeeMapper.java 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. package com.sky.mapper;
  2. import com.github.pagehelper.Page;
  3. import com.sky.annotation.AutoFill;
  4. import com.sky.dto.EmployeePageQueryDTO;
  5. import com.sky.entity.Employee;
  6. import com.sky.enumeration.OperationType;
  7. import org.apache.ibatis.annotations.Mapper;
  8. import org.apache.ibatis.annotations.Select;
  9. @Mapper
  10. public interface EmployeeMapper {
  11. /**
  12. * 根据用户名查询员工
  13. * @param username
  14. * @return
  15. */
  16. @Select("select * from employee where username = #{username}")
  17. Employee getByUsername(String username);
  18. /**
  19. * 插入员工数据
  20. * @param employee
  21. */
  22. @Select("insert into employee (name, username, password, phone, " +
  23. "sex, id_number, create_time, update_time, create_user, update_user, status)" +
  24. "values" +
  25. "(#{name},#{username},#{password},#{phone},#{sex},#{idNumber},#{createTime},#{updateTime},#{createUser}," +
  26. "#{updateUser},#{status})")
  27. @AutoFill(value = OperationType.INSERT)
  28. void insert(Employee employee);
  29. /**
  30. * 分页查询
  31. * @param employeePageQueryDTO
  32. * @return
  33. */
  34. Page<Employee> pageQuery(EmployeePageQueryDTO employeePageQueryDTO);
  35. /**
  36. * 根据主键动态修改属性
  37. * @param employee
  38. */
  39. @AutoFill(value = OperationType.UPDATE)
  40. void update(Employee employee);
  41. /**
  42. * 根据id查询员工
  43. * @param id
  44. * @return
  45. */
  46. @Select("select * from employee where id = #{id}")
  47. Employee getById(Integer id);
  48. }