Hibernate: select user0_.uid as uid4_, user0_.username as username4_, user0_.password as password4

本文链接：https://blog.csdn.net/tfy1332/article/details/10175231

本文展示了使用Hibernate框架执行的SQL查询示例，主要包括基于用户名和密码进行用户验证的查询，以及根据用户ID获取菜单项信息的联表查询。通过这些查询可以了解Hibernate如何将对象关系映射到SQL语句。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Hibernate: select user0_.uid as uid4_, user0_.username as username4_, user0_.password as password4_, user0_.email as email4_, user0_.phone as phone4_, user0_.sex as sex4_, user0_.did as did4_ from user user0_ where user0_.username=? and user0_.password=?
Hibernate: select user0_.uid as uid4_, user0_.username as username4_, user0_.password as password4_, user0_.email as email4_, user0_.phone as phone4_, user0_.sex as sex4_, user0_.did as did4_ from user user0_ where user0_.username=? and user0_.password=?
Hibernate: select menuitem0_.mid as mid6_0_, user2_.uid as uid4_1_, menuitem0_.pid as pid6_0_, menuitem0_.isParent as isParent6_0_, menuitem0_.checked as checked6_0_, menuitem0_.name as name6_0_, menuitem0_.target as target6_0_, menuitem0_.icon as icon6_0_, menuitem0_.url as url6_0_, user2_.username as username4_1_, user2_.password as password4_1_, user2_.email as email4_1_, user2_.phone as phone4_1_, user2_.sex as sex4_1_, user2_.did as did4_1_, users1_.mid as mid0__, users1_.uid as uid0__ from menuitem menuitem0_ inner join user_menuitem users1_ on menuitem0_.mid=users1_.mid inner join user user2_ on users1_.uid=user2_.uid where user2_.uid=?