public boolean updateInstitution(
String institutionName,
String studentId,
int userId,
int isInstitutionVerified,
String branchName,
int year,
String phoneNumber) {
Session session = null;
try {
session = DBUtil.getSessionFactory().openSession();
Transaction transaction = session.beginTransaction();
String sql = "SELECT * FROM USER WHERE USERID = :userId";
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(User.class);
query.setParameter("userId", userId);
java.util.List results = (java.util.List) query.list();
User currentSession = (User) results.get(0);
currentSession.setInstitutionName(institutionName);
currentSession.setStudentId(studentId);
currentSession.setPhoneNumber(phoneNumber);
currentSession.setYear(year);
currentSession.setBranchName(branchName);
currentSession.setIsInstitutionVerified(isInstitutionVerified);
currentSession.setModified(System.currentTimeMillis());
session.update(currentSession);
transaction.commit();
session.close();
return true;
} catch (HibernateException e) {
System.out.println(e.getMessage());
System.out.println("error");
e.printStackTrace();
} finally {
if (session != null && session.isOpen()) session.close();
}
return false;
}
