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:be.shad.tsqb.domain.usertype.AddressType.java

License:Apache License

@Override
public Type[] getPropertyTypes() {
    return new Type[] { StringType.INSTANCE, StringType.INSTANCE };
}

---

From source file:be.shad.tsqb.domain.usertype.AddressType.java

License:Apache License

@Override
public void nullSafeSet(final PreparedStatement preparedStatement, final Object value, final int property,
        final SharedSessionContractImplementor sessionImplementor) throws HibernateException, SQLException {
    if (null == value) {
        preparedStatement.setNull(property, StringType.INSTANCE.sqlType());
        preparedStatement.setNull(property + 1, StringType.INSTANCE.sqlType());
    } else {/*  w w  w. ja va2  s.  co m*/
        final Address address = (Address) value;
        preparedStatement.setString(property, address.getStreet());
        preparedStatement.setString(property + 1, address.getNumber());
    }
}

---

From source file:cn.com.sinosoft.cimp.makempi.orgnisempi.querympi.service.impl.QueryOrgniseMpiService.java

private PagingSrcSql queryList(Map<String, String> params) {
    PagingSrcSql srcSql = new PagingSrcSql();
    StringBuffer sb = new StringBuffer();
    List<Object> values = new ArrayList<Object>();
    List<Type> types = new ArrayList<Type>();
    //   {compName=????, ocode=?, principal=, busAddr=???, idCard=???, page=1, rows=10}

    sb.append(" select * from  cimp_orgnise_mpi where 1=1  ");

    String compName = params.get("compName");
    if (!StrUtils.isNull(compName)) {
        sb.append(" and  COMP_NAME like ? ");
        values.add("%" + compName + "%");
        types.add(StringType.INSTANCE);
    }//  ww w  . j a v a2s  .c o m

    String ocode = params.get("ocode");
    if (!StrUtils.isNull(ocode)) {
        sb.append(" AND  OCODE like ? ");
        values.add("%" + ocode + "%");
        types.add(StringType.INSTANCE);
    }

    String principal = params.get("principal");
    if (!StrUtils.isNull(principal)) {
        sb.append(" AND  PRINCIPAL like ? ");
        values.add("%" + principal + "%");
        types.add(StringType.INSTANCE);
    }
    String idCard = params.get("idCard");
    if (!StrUtils.isNull(idCard)) {
        sb.append(" AND  IDCARD like ? ");
        values.add("%" + idCard + "%");
        types.add(StringType.INSTANCE);
    }

    String busAddr = params.get("busAddr");
    if (!StrUtils.isNull(busAddr)) {
        sb.append(" AND  BUS_ADDR like ? ");
        values.add("%" + busAddr + "%");
        types.add(StringType.INSTANCE);
    }

    String hygienicLicenseNum = params.get("hygienicLicenseNum");
    if (!StrUtils.isNull(hygienicLicenseNum)) {
        sb.append(" AND  HYGIENIC_LICENSE_NUM like ? ");
        values.add("%" + hygienicLicenseNum + "%");
        types.add(StringType.INSTANCE);
    }

    /*String birthDateBegin=params.get("dt-begin");
    String birthDateEnd=params.get("dt-end");
    if(!StrUtils.isNull(birthDateBegin)){
       sb.append(" AND  BIRTH_DATE >= ?" );
       values.add(SqlUtil.toDate(birthDateBegin, 0, 0));// SqlUtil.toDate(birthDateBegin, 0, 0)
       types.add(StringType.INSTANCE);
    }
    if(!StrUtils.isNull(birthDateEnd)){
       sb.append(" AND  BIRTH_DATE <= ? " );
       values.add(SqlUtil.toDate(birthDateEnd, 0, 0));// SqlUtil.toDate(birthDateEnd, 0, 0)
       types.add(StringType.INSTANCE);
    }*/

    srcSql.setSrcSql(sb.toString());
    srcSql.setTypes(types.toArray(new Type[0]));
    srcSql.setValues(values.toArray());

    return srcSql;
}

---

From source file:cn.com.sinosoft.cimp.makempi.orgnisempi.querympi.service.impl.QueryOrgniseMpiService.java

