Java取Access数据库,为什么只能取出一行记录?
//程序如下
//结果只输出: 姓名:张三
//就Process completed


import java.sql.*;

public class database {
public static void main(String args[]) {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:telbook";
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String sql="SELECT * FROM telbook";
ResultSet rs = statement.executeQuery(sql);
String tt;
while (rs.next()) {
System.out.print("姓名:" + rs.getString("Name"));
System.out.println(" 电话:" + rs.getString("tel"));
System.out.println(" Email:" + rs.getString("email"));
}
rs.close();
connection.close();
}
catch(Exception ex){
System.out.println(ex);
System.exit(0);
}
}
}

高手同学帮忙解答,谢谢!

[解决办法]
我觉得应该没问题吧!你看一下是不是你的字段名搞错了!
我这个和你的都差不多一样的,我的可以运行,没问题.你对照一下吧!

Java code

public class SQLDemo{    public static void main(String[] args)     {        try        {        String id,name,sex;        String   strURL   =  "jdbc:odbc:testData";         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");        Connection con = DriverManager.getConnection(strURL);        Statement Stmt = con.createStatement();        ResultSet rs = Stmt.executeQuery("SELECT id,name,sex FROM test1");        System.out.println("id,name,sex");        while(rs.next())        {            id = rs.getString("id");            name = rs.getString("name");            sex = rs.getString("sex");            System.out.println(id+","+name+","+sex);        }        }        catch (Exception e)         {            e.printStackTrace();        }    }}