今天在做项目的时候,由于项目数据表用到了主外键约束,查询的时候页面上怎么也显示不出来,经过同事的指导,最后搞定。
下面是我总结的东西:
数据表的映射文件,在外键的代码里加上 lazy="false" 属性,dao里直接查询一个主表就行.由于我用的是实体,页面上直接写该实体的属性就可以显示出结果了。
hibernate在执行的时候其实是执行了2条sql语句
Hibernate: select adminuser0_.ID as ID32_, adminuser0_.FK_ROLE_ID as FK2_32_, adminuser0_.USER_NAME as USER3_32_, adminuser0_.USER_PASSWORD as USER4_32_, adminuser0_.USER_NUMBER as USER5_32_, adminuser0_.USER_TRUENAME as USER6_32_, adminuser0_.USER_DEPT as USER7_32_ from HBJXC.ADMINUSER adminuser0_
Hibernate: select role0_.ROLE_ID as ROLE1_33_0_, role0_.ROLE_NAME as ROLE2_33_0_, role0_.ROLE_CODE as ROLE3_33_0_, role0_.INPUT_DATE as INPUT4_33_0_, role0_.ORDER_ID as ORDER5_33_0_ from HBJXC.ROLE role0_ where role0_.ROLE_ID=?