@Transactional
public Map<String, String> listToMapByOrg(@RequestParam Map<String, String> params) {
    //Gson gson = new Gson();//reslut = gson.toJson(listByCO);
    Map<String, String> mapMpiByOrg = new HashMap<String, String>();
    String rowID = params.get("rowID");
    String tableNameByCO = params.get("tableNameByCO");
    /*/*from  w ww  .  ja  v a 2  s  .  com*/
       select m.query_mpi_sql from (
        select * from dic_credit_record_management where code_collection_table='CIMP_CO_DISCIPLINE' order by orders 
         ) m where rownum=1; 
     */

    String queryMPI = null;
    if (!StrUtils.isNull(rowID) && !StrUtils.isNull(tableNameByCO)) {
        String query_mpi_sql = "select m.query_mpi_sql from ("
                + "select * from dic_credit_record_management where code_collection_table='" + tableNameByCO
                + "' order by orders " + ") m where rownum=1 ";
        queryMPI = dao.executeSql(query_mpi_sql);
        //String listByCOSql="select * from "+tableNameByCO+" t where t.uuid=?";
        String listByCOSql = queryMPI + " uuid=?";
        List<Map<String, Object>> listByCO = dao.queryListBySql(listByCOSql, new Object[] { rowID },
                new Type[] { StringType.INSTANCE });
        mapMpiByOrg = (HashMap) listByCO.get(0);

    }
    return mapMpiByOrg;
}

---

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

/**
 * /*from  w  w  w  .j  av a 2s  .  co m*/
 * 
 * @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,
        boolean isSearchPunish) {
    PagingSrcSql srcSql = new PagingSrcSql();
    StringBuffer sqlb = new StringBuffer();
    StringBuffer sqlbCount = new StringBuffer();
    List<Object> values = new ArrayList<Object>();
    List<Type> types = new ArrayList<Type>();

    sqlb.append(" SELECT " + getFieldNamesByType(type));
    sqlbCount.append(" SELECT count(1) from CIMP_ST_DISCIPLINE where 1=1 ");
    if (isSearchPunish) {
        // sqlb.append(", getpunished(DIS_ID) PUNISHED_DESC,
        // getillegal(DIS_ID) FACT_DESC ");
    }
    sqlb.append(" , UUID, CREATE_TIME FROM CIMP_ST_DISCIPLINE WHERE 1=1 ");

    // ???
    if (!StrUtils.isNull(specialtyPrimary)) {
        sqlb.append(" and SPECIALTY_PRIMARY like ?");
        sqlbCount.append(" and SPECIALTY_PRIMARY like ?");
        types.add(StringType.INSTANCE);
        values.add(specialtyPrimary + "%");
    } else {// -???
        sqlb.append(" and ( SPECIALTY_PRIMARY like '06%' or SPECIALTY_PRIMARY like '0203%' ) ");
        sqlbCount.append(" and ( SPECIALTY_PRIMARY like '06%' or SPECIALTY_PRIMARY like '0203%' ) ");
    }

    addDateLimit(sqlb, sqlbCount);

    srcSql.setSrcCountSql(sqlbCount.toString());
    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.portal.ws.CreditpublicityService.java

/**
 * //  www  . ja v a  2s  .  c om
 * 
 * @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();
    StringBuffer sqlbCount = 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 ");
    sqlbCount.append(" SELECT count(1) " + " FROM " + getTabNameByType(type) + " WHERE 1=1 ");

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

    addDateLimit(sqlb, sqlbCount);

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

---

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

/**
 * //from  w  ww  .j a v  a 2 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.equals("RECORD_DATE")//
                    || key.equals("CLOSED_DATE")//
            ) {
                continue;
            }

            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.portal.ws.PublicSearchService.java

/**
 * /*from  ww  w. ja  v a 2s . co  m*/
 * 
 * @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, boolean isSearchPunish) {
    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));
    if (isSearchPunish) {
        // sqlb.append(", getpunished(DIS_ID) PUNISHED_DESC, getillegal(DIS_ID) FACT_DESC ");
    }
    sqlb.append(" , UUID, CREATE_TIME 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.portal.ws.PublicSearchService.java

/**
 * //from   w w  w  .  j a  v a  2 s  . co 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, 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 PRODUCT_TYPE = ?");
    types.add(StringType.INSTANCE);
    values.add(produceType);

    //?
    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.portal.ws.PublicSearchService.java

/**
 * /* w  w w.j  ava  2s .c om*/
 * 
 * @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.equals("LICENSEEND_END")) {
                sqlb.append(" AND LICENSEEND <= ? ");
                values.add(params.get(key));
                types.add(StringType.INSTANCE);
                continue;
            }
            if (key.equals("LICENSESTART_BEGIN")) {
                sqlb.append(" AND LICENSESTART >= ? ");
                values.add(params.get(key));
                types.add(StringType.INSTANCE);
                continue;
            }
            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);
}

---

• «
• 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
• »