qxglswry2jsdao.java

以前做的一个j2ee的项目

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

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

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

public class QXGLswry2jsDAO extends BaseDataAccessObject {
    private String swryDm;
    private int jsDm;
    private String skin;
    public QXGLswry2jsDAO() {
    }

    public boolean addSwryJs() {
        // save函数返回null。
        if ((new Integer(ApplicationContext.RET_FAIL)).equals(save(
                "T_QXGL_SWRY.addSwryJs"))) {
            return false;
        }
        return true;
    }

    public boolean addSkin() {
        // save函数返回null。
        if ((new Integer(ApplicationContext.RET_FAIL)).equals(save(
                "T_QXGL_SWRY.addSkin"))) {
            return false;
        }
        return true;
    }

    public boolean HaveSkin() throws Exception {
        List list = null;
        list = selectAll("T_QXGL_SWRY.getskin", swryDm);
        if (list == null || list.size() == 0) {
            return false;
        } else {
            return true;
        }
    }

    public int UpdateSkin() {
        return update("T_QXGL_SWRY.updateSkin", this);
    }

    public List getJsBySwryDmAndJsDm() {
        return selectAll("T_QXGL_SWRY.getJsBySwryDmAndJsDm", this);
    }

    public List getJsBySwryDm(String swryDm) {
        return selectAll("T_QXGL_SWRY.getJsBySwryDm", swryDm);
    }

    public boolean deleteSwryJs(String swryDm, String selectedJsDm) {
        String[] jsDmArray = selectedJsDm.split(",");
        this.setSwryDm(swryDm);
        for (int i = 0; i < jsDmArray.length; i++) {
            this.setJsDm((new Integer(jsDmArray[i])).intValue());
            // 删除税务人员-角色表记录
            super.delete("T_QXGL_SWRY.deleteSwryJs");
        }
        return true;
    }

/*
    public boolean deleteSwryJs(String swryDm, String selectedJsDm) {
        this.getSqlMapClient(); //用父类方法获取SqlMap对象
        try {
            try {
                sqlMap.startTransaction();

                String[] jsDmArray = selectedJsDm.split(",");
                this.setSwryDm(swryDm);
                for (int i = 0; i < jsDmArray.length; i++) {
                    this.setJsDm((new Integer(jsDmArray[i])).intValue());
                    // 删除税务人员-角色表记录
                    sqlMap.delete("T_QXGL_SWRY.deleteSwryJs", this);
                }
                sqlMap.commitTransaction();
            } finally {
                sqlMap.endTransaction();
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }

        return true;
    }
*/

    public void setSwryDm(String swryDm) {
        this.swryDm = swryDm;
    }

    public void setJsDm(int jsDm) {
        this.jsDm = jsDm;
    }

    public void setSkin(String skin) {
        this.skin = skin;
    }

    public String getSwryDm() {
        return swryDm;
    }

    public int getJsDm() {
        return jsDm;
    }

    public String getSkin() {
        return skin;
    }

    public Statement getStatement() throws Exception {
        Connection conn = getCurrentConnection();
        Statement sta = conn.createStatement();
        return sta;
    }

}