wdscyhslsjldao.java

以前做的一个j2ee的项目

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

import gov.gdlt.ssgly.taxcore.comm.dao.BaseDataAccessObject;
import java.sql.*;
import gov.gdlt.ssgly.taxcore.comm.exception.*;
import java.sql.*;
import gov.gdlt.ssgly.taxcore.comm.servicelocator.JDBCLocator;


/**
 * <p>Title: 税收管理员平台</p>
 *
 * <p>Description: 税收管理员平台</p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: 广州</p>
 * 一户式历史纪录
 * @author 张承华
 * @version 1.0
 */
public class WDSCyhslsjlDAO extends BaseDataAccessObject{
  public WDSCyhslsjlDAO() {

  }

  public static void main(String[] args) {
    WDSCyhslsjlDAO wdscyhslsjldao = new WDSCyhslsjlDAO();
  }
/*  SELECT B.FILEDOC
      FROM T_GZDA_FILEMANAGERABSTR A, T_GZDA_FILEMANAGERDETAIL B
      WHERE A.TPAYERID = ''

    AND A.URL = B.URL
*/
  //一户式文档内容
  private Object FILEDOC;
  //一户式文档名称
  private String TPAYERID;
  //一户式文档的url
  private String URL;

  private void jbInit() throws Exception {
  }

  public Object getFILEDOC() {
    return FILEDOC;
  }

  public void setFILEDOC(Object FILEDOC) {
    this.FILEDOC = FILEDOC;
  }

  public String getTPAYERID() {
    return TPAYERID;
  }

  public void setTPAYERID(String TPAYERID) {
    this.TPAYERID = TPAYERID;
  }

  public String getURL() {
    return URL;
  }

  public void setURL(String URL) {
    this.URL = URL;
  }

  public WDSCyhslsjlDAO selectYhsWd() throws Exception {
    WDSCyhslsjlDAO lsjl = new WDSCyhslsjlDAO();

    Connection conn = null;
    try {
        conn = JDBCLocator.getInstance().getJDBCConnection();
        Statement stmt = conn.createStatement();
        String sql = "SELECT TRIM(A.TPAYERID) as TPAYERID, TRIM(A.URL) as URL, B.FILEDOC as FILEDOC" +
                " FROM T_GZDA_FILEMANAGERABSTR A, T_GZDA_FILEMANAGERDETAIL B " +
                " WHERE A.TPAYERID LIKE '" + this.getTPAYERID() + "' " +
                " AND TRIM(A.URL) = TRIM(B.URL) ";
        ResultSet rs = stmt.executeQuery(sql);
        if (rs.next()) {
            lsjl.setTPAYERID(rs.getString("TPAYERID"));
            lsjl.setURL(rs.getString("URL"));
            lsjl.setFILEDOC(rs.getBlob("FILEDOC"));
        }
        rs.close();
        stmt.close();

    } catch (Exception e) {
        e.printStackTrace();
        throw new Exception(e.getMessage());
    } finally {
        if (conn != null) conn.close();
    }
    return lsjl;
  }

/*
  private Object selectE(String id, Object paramObj) throws TaxBaseSystemException {
      Object obj = null;

      try {
          //sqlMap = getSqlMapClient(); //获取SqlMap对象
          try {
              //执行select操作
              try {
                  //sqlMap.startTransaction();
                  obj = sqlMap.queryForObject(id, paramObj, this);
                  //sqlMap.commitTransaction();
              } finally {
                  //sqlMap.endTransaction();
              }
          } catch (SQLException ex) {
              ex.printStackTrace();
              return null;
          }
      } catch(Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }

      return obj;
  }
*/

}