11.21
今天实现Mapper类
LogOnMapper
package com.example.mapper; import com.example.pojo.Department; import com.example.pojo.Staff; import org.apache.ibatis.annotations.*; import java.time.LocalDate; import java.util.List; @Mapper public interface LogONMapper { @Select("select * from attendancesystem.staff where JobID=#{username} and Password=#{password}") Staff getByUser(String username, String password); @Select("select * from attendancesystem.department") List<Department> selectCount(); @Select("select count(*) from attendancesystem.staff") int count(); @Insert("insert into attendancesystem.staff (JobID, Name, Sex, Birthday, Department, Role, Password) VALUES (#{jobID},#{name},#{sex},#{birthday},#{department},#{role},#{password})") void addStaff(String jobID, String name, String sex, LocalDate birthday, String department, String role, String password); @Update("update attendancesystem.staff set Name=#{name},Sex=#{sex}, Birthday=#{birthday} where JobID=#{jobID}") void updateStaff(String jobID, String name, String sex, LocalDate birthday); @Select("select * from attendancesystem.staff where JobID like concat (#{t},'%')") List<Staff> getStaff(String t); @Delete("delete from attendancesystem.staff where JobID=#{id}") void deleteStaff(String id); @Select("select count(*) from attendancesystem.department where DepartmentID=#{id}") int aDep(String id); @Select("select count(*) from attendancesystem.department where DepartmentName=#{name}") int bDep(String name); @Insert("insert into attendancesystem.department (DepartmentID, DepartmentName) VALUES (#{departmentID},#{departmentName})") void addDep(String departmentID, String departmentName); @Update("update attendancesystem.department set DepartmentName=#{departmentName} where DepartmentID=#{departmentID}") void updateDep(String departmentID, String departmentName); @Select("select count(*) from attendancesystem.staff where Department=#{id}") int cDep(String id); @Delete("delete from attendancesystem.department where DepartmentID=#{id}") void deleteDep(String id); @Select("select count(*) from attendancesystem.staff where Role=#{name} ") int dDep(String name); @Update("update attendancesystem.staff set Role=#{name} where JobID=#{id}") void updateRole(String id, String name); @Select("select * from attendancesystem.staff where JobID=#{id}") Staff selectById(String id); @Update("update attendancesystem.staff set Password=#{password} where JobID=#{id}") void update(String id, String password); }
StaffMapper
package com.example.mapper; import com.example.pojo.Attendance; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import org.apache.ibatis.annotations.Update; import java.util.List; @Mapper public interface StaffMapper { @Select("select count(*) from attendancesystem.attendance") int count(); @Insert("insert into attendancesystem.attendance (ID,AttendanceTime,JobID,Name,Sex,Department,AttendanceType,Notes,ApprovedType) VALUES(#{id},#{attendanceTime},#{jobID},#{name}, #{sex},#{department},#{attendanceType},#{notes},#{approvedType})" ) void addStaff(int id, String attendanceTime, String jobID, String name, String sex, String department, int attendanceType, String notes, String approvedType); @Select("select * from attendancesystem.attendance where AttendanceType IN (2, 3) and ApprovedType=#{i}") List<Attendance> low(int i); @Update("update attendancesystem.attendance set ApprovedType=#{i} where AttendanceType= #{type} and Name=#{name}") void approve(String name, String type, String i); }