Python 官方文档:入门教程 => 点击学习
目录springDataJpa写原生sql遇到的问题Springdatajpa自定义SQL语句遇到错误NotsupportedforDMLoperationsSpringDataJp
@Repository
public interface EduCourseDao extends JpaRepository<EduCourse,Long>, JpaSpecificationExecutor<EduCourse> {
//根据课程id查询课程的确认信息
@Query(value = "SELECT ec.id,ec.title,ec.price,ec.lesson_num, " +
"ecd.description, " +
"es1.title AS oneSubject, " +
"es2.title AS twoSubject " +
"FROM edu_course ec LEFT JOIN edu_course_description ecd ON ec.id=ecd.id " +
"LEFT JOIN edu_teacher et ON ec.teacher_id=et.id " +
"LEFT JOIN edu_subject es1 ON ec.subject_parent_id=es1.id " +
"LEFT JOIN edu_subject es2 ON ec.subject_id=es2.id " +
"WHERE ec.id=?1 ",nativeQuery = true)
List< Map<String,Object>> findPublishInfoById(String id);
}
因为涉及到其他表,所以返回类型使用List< Map<String,Object>> ,而不是用原先定义的vo类
每行最后的,与 " 之间要有一个空格,不然报错。
今天在自定义一个Update语句时运行遇到一个错误,显示Not supported for DML operations 也就是说不支持DML操作。
我的UserRepository是继承的PagingAndSortingRepository接口,在看了JPA的文档之后,发现此接口不支持update事务,所以需要在注解上添加@Modifying。
原文如下:
3.3.7. Modifying queries
All the sections above describe how to declare queries to access a given entity or collection of entities.Of course you can add custom modifying behaviour by using facilities described in Customimplementations for Spring Data repositories. As this approach is feasible for comprehensive customfunctionality, you can achieve the execution of modifying queries that actually only need parameterbinding by annotating the query method with @Modifying:
Example 45. Declaring manipulating queries
@Modifying
@Query("update User u set u.firstname = ?1 where u.lastname = ?2")
int setFixedFirstnameFor(String firstname, String lastname);
This will trigger the query annotated to the method as updating query instead of a selecting one. As theEntityManager might contain outdated entities after the execution of the modifying query, we do notautomatically clear it (see JavaDoc of EntityManager.clear() for details) since this will effectively dropall non-flushed changes still pending in the EntityManager. If you wish the EntityManager to be clearedautomatically you can set @Modifying annotation's clearAutomatically attribute to true.
以下是我的源码:
@Modifying
@Query("update User u set u.u_name=?2,u.u_sex=?3,u.u_date = ?4,u.u_minzu = ?5,u.u_area=?6,u.u_country=?7 where u.u_id =?1")
public void updateUserById(String u_id,String u_name,String u_sex,
String u_date, String u_minzu,String u_area,
String u_country);
以上为个人经验,希望能给大家一个参考,也希望大家多多支持编程网。
--结束END--
本文标题: SpringDataJpa写原生sql遇到的问题及解决
本文链接: https://www.lsjlt.com/news/157968.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
一口价域名售卖能注册吗?域名是网站的标识,简短且易于记忆,为在线用户提供了访问我们网站的简单路径。一口价是在域名交易中一种常见的模式,而这种通常是针对已经被注册的域名转售给其他人的一种方式。
一口价域名买卖的过程通常包括以下几个步骤:
1.寻找:买家需要在域名售卖平台上找到心仪的一口价域名。平台通常会为每个可售的域名提供详细的描述,包括价格、年龄、流
443px" 443px) https://www.west.cn/docs/wp-content/uploads/2024/04/SEO图片294.jpg https://www.west.cn/docs/wp-content/uploads/2024/04/SEO图片294-768x413.jpg 域名售卖 域名一口价售卖 游戏音频 赋值/切片 框架优势 评估指南 项目规模 安全指南 Osprey 游戏分析 游戏调试 游戏图形 游戏物理 开源库
0