rwglrwjldao.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.rwgl.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: 广东地税税收管理员工作平台</p>
 *
 * <p>Copyright: Copyright (c) 2005 广东省地方税务局，广州市地方税务局</p>
 *
 * <p>Company: 广州地税</p>
 *
 * @author 王隽
 * @version 1.0
 */
public class RWGLrwjlDAO extends BaseDataAccessObject {
    private BigDecimal rw_xh;
    private String qsr_dm;
    private String clfs_dm;
    private String rwms;
    private String swry_dm;
    private String swjg_dm;
    private String rwxl_dm;
    private String lcdy;
    private String rwmxxx;
    private BigDecimal zx_xh;
    private String jsz_dm;
    private String jsz_lx;
    private BigDecimal bz_xh;
    private BigDecimal frw_xh;
    private String sms;
    public RWGLrwjlDAO() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public static void main(String[] args) {
        RWGLrwjlDAO workflowdao = new RWGLrwjlDAO();
    }

    public String getClfs_dm() {
        return clfs_dm;
    }

    public String getQsr_dm() {

        return qsr_dm;
    }

    public BigDecimal getRw_xh() {
        return rw_xh;
    }

    public String getRwms() {
        return rwms;
    }

    public String getSwry_dm() {
        return swry_dm;
    }

    public String getSwjg_dm() {
        return swjg_dm;
    }

    public String getRwxl_dm() {
        return rwxl_dm;
    }

    public String getLcdy() {
        return lcdy;
    }

    public String getRwmxxx() {
        return rwmxxx;
    }

    public BigDecimal getZx_xh() {
        return zx_xh;
    }

    public String getJsz_dm() {
        return jsz_dm;
    }

    public String getJsz_lx() {
        return jsz_lx;
    }

    public BigDecimal getBz_xh() {
        return bz_xh;
    }

    public BigDecimal getFrw_xh() {
        return frw_xh;
    }

    public String getSms() {
        return sms;
    }

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

    public void setRw_xh(BigDecimal rw_xh) {
        this.rw_xh = rw_xh;
    }

    public void setQsr_dm(String qsr_dm) {

        this.qsr_dm = qsr_dm;
    }

    public void setClfs_dm(String clfs_dm) {
        this.clfs_dm = clfs_dm;
    }

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

    public void setSwjg_dm(String swjg_dm) {
        this.swjg_dm = swjg_dm;
    }

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

    public void setLcdy(String lcdy) {
        this.lcdy = lcdy;
    }

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

    public void setZx_xh(BigDecimal zx_xh) {
        this.zx_xh = zx_xh;
    }

    public void setJsz_dm(String jsz_dm) {
        this.jsz_dm = jsz_dm;
    }

    public void setJsz_lx(String jsz_lx) {
        this.jsz_lx = jsz_lx;
    }

    public void setBz_xh(BigDecimal bz_xh) {
        this.bz_xh = bz_xh;
    }

    public void setFrw_xh(BigDecimal frw_xh) {
        this.frw_xh = frw_xh;
    }

    public void setSms(String sms) {
        this.sms = sms;
    }

