Question

JAVA.用方法把结果集rs全部输出显示,怎么做这个方法.

我的方法是这么做的
public Vector select(String selectStr)
{
connection();
try
{
Vector v = new Vector();
rs=stat.executeQuery(selectStr);
while(rs.next())
{
v.add(rs.getString(1)); //这里要怎么做?

}
rs.close();
return v;
}
catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
......
}
_________________________________________________________
public class A extends DatabaseExecute
{
void start()
{
java.util.Vector v = select("select * from userinfo");

for(int i=0;i<v.size();i++)
{
System.out.println(v.get(i));
}

}
public static void main(String[] args)
{
new A().start();
}
}

编译成功,不过最后结果集输出的只是一列,怎么写能全显示?谢谢帮忙

Answer 1

public Vector select(String selectStr)
{
connection();
try
{
Vector v = new Vector();
rs=stat.executeQuery(selectStr);
ResultSetMetaData rsmd=rs.getMetaData();
int colCount = rsmd.getColumnCount();
while(rs.next())
for (int i=0;i<colCount;i++){
{
v.add(rs.getString(i+1)); //这里要这样做

}
}
rs.close();
return v;
}
catch(Exception ex)
{
ex.printStackTrace();
}
finally
{
......
}