Java RowSetMetaDataImpl.setColumnLabel方法代码示例

import javax.sql.rowset.RowSetMetaDataImpl; //导入方法依赖的package包/类
private void initCoffeeHousesMetaData(CachedRowSet crs) throws SQLException {
    RowSetMetaDataImpl rsmd = new RowSetMetaDataImpl();
    crs.setType(RowSet.TYPE_SCROLL_INSENSITIVE);

    /*
     *  CREATE TABLE COFFEE_HOUSES(
     *   STORE_ID Integer NOT NULL,
     *   CITY VARCHAR(32),
     *   COFFEE INTEGER NOT NULL,
     *   MERCH INTEGER NOT NULL,
     *   TOTAL INTEGER NOT NULL,
     *   PRIMARY KEY (STORE_ID))
     */
    rsmd.setColumnCount(COFFEE_HOUSES_COLUMN_NAMES.length);
    for(int i = 1; i <= COFFEE_HOUSES_COLUMN_NAMES.length; i++){
        rsmd.setColumnName(i, COFFEE_HOUSES_COLUMN_NAMES[i-1]);
        rsmd.setColumnLabel(i, rsmd.getColumnName(i));
    }

    rsmd.setColumnType(1, Types.INTEGER);
    rsmd.setColumnType(2, Types.VARCHAR);
    rsmd.setColumnType(3, Types.INTEGER);
    rsmd.setColumnType(4, Types.INTEGER);
    rsmd.setColumnType(5, Types.INTEGER);
    crs.setMetaData(rsmd);
    crs.setTableName(COFFEE_HOUSES_TABLE);

}
 

import javax.sql.rowset.RowSetMetaDataImpl; //导入方法依赖的package包/类
protected void initCoffeesMetaData(CachedRowSet crs) throws SQLException {
    RowSetMetaDataImpl rsmd = new RowSetMetaDataImpl();
    crs.setType(RowSet.TYPE_SCROLL_INSENSITIVE);

    /*
     *  CREATE TABLE COFFEES (
     *   COF_ID INTEGER NOT NULL,
     *   COF_NAME VARCHAR(32) NOT NULL,
     *   SUP_ID INTEGER NOT NULL,
     *   PRICE NUMBERIC(10,2 NOT NULL,
     *   SALES INTEGER NOT NULL,
     *   TOTAL INTEGER NOT NULL,
     *   PRIMARY KEY (COF_ID),
     *   FOREIGN KEY (SUP_ID) REFERENCES SUPPLIERS (SUP_ID) )
     */
    rsmd.setColumnCount(COFFEES_COLUMN_NAMES.length);
    for(int i = 1; i <= COFFEES_COLUMN_NAMES.length; i++){
        rsmd.setColumnName(i, COFFEES_COLUMN_NAMES[i-1]);
        rsmd.setColumnLabel(i, rsmd.getColumnName(i));
    }

    rsmd.setColumnType(1, Types.INTEGER);
    rsmd.setColumnType(2, Types.VARCHAR);
    rsmd.setColumnType(3, Types.INTEGER);
    rsmd.setColumnType(4, Types.NUMERIC);
    rsmd.setPrecision(4, 10);
    rsmd.setScale(4, 2);
    rsmd.setColumnType(5, Types.INTEGER);
    rsmd.setColumnType(6, Types.INTEGER);
    crs.setMetaData(rsmd);
    crs.setTableName(COFFEES_TABLE);

}
 

