因为对jpa不太熟,遇到jpa的使用问题,搞了半个多小时,特此记录一下,
其他语句网上都有现成的资料。
@Transactional(rollbackFor = Exception.class)
@Modifying
@Query(value = "INSERT into card (cid,catk,cdef,chp,cms,cas,camp,cname,cpow) values (:#{#card.cid},:#{#card.catk},:#{#card.cdef},:#{#card.chp},:#{#card.cms},:#{#card.cas},:#{#card.camp},:#{#card.cname},:#{#card.cpow})",nativeQuery = true)
int saveOne(Card card);
刚开始只是#{#xx}这样写,实际上要添加:,如:#{#xx},才能将实体类里面的参数传进去