rwgljhapdao.java

以前做的一个j2ee的项目

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

import java.math.*;
import java.sql.*;
import java.util.*;

import gov.gdlt.ssgly.taxcore.comm.config.*;
import gov.gdlt.ssgly.taxcore.comm.dao.*;
import gov.gdlt.ssgly.taxcore.comm.log.*;
import gov.gdlt.ssgly.taxcore.comm.servicelocator.*;
import gov.gdlt.ssgly.taxcore.taxevent.htdl.*;
import gov.gdlt.ssgly.taxcore.taxevent.rwgl.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: 广东地税税收管理员工作平台</p>
 *
 * <p>Copyright: Copyright (c) 2005 广东省地方税务局，广州市地方税务局</p>
 *
 * <p>Company: 广州地税</p>
 *
 * @author 王隽
 * @version 1.0
 */
public class RWGLjhapDAO extends BaseDataAccessObject {
    private BigDecimal jh_xh;
    private String jhxdry_dm;
    private String jhxdry_mc;
    private String rwlx_dm;
    private String rwlx_mc;
    private String rwxl_dm;
    private String rwxl_mc;
    private String rwms;
    private String rwmxxx;
    private String cbbm_dm;
    private String cbbm_mc;
    private String cbry_dm;
    private String cbry_mc;
    private String rwyx_jb;
    private Timestamp jhxd_sj;
    private Timestamp ydqd_sj;
    private String cfzq_lx;
    private String swry_dm;
    private BigDecimal nsrnbm;
    private String zzyq;
    public RWGLjhapDAO() {
    }

    public void setJh_xh(BigDecimal jh_xh) {
        this.jh_xh = jh_xh;
    }

    public void setJhxdry_dm(String jhxdry_dm) {
        this.jhxdry_dm = jhxdry_dm;
    }

    public void setJhxdry_mc(String jhxdry_mc) {

        this.jhxdry_mc = jhxdry_mc;
    }

    public void setRwlx_dm(String rwlx_dm) {
        this.rwlx_dm = rwlx_dm;
    }

    public void setRwlx_mc(String rwlx_mc) {
        this.rwlx_mc = rwlx_mc;
    }

    public void setRwxl_dm(String rwxl_dm) {
        this.rwxl_dm = rwxl_dm;
    }

    public void setRwxl_mc(String rwxl_mc) {
        this.rwxl_mc = rwxl_mc;
    }

    public void setRwms(String rwms) {
        this.rwms = rwms;
    }

    public void setRwmxxx(String rwmxxx) {
        this.rwmxxx = rwmxxx;
    }

    public void setCbbm_dm(String cbbm_dm) {
        this.cbbm_dm = cbbm_dm;
    }

    public void setCbbm_mc(String cbbm_mc) {
        this.cbbm_mc = cbbm_mc;
    }

    public void setCbry_dm(String cbry_dm) {
        this.cbry_dm = cbry_dm;
    }

    public void setCbry_mc(String cbry_mc) {
        this.cbry_mc = cbry_mc;
    }

    public void setRwyx_jb(String rwyx_jb) {

        this.rwyx_jb = rwyx_jb;
    }

    public void setJhxd_sj(Timestamp jhxd_sj) {
        this.jhxd_sj = jhxd_sj;
    }

    public void setYdqd_sj(Timestamp ydqd_sj) {
        this.ydqd_sj = ydqd_sj;
    }

    public void setCfzq_lx(String cfzq_lx) {
        this.cfzq_lx = cfzq_lx;
    }

    public void setSwry_dm(String swry_dm) {
        this.swry_dm = swry_dm;
    }

    public void setNsrnbm(BigDecimal nsrnbm) {
        this.nsrnbm = nsrnbm;
    }

    public void setZzyq(String zzyq) {
        this.zzyq = zzyq;
    }

    public BigDecimal getJh_xh() {
        return jh_xh;
    }

    public String getJhxdry_dm() {
        return jhxdry_dm;
    }

    public String getJhxdry_mc() {

        return jhxdry_mc;
    }

    public String getRwlx_dm() {
        return rwlx_dm;
    }

    public String getRwlx_mc() {
        return rwlx_mc;
    }

    public String getRwxl_dm() {
        return rwxl_dm;
    }

    public String getRwxl_mc() {
        return rwxl_mc;
    }

    public String getRwms() {
        return rwms;
    }

    public String getRwmxxx() {
        return rwmxxx;
    }

    public String getCbbm_dm() {
        //为避免ibatis出错，增加对空值的判断
        if (cbbm_dm==null) cbbm_dm=new String();
        return cbbm_dm;
    }

    public String getCbbm_mc() {
        return cbbm_mc;
    }

    public String getCbry_dm() {
            //为避免ibatis出错，增加对空值的判断
            if (cbry_dm==null) cbry_dm=new String();
        return cbry_dm;
    }

    public String getCbry_mc() {
        return cbry_mc;
    }

