HQL 多对多，一对一关联查询

Student 、 Clazz 多对一关联关系：

public class Student {

private int sid;

private String sname;

private String sex;

private int age;

private String addr;

private String college;

private String spec;

private String tel;

private String email;

private Set<Clazz> clazzs;

        private StuPwd stuPwd;

        // getters and setters

}

public class Clazz {

private int id;

private String cname;

private Date btime;

private Date etime;

private int state;

private Set<Student> students;

//getters and setters

}

查询一个班级的学生：

String hql = "select s from Student s left join s.clazzs c where c.id=:id";

注意在类中 clazzs是集合，hql中是当做属性（一个班级）处理的

Student --  StuPwd 是一对一关系

public class StuPwd {

private int sid;

private String nickname;

private String password;

private Student student;

// getters and setters

}

String hql="from Student s left join s.stuPwd pw where s.sname=:name and pw.password=:pass";