public int passwordChange(String insName, String oldpw, String newpw) throws CentralStockDAOException { try { org.hibernate.classic.Session session = sessionFactory.getCurrentSession(); Login existingUser = (Login) session.get(Login.class, insName); if (insName.equals(existingUser.getInsName()) && oldpw.equals(existingUser.getUserPw())) { String hql = "UPDATE Login i set i.userPw = '" + newpw + "'WHERE i.insName = '" + insName + "'"; session.createQuery(hql).executeUpdate(); return 1; } else { return 0; } } catch (HibernateException he) { throw new CentralStockDAOException(he + ""); } catch (Exception sl) { throw new CentralStockDAOException(sl + ""); } }
public int checkLogin(String insName, String user, String pwd) throws CentralStockDAOException { try { org.hibernate.classic.Session session = sessionFactory.getCurrentSession(); Login existingUser = (Login) session.get(Login.class, insName); if (insName.equals("Centeral Admin") && user.equals(existingUser.getUserId()) && pwd.equals(existingUser.getUserPw())) { return 1; } else if (insName.equals(existingUser.getInsName()) && user.equals(existingUser.getUserId()) && pwd.equals(existingUser.getUserPw())) { return 2; } else { return 0; } } catch (HibernateException he) { throw new CentralStockDAOException(he + ""); } catch (Exception sl) { throw new CentralStockDAOException(sl + ""); } }