import javax.sql.rowset.RowSetMetaDataImpl; //导入方法依赖的package包/类
protected void initDataTypesMetaData(CachedRowSet crs) throws SQLException {
    RowSetMetaDataImpl rsmd = new RowSetMetaDataImpl();
    crs.setType(RowSet.TYPE_SCROLL_INSENSITIVE);

    rsmd.setColumnCount(DATATYPES_COLUMN_NAMES.length);

    for (int i = 1; i <= DATATYPES_COLUMN_NAMES.length; i++) {
        rsmd.setColumnName(i, DATATYPES_COLUMN_NAMES[i - 1]);
        rsmd.setColumnLabel(i, rsmd.getColumnName(i));
    }

    rsmd.setColumnType(1, Types.INTEGER);
    rsmd.setColumnType(2, Types.CHAR);
    rsmd.setColumnType(3, Types.VARCHAR);
    rsmd.setColumnType(4, Types.BIGINT);
    rsmd.setColumnType(5, Types.BOOLEAN);
    rsmd.setColumnType(6, Types.SMALLINT);
    rsmd.setColumnType(7, Types.DOUBLE);
    rsmd.setColumnType(8, Types.DECIMAL);
    rsmd.setColumnType(9, Types.REAL);
    rsmd.setColumnType(10, Types.TINYINT);
    rsmd.setColumnType(11, Types.DATE);
    rsmd.setColumnType(12, Types.TIME);
    rsmd.setColumnType(13, Types.TIMESTAMP);
    rsmd.setColumnType(14, Types.VARBINARY);
    rsmd.setColumnType(15, Types.ARRAY);
    rsmd.setColumnType(16, Types.REF);
    rsmd.setColumnType(17, Types.FLOAT);
    crs.setMetaData(rsmd);

}
 

import javax.sql.rowset.RowSetMetaDataImpl; //导入方法依赖的package包/类
/**
 * Initializes the given <code>RowSetMetaData</code> object with the values
 * in the given <code>ResultSetMetaData</code> object.
 * 
 * @param md
 *            the <code>RowSetMetaData</code> object for this
 *            <code>CachedRowSetImpl</code> object, which will be set with
 *            values from rsmd
 * @param rsmd
 *            the <code>ResultSetMetaData</code> object from which new
 *            values for md will be read
 * @throws SQLException
 *             if an error occurs
 */
private void initMetaData(RowSetMetaDataImpl md, ResultSetMetaData rsmd) throws SQLException {
	int numCols = rsmd.getColumnCount();

	md.setColumnCount(numCols);
	boolean isCaseSensitive = numCols > 0 ? rsmd.isCaseSensitive(1) : false;
	for (int col = 1; col <= numCols; col++) {
		md.setAutoIncrement(col, rsmd.isAutoIncrement(col));
		md.setCaseSensitive(col, isCaseSensitive); // fix the MySQL
													// performance
													// issue:http://blog.csdn.net/match_ding/article/details/11078553
		md.setCurrency(col, rsmd.isCurrency(col));
		md.setNullable(col, rsmd.isNullable(col));
		md.setSigned(col, rsmd.isSigned(col));
		md.setSearchable(col, rsmd.isSearchable(col));
		/*
		 * The PostgreSQL drivers sometimes return negative
		 * columnDisplaySize, which causes an exception to be thrown. Check
		 * for it.
		 */
		int size = rsmd.getColumnDisplaySize(col);
		if (size < 0) {
			size = 0;
		}
		md.setColumnDisplaySize(col, size);
		md.setColumnLabel(col, rsmd.getColumnLabel(col));
		md.setColumnName(col, rsmd.getColumnName(col));
		md.setSchemaName(col, rsmd.getSchemaName(col));
		/*
		 * Drivers return some strange values for precision, for non-numeric
		 * data, including reports of non-integer values; maybe we should
		 * check type, & set to 0 for non-numeric types.
		 */
		int precision = rsmd.getPrecision(col);
		if (precision < 0) {
			precision = 0;
		}
		md.setPrecision(col, precision);

		/*
		 * It seems, from a bug report, that a driver can sometimes return a
		 * negative value for scale. javax.sql.rowset.RowSetMetaDataImpl
		 * will throw an exception if we attempt to set a negative value. As
		 * such, we'll check for this case.
		 */
		int scale = rsmd.getScale(col);
		if (scale < 0) {
			scale = 0;
		}
		md.setScale(col, scale);
		md.setTableName(col, rsmd.getTableName(col));
		md.setCatalogName(col, rsmd.getCatalogName(col));
		md.setColumnType(col, rsmd.getColumnType(col));
		md.setColumnTypeName(col, rsmd.getColumnTypeName(col));
	}
}