com.huateng.ebank.entity.dao.mng.SeqctlDAO.java Source code

Introduction

Here is the source code for com.huateng.ebank.entity.dao.mng.SeqctlDAO.java

Source

/*
 * ==================================================================
 * The Huateng Software License
 *
 * Copyright (c) 2004-2005 Huateng Software System.  All rights
 * reserved.
 * ==================================================================
 */
//jianxue.zhang
package com.huateng.ebank.entity.dao.mng;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.type.Type;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.huateng.ebank.business.common.ErrorCode;
import com.huateng.ebank.entity.data.mng.Seqctl;
import com.huateng.ebank.framework.exceptions.CommonException;
import com.huateng.ebank.framework.util.ExceptionUtil;

/**
 * @author valley
 * jianxue.zhang
 * @date 2005-06-01
 * @desc ?
 */
public class SeqctlDAO extends HibernateDaoSupport {

    public SeqctlDAO() {
        super();
    }

    /**
     * ?Hibernate ID
     *
     * @param id
     * @return Seqctl
     * @throws CommonException
     */
    public Seqctl query(long id) throws CommonException {
        try {
            return (Seqctl) this.getHibernateTemplate().load(Seqctl.class, new Long(id), LockMode.UPGRADE);
        } catch (Exception e) {
            ExceptionUtil.throwCommonException(e.getMessage(), ErrorCode.ERROR_CODE_SEQCTL_SELECT, e);
        }
        return null;
    }

    /**
     * ?null
     * ???
     * modify by shen_antonio 20081107
     * @param valueNo
     * @param valueIndex
     * @return Seqctl
     * @throws CommonException
     */
    public Seqctl query(final int valueNo, final String valueIndex) throws CommonException {
        List list = new ArrayList();
        try {
            list = (List) this.getHibernateTemplate().execute(new HibernateCallback() {
                public Object doInHibernate(Session session) throws HibernateException {
                    //modified by xuhong 2015-03-11 ?sql2003?oracle begin
                    //             StringBuffer whereString = new StringBuffer(" select po.ID,po.MAX_VALUE,po.MIN_VALUE,po.VALUE_CURR from SEQCTL po  with (TABLOCKX) where ");
                    StringBuffer whereString = new StringBuffer(
                            " select po.ID,po.MAX_VALUE,po.MIN_VALUE,po.VALUE_CURR from SEQCTL po  where ");
                    //modified by xuhong 2015-03-11 ?sql2003?oracle end
                    whereString.append("po.value_No = ").append(valueNo).append(" and po.value_Index = '")
                            .append(valueIndex).append("'  ");
                    if (logger.isDebugEnabled()) {
                        logger.debug("queryBySQL(String) - sql sql=" + whereString.toString()); //$NON-NLS-1$
                    }
                    // System.out.println(whereString.toString());
                    Query qry = session.createSQLQuery(whereString.toString());
                    // qry.setLockMode("po", LockMode.UPGRADE);
                    return qry.list();
                }
            });
            //list = queryByCondition(whereString.toString());
        } catch (Exception e) {
            ExceptionUtil.throwCommonException(e.getMessage(), ErrorCode.ERROR_CODE_SEQCTL_SELECT, e);
        }

        if (list.size() != 1) {
            return null;
        } else {
            Object[] dd = (Object[]) list.get(0);
            Seqctl seqctl = new Seqctl();
            seqctl.setId(((BigDecimal) dd[0]).intValue());
            seqctl.setMaxValue(((BigDecimal) dd[1]).intValue());
            seqctl.setMinValue(((BigDecimal) dd[2]).intValue());
            seqctl.setValueCurr(((BigDecimal) dd[3]).intValue());
            seqctl.setValueIndex(valueIndex);
            seqctl.setValueNo(valueNo);
            return seqctl;
        }
    }

    /**
     * ????
     *
     * @param whereString
     * @param objArray
     * @param typeArray
     * @return ?SeqctlList
     * @throws CommonException
     */
    public List queryByCondition(String whereString, Object[] objArray, Type[] typeArray) throws CommonException {
        try {
            List list = this.getHibernateTemplate().find("from Seqctl po where " + whereString, objArray);
            return list;
        } catch (Exception e) {
            ExceptionUtil.throwCommonException(e.getMessage(), ErrorCode.ERROR_CODE_SEQCTL_SELECT, e);
        }
        return null;
    }

    /**
     * ????
     *
     * @param whereString
     * @return ?SeqctlList
     * @throws CommonException
     */
    public List queryByCondition(String whereString) throws CommonException {
        try {
            List list = this.getHibernateTemplate().find("from Seqctl po where " + whereString);
            return list;
        } catch (Exception e) {
            ExceptionUtil.throwCommonException(e.getMessage(), ErrorCode.ERROR_CODE_SEQCTL_SELECT, e);
        }
        return null;
    }

    /**
     * 
     *
     * @param po
     * @throws CommonException
     */
    public void update(Seqctl po) throws CommonException {
        try {
            this.getHibernateTemplate().update(po);
        } catch (Exception e) {
            ExceptionUtil.throwCommonException(e.getMessage(), ErrorCode.ERROR_CODE_SEQCTL_UPDATE, e);
        }
    }

    /**
     * ?
     *
     * @param po
     * @throws CommonException
     */
    public void insert(Seqctl po) throws CommonException {
        try {
            this.getHibernateTemplate().save(po);
        } catch (Exception e) {
            ExceptionUtil.throwCommonException(e.getMessage(), ErrorCode.ERROR_CODE_SEQCTL_INSERT, e);
        }
    }

    /**
     * 
     *
     * @param po
     * @throws CommonException
     */
    public void delete(Seqctl po) throws CommonException {
        try {
            this.getHibernateTemplate().delete(po);
        } catch (Exception e) {
            ExceptionUtil.throwCommonException(e.getMessage(), ErrorCode.ERROR_CODE_SEQCTL_DELETE, e);
        }
    }

    /**
     * ?Hibernate ID
     *
     * @param id
     * @throws CommonException
     */
    public void delete(long id) throws CommonException {
        try {
            this.getHibernateTemplate().delete(query(id));
        } catch (Exception e) {
            ExceptionUtil.throwCommonException(e.getMessage(), ErrorCode.ERROR_CODE_SEQCTL_DELETE, e);
        }
    }
}