可以使用ResultSetMetaData接口实现,ResultSet.getMetaData()方法就是返回实现这个接口的类,详细的请参考JDK文档
解决方案 »
- 十万火急啊 各位大神帮帮忙啊
- 求JSP的论坛源码?
- 是高手就进来!!!
- 请问怎么在struts中的jsp下写javascipt呀
- 在tomcat5.5.9下,如果创建一个新的project?
- 关于配置数据源的问题!!
- 新手问题,如何在企业管理器中给用户分配一个数据库的权限,请高手们帮帮忙!
- ajax 返回的innerHTML里面的js代码如何执行?
- 我想用beans保存多个页面写的数据,怎么只输出最后一个呢?
- 关于java.util.Date中引用getDay()方法的问题?进来看看吧......
- 本人急需JS读写COOKIE的方法,最好有个完整的例子,使COOKIE有一定格式
- 求助错误消息"Invalid public ID"的问题!
http://java.sun.com/j2se/1.4.2/docs/api/
int type1=rsmd .getColumnType(1);
public static final int ARRAY 2003
public static final int BIGINT -5
public static final int BINARY -2
public static final int BIT -7
public static final int BLOB 2004
public static final int BOOLEAN 16
public static final int CHAR 1
public static final int CLOB 2005
public static final int DATALINK 70
public static final int DATE 91
public static final int DECIMAL 3
public static final int DISTINCT 2001
public static final int DOUBLE 8
public static final int FLOAT 6
public static final int INTEGER 4
public static final int JAVA_OBJECT 2000
public static final int LONGVARBINARY -4
public static final int LONGVARCHAR -1
public static final int NULL 0
public static final int NUMERIC 2
public static final int OTHER 1111
public static final int REAL 7
public static final int REF 2006
public static final int SMALLINT 5
public static final int STRUCT 2002
public static final int TIME 92
public static final int TIMESTAMP 93
public static final int TINYINT -6
public static final int VARBINARY -3
public static final int VARCHAR 12
public ResultSet getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types)
throws SQLExceptionRetrieves a description of the tables available in the given catalog. Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.
Each table description has the following columns: TABLE_CAT String => table catalog (may be null)
TABLE_SCHEM String => table schema (may be null)
TABLE_NAME String => table name
TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
REMARKS String => explanatory comment on the table
TYPE_CAT String => the types catalog (may be null)
TYPE_SCHEM String => the types schema (may be null)
TYPE_NAME String => type name (may be null)
SELF_REFERENCING_COL_NAME String => name of the designated "identifier" column of a typed table (may be null)
REF_GENERATION String => specifies how values in SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER", "DERIVED". (may be null)
Note: Some databases may not return information for all tables.
Parameters:
catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
schemaPattern - a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
tableNamePattern - a table name pattern; must match the table name as it is stored in the database
types - a list of table types to include; null returns all types
Returns:
ResultSet - each row is a table description