Example usage for org.hibernate.type StringType INSTANCE

Introduction

In this page you can find the example usage for org.hibernate.type StringType INSTANCE.

Prototype

StringType INSTANCE

To view the source code for org.hibernate.type StringType INSTANCE.

Click Source Link

Usage

From source file:cn.com.sinosoft.cimp.portal.ws.PublicSearchService.java

/**
 * ??,//from   w w  w . j av a2  s .  c o  m
 *
 * 
 * @param params
 * @param sql
 * @param values
 * @param types
 * @author <a href="mailto:nytclizy@gmail.com">?</a>
 */
private void handleSearchParams(String type, Map<String, String> params, StringBuffer sql, List<Object> values,
        List<Type> types) {
    String[] paramFields = INFOS.get(type)[2];
    for (String paramField : paramFields) {
        if (!StrUtils.isNull(params.get(paramField))) {

            //?paramField
            paramField = StringEscapeUtils.escapeSql(paramField);

            if (isLikeField(paramField)) {
                sql.append(" AND " + paramField + " like ? ");
                values.add(params.get(paramField) + "%");
            } else {
                sql.append(" AND " + paramField + " = ? ");
                values.add(params.get(paramField));
            }

            types.add(StringType.INSTANCE);
        }
    }
}

---

From source file:cn.com.sinosoft.cimp.tran.websit.service.CreditpublicityService.java

/**
 * /*ww w  . j a  v a  2 s  .com*/
 * 
 * @Method: getDisciplineSearchInfos
 * @Method Description: ?
 * @Input parameters:@param type
 * @Input parameters:@param  specialtyPrimary ???
 * @Input parameters:@param params
 * @Input parameters:@param pageParam
 * @Input parameters:@return     
 * @Return parameters:PagingResult
 * @Auther:ZhangPan
 * @Date: 2015-9-29 ?6:15:54
 * @Throws: exception  
 *
 */
public PagingResult getDisciplineSearchInfos(String type, String specialtyPrimary, PageParam pageParam) {
    PagingSrcSql srcSql = new PagingSrcSql();
    StringBuffer sqlb = new StringBuffer();
    List<Object> values = new ArrayList<Object>();
    List<Type> types = new ArrayList<Type>();

    sqlb.append(" SELECT " + getFieldNamesByType(type) + " , getpunished(DIS_ID) PUNISHED_DESC "
            + " , getillegal(DIS_ID) FACT_DESC " + " FROM CIMP_ST_DISCIPLINE " + " WHERE 1=1 ");

    //???
    sqlb.append(" and SPECIALTY_PRIMARY like ?");
    types.add(StringType.INSTANCE);
    values.add(specialtyPrimary + "%");

    addDateLimit(sqlb);

    srcSql.setSrcSql(sqlb.toString());
    srcSql.setTypes(types.toArray(new Type[0]));
    srcSql.setValues(values.toArray());
    return pagingSearch(pageParam, srcSql);
}

---

From source file:cn.com.sinosoft.cimp.tran.websit.service.CreditpublicityService.java

/**
 * /*from  w w w. j a v a 2s  .  c o  m*/
 * 
 * @Method: getFoodSearchInfos
 * @Method Description: ???
 * @Input parameters:@param type
 * @Input parameters:@param produceType
 * @Input parameters:@param params
 * @Input parameters:@param pageParam
 * @Input parameters:@return     
 * @Return parameters:PagingResult
 * @Auther:ZhangPan
 * @Date: 2015-9-29 ?10:39:22
 * @Throws: exception  
 *
 */
private PagingResult getFoodSearchInfos(String type, String produceType, PageParam pageParam) {
    PagingSrcSql srcSql = new PagingSrcSql();
    StringBuffer sqlb = new StringBuffer();
    List<Object> values = new ArrayList<Object>();
    List<Type> types = new ArrayList<Type>();

    sqlb.append(" SELECT " + getFieldNamesByType(type) + " FROM " + getTabNameByType(type) + " WHERE 1=1 ");

    //?
    sqlb.append(" and PRODUCT_TYPE = ?");
    types.add(StringType.INSTANCE);
    values.add(produceType);

    addDateLimit(sqlb);

    srcSql.setSrcSql(sqlb.toString());
    srcSql.setTypes(types.toArray(new Type[0]));
    srcSql.setValues(values.toArray());
    return pagingSearch(pageParam, srcSql);
}

