Mybatis员工信息管理系统：创建、查询、更新和删除员工数据

"新建员工表包含一下字段：\n员工编号，员工姓名，员工性别，员工年龄，员工籍贯，入职时间，薪资\n\n使用mybatis的mapper接口开发完成以下功能：\n1.查询所有员工信息\n2.新增一名员工信息\n3.根据员工编号修改员工信息\n4.根据员工编号删除员工信息\n5.根据性别分组统计平均薪资\n6.查询入职时间在最近一年的员工信息\n7.查询入职两年到三年之间员工的最高薪资和最低薪资的员工信息\n8.查询年龄为25岁的员工中最高薪资的员工信息\n\nPS：关于时间的操作请自己查询相关资料。搜索内容：mybatis时间类型比较\n内容：这里是一个示例的员工表的创建脚本：\n\nsql\nCREATE TABLE employee (\nid INT PRIMARY KEY AUTO_INCREMENT,\nemployee_number INT,\nemployee_name VARCHAR(255),\ngender VARCHAR(10),\nage INT,\nnative_place VARCHAR(255),\nentry_time DATE,\nsalary DECIMAL(10, 2)\n);\n\n\n接下来，你可以创建一个对应该表的实体类，并在Mybatis中创建一个对应的Mapper接口。\n\n1. 查询所有员工信息\n\nMapper接口中定义一个方法：\n\njava\nList<Employee> getAllEmployees();\n\n\n对应的SQL语句：\n\nxml\n<select id="getAllEmployees" resultType="Employee">\n SELECT * FROM employee\n</select>\n\n\n2. 新增一名员工信息\n\nMapper接口中定义一个方法：\n\njava\nvoid addEmployee(Employee employee);\n\n\n对应的SQL语句：\n\nxml\n<insert id="addEmployee">\n INSERT INTO employee (employee_number, employee_name, gender, age, native_place, entry_time, salary)\n VALUES (#{employeeNumber}, #{employeeName}, #{gender}, #{age}, #{nativePlace}, #{entryTime}, #{salary})\n</insert>\n\n\n3. 根据员工编号修改员工信息\n\nMapper接口中定义一个方法：\n\njava\nvoid updateEmployee(Employee employee);\n\n\n对应的SQL语句：\n\nxml\n<update id="updateEmployee">\n UPDATE employee SET employee_number = #{employeeNumber}, employee_name = #{employeeName}, gender = #{gender},\n age = #{age}, native_place = #{nativePlace}, entry_time = #{entryTime}, salary = #{salary}\n WHERE id = #{id}\n</update>\n\n\n4. 根据员工编号删除员工信息\n\nMapper接口中定义一个方法：\n\njava\nvoid deleteEmployee(int id);\n\n\n对应的SQL语句：\n\nxml\n<delete id="deleteEmployee">\n DELETE FROM employee WHERE id = #{id}\n</delete>\n\n\n5. 根据性别分组统计平均薪资\n\nMapper接口中定义一个方法：\n\njava\nList<Map<String, Object>> getAverageSalaryByGender();\n\n\n对应的SQL语句：\n\nxml\n<select id="getAverageSalaryByGender" resultType="java.util.Map">\n SELECT gender, AVG(salary) AS average_salary\n FROM employee\n GROUP BY gender\n</select>\n\n\n6. 查询入职时间在最近一年的员工信息\n\nMapper接口中定义一个方法：\n\njava\nList<Employee> getRecentYearEmployees();\n\n\n对应的SQL语句：\n\nxml\n<select id="getRecentYearEmployees" resultType="Employee">\n SELECT *\n FROM employee\n WHERE entry_time >= DATE_SUB(CURDATE(), INTERVAL 1 YEAR)\n</select>\n\n\n7. 查询入职两年到三年之间员工的最高薪资和最低薪资的员工信息\n\nMapper接口中定义一个方法：\n\njava\nList<Employee> getEmployeesByEntryYears();\n\n\n对应的SQL语句：\n\nxml\n<select id="getEmployeesByEntryYears" resultType="Employee">\n SELECT *\n FROM employee\n WHERE entry_time >= DATE_SUB(CURDATE(), INTERVAL 3 YEAR)\n AND entry_time < DATE_SUB(CURDATE(), INTERVAL 2 YEAR)\n ORDER BY salary DESC\n LIMIT 1\n</select>\n\n\n8. 查询年龄为25岁的员工中最高薪资的员工信息\n\nMapper接口中定义一个方法：\n\njava\nEmployee getHighestSalaryEmployeeByAge(int age);\n\n\n对应的SQL语句：\n\nxml\n<select id="getHighestSalaryEmployeeByAge" resultType="Employee">\n SELECT *\n FROM employee\n WHERE age = #{age}\n ORDER BY salary DESC\n LIMIT 1\n</select>\n\n\n以上是一个示例的使用Mybatis的Mapper接口开发员工信息管理功能的实现。你可以根据需要进行修改和扩展。\n