qxglswrydao.java

以前做的一个j2ee的项目

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

import java.util.*;

import gov.gdlt.ssgly.taxcore.comm.dao.*;
import java.sql.Connection;
import java.sql.SQLException;
import gov.gdlt.ssgly.taxcore.comm.servicelocator.JDBCLocator;

public class QXGLswryDAO extends BaseDataAccessObject {
    private String swryDm;
    private String swjgDm;
    private String swryMc;
    private String userId;

    public QXGLswryDAO() {
    }

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

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

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

    // 用于UserBean中读取用户信息
    public List getSwryInfoByDm(String swryDm) {
        return selectAll("T_QXGL_SWRY.getSwryInfoByDm", swryDm);
    }

    /* 使用大集中克隆库进行读取sessionId */
    public List getUserIdBySessionId(String sessionId) {
        List list = null;
        this.getSqlMapClient(); //获取SqlMap对象

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

            list = sqlMap.queryForList("T_QXGL_SWRY.getUserIdBySessionId", sessionId);

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

        return list;
    }

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

    public void setSwjgDm(String swjgDm) {
        this.swjgDm = swjgDm;
    }

    public void setSwryMc(String swryMc) {
        this.swryMc = swryMc;
    }

    public void setUserId(String userId) {
        this.userId = userId;
    }

    public String getSwryDm() {
        return swryDm;
    }

    public String getSwjgDm() {
        return swjgDm;
    }

    public String getSwryMc() {
        return swryMc;
    }

    public String getUserId() {
        return userId;
    }
}