---

From source file:cn.com.sinosoft.cimp.tran.websit.service.PublicSearchService.java

/**
 * /*from   ww w  .j  ava2  s  .c  o  m*/
 * 
 * @Method: getSeWarterInfos
 * @Method Description: ??????
 * @Input parameters:@param type
 * @Input parameters:@param params
 * @Input parameters:@param pageParam
 * @Input parameters:@return     
 * @Return parameters:PagingResult
 * @Auther:ZhangPan
 * @Date: 2015-9-29 ?6:38:14
 * @Throws: exception  
 *
 */
public PagingResult getSeWarterInfos(String type, Map<String, String> params, PageParam pageParam) {
    PagingSrcSql srcSql = new PagingSrcSql();
    StringBuffer sqlb = new StringBuffer();
    List<Object> values = new ArrayList<Object>();
    List<Type> types = new ArrayList<Type>();

    sqlb.append(" SELECT " + getFieldNamesByType(type) + " FROM " + getTabNameByType(type) + " WHERE 1=1 ");

    //????
    /*sqlb.append(" AND STATE_RELEASE = ? AND STATE_VALID = ? ");
    values.add(APP.CIMP_DATAPUBSTATE_ENABLE);
    values.add(APP.CIMP_DATASTATE_ENABLE);
    types.add(StringType.INSTANCE);
    types.add(StringType.INSTANCE);*/
    //??????
    sqlb.append(" and COMP_TYPE LIKE '0203%'");

    //?
    handleSearchParams(type, params, sqlb, values, types);

    //?
    for (String key : params.keySet()) {
        if (!StrUtils.isNull(params.get(key))) {
            if (key.endsWith("_BEGIN")) {
                sqlb.append(" AND " + SqlUtil.toDate(params.get(key), 1, 0) + " <= "
                        + key.substring(0, key.length() - 6));
            } else if (key.endsWith("_END")) {
                sqlb.append(" AND " + SqlUtil.toDate(params.get(key), 1, 0) + " >= "
                        + key.substring(0, key.length() - 4));
            } else if (key.endsWith("DATE")) {
                sqlb.append(" AND " + SqlUtil.toChar(key, 0, 0) + " = ? ");
                values.add(params.get(key));
                types.add(StringType.INSTANCE);
            }
        }
    }

    srcSql.setSrcSql(sqlb.toString());
    srcSql.setTypes(types.toArray(new Type[0]));
    srcSql.setValues(values.toArray());
    return pagingSearch(pageParam, srcSql);
}

---

From source file:cn.com.sinosoft.cimp.tran.websit.service.PublicSearchService.java

/**
 * /*w  w w. j  a  va2s  .c om*/
 * 
 * @Method: getDisciplineSearchInfos
 * @Method Description: ?
 * @Input parameters:@param type
 * @Input parameters:@param  specialtyPrimary ???
 * @Input parameters:@param params
 * @Input parameters:@param pageParam
 * @Input parameters:@return     
 * @Return parameters:PagingResult
 * @Auther:ZhangPan
 * @Date: 2015-9-29 ?6:15:54
 * @Throws: exception  
 *
 */
