How do i show all the values in one window(JOptionPane)??

[Antonioj1015]

I have the following code:

try
{
Class.forName("com.mysql.jdbc.Driver");
conec = DriverManager.getConnection("jdbc:mysql://localhost/Inventory","root", "");
est=conec.createStatement();
res=est.executeQuery("SELECT id_client,name_client,date FROM client");
while(res.next())
{
idClient1=res.getString("id_client");
NameClient=res.getString("name_client");
Date1=res.getString("date");
JOptionPane.showMessageDialog(null, "Document: "+idClient1+"\nName: "+NameClient+"\nDate: "+Date1);
}}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}

the problem is that it shows the values but i have to click on accept to continue with the next one, How do i show all the values in one window?
THANKS...

[Fubarable]

Create an ArrayList<String> and place the String you generate from the data returned into this list. Then create a String array from this list and show it in the JOptionPane. For instance:

      String[] strings = {"mon", "tues", "wed", "thurs", "fri"};
      
      List<String> stringList = new ArrayList<String>();
      for (String string : strings) {
         // here you will use instead this:
         // String string = "Document: "+idClient1+"\nName: "+NameClient+"\nDate: "+Date1
         stringList.add(string);
      }
      
      
      String[] stringArray = stringList.toArray(new String[0]);
      JOptionPane.showMessageDialog(null, stringArray);