公司日常考勤系统#2

定义实体类与接口，在接口中实现基本的增删改查

package com.xxx.pojo;

public class Attendance {
    private String id;
    private String attendanceTime;
    private String jobId;
    private String name;
    private String sex;
    private String birthday;
    private String department;
    private String attendanceType;

    @Override
    public String toString() {
        return "Attendance{" +
                "id='" + id + '\'' +
                ", attendanceTime='" + attendanceTime + '\'' +
                ", jobID='" + jobId + '\'' +
                ", name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                ", birthday='" + birthday + '\'' +
                ", department='" + department + '\'' +
                ", attendanceType='" + attendanceType + '\'' +
                '}';
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getAttendanceTime() {
        return attendanceTime;
    }

    public void setAttendanceTime(String attendanceTime) {
        this.attendanceTime = attendanceTime;
    }

    public String getJobId() {
        return jobId;
    }

    public void setJobId(String jobId) {
        this.jobId = jobId;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getBirthday() {
        return birthday;
    }

    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }

    public String getAttendanceType() {
        return attendanceType;
    }

    public void setAttendanceType(String attendanceType) {
        this.attendanceType = attendanceType;
    }
}

package com.xxx.pojo;

public class Department {
  private String departmentID;
  private String department;

    @Override
    public String toString() {
        return "Department{" +
                "departmentID='" + departmentID + '\'' +
                ", department='" + department + '\'' +
                '}';
    }

    public String getDepartmentID() {
        return departmentID;
    }

    public void setDepartmentID(String departmentID) {
        this.departmentID = departmentID;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }
}

package com.xxx.pojo;

public class Employee {
    private String jobId;
    private String name;
    private String sex;
    private String birthday;
    private String department;
    private String role;
    private String password;

    @Override
    public String toString() {
        return "Employee{" +
                "JobID='" + jobId + '\'' +
                ", Name='" + name + '\'' +
                ", sex='" + sex + '\'' +
                ", birthday='" + birthday + '\'' +
                ", department='" + department + '\'' +
                ", role='" + role + '\'' +
                ", password='" + password + '\'' +
                '}';
    }

    public String getJobId() {
        return jobId;
    }

    public void setJobId(String jobId) {
        this.jobId = jobId;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getBirthday() {
        return birthday;
    }

    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }

    public String getRole() {
        return role;
    }