public PagingResult getDisciplineSearchInfos(String type, String specialtyPrimary, Map<String, String> params,
        PageParam pageParam) {
    PagingSrcSql srcSql = new PagingSrcSql();
    StringBuffer sqlb = new StringBuffer();
    List<Object> values = new ArrayList<Object>();
    List<Type> types = new ArrayList<Type>();

    sqlb.append(" SELECT " + getFieldNamesByType(type) + " , getpunished(DIS_ID) PUNISHED_DESC "
            + " , getillegal(DIS_ID) FACT_DESC " + " FROM CIMP_ST_DISCIPLINE " + " WHERE 1=1 ");

    //????
    /*sqlb.append(" AND STATE_RELEASE = ? AND STATE_VALID = ? ");
    values.add(APP.CIMP_DATAPUBSTATE_ENABLE);
    values.add(APP.CIMP_DATASTATE_ENABLE);
    types.add(StringType.INSTANCE);
    types.add(StringType.INSTANCE);*/
    //???
    sqlb.append(" and SPECIALTY_PRIMARY like ?");
    types.add(StringType.INSTANCE);
    values.add(specialtyPrimary + "%");

    //?
    handleSearchParams(type, params, sqlb, values, types);

    //?
    for (String key : params.keySet()) {
        if (!StrUtils.isNull(params.get(key))) {
            if (key.endsWith("_BEGIN")) {
                sqlb.append(" AND " + SqlUtil.toDate(params.get(key), 1, 0) + " <= "
                        + key.substring(0, key.length() - 6));
            } else if (key.endsWith("_END")) {
                sqlb.append(" AND " + SqlUtil.toDate(params.get(key), 1, 0) + " >= "
                        + key.substring(0, key.length() - 4));
            } else if (key.endsWith("DATE")) {
                sqlb.append(" AND " + SqlUtil.toChar(key, 0, 0) + " = ? ");
                values.add(params.get(key));
                types.add(StringType.INSTANCE);
            }
        }
    }

    srcSql.setSrcSql(sqlb.toString());
    srcSql.setTypes(types.toArray(new Type[0]));
    srcSql.setValues(values.toArray());
    return pagingSearch(pageParam, srcSql);
}

---

From source file:cn.com.sinosoft.cimp.tran.websit.service.PublicSearchService.java

/**
 * //from  w  w w  .  j a  v  a  2s .  co m
 * 
 * @Method: getSimplePubsearchInfos
 * @Method Description: ?
 * @Input parameters:@param type
 * @Input parameters:@param params
 * @Input parameters:@param pageParam
 * @Input parameters:@return     
 * @Return parameters:PagingResult
 * @Auther:ZhangPan
 * @Date: 2015-9-28 ?3:29:28
 * @Throws: exception  
 *
 */
private PagingResult getSimplePubsearchInfos(String type, Map<String, String> params, PageParam pageParam) {
    PagingSrcSql srcSql = new PagingSrcSql();
    StringBuffer sqlb = new StringBuffer();
    List<Object> values = new ArrayList<Object>();
    List<Type> types = new ArrayList<Type>();

    sqlb.append(" SELECT " + getFieldNamesByType(type) + " FROM " + getTabNameByType(type) + " WHERE 1=1 ");

    //????
    /*sqlb.append(" AND STATE_RELEASE = ? AND STATE_VALID = ? ");
    values.add(APP.CIMP_DATAPUBSTATE_ENABLE);
    values.add(APP.CIMP_DATASTATE_ENABLE);
    types.add(StringType.INSTANCE);
    types.add(StringType.INSTANCE);*/

    //?
    handleSearchParams(type, params, sqlb, values, types);

    //?
    for (String key : params.keySet()) {
        if (!StrUtils.isNull(params.get(key))) {
            if (key.endsWith("_BEGIN")) {
                sqlb.append(" AND " + SqlUtil.toDate(params.get(key), 1, 0) + " <= "
                        + key.substring(0, key.length() - 6));
            } else if (key.endsWith("_END")) {
                sqlb.append(" AND " + SqlUtil.toDate(params.get(key), 1, 0) + " >= "
                        + key.substring(0, key.length() - 4));
            } else if (key.endsWith("DATE")) {
                sqlb.append(" AND " + SqlUtil.toChar(key, 0, 0) + " = ? ");
                values.add(params.get(key));
                types.add(StringType.INSTANCE);
            }
        }
    }

    srcSql.setSrcSql(sqlb.toString());
    srcSql.setTypes(types.toArray(new Type[0]));
    srcSql.setValues(values.toArray());
    return pagingSearch(pageParam, srcSql);
}

---

From source file:cn.com.sinosoft.cimp.tran.websit.service.PublicSearchService.java

/**
 * ??,/*from  ww w .  j a  v  a 2s  . c o  m*/
 *
 * 
 * @param params
 * @param sql
 * @param values
 * @param types
 * @author <a href="mailto:nytclizy@gmail.com">?</a>
 */
private void handleSearchParams(String type, Map<String, String> params, StringBuffer sql, List<Object> values,
        List<Type> types) {
    String[] paramFields = INFOS.get(type)[2];
    for (String paramField : paramFields) {
        if (!StrUtils.isNull(params.get(paramField))) {
            sql.append(" AND " + paramField + " = ? ");
            values.add(params.get(paramField));
            types.add(StringType.INSTANCE);
        }
    }
}

