java中ResultSet遍曆資料__javaweb

1.尋找資料庫中表的列名

<pre name="code" class="html">String sql = "select *from tblmetadatainfo";ResultSet rs = MySqlHelper.executeQuery(sql, null);String str="";try {ResultSetMetaData rsmd = rs.getMetaData();for (int i = 1; i < rsmd.getColumnCount(); i++) {str+=rsmd.getColumnName(i)+",";}str=str.substring(0, str.length()-1);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}

2.尋找資料庫中表中每條記錄的列值

for(int i=1;i<rs.getMetaData().getColumnCount();i++){str+=rs.getString(i)+",";}