Java Code Examples for org.hibernate.Query.setBoolean()

The following are Jave code examples for showing how to use setBoolean() of the org.hibernate.Query class. You can vote up the examples you like. Your votes will be used in our system to get more good examples.
+ Save this method
Example 1
Project: sjk   File: MoFeaturedDaoImpl.java   View Source Code Vote up 7 votes
@Override
public Boolean updateDeleted(List<Integer> ids, boolean deleted) {
    String hql = "update MoFeatured set Deleted =:deleted where id in (:ids)";
    Query query = getSession().createQuery(hql);
    query.setBoolean("deleted", deleted);
    query.setParameterList("ids", ids);
    return query.executeUpdate() > 0;
}
 
Example 2
Project: unitimes   File: TimePattern.java   View Source Code Vote up 6 votes
public static List<TimePattern> findAll(Long sessionId, Boolean visible) {
	String query = "from TimePattern tp " +
				 	"where tp.session.uniqueId=:sessionId";
	if (visible!=null) 
	    query += " and visible=:visible";
	
	org.hibernate.Session hibSession = new TimePatternDAO().getSession();
	Query q = hibSession.createQuery(query);
	q.setCacheable(true);
	q.setLong("sessionId", sessionId.longValue());
	if (visible!=null) 
	    q.setBoolean("visible", visible.booleanValue());
	
    List<TimePattern> v = q.list();
    Collections.sort(v);
    return v;
}
 
Example 3
Project: sjk   File: MonUserChannelAppDaoImpl.java   View Source Code Vote up 6 votes
/**
 * @param marketName
 *            :市场名称
 * @param status
 *            :是否可以 true为可以 ,false不可以禁用,不用再监控了。
 */
@Override
public List<MonUserChannelApp> queryList(String marketName, Boolean status) {
    StringBuilder sbSql = new StringBuilder();
    sbSql.append("from MonUserChannelApp m where  1=1 ");
    if (status != null) {
        sbSql.append(" and  m.status=:status ");
    }
    if (StringUtils.isNotBlank(marketName)) {
        sbSql.append(" and   m.marketName=:marketName  ");
    }
    Query query = getSession().createQuery(sbSql.toString());
    if (status != null) {
        query.setBoolean("status", status);
    }
    if (StringUtils.isNotBlank(marketName)) {
        query.setString("marketName", marketName);
    }
    return HibernateHelper.list(query);
}
 
Example 4
Project: sjk   File: MetroDaoImpl.java   View Source Code Vote up 5 votes
@Override
public Boolean updateDeleted(List<Integer> ids, boolean deleted) {
    String hql = "update Metro set Deleted =:deleted where id in (:ids)";
    Query query = getSession().createQuery(hql);
    query.setBoolean("deleted", deleted);
    query.setParameterList("ids", ids);
    return query.executeUpdate() > 0;
}
 
Example 5
Project: ctsms   File: QueryUtil.java   View Source Code Vote up 4 votes
public static void setQueryParameterFromCriterion(String propertyName, Query query, CriterionValueType valueType, int pos, CriterionInstantVO value) throws Exception {
	switch (valueType) {
		case BOOLEAN:
			query.setBoolean(pos, value.getBooleanValue());
			break;
		case BOOLEAN_HASH:
			query.setBinary(pos, CryptoUtil.hashForSearch(value.getBooleanValue()));
			break;
		case DATE:
			query.setDate(pos, value.getDateValue());
			break;
		case DATE_HASH:
			query.setBinary(pos, CryptoUtil.hashForSearch(value.getDateValue()));
			break;
		case TIME:
			query.setTime(pos, value.getTimeValue());
			break;
		case TIME_HASH:
			query.setBinary(pos, CryptoUtil.hashForSearch(value.getTimeValue()));
			break;
		case FLOAT:
			query.setFloat(pos, value.getFloatValue().floatValue());
			break;
		case FLOAT_HASH:
			query.setBinary(pos, CryptoUtil.hashForSearch(value.getFloatValue()));
			break;
		case LONG:
			query.setBigInteger(pos, new BigInteger(value.getLongValue().toString()));
			break;
		case LONG_HASH:
			query.setBinary(pos, CryptoUtil.hashForSearch(value.getLongValue()));
			break;
		case STRING:
			query.setString(pos, value.getStringValue());
			break;
		case STRING_HASH:
			query.setBinary(pos, CryptoUtil.hashForSearch(value.getStringValue()));
			break;
		case TIMESTAMP:
			query.setTimestamp(pos, value.getTimestampValue());
			break;
		case TIMESTAMP_HASH:
			query.setBinary(pos, CryptoUtil.hashForSearch(value.getTimestampValue()));
			break;
		case NONE:
			break;
		default:
			// datatype unimplemented
			throw new IllegalArgumentException(MessageFormat.format(CommonUtil.UNSUPPORTED_CRITERION_VALUE_TYPE, valueType.toString()));
	}
}
 
