Need advice on creating a ListView?

Question

Java

A list is given (bus numbers No. 1,2,3,4, etc.) in general, when you click on the bus number, its route opens. It is necessary to store a large list of buses and implement a search for the bus number by stop. I think to store all data in xml. For example :

<resources>
        <bus id="1">
            <stationUp>A</stationUp>
            <stationUp>B</stationUp>
            <stationIp>C</stationIp>
            <stationDown>C</stationDown>
            <stationDown>B</stationDown>
            <stationDown>A</stationDown>
        </bus>
        <bus id="2">
            <stationUp>A</stationUp>
            <stationUp>B</stationUp>
            <stationIp>C</stationIp>
            <stationDown>C</stationDown>
            <stationDown>B</stationDown>
            <stationDown>A</stationDown>
        </bus>
</resources>

With approximately 230 routes and each with 30 stops, the list is huge. Please advise how would you store this array?

Answer 1

Please advise how would you store this array?

*drumroll*
In a sql database?