从数据库里查询出来的记录集ResultSet,
是一个ArrayList,而这个ArrayList的每一个元素是一个HashMap,也就是说,从数据库里取出来的每一条记录都是用一个HashMap装着的。所以要取每一个字段就是从HashMap中取数据。
是一个ArrayList,而这个ArrayList的每一个元素是一个HashMap,也就是说,从数据库里取出来的每一条记录都是用一个HashMap装着的。所以要取每一个字段就是从HashMap中取数据。
{
String getVal = "";
Vector vecSet = new Vector(); stmt = connDB.createStatement();
rs = stmt.executeQuery(inSql);
int fieldNum = rs.getMetaData().getColumnCount();
Vector vecRecord;
for(; rs.next(); vecSet.addElement(vecRecord))
{
vecRecord = new Vector();
for(int i = 0; i < fieldNum; i++)
{
getVal = rs.getString(i + 1);
if(getVal == null)
getVal = "";
vecRecord.addElement(getVal);
}
} return vecSet;
}
Vector 这里和Hashtable是一样的
public class test{
public static void main(String args[]){
Hashtable ht=new Hashtable();
ht.put("1","a");
ht.put("2","b");
ht.put("3","c");
Enumeration e = ht.elements();
Enumeration e2 = ht.keys();
while(e.hasMoreElements()) {
System.out.println((String)e.nextElement());
System.out.println((String)e2.nextElement());
}
}
}
sql = "select * from *";
ps = con.prepareStatement(sql);
result = ps.executeQuery();
while (result.next())
{
Hashtable hash =new Hashtable();
hash.put("NAME",result.getString("NAME"));
hash.put("ADDRESS",result.getString("ADDRESS"));
vec.add(hash);
}
return vec等到用时候
for (i = 0;i <vec.size();i++){
Hashtable hash = (Hashtable)pVec.get(i);
hash.get(); vec.add(samview_);
}
sql = "select * from *";
ps = con.prepareStatement(sql);
result = ps.executeQuery();
while (result.next())
{
Hashtable hash =new Hashtable();
hash.put("NAME",result.getString("NAME"));
hash.put("ADDRESS",result.getString("ADDRESS"));
vec.add(hash);
}
return vec等到用时候
for (i = 0;i <vec.size();i++){
Hashtable hash = (Hashtable)pVec.get(i);
String str = "";
str = hash.get("NAME");
// str = hash.get("ADDRESS"); }