public static Date getDateFromDB(String strDbName) { Session session = null; Transaction tx = null; Date rightNow = null; try { session = getSessionDude(strDbName); tx = session.beginTransaction(); Query query = session.createSQLQuery("SELECT SYSDATE FROM Dual"); List listQuery = query.list(); if (listQuery != null && !listQuery.isEmpty()) { for (int i = 0; i < listQuery.size(); i++) { java.sql.Timestamp rightNowTimeStamp = (java.sql.Timestamp) listQuery.get(i); rightNow = new Date(rightNowTimeStamp.getTime()); if (rightNow != null) { break; } } } } catch (Exception xcp) { xcp.printStackTrace(); } finally { if (session != null && session.isOpen()) { session.close(); } } return rightNow; }
/** * @param classBean * @param strKey * @param value * @return a List of obejcts */ public static java.util.List getListOfObjectByKey( Class classBean, String strKey, Object value, String strDbName) { Session session = null; Transaction tx = null; List result = null; try { session = getSessionDude(strDbName); // sessionFactory.getCurrentSession(); tx = session.beginTransaction(); Criteria criteria = session.createCriteria(classBean); if (strKey != null) { criteria.add(Restrictions.eq(strKey, value)); } result = criteria.list(); tx.commit(); } catch (Exception xcp) { xcp.printStackTrace(); } finally { if (session != null && session.isOpen()) { session.close(); } } return result; }
public static List getListObjectsByAnds( Class myClass, Map<String, Object> mapArgs, String strDbName) { List result = null; Session session = null; Transaction tx = null; if (mapArgs != null && mapArgs.size() > 0) { try { session = getSessionDude(strDbName); // sessionFactory.getCurrentSession(); tx = session.beginTransaction(); Criteria criteria = session.createCriteria(myClass); Iterator iter = mapArgs.entrySet().iterator(); while (iter.hasNext()) { Map.Entry<String, Object> pair = (Map.Entry<String, Object>) iter.next(); criteria.add(Restrictions.eq(pair.getKey(), pair.getValue())); } tx.commit(); result = criteria.list(); } catch (Exception xcp) { xcp.printStackTrace(); } finally { if (session != null && session.isOpen()) { session.close(); } } } return result; }
/** * @param classBean * @param strKey * @param value * @return a first Object from a List of obejcts */ public static Object getObjectByKey( Class classBean, String strKey, Object value, String strDbName) { Session session = getSessionDude(strDbName); // sessionFactory.getCurrentSession(); Transaction tx = session.beginTransaction(); List result = null; Object obj = null; try { Criteria criteria = session.createCriteria(classBean); if (strKey != null) { criteria.add(Restrictions.eq(strKey, value)); } result = criteria.list(); tx.commit(); if (result != null && result.size() > 0) { obj = result.get(0); } } catch (Exception xcp) { xcp.printStackTrace(); } finally { if (session != null && session.isOpen()) { session.close(); } } return obj; }
public static void procedureExecuterPSTATUSREQUISICAO(String reqStCodigo, String strDbName) { Session session = getSessionDude(strDbName); Transaction tx = session.beginTransaction(); Connection con = session.connection(); List result; try { CallableStatement cs = con.prepareCall("{ call PSTATUSREQUISICAO(?,?,?) }"); cs.setString(1, reqStCodigo); // first parameter index start with 1 cs.setString(2, ""); // second parameter cs.setString(3, ""); // second parameter cs.execute(); // call stored procedure tx.commit(); } catch (Exception xcp) { xcp.printStackTrace(); ; } finally { if (session != null && session.isOpen()) { session.close(); } } }