    public String getRwyx_jb() {
            //为避免ibatis出错，增加对空值的判断
            if (rwyx_jb==null) rwyx_jb=new String("2");
        return rwyx_jb;
    }

    public Timestamp getJhxd_sj() {
        return jhxd_sj;
    }

    public Timestamp getYdqd_sj() {
        return ydqd_sj;
    }

    public String getCfzq_lx() {
            //为避免ibatis出错，增加对空值的判断
            if (cfzq_lx==null) cfzq_lx=new String();
        return cfzq_lx;
    }

    public String getSwry_dm() {
        return swry_dm;
    }

    public BigDecimal getNsrnbm() {
            //为避免ibatis出错，增加对空值的判断
            if (nsrnbm==null) nsrnbm=new BigDecimal(0);
        return nsrnbm;
    }

    public String getZzyq() {
            //为避免ibatis出错，增加对空值的判断
            if (zzyq==null) zzyq=new String();
        return zzyq;
    }

    /**
     * 查询计划详细内容，需要先设定计划序号
     * @return RWGLjhrwVO
     */
    public RWGLjhrwVO getJhap(){
    Object obj = null;
        RWGLjhrwVO jhrw=new RWGLjhrwVO();
        this.getSqlMapClient(); //获取SqlMap对象
        Connection connection = null;
        try {
            connection = JDBCLocator.getInstance().getJDBCConnection();
            sqlMap.setUserConnection(connection);
            //执行select操作
            try {
                obj = sqlMap.queryForObject("T_RWGL_JHAP.getJhap",jh_xh, jhrw);
            } finally {
                try {
                    if (connection != null) {
                        connection.close();
                    }
                } catch (SQLException e) {e.printStackTrace();
                }
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return null;
        }
        return jhrw;
    }

    /**
     * 新建计划，需要先给各属性赋值
     * @return BigDecimal \u2014\u2014返回新计划的序号
     */
    public BigDecimal newJhap(){
        int errCode=ApplicationContext.ROWS_NOT_FOUND;
        Object obj=null;
        //获取新的任务序号
        errCode=this.select("T_RWGL_JHAP.newJhap1",null);
        LogWritter.sysDebug("new jh_xh="+jh_xh+", and rwmxxx.length="+rwmxxx.length());
        if (errCode==ApplicationContext.ROWS_FOUND){
            //填写任务计划表
            obj=this.save("T_RWGL_JHAP.newJhap2");
        }
        LogWritter.sysDebug("DAO : new jhap save ok");
        return jh_xh;
    }

    /**
     * 计划的实现，调用存储过程
     * @return int \u2014\u2014无用
     */
    public BigDecimal jhsx(){
        HTDLreturnVO returnVO=new HTDLreturnVO();
        String params=jh_xh.toString();
        String done="";
        String msg="";
        returnVO.setCsl(params);
        returnVO.setDetail(msg);
        returnVO.setStatus(done);
        LogWritter.sysDebug("DAO starting workflow, params="+params);
        this.select("T_RWGL_JHAP.startJhap",returnVO);
        LogWritter.sysDebug(returnVO.getDetail());
        BigDecimal rw_xh=null;
        if (returnVO.getStatus()!=null && returnVO.getStatus().equals("0")) try{
            String rwxhS=returnVO.getDetail().substring(6,16);
            LogWritter.sysDebug("got new rw_xh="+rwxhS);
            rw_xh=new BigDecimal(rwxhS);
        }catch (Exception ex){}
        return rw_xh;
    }

    /**
     * 保存计划的内容
     * @param jhrw RWGLjhrwVO \u2014\u2014将计划的内容封装在VO中提交
     * @return int \u2014\u2014返回1表示成功
     */
    public int saveJhap(RWGLjhrwVO jhrw){
        //设置某些数据的默认值
        if (jhrw.getNsrnbm()==null) jhrw.setNsrnbm(new BigDecimal(0));
        if (jhrw.getZzyq()==null) jhrw.setZzyq(new String());
        if (jhrw.getCbbm_dm()==null) jhrw.setCbbm_dm(new String());
        if (jhrw.getCbry_dm()==null) jhrw.setCbry_dm(new String());
        if (jhrw.getCfzq_lx()==null) jhrw.setCfzq_lx(new String());
        if (jhrw.getRwyxjb()==null) jhrw.setRwyxjb("2");
        //更新数据
        int rows=this.update("T_RWGL_JHAP.saveJhap",jhrw);
        return rows;
    }

    public ArrayList getRwlxDmb(){
        return (ArrayList)this.selectAll("T_RWGL_JHAP.getRwlxDxl",null);
    }

    public ArrayList getSwjg(){
        return (ArrayList)this.selectAll("T_RWGL_JHAP.getSwjg",swry_dm);
    }

    public ArrayList getSwry(){
        return (ArrayList)this.selectAll("T_RWGL_JHAP.getSwry",swry_dm);
    }

    public String getWdmb(){
        return (String)this.select2("T_RWGL_JHAP.getWdmb",jh_xh);
    }
}