resultwrapper.java

来自「cwbbs 云网论坛源码」· Java 代码 · 共 75 行

package cn.js.fan.db;

import java.sql.*;

public class ResultWrapper {
    ResultSet rs = null;
    ResultSetMetaData rm = null;

    public ResultWrapper(ResultSet rs) throws SQLException {
        this.rs = rs;
        rm = rs.getMetaData();
    }



    
    public Object getObject(int col) throws SQLException {
        int t = rm.getColumnType(col);

        Object obj = null;
        switch (t) {
          case Types.ARRAY: obj = rs.getArray(col); break;
          case Types.BIGINT: obj = new Long(rs.getLong(col)); break;
          case Types.BINARY: obj = rs.getBinaryStream(col); break;
          case Types.BIT: obj = new Integer(rs.getInt(col)); break;
          case Types.BLOB: obj = rs.getBlob(col); break;
          case Types.BOOLEAN: obj = new Boolean(rs.getBoolean(col)); break;
          case Types.CHAR: obj = rs.getString(col); break;
          case Types.CLOB: obj = rs.getClob(col); break;
          case Types.DATALINK: obj = rs.getString(col); break;
          case Types.DATE: Timestamp ts = rs.getTimestamp(col); if (ts!=null) obj = new Date(ts.getTime()); else obj=null; break;
          case Types.DECIMAL: obj = rs.getBigDecimal(col); break;
          case Types.DISTINCT: obj = rs.getString(col); break;
          case Types.DOUBLE: obj = new Double(rs.getDouble(col)); break;
          case Types.FLOAT: obj = new Float(rs.getFloat(col)); break;
          case Types.INTEGER: obj = new Integer(rs.getInt(col)); break;
          case Types.JAVA_OBJECT: obj = rs.getString(col); break;
          case Types.LONGVARBINARY: obj = rs.getBigDecimal(col); break;
          case Types.LONGVARCHAR: obj = rs.getString(col); break;
          case Types.NULL: obj = null; break;
          case Types.NUMERIC:
              
              
              
              
              
              
              
              if (rm.getScale(col)>0) {
                  obj = new Double(rs.getDouble(col));
              }
              else
                  obj = new Long(rs.getLong(col));
              break;
          case Types.OTHER: obj = rs.getString(col); break;
          case Types.REAL: obj = rs.getString(col); break;
          case Types.REF: obj = rs.getString(col); break;
          case Types.SMALLINT: obj = new Integer(rs.getInt(col)); break;
          case Types.STRUCT: obj = rs.getString(col); break;
          case Types.TIME: obj = rs.getTime(col); break;
          case Types.TIMESTAMP: obj = rs.getTimestamp(col); break;
          case Types.TINYINT: obj = new Integer(rs.getInt(col)); break;
          case Types.VARBINARY: obj = rs.getBinaryStream(rs.getInt(col)); break;
          case Types.VARCHAR: obj = rs.getString(col); break;
          default: obj = rs.getString(col);
        }
        
        return obj;
    }

    public boolean next() throws SQLException {
        return rs.next();
    }
}