/*
把ResultSet封装成ArrayList返回
@param ResultSet rs.
@returned arrayList list;
*/
public static List ResultSetToList(ResultSet rs) throws java.sql.SQLException{
if (rs == null)
return java.util.Collections.EMPTY_LIST;
ResultSetMetaData mt = rs.getMetaData();
int columnCount = mt.getColumnCount();
String value = null;
List list = new ArrayList();
Map map;
try{
while (rs.next()){
map = new HashMap(columnCount);
for (int i = 1; i <= columnCount; i++){
value = (String)rs.getString(i);
if (value == null) value = "";
map.put(mt.getColumnName(i).toLowerCase(),value);
}
list.add(map);
}
} catch(SQLException ex){
System.out.println("Cann't convert!");
}
return list;
}我的类中的一个方法,你可以再扩充.它的作用是将记录集转成ArrayList返回,调用时用: ClassName.ResultSetToList(rs);
把ResultSet封装成ArrayList返回
@param ResultSet rs.
@returned arrayList list;
*/
public static List ResultSetToList(ResultSet rs) throws java.sql.SQLException{
if (rs == null)
return java.util.Collections.EMPTY_LIST;
ResultSetMetaData mt = rs.getMetaData();
int columnCount = mt.getColumnCount();
String value = null;
List list = new ArrayList();
Map map;
try{
while (rs.next()){
map = new HashMap(columnCount);
for (int i = 1; i <= columnCount; i++){
value = (String)rs.getString(i);
if (value == null) value = "";
map.put(mt.getColumnName(i).toLowerCase(),value);
}
list.add(map);
}
} catch(SQLException ex){
System.out.println("Cann't convert!");
}
return list;
}我的类中的一个方法,你可以再扩充.它的作用是将记录集转成ArrayList返回,调用时用: ClassName.ResultSetToList(rs);
Statement smt=con.createStatement();
String sql2="select * from myweb";
ResultSet rst=smt.executeQuery(sql2);要查看结果:
<%
out.println("All Record:");
while(rst.next())
{
%>
<tr>
<td><%=rst.getString(1)%></td>
<td><%=rst.getString(2)%></td>
<td><%=rst.getString(3)%></td>
</tr>
<%
}
%>
麻烦你看一下
http://community.csdn.net/Expert/topic/3168/3168683.xml?temp=.5971186