Java 数据库 MySQL

Question

您好，在下面的代码中，它只打印表中的第一个 ID 和名字。你如何让它打印出查询的所有结果而不仅仅是第一个结果？谢谢

Statement stat = conn.createStatement();  

stat.execute("CREATE TABLE Test (Id VARCHAR(20), Name VARCHAR(20))");  
stat.execute("INSERT INTO Test VALUES ('1AA', 'John')");  
stat.execute("INSERT INTO Test VALUES ('2AA', 'George')");
stat.execute("INSERT INTO Test VALUES ('3AA', 'Richard')");


ResultSet result = stat.executeQuery("SELECT * FROM Test");  
result.next();  
System.out.println(result.getString("Name"));  
System.out.println(result.getString("Id"));
stat.execute("DROP TABLE Test");  

Answer 1

使用 while 循环遍历所有结果:

...
ResultSet result = stat.executeQuery("SELECT * FROM Test");  
while(result.next()) {  
    System.out.println(result.getString("Name"));  
    System.out.println(result.getString("Id"));
}
stat.execute("DROP TABLE Test");