wdscwdmbzbdao.java

以前做的一个j2ee的项目

//Source file: D:\\OLLA\\DS_WORK\\gzds-uml\\gov\\gdlt\\taxcore\\taxdao\\ssgly\\wdsc\\WDSCwdmbzbDAO.java

package gov.gdlt.ssgly.taxcore.taxdao.wdsc;

import java.sql.*;
import java.util.*;
import java.util.Date;

import com.ibatis.sqlmap.client.*;
import gov.gdlt.ssgly.taxcore.comm.config.*;
import gov.gdlt.ssgly.taxcore.comm.dao.*;
import gov.gdlt.ssgly.taxcore.comm.exception.*;


/**
 * 文档指标，保存模板指标信息（内容）
 */
public class WDSCwdmbzbDAO extends BaseDataAccessObject
{
/*

        MB_DM, ZB_DM, TO_CHAR(XG_SJ, 'fmYYYY/MM/DD HH24:MI:SS.ff') XG_SJ, XG_CZY_DM
        MB_DM     VARCHAR2(4)  NOT NULL,
        ZB_DM     VARCHAR2(20) NOT NULL,
        XG_SJ     TIMESTAMP(6)     NULL,
        XG_CZY_DM VARCHAR2(11)     NULL,
*/

   private String MB_DM, NEW_MB_DM;
   private String ZB_DM;
   private String MB_LB, NEW_MB_LB;
   private Date XG_SJ;
   private String XG_CZY_DM;
   private Vector ZB_NR;
   private String MB_SWJG, NEW_MB_SWJG;


   private String OPER_TYPE;//指定对指标值的操作
   private String OPER_KEY;//指标前缀值
   private String OPER_RESULT;//用字符串存放操作结果
   private double zbSumResult;//指标值求和结果


   /**
    * @roseuid 42D3371C033C
    */
   public WDSCwdmbzbDAO()
   {

   }

   public WDSCwdmbzbDAO(SqlMapClient sqlMap)
   {
       this.sqlMap = sqlMap;
   }

   public SqlMapClient getSqlMap() {//sqlMap;
       return sqlMap;
   }
   public SqlMapClient setSqlMap(SqlMapClient map) {//sqlMap;
       return sqlMap = map;
   }