    public void setRole(String role) {
        this.role = role;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

package com.xxx.mapper;

import com.xxx.pojo.Attendance;

import org.apache.ibatis.annotations.*;

import java.util.List;

public interface AttendanceMapper {
    @Insert("insert into attendance (Id,AttendanceTime,JobId,Name,sex,birthday,department,attendanceType) VALUES (null, #{attendanceTime}, #{jobId}, #{name}, #{sex}, #{birthday},#{department},#{attendanceType})")
    void add(Attendance attendance);
    @Select("select * from attendance where jobId=#{id}")
    List<Attendance> selectAllById(String id);
    @Select("select * from attendance where department=#{department}")
    List<Attendance> selectAllByDepartment(String department);

//    @Update("update attendance set Name=#{name}, sex=#{sex}, birthday=#{birthday} where JobID=#{jobId}")
//    void update(Attendance attendance);

//    @Update("update attendance set Password='123456' where JobID=#{id}")
//    void resetPassword(@Param("id") String id);
//    @Update("update attendance set role=#{role} where JobID=#{id}")
//    void setRole(@Param("id") String id, @Param("role") String role);

//    @Delete("delete from attendance where JobID=#{id}")
//    void delete(@Param("id") String id);



//    @Select("select * from attendance where JobID=#{id}")
//    Attendance selectById(@Param("id") String id);
}

package com.xxx.mapper;

import com.xxx.pojo.Department;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface DepartmentMapper {

    // 插入新的部门
    @Insert("insert into department (departmentID, department) values (#{departmentID}, #{department})")
    void add(Department department);

    // 查询所有部门
    @Select("select * from department")
    List<Department> selectAll();

    // 根据部门ID查询部门
    @Select("select * from department where departmentID = #{departmentID}")
    Department selectByID(String departmentID);

    // 更新部门信息
    @Update("update department set department = #{department} where departmentID = #{departmentID}")
    void update(Department department);

    // 删除部门
    @Delete("delete from department where departmentID = #{departmentID}")
    void delete(@Param("departmentID") String departmentID);
}

package com.xxx.mapper;

import com.xxx.pojo.Employee;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface EmployeeMapper {
    @Insert("insert into employee (Name, sex, birthday, department, role, password) VALUES (#{name}, #{sex}, #{birthday}, #{department}, #{role}, #{password})")
    void add(Employee employee);

    @Update("update employee set Name=#{name}, sex=#{sex}, birthday=#{birthday} where JobID=#{jobId}")
    void update(Employee employee);

    @Update("update employee set Password='123456' where JobID=#{id}")
    void resetPassword(@Param("id") String id);
    @Update("update employee set Password='123456' where JobID=#{id}")
    void changePassword(@Param("id") String password, @Param("id") String id);
    @Update("update employee set role=#{role} where JobID=#{id}")
    void setRole(@Param("id") String id, @Param("role") String role);
    @Update("update employee set department=#{department} where JobID=#{id}")
    void setDepartment(@Param("id") String id, @Param("department") String department);

    @Delete("delete from employee where JobID=#{id}")
    void delete(@Param("id") String id);

    @Select("select * from employee")
    List<Employee> selectAll();


    @Select("select * from employee where JobID=#{id}")
    Employee selectById(@Param("id") String id);


}

package com.xxx.service;

import com.xxx.mapper.AttendanceMapper;
import com.xxx.pojo.Attendance;
import com.xxx.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import java.util.List;

public class AttendanceService {
    private SqlSessionFactory factory= SqlSessionFactoryUtils.getSqlSessionFactory();
    public void add(Attendance attendance){
        SqlSession session=factory.openSession();
        AttendanceMapper attendanceMapper=session.getMapper(AttendanceMapper.class);
        attendanceMapper.add(attendance);
        session.commit();
        session.close();

    }
    public List<Attendance> selectAllById(String id){
        SqlSession session=factory.openSession();
        AttendanceMapper attendanceMapper=session.getMapper(AttendanceMapper.class);
        List<Attendance> attendanceList=attendanceMapper.selectAllById(id);
        session.commit();
        session.close();
        return attendanceList;

    }
    public List<Attendance> selectAllByDepartment(String department){
        SqlSession session=factory.openSession();
        AttendanceMapper attendanceMapper=session.getMapper(AttendanceMapper.class);
        List<Attendance> attendanceList=attendanceMapper.selectAllByDepartment(department);
        session.commit();
        session.close();
        return attendanceList;
    }
}

package com.xxx.service;

import com.xxx.mapper.DepartmentMapper;
import com.xxx.pojo.Department;
import com.xxx.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import java.util.List;

public class DepartmentService {
    private SqlSessionFactory factory= SqlSessionFactoryUtils.getSqlSessionFactory();
    public void add(Department department) {
        SqlSession session=factory.openSession();
        DepartmentMapper mapper=session.getMapper(DepartmentMapper.class);
        mapper.add(department);
        session.commit();
        session.close();
    }
    public List<Department> selectAll() {
        SqlSession session=factory.openSession();
        DepartmentMapper mapper=session.getMapper(DepartmentMapper.class);
        List<Department> departments = mapper.selectAll();
        session.close();
        return departments;
    }
    public Department selectById(String id) {
        SqlSession session=factory.openSession();
        DepartmentMapper mapper=session.getMapper(DepartmentMapper.class);
        Department department = mapper.selectByID(id);
        session.close();
        return department;
    }
    public void update(Department department) {
        SqlSession session=factory.openSession();
        DepartmentMapper mapper=session.getMapper(DepartmentMapper.class);
        mapper.update(department);
        session.commit();
        session.close();
    }
    public void delete(String id) {
        SqlSession session=factory.openSession();
        DepartmentMapper mapper=session.getMapper(DepartmentMapper.class);
        mapper.delete(id);
        session.commit();
        session.close();


    }
}

package com.xxx.service;

import com.xxx.mapper.EmployeeMapper;
import com.xxx.pojo.Employee;
import com.xxx.util.SqlSessionFactoryUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import java.util.List;

public class EmployeeService {
    private SqlSessionFactory factory=SqlSessionFactoryUtils.getSqlSessionFactory();
    public void add(Employee employee){
        SqlSession session=factory.openSession();
        EmployeeMapper mapper=session.getMapper(EmployeeMapper.class);
        mapper.add(employee);
        session.commit();
        session.close();

    }
    public void delete(String id){
        SqlSession session=factory.openSession();
        EmployeeMapper mapper=session.getMapper(EmployeeMapper.class);
        mapper.delete(id);
        session.commit();
        session.close();

    }
    public void update(Employee employee){
        SqlSession session=factory.openSession();
        EmployeeMapper mapper=session.getMapper(EmployeeMapper.class);
        mapper.update(employee);
        session.commit();
        session.close();

    }
    public void reset(String id){
        SqlSession session=factory.openSession();
        EmployeeMapper mapper=session.getMapper(EmployeeMapper.class);
        mapper.resetPassword(id);
        session.commit();
        session.close();

    }
    public List<Employee> selectAll(){
        SqlSession session=factory.openSession();
        EmployeeMapper mapper=session.getMapper(EmployeeMapper.class);
        List<Employee> employees=mapper.selectAll();
        session.close();
        return employees;
    }
    public Employee selectById(String id){
        SqlSession session=factory.openSession();
        EmployeeMapper mapper=session.getMapper(EmployeeMapper.class);
        Employee employee=mapper.selectById(id);
        session.close();
        return employee;

    }
    public void setRole(String id,String role){
        SqlSession session=factory.openSession();
        EmployeeMapper mapper=session.getMapper(EmployeeMapper.class);
        mapper.setRole(id,role);
        session.commit();
        session.close();

    }
    public void changePassword(String password,String id){
        SqlSession session=factory.openSession();
        EmployeeMapper mapper=session.getMapper(EmployeeMapper.class);
        mapper.changePassword(password,id);
        session.commit();
        session.close();

    }
    public void setDepartment(String id,String department){
        SqlSession session=factory.openSession();
        EmployeeMapper mapper=session.getMapper(EmployeeMapper.class);
        mapper.setDepartment(id,department);
        session.commit();
        session.close();
    }
}