关于ResultSetMetaData 自动获取表列和表值解决方案

关于ResultSetMetaData 自动获取表列和表值
public String DBMessage(long id){
String dbdriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver://localhost:3333;databaseName=aidb";
String us="sa";
String pw="sa";
String sql="select * from ColumnItem where id="+id+"";

Connection conn=null;
Statement stat=null;
ResultSet rs=null;
StringBuffer sb= new StringBuffer();

try {
Class.forName(dbdriver);
conn=DriverManager.getConnection(url, us, pw);
stat=conn.createStatement();
rs=stat.executeQuery(sql);

while(rs.next()){
ResultSetMetaData rsmd = rs.getMetaData();
int counts = rsmd.getColumnCount();
for (int col = 0; col < counts; col++) {
String colname = rsmd.getColumnName(col+1);
// String colclass=(String) rs.getObject(colname);
sb.append(colname);
sb.append(",");
// sb.append(colclass);
sb.append("\r\n");

System.out.println(colname);
}

// str += rs.getInt("colId");
// str += ",";
// str += rs.getInt("sid");
// str += ",";
// str += rs.getInt("id");
// str += ",";
// str += rs.getString("colCode");
// str += ",";
// str += rs.getString("colName");
// str += ",";
// str += rs.getInt("colPid");
// str += ",";
// str += rs.getInt("colLevel");
// str += ",";
// str += rs.getInt("colType");
// str += ",";
// str += rs.getInt("colLenght");
// str += ",";
// str += rs.getString("colDate");
// str += ",";
// str += rs.getInt("com_id");
// str += ",";
// str += rs.getInt("display");
// str += ",";
// str += rs.getString("formula");
// str += ",";
// str += rs.getInt("isText");
// str += "\r\n";
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return sb.toString();
}

 for里面应该怎么写才能自动获取到表列和表列的值？现表列已经获取到了，表列的值怎么获取？


------解决方案--------------------
rs.getInt(index);
或者
rs.getInt("colname");
不就行了么。
------解决方案--------------------

Java code

public class Test{    public String DBMessage(long id){        String dbdriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";        String url="jdbc:sqlserver://localhost:3333;databaseName=aidb";        String us="sa";        String pw="sa";        String sql="select * from ColumnItem where id="+id+"";        Connection conn=null;        Statement stat=null;        ResultSet rs=null;        StringBuffer sb= new StringBuffer();        try {            Class.forName(dbdriver);            conn=DriverManager.getConnection(url, us, pw);            stat=conn.createStatement();            rs=stat.executeQuery(sql);                while(rs.next()){                ResultSetMetaData rsmd = rs.getMetaData();                int counts = rsmd.getColumnCount();                for (int col = 0; col < counts; col++) {                    String colname = rsmd.getColumnName(col+1);                    sb.append(rsmd.getColumnName(col+1)+",");                    System.out.println(colname);                }                sb.setLength(sb.length()-1);                sb.append("\r\n");                while(rs.next()){                     sb.append(rs.getInt("colId")+",");                     sb.append(rs.getInt("sid")+",");                     //....自己写                     sb.setLength(sb.length()-1);                     sb.append("\r\n");                }            }        } catch (ClassNotFoundException e) {        e.printStackTrace();        } catch (SQLException e) {        e.printStackTrace();        }        return sb.toString();    } }//楼主这问题还在纠结啊？排版很简单啊，难得是取数据