dmzbgldao.java

以前做的一个j2ee的项目

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

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

import gov.gdlt.ssgly.taxcore.comm.dao.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: 广东地税税收管理员工作平台</p>
 *
 * <p>Copyright: Copyright (c) 2005 广东省地方税务局，广州市地方税务局</p>
 *
 * <p>Company: 广州地税</p>
 * 代码指标管理
 * @author 张承华
 * @version 1.0
 */
public class DMzbglDAO extends BaseDataAccessObject {
    public DMzbglDAO() {
    }

    public static void main(String[] args) {
        DMzbglDAO dmzbgldao = new DMzbglDAO();
    }

    public String getBZ() {
        return BZ;
    }

    public String getDMB_MC() {
        return DMB_MC;
    }

    public String getDML_MC() {
        return DML_MC;
    }

    public String getLR_BJ() {
        return LR_BJ;
    }

    public Date getLR_SJ() {
        return LR_SJ;
    }

    public String getMC() {
        return MC;
    }

    public String getQS_SQL() {
        return QS_SQL;
    }

    public Date getXG_SJ() {
        return XG_SJ;
    }

    public String getXY_BJ() {
        return XY_BJ;
    }

    public String getZB_DM() {
        return ZB_DM;
    }

    public String getZB_LX() {
        return ZB_LX;
    }

    public void setBZ(String BZ) {
        this.BZ = BZ;
    }

    public void setDMB_MC(String DMB_MC) {
        this.DMB_MC = DMB_MC;
    }

    public void setDML_MC(String DML_MC) {
        this.DML_MC = DML_MC;
    }

    public void setLR_BJ(String LR_BJ) {
        this.LR_BJ = LR_BJ;
    }

    public void setLR_SJ(Date LR_SJ) {
        this.LR_SJ = LR_SJ;
    }

    public void setMC(String MC) {
        this.MC = MC;
    }

    public void setQS_SQL(String QS_SQL) {
        this.QS_SQL = QS_SQL;
    }

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

    public void setXY_BJ(String XY_BJ) {
        this.XY_BJ = XY_BJ;
    }

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

    public void setZB_LX(String ZB_LX) {
        this.ZB_LX = ZB_LX;
    }

    public String getMB_DM() {
        return MB_DM;
    }

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

    /*
    ZB_DM  VARCHAR2(20)   NOT NULL,
    MC     VARCHAR2(30)       NULL,
    BZ     VARCHAR2(300)      NULL,
    ZB_LX  VARCHAR2(4)        NULL,
    XY_BJ  CHAR(1)            NULL,
    LR_SJ  TIMESTAMP(6)       NULL,
    XG_SJ  TIMESTAMP(6)       NULL,
    QS_SQL VARCHAR2(1000)     NULL,
    DMB_MC VARCHAR2(20)       NULL,
    DML_MC VARCHAR2(20)       NULL,
    LR_BJ  CHAR(1)            NULL
    */

    private String ZB_DM;
    private String MC;
    private String BZ;
    private String ZB_LX;
    private String XY_BJ;
    private Date LR_SJ;
    private Date XG_SJ;
    private String QS_SQL;
    private String DMB_MC;
    private String DML_MC;
    private String LR_BJ;
    private String MB_LB;

    private String MB_DM;

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

    public DMzbglDAO getZbDm(String zbdm) throws Exception {
        DMzbglDAO zb = new DMzbglDAO();
        try {
            zb = (DMzbglDAO)this.selectE("WDSC.selectZbDm", zbdm);
        }catch(Exception e) {
            throw new Exception(e.getMessage());
        }
        return zb;
    }

    public List getZbDmNotInMb(String mbdm, String swjg, String mblb) throws Exception {
        WDSCwdmbzbDAO mbzb = new WDSCwdmbzbDAO();
        mbzb.setMB_DM(mbdm);
        mbzb.setMB_SWJG(swjg);
        mbzb.setMB_LB(mblb);
        List list = null;
        try {
            list = this.selectAll("WDSC.selectZbDmNotInMb", mbzb);
        } catch(Exception e) {
            throw new Exception(e.getMessage());
        }
        return list;
    }


    //通过模板代码得到指标
    public List getZbDmByMb(String mbdm, String mblb, String swjg) throws Exception {
        WDSCwdmbzbDAO mbzb = new WDSCwdmbzbDAO();
        mbzb.setMB_DM(mbdm);
        mbzb.setMB_SWJG(swjg);
        mbzb.setMB_LB(mblb);
        try {
            return this.selectAll("WDSC.selectZbDmByMb", mbzb);
        }catch(Exception e) {
            throw new Exception(e.getMessage());
        }
    }

    private Object selectE(String id, Object paramObj) throws Exception {
        Object obj = null;
        try{
            //sqlMap = this.getSqlMapClient(); //获取SqlMap对象
            try {
                //执行select操作
                try {
                    //sqlMap.startTransaction();
                    obj = sqlMap.queryForObject(id, paramObj, this);
                    //sqlMap.commitTransaction();
                } finally {
                    //sqlMap.endTransaction();
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
                return null;
            }
        }catch(Exception e) {
            throw new Exception(e.getMessage());
        }
        return obj;
    }

    public String getMB_LB() {
        return MB_LB;
    }

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

}