高考问答街机格斗游戏日本:JAVA.用方法把结果集rs全部输出显示,怎么做这个方法.
来源：百度文库 编辑：高考问答 时间：2024/04/30 00:35:23
我的方法是这么做的
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();
}
}
编译成功,不过最后结果集输出的只是一列,怎么写能全显示?谢谢帮忙
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();
}
}
编译成功,不过最后结果集输出的只是一列,怎么写能全显示?谢谢帮忙
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
{
......
}