---

From source file:com.court.controller.HomeFXMLController.java

private Map<String, Number> getLoanReleasedData() {
    LocalDate now = LocalDate.now();
    Map<String, Number> map = new HashMap<>();
    Session s = HibernateUtil.getSessionFactory().openSession();
    Criteria c = s.createCriteria(MemberLoan.class);

    ProjectionList pList = Projections.projectionList();
    ClassMetadata lpMeta = s.getSessionFactory().getClassMetadata(MemberLoan.class);
    pList.add(Projections.property(lpMeta.getIdentifierPropertyName()));
    for (String prop : lpMeta.getPropertyNames()) {
        pList.add(Projections.property(prop), prop);
    }//w w w .  j  a  va2s .com
    c.add(Restrictions.eq("status", true));
    c.add(Restrictions.between("grantedDate", FxUtilsHandler.getDateFrom(now.with(firstDayOfYear())),
            FxUtilsHandler.getDateFrom(now.with(lastDayOfYear()))));
    c.setProjection(pList
            .add(Projections.sqlGroupProjection("DATE_FORMAT(granted_date, '%Y-%m-01') AS groupPro", "groupPro",
                    new String[] { "groupPro" }, new Type[] { StringType.INSTANCE }))
            .add(Projections.sqlProjection("SUM(loan_amount) AS lSum", new String[] { "lSum" },
                    new Type[] { DoubleType.INSTANCE })));

    c.addOrder(Order.asc("grantedDate"));
    c.setResultTransformer(Transformers.aliasToBean(MemberLoan.class));
    List<MemberLoan> list = (List<MemberLoan>) c.list();
    for (MemberLoan ml : list) {
        map.put(ml.getGroupPro(), ml.getlSum());
    }
    s.close();
    return map;
}

---

From source file:com.court.controller.HomeFXMLController.java

private Map<String, Number> getLoanCollectionData() {
    LocalDate now = LocalDate.now();
    Map<String, Number> map = new HashMap<>();
    Session s = HibernateUtil.getSessionFactory().openSession();
    Criteria c = s.createCriteria(LoanPayment.class);

    ProjectionList pList = Projections.projectionList();
    ClassMetadata lpMeta = s.getSessionFactory().getClassMetadata(LoanPayment.class);
    pList.add(Projections.property(lpMeta.getIdentifierPropertyName()));
    for (String prop : lpMeta.getPropertyNames()) {
        pList.add(Projections.property(prop), prop);
    }/*from w w  w  .j a v a 2  s.  co m*/
    c.add(Restrictions.between("paymentDate", FxUtilsHandler.getDateFrom(now.with(firstDayOfYear())),
            FxUtilsHandler.getDateFrom(now.with(lastDayOfYear()))));
    c.setProjection(pList
            .add(Projections.sqlGroupProjection("DATE_FORMAT(payment_date, '%Y-%m-01') AS groupPro", "groupPro",
                    new String[] { "groupPro" }, new Type[] { StringType.INSTANCE }))
            .add(Projections.sqlProjection("SUM(paid_amt) AS lSum", new String[] { "lSum" },
                    new Type[] { DoubleType.INSTANCE })));

    c.addOrder(Order.asc("paymentDate"));
    c.setResultTransformer(Transformers.aliasToBean(LoanPayment.class));
    List<LoanPayment> list = (List<LoanPayment>) c.list();
    for (LoanPayment lp : list) {
        map.put(lp.getGroupPro(), lp.getlSum());
    }
    s.close();
    return map;
}

---

From source file:com.dungnv.streetfood.business.ArticleBusiness.java

License:Open Source License

