使用java和sql server设计和实现员工管理的管理系统并给出代码。该系统主要的功能如下： 1、 员工基本信息的管理：员工基本信息的录入、修改、删除和查询功能。2、 部门信息的管理：部门信息的录入、修改、删除和查询功能。3、 请假信息管理：实现员工请假信息的录入、修改、删除和查询功能 4、 考勤信息管理：迟到、早退、旷工等信息的录入、修改、删除和查询功能。5、 加班信息管理：加班信息的录入、修改、删除和查询功能。6、 工资信息管理：工资信息的录入、修改、删除和查询功能。

由于题目中要求使用Java和SQL Server来设计和实现员工管理的管理系统，我们可以采用Java作为后端编程语言，使用Spring Boot框架进行开发，同时使用MyBatis框架进行数据库操作，并且使用SQL Server作为数据库。

下面是代码实现，我们将其分为几个模块来实现。

## 模块一：员工基本信息管理

### 员工信息实体类

public class Employee {
    private int id;
    private String name;
    private String gender;
    private Date birthday;
    private String idCard;
    private String phone;
    private String address;
    private String email;
    private Date hireDate;
    private Department department;
    // setter和getter方法
}

### 员工信息DAO接口

public interface EmployeeMapper {
    int add(Employee employee);
    int delete(int id);
    int update(Employee employee);
    Employee findById(int id);
    List<Employee> findAll();
}

### 员工信息DAO实现类

@Repository
public class EmployeeMapperImpl implements EmployeeMapper {
    @Autowired
    private SqlSession sqlSession;

    @Override
    public int add(Employee employee) {
        return sqlSession.insert("EmployeeMapper.add", employee);
    }

    @Override
    public int delete(int id) {
        return sqlSession.delete("EmployeeMapper.delete", id);
    }

    @Override
    public int update(Employee employee) {
        return sqlSession.update("EmployeeMapper.update", employee);
    }

    @Override
    public Employee findById(int id) {
        return sqlSession.selectOne("EmployeeMapper.findById", id);
    }

    @Override
    public List<Employee> findAll() {
        return sqlSession.selectList("EmployeeMapper.findAll");
    }
}

### 员工信息服务类

@Service
public class EmployeeService {
    @Autowired
    private EmployeeMapper employeeMapper;

    public int add(Employee employee) {
        return employeeMapper.add(employee);
    }

    public int delete(int id) {
        return employeeMapper.delete(id);
    }

    public int update(Employee employee) {
        return employeeMapper.update(employee);
    }

    public Employee findById(int id) {
        return employeeMapper.findById(id);
    }

    public List<Employee> findAll() {
        return employeeMapper.findAll();
    }
}

## 模块二：部门信息管理

### 部门信息实体类

public class Department {
    private int id;
    private String name;
    private String description;
    // setter和getter方法
}

### 部门信息DAO接口

public interface DepartmentMapper {
    int add(Department department);
    int delete(int id);
    int update(Department department);
    Department findById(int id);
    List<Department> findAll();
}

### 部门信息DAO实现类

@Repository
public class DepartmentMapperImpl implements DepartmentMapper {
    @Autowired
    private SqlSession sqlSession;

    @Override
    public int add(Department department) {
        return sqlSession.insert("DepartmentMapper.add", department);
    }

    @Override
    public int delete(int id) {
        return sqlSession.delete("DepartmentMapper.delete", id);
    }

    @Override
    public int update(Department department) {
        return sqlSession.update("DepartmentMapper.update", department);
    }

    @Override
    public Department findById(int id) {
        return sqlSession.selectOne("DepartmentMapper.findById", id);
    }

    @Override
    public List<Department> findAll() {
        return sqlSession.selectList("DepartmentMapper.findAll");
    }
}

### 部门信息服务类

@Service
public class DepartmentService {
    @Autowired
    private DepartmentMapper departmentMapper;

    public int add(Department department) {
        return departmentMapper.add(department);
    }

    public int delete(int id) {
        return departmentMapper.delete(id);
    }

    public int update(Department department) {
        return departmentMapper.update(department);
    }

    public Department findById(int id) {
        return departmentMapper.findById(id);
    }

    public List<Department> findAll() {
        return departmentMapper.findAll();
    }
}

## 模块三：请假信息管理

### 请假信息实体类

public class Leave {
    private int id;
    private Employee employee;
    private Date startTime;
    private Date endTime;
    private String reason;
    private String status;
    // setter和getter方法
}

### 请假信息DAO接口

public interface LeaveMapper {
    int add(Leave leave);
    int delete(int id);
    int update(Leave leave);
    Leave findById(int id);
    List<Leave> findAll();
}

### 请假信息DAO实现类

@Repository
public class LeaveMapperImpl implements LeaveMapper {
    @Autowired
    private SqlSession sqlSession;

    @Override
    public int add(Leave leave) {
        return sqlSession.insert("LeaveMapper.add", leave);
    }

    @Override
    public int delete(int id) {
        return sqlSession.delete("LeaveMapper.delete", id);
    }

    @Override
    public int update(Leave leave) {
        return sqlSession.update("LeaveMapper.update", leave);
    }

    @Override
    public Leave findById(int id) {
        return sqlSession.selectOne("LeaveMapper.findById", id);
    }

    @Override
    public List<Leave> findAll() {
        return sqlSession.selectList("LeaveMapper.findAll");
    }
}

### 请假信息服务类

@Service
public class LeaveService {
    @Autowired
    private LeaveMapper leaveMapper;

    public int add(Leave leave) {
        return leaveMapper.add(leave);
    }

    public int delete(int id) {
        return leaveMapper.delete(id);
    }

