Home > Back-end >  Jpa the underlying hibernate automatic splicing statement cross join how to inner join
Jpa the underlying hibernate automatic splicing statement cross join how to inner join

Time:09-22

就是日志中的sql Hibernate: select user0_.id as id1_25_, user0_.active_time as active_t2_25_, user0_.avatar as avatar3_25_, user0_.birthday as birthday4_25_, user0_.country as country5_25_, user0_.create_time as create_t6_25_, user0_.email as email7_25_, user0_.external_id as external8_25_, user0_.firebase_token as firebase9_25_, user0_.gender as gender10_25_, user0_.ip as ip11_25_, user0_.is_elite as is_elit12_25_, user0_.is_locked as is_lock13_25_, user0_.lang as lang14_25_, user0_.mobile as mobile15_25_, user0_.my_invite_code as my_invi16_25_, user0_.name as name17_25_, user0_.password as passwor18_25_, user0_.pay_password as pay_pas19_25_, user0_.province as provinc20_25_, user0_.region as region21_25_, user0_.salt as salt22_25_, user0_.self_intro as self_in23_25_, user0_.udid as udid24_25_, user0_.update_time as update_25_25_, user0_.user_id as user_id26_25_
The from user user0_ cross join third_party_account thirdparty1_
Where user0_. User_id=thirdparty1_. User_id and thirdparty1_. Source=? And thirdparty1_. Third_party_id=?

Used to cross the join need to cross into inner but here in the code below UserRepository above this approach is not to write SQL, this should be how to modify

CodePudding user response:

Public interface UserRepository extends JpaRepository {

The User findByUserId (String userId);
}
  • Related