关于#java#的问题：jpa,sql语句不会写

Question

jpa,sql语句不会写

//现有这些字段
id,vs_id, vt_time, depart_id, remark,create_time


//我要把这些数据存进数据库
//下面是我写的sql语句 ,运行报错了

@Query(nativeQuery = true, value = "INSERT INTO vaccine_time(id,vs_id, vt_time, depart_id, remark,create_time)" +
            " VALUE(id=null,vs_id =?1,DATE_FORMAT(vt_time,'%Y-%m-%d%H:%l:%s')=?2, depart_id =?3, remark =?4,create_time=DATE_FORMAT(now(),'%Y-%m-%d%H:%l:%s'))")
    int save(Long vsId, String vtTime, Long finalDepartId, String remark);


//报错
org.springframework.orm.jpa.JpaSystemException: could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

Answer 1

@Query(nativeQuery = true, value = "INSERT INTO vaccine_time(vs_id, vt_time, depart_id, remark,create_time)" +
            " VALUE(?1,DATE_FORMAT(?2,'%Y-%m-%d%H:%l:%s'), ?3, ?4,DATE_FORMAT(now(),'%Y-%m-%d%H:%l:%s'))")

这里表结构的ID 必须不为主键，且必须可为空。