ductgp.java

java 读写EXCEL文件的源码

/********************************************************************
 *
 * $RCSfile: DuctGp.java,v $  $Revision: 1.1 $  $Date: 2003/09/22 08:06:24 $
 *
 * $Log: DuctGp.java,v $
 * Revision 1.1  2003/09/22 08:06:24  icestone
 * init
 *
 *
 *
 **********************************************************************/
package pcdmupgradedata;

/**
 * <p>Title:管道类 </p>
 * <p>Description:返回管道段编号Vector </p>
 */
import java.sql.*;
import java.util.Vector;

public class DuctGp{
  private Connection conn = null;
  private String strSourceDBName = null;
  public DuctGp(){
  }

  /**获取Conn连接*/
  public DuctGp(Connection conn,String strInSourceDBName){
    this.conn = conn;
    this.strSourceDBName = strInSourceDBName;
  }

  /**从数据库“管道段”表中查询所有管道段编码*/
  public Vector getDuctGpNos(){
    Vector vDuctGpNos = new Vector();
    String strSql;
    String strDuctGpCode; //管道段编码
    String strStartECode; //起始设施编码
    String strEndECode; //终止设施编码

    Statement  stmt = null;
    ResultSet  rset = null;
    try {
      stmt = conn.createStatement();
      strSql = "Select 管道段编码,起始设施编码,终止设施编码 From " +
               strSourceDBName + ".GDD_T";
      rset = stmt.executeQuery(strSql);
      int i = 0;
      while(rset.next()){
        strDuctGpCode = rset.getString("管道段编码");
        strStartECode = rset.getString("起始设施编码");
        strEndECode = rset.getString("终止设施编码");
        DuctGpEntity oDuctGpEntity = new DuctGpEntity(strDuctGpCode,
                                                      strStartECode,
                                                      strEndECode);
        vDuctGpNos.addElement(oDuctGpEntity);
        //测试
        /*
        DuctGpEntity oDuctGpEntityTest = (DuctGpEntity) vDuctGpNos.elementAt(i);
        System.out.println(oDuctGpEntityTest.getDuctGpCode());
        i = i + 1;
        */
      }
      rset.close();
      rset = null;
      stmt.close();
      stmt = null;
    }
    catch(SQLException e) {
      System.out.println("SQL error: " + e.toString());
    }
    finally {
      if (rset != null)
        try {rset.close();} catch(SQLException ignore) {}
      if (stmt != null)
        try {stmt.close();} catch(SQLException ignore) {}
    }
    return vDuctGpNos;
  }

}