我有一个查询结果集（日期和房间）某种矩阵。
9间客房和日期介于（2022年1月1日至2022年1月31日）。

try {
    String query="select  a.Tarikh AS 'TARIKH',a.Room AS 'ROOM',b.Room as 'BOOKED'"
            + "from     (Select * from Tarikh Cross Join Room) as a\n"
            + "left join Booking as b\n"
            + "on        a.Tarikh = b.Tarikh\n"
            + "and       (a.Room = b.Room)\n"
            + "WHERE        (a.Tarikh BETWEEN '2022-01-01' AND '2022-03-01');";
    PreparedStatement pst=connection.prepareStatement(query);
    ResultSet rs = pst.executeQuery();

    // this line below implement the usage of net.proteanit.sql.DbUtils (import library)    
    table_1.setModel(DbUtils.resultSetToTableModel(rs));
    // ---      

    pst.execute();  
    rs.close();
} catch (Exception e) {
    e.printStackT
}

问题是，如何使JtableModel从这个

Room    Date            Booked
101 2022-01-01  2022-01-01
102 2022-01-01  2022-01-01
103 2022-01-01  2022-01-01
104 2022-01-01  2022-01-01
105 2022-01-01  null
106 2022-01-01  null
107 2022-01-01  null
108 2022-01-01  null
109 2022-01-01  null
101 2022-01-02  null
102 2022-01-02  2022-01-02
103 2022-01-02  null
104 2022-01-02  null
105 2022-01-02  null
106 2022-01-02  null
107 2022-01-02  null
108 2022-01-02  null
109 2022-01-02  null
and so on....

我希望记录是：

0101  0201 0301 0401 0501 and so on....
101      X 
102      X     X
103      X 
104      X
105
106
107
108
109

有人知道吗，请帮忙。TQ