/**
* 获取字段
*/
public String getColumnName(String table){
String s="";
try{
Connection conn = this.getConn();
String sql="select * from "+table;
PreparedStatement pst =conn.prepareStatement(sql);
ResultSet rs=pst.executeQuery();
ResultSetMetaData rsmd=rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
for(int i=0;i<numberOfColumns;i++){
s+=rsmd.getColumnName(i+1);
if(i<numberOfColumns-1)
{
s+=",";
}
}
}
catch (Exception e) {
}
return s;
}
* 获取字段
*/
public String getColumnName(String table){
String s="";
try{
Connection conn = this.getConn();
String sql="select * from "+table;
PreparedStatement pst =conn.prepareStatement(sql);
ResultSet rs=pst.executeQuery();
ResultSetMetaData rsmd=rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
for(int i=0;i<numberOfColumns;i++){
s+=rsmd.getColumnName(i+1);
if(i<numberOfColumns-1)
{
s+=",";
}
}
}
catch (Exception e) {
}
return s;
}