Example 6
Project: ctsms   File: QueryUtil.java   View Source Code Vote up 4 votes
public static void setQueryParameterFromString(Query query, Class propertyClass, int pos, String value) throws Exception {
	if (propertyClass.equals(String.class)) {
		query.setString(pos, value);
	} else if (propertyClass.equals(Long.class)) {
		query.setBigInteger(pos, new BigInteger(value));
	} else if (propertyClass.equals(java.lang.Long.TYPE)) {
		query.setBigInteger(pos, new BigInteger(value));
	} else if (propertyClass.equals(Integer.class)) {
		query.setInteger(pos, new Integer(value));
	} else if (propertyClass.equals(java.lang.Integer.TYPE)) {
		query.setInteger(pos, new Integer(value));
	} else if (propertyClass.equals(Boolean.class)) {
		query.setBoolean(pos, new Boolean(value));
	} else if (propertyClass.equals(java.lang.Boolean.TYPE)) {
		query.setBoolean(pos, new Boolean(value));
	} else if (propertyClass.equals(Float.class)) {
		query.setFloat(pos, new Float(value));
	} else if (propertyClass.equals(java.lang.Float.TYPE)) {
		query.setFloat(pos, new Float(value));
	} else if (propertyClass.equals(Double.class)) {
		query.setDouble(pos, new Double(value));
	} else if (propertyClass.equals(java.lang.Double.TYPE)) {
		query.setDouble(pos, new Double(value));
	} else if (propertyClass.equals(Date.class)) {
		query.setDate(pos, CommonUtil.parseDate(value, CommonUtil.INPUT_DATE_PATTERN));
	} else if (propertyClass.equals(Timestamp.class)) {
		query.setTimestamp(pos, CommonUtil.dateToTimestamp(CommonUtil.parseDate(value, CommonUtil.INPUT_DATETIME_PATTERN)));
	} else if (propertyClass.equals(VariablePeriod.class)) {
		query.setString(pos, VariablePeriod.fromString(value).name());
	} else if (propertyClass.equals(AuthenticationType.class)) {
		query.setString(pos, AuthenticationType.fromString(value).name());
	} else if (propertyClass.equals(Sex.class)) {
		query.setString(pos, Sex.fromString(value).name());
	} else if (propertyClass.equals(DBModule.class)) {
		query.setString(pos, DBModule.fromString(value).name());
	} else if (propertyClass.equals(HyperlinkModule.class)) {
		query.setString(pos, HyperlinkModule.fromString(value).name());
	} else if (propertyClass.equals(JournalModule.class)) {
		query.setString(pos, JournalModule.fromString(value).name());
	} else if (propertyClass.equals(FileModule.class)) {
		query.setString(pos, FileModule.fromString(value).name());
	} else if (propertyClass.equals(Color.class)) {
		query.setString(pos, Color.fromString(value).name());
	} else if (propertyClass.equals(InputFieldType.class)) {
		query.setString(pos, InputFieldType.fromString(value).name());
	} else if (propertyClass.equals(EventImportance.class)) {
		query.setString(pos, EventImportance.fromString(value).name());
	} else if (propertyClass.equals(ExportStatus.class)) {
		query.setString(pos, ExportStatus.fromString(value).name());
	} else if (propertyClass.isArray() && propertyClass.getComponentType().equals(java.lang.Byte.TYPE)) { // only string hashes supported, no boolean, float, etc...
		query.setBinary(pos, CryptoUtil.hashForSearch(value));
	} else {
		// illegal type...
		throw new IllegalArgumentException(MessageFormat.format(CommonUtil.INPUT_TYPE_NOT_SUPPORTED, propertyClass.toString()));
	}
}