    public int update(Leave leave) {
        return leaveMapper.update(leave);
    }

    public Leave findById(int id) {
        return leaveMapper.findById(id);
    }

    public List<Leave> findAll() {
        return leaveMapper.findAll();
    }
}

## 模块四：考勤信息管理

### 考勤信息实体类

public class Attendance {
    private int id;
    private Employee employee;
    private Date date;
    private String status;
    // setter和getter方法
}

### 考勤信息DAO接口

public interface AttendanceMapper {
    int add(Attendance attendance);
    int delete(int id);
    int update(Attendance attendance);
    Attendance findById(int id);
    List<Attendance> findAll();
}

### 考勤信息DAO实现类

@Repository
public class AttendanceMapperImpl implements AttendanceMapper {
    @Autowired
    private SqlSession sqlSession;

    @Override
    public int add(Attendance attendance) {
        return sqlSession.insert("AttendanceMapper.add", attendance);
    }

    @Override
    public int delete(int id) {
        return sqlSession.delete("AttendanceMapper.delete", id);
    }

    @Override
    public int update(Attendance attendance) {
        return sqlSession.update("AttendanceMapper.update", attendance);
    }

    @Override
    public Attendance findById(int id) {
        return sqlSession.selectOne("AttendanceMapper.findById", id);
    }

    @Override
    public List<Attendance> findAll() {
        return sqlSession.selectList("AttendanceMapper.findAll");
    }
}

### 考勤信息服务类

@Service
public class AttendanceService {
    @Autowired
    private AttendanceMapper attendanceMapper;

    public int add(Attendance attendance) {
        return attendanceMapper.add(attendance);
    }

    public int delete(int id) {
        return attendanceMapper.delete(id);
    }

    public int update(Attendance attendance) {
        return attendanceMapper.update(attendance);
    }

    public Attendance findById(int id) {
        return attendanceMapper.findById(id);
    }

    public List<Attendance> findAll() {
        return attendanceMapper.findAll();
    }
}

## 模块五：加班信息管理

### 加班信息实体类

public class Overtime {
    private int id;
    private Employee employee;
    private Date date;
    private String reason;
    private String status;
    // setter和getter方法
}

### 加班信息DAO接口

public interface OvertimeMapper {
    int add(Overtime overtime);
    int delete(int id);
    int update(Overtime overtime);
    Overtime findById(int id);
    List<Overtime> findAll();
}

### 加班信息DAO实现类

@Repository
public class OvertimeMapperImpl implements OvertimeMapper {
    @Autowired
    private SqlSession sqlSession;

    @Override
    public int add(Overtime overtime) {
        return sqlSession.insert("OvertimeMapper.add", overtime);
    }

    @Override
    public int delete(int id) {
        return sqlSession.delete("OvertimeMapper.delete", id);
    }

    @Override
    public int update(Overtime overtime) {
        return sqlSession.update("OvertimeMapper.update", overtime);
    }

    @Override
    public Overtime findById(int id) {
        return sqlSession.selectOne("OvertimeMapper.findById", id);
    }

    @Override
    public List<Overtime> findAll() {
        return sqlSession.selectList("OvertimeMapper.findAll");
    }
}

### 加班信息服务类

@Service
public class OvertimeService {
    @Autowired
    private OvertimeMapper overtimeMapper;

    public int add(Overtime overtime) {
        return overtimeMapper.add(overtime);
    }

    public int delete(int id) {
        return overtimeMapper.delete(id);
    }

    public int update(Overtime overtime) {
        return overtimeMapper.update(overtime);
    }

    public Overtime findById(int id) {
        return overtimeMapper.findById(id);
    }

    public List<Overtime> findAll() {
        return overtimeMapper.findAll();
    }
}

## 模块六：工资信息管理

### 工资信息实体类

public class Salary {
    private int id;
    private Employee employee;
    private Date date;
    private double basicSalary;
    private double bonus;
    private double deduction;
    private double tax;
    private double netSalary;
    // setter和getter方法
}

### 工资信息DAO接口

public interface SalaryMapper {
    int add(Salary salary);
    int delete(int id);
    int update(Salary salary);
    Salary findById(int id);
    List<Salary> findAll();
}

### 工资信息DAO实现类

@Repository
public class SalaryMapperImpl implements SalaryMapper {
    @Autowired
    private SqlSession sqlSession;

    @Override
    public int add(Salary salary) {
        return sqlSession.insert("SalaryMapper.add", salary);
    }

    @Override
    public int delete(int id) {
        return sqlSession.delete("SalaryMapper.delete", id);
    }

    @Override
    public int update(Salary salary) {
        return sqlSession.update("SalaryMapper.update", salary);
    }

    @Override
    public Salary findById(int id) {
        return sqlSession.selectOne("SalaryMapper.findById", id);
    }

    @Override
    public List<Salary> findAll() {
        return sqlSession.selectList("SalaryMapper.findAll");
    }
}

### 工资信息服务类

@Service
public class SalaryService {
    @Autowired
    private SalaryMapper salaryMapper;

    public int add(Salary salary) {
        return salaryMapper.add(salary);
    }

    public int delete(int id) {
        return salaryMapper.delete(id);
    }

    public int update(Salary salary) {
        return salaryMapper.update(salary);
    }

    public Salary findById(int id) {
        return salaryMapper.findById(id);
    }

    public List<Salary> findAll() {
        return salaryMapper.findAll();
    }
}

至此，我们已经完成了员工管理系统的设计和实现。当然，以上代码只是一个简单的示例，实际开发中还需要考虑更多的因素，如数据校验、异常处理、安全性等。