    public ArrayList getDblb(String swry_dm) {
        LogWritter.sysDebug("begin getting dblb for " + swry_dm);
        List list = null;
        try {
            list = this.selectAll("T_RWGL_RWJL.getDblb", swry_dm);
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        LogWritter.sysDebug("get " + list.size() + " data.");
        return (ArrayList) list;
    }

    public ArrayList getZblb(String swry_dm) {
        List list = this.selectAll("T_RWGL_RWJL.getZblb", swry_dm);
        return (ArrayList) list;
    }

    public ArrayList getYblb(String swry_dm) {
        List list = this.selectAll("T_RWGL_RWJL.getYblb", swry_dm);
        return (ArrayList) list;
    }

    public ArrayList getQblb(String swry_dm) {
        List list = this.selectAll("T_RWGL_RWJL.getQblb", swry_dm);
        return (ArrayList) list;
    }

    public int getNextRy1() {
        int errCode = ApplicationContext.ROWS_NOT_FOUND;
        errCode = this.select("T_RWGL_RWJL.nextRy1", this);
        return errCode;
    }


    public ArrayList getNextRy2() {
        List list = null;
        list = this.selectAll("T_RWGL_RWJL.nextRy2", this);
        if (list.size() == 0) {
            rwxl_dm = "9999";
            list = this.selectAll("T_RWGL_RWJL.nextRy2", this);
        }
        return (ArrayList) list;
    }

    public RWGLrwmxVO getRwmx() {
        Object obj = null;
        RWGLrwmxVO rwmx = new RWGLrwmxVO();
        this.getSqlMapClient(); //获取SqlMap对象
        // try {
        //执行select操作
        /*     try {
                 sqlMap.startTransaction();
         obj = sqlMap.queryForObject("T_RWGL_RWJL.getRwmxxx", this, rwmx);
                 sqlMap.commitTransaction();
             } finally {
                 sqlMap.endTransaction();
             }
         } catch (SQLException ex) {
             ex.printStackTrace();
         }*/

        Connection connection = null;
        try {
            connection = JDBCLocator.getInstance().getJDBCConnection();
            sqlMap.setUserConnection(connection);

            obj = sqlMap.queryForObject("T_RWGL_RWJL.getRwmxxx", this, rwmx);

        } catch (SQLException e) {
        } finally {
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
            }
        }

        return rwmx;
    }

    public int save1() {
        return this.update("T_RWGL_RWJL.save1", this);
    }

    public int send1() {
        return this.select("T_RWGL_RWJL.send1", this);
    }

    public int send5() {
        return this.update("T_RWGL_RWJL.send5", this);
    }

    public int send6(){
        Object obj = null;
        this.getSqlMapClient(); //获取SqlMap对象
        Connection connection = null;
        try {
            connection = JDBCLocator.getInstance().getJDBCConnection();
            sqlMap.setUserConnection(connection);

            obj = sqlMap.queryForObject("T_RWGL_RWJL.send6", this, this);

        } catch (SQLException e) {e.printStackTrace();
        } finally {
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {e.printStackTrace();
            }
        }
        return 1;
    }

    public BigDecimal bj() {
        int rows = 0;
        int errCode = ApplicationContext.ROWS_NOT_FOUND;
        frw_xh = BigDecimal.valueOf(0);
        rows = this.update("T_RWGL_RWJL.bj1", this);
        if (rows == 1) {
            frw_xh=(BigDecimal)this.select2("T_RWGL_RWJL.bj2",rw_xh);
            if (frw_xh!=null) {
                LogWritter.sysDebug("found frwxh=" + frw_xh);
                rows = this.update("T_RWGL_RWJL.wakeUp", frw_xh);
            } else {
                LogWritter.sysDebug("not found frwxh=" + frw_xh);
            }
        }
        if (frw_xh == null) {
            frw_xh = BigDecimal.valueOf(0);
        }
        return frw_xh;
    }

    public RWGLrwfjVO getFjxx(String url) {
        RWGLrwfjVO rwfj = new RWGLrwfjVO(url);
        Object obj = null;
        this.getSqlMapClient(); //获取SqlMap对象
        //try {
        //执行select操作
        /*    try {
                sqlMap.startTransaction();
                obj = sqlMap.queryForObject("T_RWGL_RWJL.getFjxx", rwfj, rwfj);
                sqlMap.commitTransaction();
            } finally {
                sqlMap.endTransaction();
            }
                 } catch (SQLException ex) {
            ex.printStackTrace();
                 }
                 if (obj == null) {
            return null;
                 } else {
            return rwfj;
                 }*/

        Connection connection = null;
        try {
            connection = JDBCLocator.getInstance().getJDBCConnection();
            sqlMap.setUserConnection(connection);

            obj = sqlMap.queryForObject("T_RWGL_RWJL.getFjxx", rwfj, rwfj);

        } catch (SQLException e) {
        } finally {
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
            }
        }

        if (obj == null) {
            return null;
        } else {
            return rwfj;
        }
    }

    public int addFile(RWGLrwmxVO rwmx) {
        return this.update("T_RWGL_RWJL.addFile", rwmx);
    }

    private void jbInit() throws Exception {
    }
}