Storing a SQL column into a java array

Question

I want to store a sql column into an array using a method in java

my code:

public static String[] getAirports() {
        String airport[];


        try {
            String sql = "SELECT airportname FROM luggageApp.airport";
            Class.forName("com.mysql.jdbc.Driver");
            Connection connection = DatabaseManager.openConnection();
            Statement statement = connection.createStatement();
            PreparedStatement pst = connection.prepareStatement(sql);
            ResultSet rs = pst.executeQuery();


            ResultSetMetaData rsmetadata = rs.getMetaData();

            int columns = rsmetadata.getColumnCount();
            airport[] = new String[columns];


            while (rs.next()) {
                for (int j = 1; j < columns; j++) {
                    airport[j] = rs.getString(j);
                }
            }

            connection.close();
        } catch (Exception e) {
            e.printStackTrace();

        }

        return airport;
    }

What I want: In a for loop I would like to add all the airport names 1 by 1 into the array so I can later on call this method to fill in a jCombobox.

I was not sure to create an int variable for the amount of cells the column airport has. So I could use this in the for loop. — Rafael
– Rafael, Commented Dec 3, 2014 at 12:33
column variable should be first defined than it should be used as it will give compile time error. — Bhargav Modi
– Bhargav Modi, Commented Dec 3, 2014 at 12:50

Ruchira Gayan Ranaweera · Accepted Answer · 2014-12-03 12:37:17Z

3

You can do something like following.

int j=0;
while (rs.next()) {      
   airport[j] = rs.getString("airportname");// get value in airportname column
                                            // and add to array
   j++;
}

Instead of array it is better to use a ArrayList

Eg:

List<String> airPorts=new ArrayList<>();
 while (rs.next()) {      
   airPorts.add(rs.getString("airportname"));                                 
}

edited Dec 3, 2014 at 12:37

answered Dec 3, 2014 at 12:32

Ruchira Gayan Ranaweera

35.7k17 gold badges78 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Rafael Over a year ago

Could you explain why it is better to use an ArrayList over an array?

Bhargav Modi Over a year ago

because The capacity of an Array is fixed. Where as,ArrayList can increase and decrease size dynamically.

Ruchira Gayan Ranaweera Over a year ago

@Mr.Goose array has a fixed length and you need to define the size of array. But you don't need to bother about the length of ArrayList, and no need to define it.

Collectives™ on Stack Overflow

Storing a SQL column into a java array

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related