spring boot整合mybatis使用注解得到自增主键返回值

最新推荐文章于 2024-09-23 20:57:02 发布

nero_claudius

最新推荐文章于 2024-09-23 20:57:02 发布

阅读量5.3k

点赞数 2

本文链接：https://blog.csdn.net/nero_claudius/article/details/88982076

版权

Spring Boot 同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

mybatis

2 篇文章 0 订阅

订阅专栏

spring boot整合mybatis得到自增主键返回值

实体类

@Data
public class OrderRecord {

    private int applicantId;
    private String reason;
    private String members;
    private String startTime;
    private String endTime;
    private int flag;
    private int state;
    private int roomId;
    private int recordId;
    private int departmentId;
    private int companyId;
}

Mapper接口

public interface SimpleUserMapper {

    @Insert("insert into order_record(applicant_id,reason,members,start_time,end_time,room_id,state,department_id,company_id) values(#{applicantId},#{reason},#{members},#{startTime},#{endTime},#{roomId},#{state},#{departmentId},#{companyId})")
    @Options(useGeneratedKeys = true,keyProperty = "recordId")
    int addRecord(OrderRecord orderRecord);
}

useGeneratedKeys设为true是表示使用jdbc的getGeneratedKeys方法来取出数据的主键值（默认为false）

keyProperty标记返回的主键值传递给某个具体的属性（本例是将返回的值重新封装给recordId）

测试

@RunWith(SpringRunner.class)
@SpringBootTest
public class ManagementApplicationTests {

	@Autowired
	private SimpleUserMapper simpleUserMapper;

	@Test
	public void contextLoads() throws UnsupportedEncodingException {
        
		OrderRecord orderRecord = new OrderRecord();
		orderRecord.setApplicantId(1);
		System.out.println(orderRecord.getRecordId());
		simpleUserMapper.addRecord(orderRecord);
		System.out.println(orderRecord.getRecordId());

	}