如何从房间查询返回POJO

// Room POJO类
public class Room {
    private int roomId;
    private String roomName;
    private int capacity;

    // 构造方法、getter和setter省略

    @Override
    public String toString() {
        return "Room [roomId=" + roomId + ", roomName=" + roomName + ", capacity=" + capacity + "]";
    }
}

// 数据库查询方法
public Room getRoomById(int roomId) {
    Room room = null;
    try {
        // 执行数据库查询操作，获取房间信息
        // 这里使用伪代码代替实际的数据库查询操作
        ResultSet resultSet = executeQuery("SELECT * FROM rooms WHERE roomId = " + roomId);

        // 将查询结果映射到Room对象
        if (resultSet.next()) {
            room = new Room();
            room.setRoomId(resultSet.getInt("roomId"));
            room.setRoomName(resultSet.getString("roomName"));
            room.setCapacity(resultSet.getInt("capacity"));
        }
    } catch (SQLException e) {
        // 异常处理
    }
    return room;
}

// 调用数据库查询方法并返回POJO对象
Room room = getRoomById(1);
System.out.println(room);