Hibernate: select person0_.person_id as person1_, person0_.users_name as users2_28_, person0_.person_identity as person3_28_, person0_.person_name as person4_28_, person0_.person_sex as person5_28_, person0_.person_password as person6_28_, person0_.person_mail as person7_28_, person0_.person_addr as person8_28_, person0_.person_zipcode as person9_28_, person0_.person_tel as person10_28_, person0_.person_intr as person11_28_, person0_.person_photo as person12_28_, person0_.person_identification as person13_28_, person0_.last_ip as last14_28_, person0_.last_login_time as last15_28_, person0_.retry_times as retry16_28_, person0_.user_status as user17_28_, person0_.all_logins as all18_28_, person0_1_.student_special as student2_45_, person0_1_.student_hobby as student3_45_, person0_1_.student_num as student4_45_, person0_1_.student_no as student5_45_, person0_1_.classes_id as classes6_45_, person0_1_.state_id as state7_45_, person0_1_.grade_id as grade8_45_, person0_2_.re1 as re2_48_, person0_2_.re2 as re3_48_, person0_2_.teacher_no as teacher4_48_, person0_2_.dept_id as dept5_48_, person0_2_.pos_id as pos6_48_, person0_2_.title_id as title7_48_, person0_3_.name as name56_, person0_3_.title as title56_, person0_4_.parent_name as parent2_57_, person0_4_.parent_title as parent3_57_, person0_4_.parent_workplace as parent4_57_, person0_4_.parent_situation as parent5_57_, person0_4_.re1 as re6_57_, person0_4_.re2 as re7_57_, person0_4_.student_no as student8_57_, case when person0_1_.person_id is not null then 1 when person0_2_.person_id is not null then 2 when person0_3_.person_id is not null then 3 when person0_4_.person_id is not null then 4 when person0_.person_id is not null then 0 end as clazz_ from table_person person0_ left outer join table_student person0_1_ on person0_.person_id=person0_1_.person_id left outer join table_teacher person0_2_ on person0_.person_id=person0_2_.person_id left outer join others person0_3_ on person0_.person_id=person0_3_.person_id left outer join table_parent person0_4_ on person0_.person_id=person0_4_.person_id where person0_.users_name=?
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货