ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount(); //得到字段个数
rsmd.getColumnName(int整数)(得到字段名)
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount(); //得到字段个数
rsmd.getColumnName(int整数)(得到字段名)
int valarr[] = new int[cols+1];
valarr[i]=meta.getColumnType(i);//得字段的类型
tmp=meta.getColumnName(i);//得字段名
写的不够详细。琢磨一下吧。
public static Vector getTableData(Connection conn,Statement stmt,String tableName)
{
Vector v=new Vector();
try
{
stmt=conn.createStatement();
ResultSet reset=stmt.executeQuery("select * from "+tableName+" where 1=0");
reset.next();
ResultSetMetaData rsmd=reset.getMetaData();
for(int i=1;i<=rsmd.getColumnCount();i++)
{
String[] n=new String[3];
n[0]=rsmd.getColumnName(i);//字段名
n[1]=String.valueOf(rsmd.getColumnType(i));//字段类型
n[2]=String.valueOf(rsmd.getColumnDisplaySize(i));//字段长度
v.add(i-1,n);
}
}
catch(Exception e)
{
e.printStackTrace();
}
return v;
}