小書童

以 "新增評論" 為例

檔案: 
ReviewsRepository.java

程式碼:

@Modifying
    @Query(value="insert into Reviews (productId,memberId,memberName,email,rating,reviews,time) values(:productId,:memberId,:memberName,:email,:rating,:reviews,:time)" ,nativeQuery = true)
    @Transactional
    void insert(@Param("productId") int productId,@Param("memberId") int loginId, @Param("memberName") String memberName, @Param("email") String email,
            @Param("rating") int rating, @Param("reviews") String reviews, @Param("time") String time);