Question

java读取数据库写入jTable

小弟初学,在用java读取数据库写入jTable中的时候只能显示一行,请求帮助.

String me=mex.getText();
if("0".equals(me))
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:kmgl","","");
String sql="select * from km";
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
int i = 0;
String xkh=rs.getString(1).trim();
String xmm=rs.getString(2).trim();
String xme=rs.getString(3).trim();
String xsy=rs.getString(4).trim();
biao.setValueAt(xkh, i, 0);
biao.setValueAt(xmm, i, 1);
biao.setValueAt(xme, i, 2);
biao.setValueAt(xsy, i, 3);
i++;
}
rs.close();
con.close();
}
catch(Exception e){
System.out.print(e.getMessage());
}
}
else {}
}

Answer 1

while(rs.hasNext())，不是rs.next()

追问

大神你好,rs.hasNext()提示错误

===========================

搞定了,自己把i=0写在循环内了,每次都是i=0;   - -~

 while(rs.next()){

        int i = 0;

改为

 int i = 0;

 while(rs.next()){

       

就好了,自己太2了 - -