使用rs.next()从ResultSet获取特定数据

try {
    // 创建数据库连接
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
    
    // 创建SQL查询语句
    String sql = "SELECT * FROM mytable";
    
    // 创建Statement对象
    Statement stmt = conn.createStatement();
    
    // 执行查询，并获取ResultSet对象
    ResultSet rs = stmt.executeQuery(sql);
    
    // 遍历ResultSet并获取数据
    while (rs.next()) {
        // 获取特定列的数据
        int id = rs.getInt("id");
        String name = rs.getString("name");
        double price = rs.getDouble("price");
        
        // 处理数据
        System.out.println("ID: " + id);
        System.out.println("Name: " + name);
        System.out.println("Price: " + price);
    }
    
    // 关闭连接
    rs.close();
    stmt.close();
    conn.close();
} catch (SQLException e) {
    e.printStackTrace();
}