java - spring boot CrudRepository 查询传递对象mysql

Question

我有以下代码：

public interface UserRepository extends CrudRepository<User, Integer> {


@Modifying
@Transactional
@Query(value = "INSERT INTO users(email, password, name) VALUES (?,?,?)", nativeQuery = true)
void insertUserToUsers(String email, String password, String name);
}

我不想传递值，我想传递这样的用户对象：

void insertUserToUsers(User user);

标签： javamysqlspring-boot

Answer 1

试试这个

public interface UserRepository extends CrudRepository<User, Integer> {


@Modifying
@Transactional
@Query(value = "INSERT INTO users(email, password, name) VALUES (:#{#user.email},:#{#user.firstname},:#{#user.name})", nativeQuery = true)
void insertUserToUsers(@Param("user") User user);
}