xtflflgxdao.java

来自「以前做的一个j2ee的项目」· Java 代码 · 共 88 行

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

import java.util.*;

import java.sql.SQLException;
import gov.gdlt.ssgly.taxcore.taxdao.qxgl.QXGLshareDAO;

public class XTFLflgxDAO extends QXGLshareDAO {
    private static final String TABLE_NAME = "T_FLGL_FLXX";

    public XTFLflgxDAO() {
    }

    public List getXtflBySwryDm(String swryDm) {
        return selectAll("T_QXGL_GX.selectXtflBySwryDm", swryDm);
    }

    public List getFlgxByFlxh(String flXh) {
        return super.getGxfwBySjxh(flXh, TABLE_NAME);
    }

    public boolean addXtflShare(String flXh, String selectedJgryDm) {
        return super.addGxfw(flXh, selectedJgryDm, TABLE_NAME);
    }

    public boolean deleteXtflShare(String selectedJgryDm) {
        return super.deleteGxfw(selectedJgryDm, TABLE_NAME);
    }
/*
    public List getFlgxByFlxh(String flXh) {
        this.setFlXh(flXh);
        return selectAll("T_QXGL_GX.selectFlgxByFlxh", this);
    }

    public boolean addXtflShare(String flXh, String selectedJgryDm) {
        this.getSqlMapClient(); //用父类方法获取SqlMap对象
        try {
            try {
                sqlMap.startTransaction();

                String[] jgryDmArray = selectedJgryDm.split(",");
                this.setFlXh(flXh);
                for (int i = 0; i < jgryDmArray.length; i++) {
                    this.setJgryDm(jgryDmArray[i]);
                    // 判断数据库中是否已经存在该条分类共享记录
                    if (sqlMap.queryForObject("T_QXGL_GX.selectFlgxByFlxhAndJgryDm", this) == null) {
                        sqlMap.insert("T_QXGL_GX.addXtflShare", this);
                    }
                }
                sqlMap.commitTransaction();
            } finally {
                sqlMap.endTransaction();
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }

        return true;
    }

    public boolean deleteXtflShare(String selectedJgryDm) {
        this.getSqlMapClient(); //用父类方法获取SqlMap对象
        try {
            try {
                sqlMap.startTransaction();

                String[] flXhJgryDmArray = selectedJgryDm.split(",");
                for (int i = 0; i < flXhJgryDmArray.length; i++) {
                    String[] dmArray = flXhJgryDmArray[i].split(":");
                    this.setFlXh(dmArray[0]);
                    this.setJgryDm(dmArray[1]);
                    sqlMap.insert("T_QXGL_GX.deleteXtflShare", this);
                }
                sqlMap.commitTransaction();
            } finally {
                sqlMap.endTransaction();
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }

        return true;
    }
*/
}