81,090
社区成员
发帖
与我相关
我的任务
分享
String sql="UPDATE major m,"
+ "(select major.majorId,"
+ "count(course.courseId) as num "
+ "from course "
+ "INNER JOIN major "
+ "ON major.majorId = course.majorId "
+ "GROUP BY major.majorId "
+ ") c "
+ "SET m.courseNum=c.num "
+ "WHERE m.majorId=c.majorId";
本来是想把这一句改成hql语句
后来发现hibernate可以直接运行sql语句,就没有改了
好在只是修改数据库,没有怎么用到关系映射
谢谢楼上两位了(*^_^*)