Thread: How to retrieve data from MYSQL database to JComboBox or to an array

Which bit do you have no idea about - constructing a JComboBox, transferring data from resultSet to array/Vector, or retrieving data from MySQL? You should: SELECT a ResultSet from MySQL (java.sql.Connection, java.sql.Statement, java.sql.ResultSet), transfer the data you want to display to the user into an array or java.util.Vector, invoke the JComboBox constructor with the data you've collected.

transferring mysql data to array is my problem

here is the code that I'm playing with

public int i;
public String [] array;
PreparedStatement pstmt = con.prepareStatement("Select * from products");
ResultSet rs = pstmt.executeQuery();
while(rs.next())
{
array[i]=rs.getString(2);
i++;
}
 
JComboBox combo = new JComboBox(array);

I'm getting no error but eclipse is suspends the program

highlighting (exception nullpointer exception)
array[i]=rs.getString(2);

Where do you give a value to the array variable?
You give a value to a variable by using the assignment statement:
array = ....

The array variable is a String[] array.
The getString() method returns a String.

You need to give the array variable a value. It is defined as String[]
You need to use the new statement to give it a String[] value.
array = new String[1]; // give the variable array a value

thanks it's already solved. I forgot the give the array a value