Example #1
0
  public Boolean isTeacherExists(String teacherLoginName, int regid) {
    Transaction transaction = null;
    Session session = null;
    List<RegisterBean> list = null;
    List<Teacher> list2 = null;
    try {
      session = HibernateUtil.getSessionfactory().openSession();
      transaction = session.beginTransaction();
      Query query = session.createQuery("from RegisterBean where loginName=:userid and role=2");
      query.setParameter("userid", teacherLoginName);
      list = query.list();
      if (list.size() > 0) {
        RegisterBean bean = list.get(0);
        Teacher teacher = new Teacher();
        teacher.setClass_id(regid);
        teacher.setUser_id(bean.getRegId());
        query = session.createQuery("from Teacher where user_id=:userid and class_id=:regid");
        query.setParameter("userid", teacher.getUser_id());
        query.setParameter("regid", teacher.getClass_id());
        list2 = query.list();

        if (list2.size() > 0) {
          return true;
        } else {

          return false;
        }
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      if (null != session) {
        session.close();
      }
    }
    return false;
  }