newresultset.java

SAP这个系统的一个转换器

package com.idoc.util.db;

/**
 * <p>Title: IDOC Interface</p>
 * <p>Description: IDOC 转换器</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: SiChuan XinHua</p>
 * @author Richary
 * @version 1.0
 */

import java.sql.*;
import java.util.Vector;
import java.util.Hashtable;

public class NewResultSet {

  private ResultSet rs = null;
  private RowSet rows = null;
  private Object[] data = null;

  public NewResultSet(ResultSet rs) {
    if (rs==null) return;
    rows = new RowSet();
    this.rs = rs;
    try {
      ResultSetMetaData rsmd = rs.getMetaData();
      int cols = rsmd.getColumnCount();

      while (rs.next()) {
        Row row = new Row();
        for (int i = 0; i < cols; i++) {
          String name = rsmd.getColumnName(i + 1);
          if(name == null) name = (i + 1) + "field";
          String value = rs.getString(i + 1);
      //System.out.println(name + "-->" + value);
          if(value == null) value = "";
          row.put(name, value);
        }
        rows.add(row);
      }
    }
    catch(Exception e) {
      System.out.println("NewResultSet's Construct is Error!");
      e.printStackTrace();
    }
  }

  public RowSet getRowSet() {
    return this.rows;
  }

  public Object[] getData() {
    //System.out.println("data's length " + data.length);
    return this.data;
  }


}