   public List getWdMbZb(WDSCwdmbzbDAO mbzb) throws Exception {
       List list = null;
       try {
           list = this.selectAll("WDSC.selectWdMbZb", mbzb);
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

       return list;
   }
   public List getWdMbZb() throws Exception {
       List list = null;
       try {
           list = this.selectAll("WDSC.selectWdMbZb", this);
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

       return list;
   }

   /////////////////////////////////////////////////////////////////////////////

   public void insertWdMbZb() throws Exception {
       try {
           this.save("WDSC.insertWdMbZb");
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

   }

   public void insertWdMbZbWithOutTrans() throws Exception {
       try {
           this.saveE("WDSC.insertWdMbZb");
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

   }

   /////////////////////////////////////////////////////////////////////////////
   public void updateWdMbZb(WDSCwdmbzbDAO mbzb) throws Exception {
       if (mbzb == null) return;
       try {
           this.update("WDSC.updateWdMbZb", mbzb);
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

   }

   public void updateWdMbZb() throws Exception {
       try {
           this.update("WDSC.updateWdMbZb", this);
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

   }

   //更新主键
   public void updateWdMbZbPKey() throws Exception {
       try {
           this.updateE("WDSC.updateWdMbZbPKey", this);
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

   }


   /**
     * 提供通用的更新记录的方法
     * @param id：String SqlMap配置文件的SQL语句ID值
     * @param paramObj：Object 传入的参数对象
     * @return int <br>
     *     >=0 被更新的记录数<br>
     *     RET_FAIL 执行失败
     */
    protected int updateE(String id, Object paramObj) throws Exception {
        int rows = 0;

        try {
            //执行update操作
            try {
                rows = sqlMap.update(id, paramObj);
            } finally {
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            throw new Exception(ex.getMessage());
        }

        return rows;
    }

   /////////////////////////////////////////////////////////////////////////////
   public int deleteWdMbZb(WDSCwdmbzbDAO mbzb) throws TaxBaseSystemException {
       if (mbzb == null) return 0;
       try {
           return this.delete("WDSC.deleteWdMbZb", mbzb);
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

   }
   public int deleteWdMbZb() throws TaxBaseSystemException {
       try {
           return this.delete("WDSC.deleteWdMbZb");
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

   }
   public int deleteWdMbZbWithOutTrans() throws TaxBaseSystemException {
       try {
           return this.deleteE("WDSC.deleteWdMbZb");
       } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

   }

////////////////////////////////////////////////////////////////////////////////
    public String getMB_DM() {
        return MB_DM;
    }

    public String getXG_CZY_DM() {
        return XG_CZY_DM;
    }

    public String getZB_DM() {
        return ZB_DM;
    }

    public void setMB_DM(String MB_DM) {
        this.MB_DM = MB_DM;
    }

    public void setXG_CZY_DM(String XG_CZY_DM) {
        this.XG_CZY_DM = XG_CZY_DM;
    }

    public void setZB_DM(String ZB_DM) {
        this.ZB_DM = ZB_DM;
    }

    public Date getXG_SJ() {
        return XG_SJ;
    }

    public void setXG_SJ(Date XG_SJ) {
        this.XG_SJ = XG_SJ;
    }

    public Vector getZB_NR() {
        return ZB_NR;
    }

    public void setZB_NR(Vector ZB_NR) {
        this.ZB_NR = ZB_NR;
    }


    private Object selectE(String id, Object paramObj) throws TaxBaseSystemException {
        Object obj = null;
        try {
            try {
                try {
                    obj = sqlMap.queryForObject(id, paramObj, this);
                } finally {
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
                return null;
            }
        } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

        return obj;
    }


    protected Object saveE(String id) throws TaxBaseSystemException {
        Object generatedKey = null;
        try {
            try {
                try {
                    generatedKey = sqlMap.insert(id, this);
                } finally {
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
                return new Integer(ApplicationContext.RET_FAIL);
            }
        } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

        return generatedKey;
    }

    /**
     * 提供通用的删除记录的方法
     * @param id：String SqlMap配置文件的SQL语句ID值
     * @param paramObj：Object 传入的参数对象
     * @return int <br>
     *     >=0 被删除的记录数<br>
     *     RET_FAIL 执行失败
     */
    protected int deleteE(String id) throws TaxBaseSystemException {
        int rows = 0;
        try {
            try {
                try {
                    rows = sqlMap.delete(id, this);
                } finally {
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
                return ApplicationContext.RET_FAIL;
            }
        } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

        return rows;
    }


    public String getMB_SWJG() {
        return MB_SWJG;
    }

    public void setMB_SWJG(String MB_SWJG) {
        this.MB_SWJG = MB_SWJG;
    }

    public String getNEW_MB_DM() {
        return NEW_MB_DM;
    }

    public void setNEW_MB_DM(String NEW_MB_DM) {
        this.NEW_MB_DM = NEW_MB_DM;
    }

    public String getNEW_MB_SWJG() {
        return NEW_MB_SWJG;
    }

    public void setNEW_MB_SWJG(String NEW_MB_SWJG) {
        this.NEW_MB_SWJG = NEW_MB_SWJG;
    }

    public String getMB_LB() {
        return MB_LB;
    }

    public void setMB_LB(String MB_LB) {
        this.MB_LB = MB_LB;
    }

    public String getNEW_MB_LB() {
        return NEW_MB_LB;
    }

    public void setNEW_MB_LB(String NEW_MB_LB) {
        this.NEW_MB_LB = NEW_MB_LB;
    }

    public String getOPER_RESULT() {
        return OPER_RESULT;
    }

    public void setOPER_RESULT(String OPER_RESULT) {
        this.OPER_RESULT = OPER_RESULT;
    }

    public String getOPER_TYPE() {
        return OPER_TYPE;
    }

    public void setOPER_TYPE(String OPER_TYPE) {
        this.OPER_TYPE = OPER_TYPE;
    }

    public double getZbSumResult() {
        return zbSumResult;
    }

    public String getOPER_KEY() {
        return OPER_KEY;
    }

    public void setZbSumResult(double zbSumResult) {
        this.zbSumResult = zbSumResult;
    }

    public void setOPER_KEY(String OPER_KEY) {
        this.OPER_KEY = OPER_KEY;
    }


}