mybatis员工管理系统代码

MyBatis是一个开源的持久层框架，它可以帮助我们简化数据库操作的代码。下面是一个简单的MyBatis员工管理系统的代码示例：

1. 创建数据库表：

CREATE TABLE employee (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(50),
  age INT,
  department VARCHAR(50)
);

2. 创建Employee实体类：

public class Employee {
  private int id;
  private String name;
  private int age;
  private String department;

  // 省略构造方法、getter和setter方法
}

3. 创建Mapper接口：

public interface EmployeeMapper {
  void addEmployee(Employee employee);
  void updateEmployee(Employee employee);
  void deleteEmployee(int id);
  Employee getEmployeeById(int id);
  List<Employee> getAllEmployees();
}

4. 创建Mapper XML文件：

<!-- EmployeeMapper.xml -->
<mapper namespace="com.example.mapper.EmployeeMapper">
  <insert id="addEmployee" parameterType="com.example.entity.Employee">
    INSERT INTO employee (name, age, department)
    VALUES (#{name}, #{age}, #{department})
  </insert>

  <update id="updateEmployee" parameterType="com.example.entity.Employee">
    UPDATE employee
    SET name = #{name}, age = #{age}, department = #{department}
    WHERE id = #{id}
  </update>

  <delete id="deleteEmployee" parameterType="int">
    DELETE FROM employee WHERE id = #{id}
  </delete>

  <select id="getEmployeeById" parameterType="int" resultType="com.example.entity.Employee">
    SELECT * FROM employee WHERE id = #{id}
  </select>

  <select id="getAllEmployees" resultType="com.example.entity.Employee">
    SELECT * FROM employee
  </select>
</mapper>

5. 创建MyBatis配置文件：

<!-- mybatis-config.xml -->
<configuration>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mybatis_example"/>
        <property name="username" value="root"/>
        <property name="password" value="password"/>
      </dataSource>
    </environment>
  </environments>

  <mappers>
    <mapper resource="com/example/mapper/EmployeeMapper.xml"/>
  </mappers>
</configuration>

6. 使用MyBatis进行数据库操作：

public class Main {
  public static void main(String[] args) {
    String resource = "mybatis-config.xml";
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

    try (SqlSession session = sqlSessionFactory.openSession()) {
      EmployeeMapper employeeMapper = session.getMapper(EmployeeMapper.class);

      // 添加员工
      Employee employee = new Employee();
      employee.setName("张三");
      employee.setAge(25);
      employee.setDepartment("技术部");
      employeeMapper.addEmployee(employee);

      // 更新员工信息
      employee.setName("李四");
      employee.setAge(30);
      employee.setDepartment("人事部");
      employeeMapper.updateEmployee(employee);

      // 删除员工
      employeeMapper.deleteEmployee(employee.getId());

      // 查询员工
      Employee retrievedEmployee = employeeMapper.getEmployeeById(1);
      System.out.println(retrievedEmployee);

      // 查询所有员工
      List<Employee> employees = employeeMapper.getAllEmployees();
      System.out.println(employees);
    }
  }
}

以上是一个简单的MyBatis员工管理系统的代码示例，通过使用MyBatis框架，我们可以更方便地进行数据库操作。如果你有任何问题，请随时提问。