ResultSet接口

执行SQL语句的查询语句会返回查询的结果集，在JDBC  API中，使用ResultSet对象接收查询结果集。查询示例：

package jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class QueryDemo {public static void main(String[] args) throws ClassNotFoundException {try {Class.forName("com.mysql.jdbc.Driver");String uri = "jdbc:mysql://localhost:3306/wtyy";String username = "root";String pwd = "wtyy";Connection conn = DriverManager.getConnection(uri, username, pwd);Statement statement=conn.createStatement();String sql="select * from student";ResultSet rs=statement.executeQuery(sql);while(rs.next()){System.out.println(rs.getString("name"));System.out.println(rs.getInt("age"));}rs.close();statement.close();conn.close();} catch (SQLException e) {e.printStackTrace();}}}