mybatis 新增员工信息
时间: 2023-11-11 15:05:05 浏览: 37
在 MyBatis 中新增员工信息需要进行如下步骤:
1. 创建员工信息实体类,例如:
```java
public class Employee {
private Integer id;
private String name;
private Integer age;
// 省略 getter 和 setter 方法
}
```
2. 创建 Mapper 接口,定义新增员工信息的方法,例如:
```java
public interface EmployeeMapper {
void addEmployee(Employee employee);
}
```
3. 创建 Mapper XML 文件,映射新增员工信息的 SQL 语句,例如:
```xml
<mapper namespace="com.example.mapper.EmployeeMapper">
<insert id="addEmployee" parameterType="com.example.entity.Employee">
insert into employee(name, age) values (#{name}, #{age})
</insert>
</mapper>
```
4. 在 Spring 配置文件中配置 MyBatis 相关的 Bean,例如:
```xml
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/mybatis" />
<property name="username" value="root" />
<property name="password" value="root" />
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mapperLocations" value="classpath:mapper/*.xml" />
</bean>
<bean id="employeeMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.example.mapper.EmployeeMapper" />
<property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
```
5. 在业务逻辑代码中调用新增员工信息的方法,例如:
```java
@Autowired
private EmployeeMapper employeeMapper;
public void addEmployee(Employee employee) {
employeeMapper.addEmployee(employee);
}
```