ResultSet 两种取值 按顺序总是用的也总是 忘记 第一个是1开始 做个记录

您指定栏位名称来取得资料：

ResultSet result = stmt.executeQuery("SELECT * FROM message");
while(result.next()) ...{
System.out.print(result.getString("name") + " ");
System.out.print(result.getString("email") + " ");
System.out.print(result.getString("subject") + " ");
System.out.print(result.getString("time") + " ");
System.out.println(result.getString("memo") + " ");
}

　　使用查询到的结果之栏位顺序来显示结果的方式如下：

ResultSet result = stmt.executeQuery("SELECT * FROM message");
while(result.next()) ...{
System.out.print(result.getString(1) + " ");
System.out.print(result.getString(2) + " ");
System.out.print(result.getString(3) + " ");
System.out.print(result.getString(4) + " ");
System.out.println(result.getString(5) + " ");
}