Example usage for org.hibernate SQLQuery setParameter

Introduction

In this page you can find the example usage for org.hibernate SQLQuery setParameter.

Prototype

@Override
    NativeQuery<T> setParameter(int position, Object val);

Source Link

Usage

From source file:com.poka.dao.impl.BaseDao.java

public String getFunc(String sql, Map<String, Object> params) {
    String result = null;//from w w  w.  j  a  v  a  2 s.  c om
    Transaction transaction = null;
    transaction = getCurrentSession().beginTransaction();
    SQLQuery q = getCurrentSession().createSQLQuery(sql);
    if (params != null && !params.isEmpty()) {
        for (String key : params.keySet()) {
            q.setParameter(key, params.get(key));
        }
    }
    result = (String) q.uniqueResult();
    transaction.commit();
    return result;
}

From source file:com.project.framework.dao.GenericDao.java

License:Apache License

/**
 * ?SQL??SQLQuery// w  ww .jav a 2s.  c o m
 * 
 * @param nativeQueryString SQL?
 * @param values ????,?
 */
public SQLQuery createNativeQuery(final String nativeQueryString, final Object... values) {

    Assert.hasText(nativeQueryString, "nativeQueryString Can not NULL");
    SQLQuery query = getSession().createSQLQuery(nativeQueryString);
    if (values != null) {
        for (int i = 0; i < values.length; i++) {
            query.setParameter(i, values[i]);
        }
    }
    return query;
}

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldDAS.java

License:Open Source License

public List<Integer> getCustomerFieldValues(Integer customerId, MetaFieldType type) {
    if (null == customerId || null == type) {
        throw new IllegalArgumentException("can have null arguments for customer or type");
    }/*  w  w w . j  ava2  s .co  m*/

    SQLQuery query = getSession().createSQLQuery(findCustomerValuesSQL);
    query.setParameter("type", type.toString());
    query.setParameter("customer", customerId);
    return query.list();
}

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldDAS.java

License:Open Source License

public List<Integer> getCustomerFieldValues(Integer customerId, MetaFieldType type, Integer groupId,
        Date effectiveDate) {//from  w  w w  .j a  v a  2  s.  c  o  m
    if (null == customerId || null == type || null == groupId) {
        throw new IllegalArgumentException("can have null arguments for customer, type or group");
    }

    SQLQuery query = getSession().createSQLQuery(findCustomerValuesByGroupSQL);
    query.setParameter("type", type.toString());
    query.setParameter("customer", customerId);
    query.setParameter("groupId", groupId);
    query.setDate("startDate", effectiveDate);
    return query.list();
}

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldDAS.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Integer> getByFieldType(Integer entityId, MetaFieldType[] types) {
    if (null == entityId || null == types || types.length == 0) {
        throw new IllegalArgumentException("entity and types must be defined");
    }//from w ww .j a v a  2  s . c  om
    String strTypes[] = toStringArray(types);
    SQLQuery query = getSession().createSQLQuery(getByFieldTypes);
    query.setParameter("entity", entityId);
    query.setParameterList("types", strTypes);
    return query.list();
}

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldDAS.java

License:Open Source License

public List<Integer> getValuesByCustomerAndFields(Integer customerId, List<Integer> fields) {
    if (null == customerId || null == fields || fields.size() == 0) {
        throw new IllegalArgumentException(" customer and fields can not be null");
    }/* w ww  .  j a  v a2 s.c o  m*/

    SQLQuery query = getSession().createSQLQuery(getValuesByCustomerFields);
    query.setParameter("customer", customerId);
    query.setParameterList("fields", fields);

    query.setDate("startDate", new Date());

    return query.list();
}

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldDAS.java

License:Open Source License

public List<Integer> findPlansByMetaFieldValue(MetaField metaField, String value, Integer entityId) {
    SQLQuery query = getSession().createSQLQuery(getPlansByMetaFieldQuery);
    query.setParameter("mfId", metaField.getId());
    query.setParameter("value", value);
    query.setParameter("entityId", entityId);

    return query.list();
}

From source file:com.school.dao.StageImplement.java

/**
 * *****************************************************************************************************
 * **************************************** ROW OPERATION *******************************************************
 * *****************************************************************************************************
 * @param stage//from   ww w  .  j  a v a 2  s.  c o  m
 * @return 
 */

@Override
public List<RowsOFStage> getAllRows(Stage stage) {

    hibernateDriver.openSession();

    String sql = "SELECT * FROM Rows_OF_Stage WHERE stage_id= :stageID";
    SQLQuery query = hibernateDriver.getSession().createSQLQuery(sql);
    query.addEntity(RowsOFStage.class);
    query.setParameter("stageID", stage.getId());
    List<RowsOFStage> results = query.list();

    hibernateDriver.closeSession();

    return results;
}

From source file:com.school.dao.UserImplement.java

@Override
public Stuff getUser(String userEmail, String userPassword) {
    Stuff user = null;//from  w  ww . ja  va 2s.  co m
    try {
        hibernateDriver.openSession();

        String getUserSql = "Select u.REC_ID , u.USER_TYPE ,u.JOIN_DATE,u.FAMILY_INFO_ID,u.PERSONAL_INFO_ID,u.CLASS_ID,u.STAGE_ID from USERS u INNER JOIN PERSONAL_INFO p ON p.EMAIL= :userEmail and p.PASSWORD= :userPassword";
        SQLQuery query = hibernateDriver.getSession().createSQLQuery(getUserSql);
        query.addEntity(Stuff.class);
        query.setResultTransformer(Criteria.PROJECTION);
        query.setParameter("userEmail", userEmail);
        query.setParameter("userPassword", userPassword);
        user = (Stuff) query.uniqueResult();

        hibernateDriver.closeSession();
    } catch (Exception ex) {
        ex.printStackTrace();
    }

    return user;
}

From source file:com.sistcontable.dao.CuentaDAO.java

public void searchCuentaByID(String id) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();//  ww w . j a  va2s  .  c o m
    List<Cuenta> lista = new ArrayList();
    try {
        String query = "select * from cuenta where ID_CUENTA=:idCuenta";
        SQLQuery sqlQuery = session.createSQLQuery(query);
        sqlQuery.addEntity(Cuenta.class);
        sqlQuery.setParameter("idCuenta", id);
        List result = sqlQuery.list();

        for (int i = 0; i < result.size(); i++) {
            System.out.println("id: ");
            Cuenta cuenta = (Cuenta) result.get(i);

            System.out.println("idCuenta: " + cuenta.getIdCuenta());
            System.out.println("estado: " + cuenta.getEstado().getNombreEstado());
            System.out.println("rubro: " + cuenta.getRubro().getNombreRubro());
            System.out.println("nombreCuenta: " + cuenta.getNombreCuenta());
            System.out.println("cuentaMayor: " + cuenta.getCuentaMayor());
        }
    } catch (Exception e) {
        System.out.println("ERROR " + e);
        lista = null;
    } finally {
        session.close();
    }
}