How can I show records on a JOption Window instead of a println?

I have the input from the user as JOption but how can I show the results also on a JOption Window inested of the println code?

            while ( rs.next() ) {
                String itemidvar = rs.getString("itemid");
                System.out.println(itemidvar);
                String itemnamevar = rs.getString("itemname");
                System.out.println(itemnamevar);
            }


import java.sql.*; 
import javax.swing.*;
public class NewClass {
    
 
  
    public static void main (String[] args) { 
        String itemnamestr;
        
        itemnamestr = JOptionPane.showInputDialog(null, "Enter item name.");
 
        try { 
            String url = "jdbc:mysql://localhost:3306/test1"; 
            Connection conn = DriverManager.getConnection(url,"root","dragon77"); 
            Statement stmt = conn.createStatement(); 
            ResultSet rs; 
  
            rs = stmt.executeQuery("SELECT itemid, itemname FROM inventorytable WHERE itemname = '"+itemnamestr +"'"); 
            
            while ( rs.next() ) { 
                String itemidvar = rs.getString("itemid"); 
                System.out.println(itemidvar); 
                String itemnamevar = rs.getString("itemname"); 
                System.out.println(itemnamevar); 
            } 
            conn.close(); 
        } catch (Exception e) { 
            System.err.println("Got an exception! "); 
            System.err.println(e.getMessage()); 
        } 
    } 
}

Open in new window

glyncoAsked:
Who is Participating?
 
chaitu chaituConnect With a Mentor Commented:
write a one custom object like Item class.i dont know swing but generic logic is like this...

public class Item
{
private String itemId;
private Sring itemName;

write setter and getter methods;


}
initilize arraylist here;
ArrayList al = new ArrayList();
while ( rs.next() ) { 
                String itemidvar = rs.getString("itemid"); 
                String itemnamevar = rs.getString("itemname"); 
      Item it = new Item();
it.setItemId(itemidvar);
it.setItemNamevar(itemnamevar);
al.add(it);
 
            } 
 
for loop this arraylist in ur JOption Window 
 
like (int i=0;i<al.size();i++)
{
Item it= (Item)al.get(i):
print these values
it.getItemId();
it.getItemName();
}

Open in new window

0
 
glyncoAuthor Commented:
I need the correct syntax because I am still a beginner learning. I can also do it on Netbeans IDE 6.1
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.