/**
* 得到用户列表
* @param s 新闻信息表
* @param httpservletrequest 从页面得到信息
* @return 返回新闻列表
*/
public Vector GetuserList(String s)
{
Vector vector = new Vector();
Hashtable hashtable;
String sql = "";
sql = "select * from "+s+" ";
System.out.println(sql);
int id=0;
String username="";
String userrealname="";
try
{
ResultSet rs = null;
for(rs = dbconn1.executeQuery(sql); rs.next(); vector.addElement(hashtable))
{
hashtable = new Hashtable();
id = rs.getInt("id");
username = rs.getString("username");
userrealname = rs.getString("userrealname");
hashtable.put("id", new Integer(id));
hashtable.put("username", username);
hashtable.put("userrealname", userrealname);
}
rs.close();
dbconn1.CloseConn();
}
catch (Exception e)
{
System.err.println("message from GetNewsList:"+ e);
}
return vector;
}数据库里面有好多记录的,怎么就搜索不出来了???
* 得到用户列表
* @param s 新闻信息表
* @param httpservletrequest 从页面得到信息
* @return 返回新闻列表
*/
public Vector GetuserList(String s)
{
Vector vector = new Vector();
Hashtable hashtable;
String sql = "";
sql = "select * from "+s+" ";
System.out.println(sql);
int id=0;
String username="";
String userrealname="";
try
{
ResultSet rs = null;
for(rs = dbconn1.executeQuery(sql); rs.next(); vector.addElement(hashtable))
{
hashtable = new Hashtable();
id = rs.getInt("id");
username = rs.getString("username");
userrealname = rs.getString("userrealname");
hashtable.put("id", new Integer(id));
hashtable.put("username", username);
hashtable.put("userrealname", userrealname);
}
rs.close();
dbconn1.CloseConn();
}
catch (Exception e)
{
System.err.println("message from GetNewsList:"+ e);
}
return vector;
}数据库里面有好多记录的,怎么就搜索不出来了???
Vector vector = new Vector();
Hashtable hashtable = new Hashtable();;
String sql = "";
而在循环中直接使用hashtable 就可以了。
因为如果你每次在循环中new一次,那么。这个hashtable 就新产生一次,所以当然只能保存一条记录了!:)