@Override
public List<ArticleDTO> getListArticleDTOLess(String userName, String localeCode, String countryCode,
        String token, ArticleDTO dto, int rowStart, int maxRow, boolean isCount, String sortType,
        String sortFieldList) {//from  w  w w .j a  v  a2s  .c o m
    StringBuilder sbQuery = new StringBuilder();
    List<Object> listParam = new ArrayList<>();
    List<Type> listType = new ArrayList<>();

    if (isCount) {
        sbQuery.append(" select count(a.id) as id from article a where 1=1 ");
    } else {
        sbQuery.append(" select a.id");
        sbQuery.append(" , a.title");
        if (dto == null || !"1".equals(dto.getIsGetOnlyIdentified())) {
            sbQuery.append(" , a.short_content shortContent");
            sbQuery.append(" , a.view_count viewCount");
            sbQuery.append(" , g.id imageId");
            sbQuery.append(" , g.url imageUrl");
        }

        sbQuery.append("  from article a left outer join img g on a.id = g.article_id and g.orders = 1");
        sbQuery.append(" where 1 = 1");
    }

    if (dto != null) {
        StringUtils.trimString(dto, false);

        if (!StringUtils.isNullOrEmpty(dto.getId())) {
            sbQuery.append(" AND  a.id = ?");
            listParam.add(Long.valueOf(dto.getId()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(dto.getRestaurantId())) {
            sbQuery.append(
                    " AND a.id in ( select article_id from restaurant_article where restaurant_id = ? ) ");
            listParam.add(Long.valueOf(dto.getRestaurantId()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(dto.getNotRestaurantId())) {
            sbQuery.append(
                    " AND a.id not in ( select article_id from restaurant_article where restaurant_id = ? ) ");
            listParam.add(Long.valueOf(dto.getNotRestaurantId()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(dto.getDishId())) {
            sbQuery.append(" AND a.id in ( select article_id from dish_article where dish_id = ? ) ");
            listParam.add(Long.valueOf(dto.getDishId()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(dto.getNotDishId())) {
            sbQuery.append(" AND a.id not in ( select article_id from dish_article where dish_id = ? ) ");
            listParam.add(Long.valueOf(dto.getNotDishId()));
            listType.add(LongType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(dto.getTitle())) {
            sbQuery.append(" AND lower(a.title) like ? ");
            listParam.add("%" + dto.getTitle().toLowerCase() + "%");
            listType.add(StringType.INSTANCE);
        }
        if (!StringUtils.isNullOrEmpty(dto.getShortContent())) {
            sbQuery.append(" AND lower(a.short_content) like ? ");
            listParam.add("%" + dto.getShortContent().toLowerCase() + "%");
            listType.add(StringType.INSTANCE);
        }

        if (!StringUtils.isNullOrEmpty(dto.getContent())) {
            sbQuery.append(" AND lower(a.content) like ? ");
            listParam.add("%" + dto.getContent().toLowerCase() + "%");
            listType.add(StringType.INSTANCE);
        }

        if (dto.getListTag() != null && !dto.getListTag().isEmpty()) {
            sbQuery.append(" AND  a.id in (select article_id from tag_article where tag_id in ");
            sbQuery.append(QueryUtil.getParameterHolderString(dto.getListTag().size()));
            sbQuery.append(" )");
            List<String> listTag = dto.getListTag();
            for (String tagId : listTag) {
                listParam.add(Long.valueOf(tagId));
                listType.add(LongType.INSTANCE);
            }
        }
    }

    if (!isCount) {
        sbQuery.append(" order by a.title DESC");
        if (maxRow != 0) {
            sbQuery.append(" limit ?, ?");
            listParam.add(rowStart);
            listType.add(IntegerType.INSTANCE);
            listParam.add(maxRow);
            listType.add(IntegerType.INSTANCE);
        }

    }

    SQLQuery query = gettDAO().getSession().createSQLQuery(sbQuery.toString());
    query.addScalar("id", StringType.INSTANCE);
    if (!isCount) {
        query.addScalar("title", StringType.INSTANCE);
        if (dto == null || !"1".equals(dto.getIsGetOnlyIdentified())) {
            query.addScalar("shortContent", StringType.INSTANCE);
            query.addScalar("viewCount", StringType.INSTANCE);
            query.addScalar("imageId", StringType.INSTANCE);
            query.addScalar("imageUrl", StringType.INSTANCE);
        }
    }

    query.setResultTransformer(Transformers.aliasToBean(ArticleDTO.class));

    for (int i = 0; i < listParam.size(); i++) {
        query.setParameter(i, listParam.get(i), listType.get(i));
    }

    List<ArticleDTO> list = query.list();
    return list;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• »