gzdawdgxdao.java

以前做的一个j2ee的项目

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

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

public class GZDAwdgxDAO extends QXGLshareDAO {
    private static final String TABLE_NAME = "T_GZDA_FILEMANAGERABSTR";

    public GZDAwdgxDAO() {
    }

    public List getWdgxByFileUrl(String url) {
        return super.getGxfwBySjxh(url, TABLE_NAME);
    }

    public boolean addWdgxShare(String selectedFileUrls, String selectedJgryDm) {
        String[] urlArray = selectedFileUrls.split(",,");

        for (int i = 0; i < urlArray.length; i++) {
            super.addGxfw(urlArray[i], selectedJgryDm, TABLE_NAME);
        }

        return true;
    }

    public boolean deleteWdgxShare(String selectedJgryDm) {
        return super.deleteGxfw(selectedJgryDm, TABLE_NAME);
    }
/*
    public List getWdgxByFileUrl(String url) {
        this.setUrl(url);
        return selectAll("T_QXGL_GX.selectWdgxByFileUrl", this);
    }

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

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

        return true;
    }

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

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

        return true;
    }
*/
}