ResultSet用法

小谈ResultSet用法
http://www.233.com/Java/jichu/20100221/090841805.html

ResultSet用法集锦
http://soft-development.iteye.com/blog/1420323

--------------------------------------------------------

Statement st = conn.CreateStatement
ResultSet rs = Statement.excuteQuery(sqlStr);
rs.next();
rs.previous();

Example:
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") + " ");

}

posted @ 2013-05-23 02:02  petercao  阅读(10391)  评论(0编辑  收藏  举报