JTable中的ResultSet [英] ResultSet in JTable

问题描述

如何在JTable中显示ResultSet。我正在使用此代码

How to display ResultSet in JTable. i am using this code

 String [] record= new 
    String[ColCount]; 
    for (i=0; i<ColCount; i++) 
    { 
    record[i]=rset1.getString(i+1); 

    } 
    cell[i] = rset1.getString("loginname"); 
    cell[i] = rset1.getString( "role"); 
    System.out.println(cell[i][0]);
    //ItemGroup = rset1.getString( "Status"); 
    } 
    System.out.println(ItemCode);
    JTable jt = new JTable( 
    cell[i], headers);

但我只得到一行最后插入数据库。

but I get only one row which is lastly inserted to database.

推荐答案

您需要在代码周围放置一个while循环来迭代结果集。例如，

You need to put a while loop around your code to iterate over the result set. eg,

while(rset1.next())
{
//do something
}

这篇关于JTable中的ResultSet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！