插入数据到数据库
mapper接口中添加插入@Insert注解
注意:insert方法传入一个实体对象,#{}中要和实体类的属性名一致才能获取到属性值
@Insert("insert into emp(username, name, gender, image, jop, entrydate, dept_id, create_time, update_time) " +
"values (#{username},#{name},#{gender},#{image},#{job},#{entrydate},#{deptId},#{createTime},#{updateTime}) ")
public void insert(User user);
编写一个测试方法
package com.itheima;
import com.itheima.bean.User;
import com.itheima.mapper.EmpMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.time.LocalDate;
import java.time.LocalDateTime;
@SpringBootTest
class SpringbootItheimaApplicationTests {
@Autowired //注入对象
private EmpMapper empMapper;
@Test
public void empInsert(){
User user = new User();
user.setUsername("Tom");
user.setName("汤姆");
user.setImage("1.jpg");
user.setGender((short)1);
user.setJob((short)1);
user.setEntrydate(LocalDate.of(2000,1,1));
user.setCreateTime(LocalDateTime.now());
user.setUpdateTime(LocalDateTime.now());
user.setDeptId(1);
empMapper.insert(user);
}
}
在一些场景中,需要获取数据库数据到主键,但在默认情况下是不会返回主键值的,想要插入后获取主键值可以添加@Option注解,keyProperty = "id"表示生成的主键值封装到实体对象的id属性中,useGeneratedKeys = true代表获取返回到主键值
@Options(keyProperty = "id",useGeneratedKeys = true)
@Insert("insert into emp(username, name, gender, image, jop, entrydate, dept_id, create_time, update_time) " +
"values (#{username},#{name},#{gender},#{image},#{job},#{entrydate},#{deptId},#{createTime},#{updateTime}) ")
public void insert(User user);
}