Spring Boot中mybatis insert 如何获得自增id

最新推荐文章于 2025-06-05 14:59:41 发布

转载最新推荐文章于 2025-06-05 14:59:41 发布 · 3.7k 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/zifeiy/p/9760500.html

文章标签：

#java #数据库

https://www.cnblogs.com/quan-coder/p/8728410.html

注意要显式设置主键，通过：

@Options(useGeneratedKeys = true, keyProperty = "id")

将id设置为主键返回。

https://blog.youkuaiyun.com/suwu150/article/details/52896496

一个示例（Mapper中的代码片段）：

    @Insert("insert into tz_lawsuits " + 
            "(credit_cooperative, change_date, admin, borrower, borrower_id, guarantee, litigation_principal, type, starting_end_date," + 
            " lawyer, action_date, litigation_costs, attorney_fees, advance, verdict_id, implementation_date, award_id, takeback_agent_fee," + 
            " takeback_litigation_costs, takeback_principal, outstanding_principal, responsible_person)" + 
            " values" + 
            "(#{credit_cooperative}, #{change_date}, #{admin}, #{borrower}, #{borrower_id}, #{guarantee}, #{litigation_principal}, #{type}, #{starting_end_date}," + 
            " #{lawyer}, #{action_date}, #{litigation_costs}, #{attorney_fees}, #{advance}, #{verdict_id}, #{implementation_date}, #{award_id}, #{takeback_agent_fee}," + 
            " #{takeback_litigation_costs}, #{takeback_principal}, #{outstanding_principal}, #{responsible_person})")
    @Options(useGeneratedKeys = true, keyProperty = "id")
    Integer insertTzLawsuitsObject(TzLawsuits tzLawsuits);

转载于:https://www.cnblogs.com/zifeiy/p/9760500.html