Solved

How can I change this code to display to JOptionPane instead of println?

Posted on 2008-10-25
6
302 Views
Last Modified: 2012-05-05
I need to display this code in JOptionPane.
con = DriverManager.getConnection(url,
"myLogin", "myPassword");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
int rowCount = 1;
while (rs.next()) {
System.out.println("Row " + rowCount + ": ");
for (int i = 1; i <= numberOfColumns; i++) {
System.out.print(" Column " + i + ": ");
System.out.println(rs.getString(i));
}
System.out.println("");
rowCount++;
}

Open in new window

0
Comment
Question by:glynco
  • 4
  • 2
6 Comments
 

Author Comment

by:glynco
ID: 22805811
Here is with JOptionPane but how can I display all at once?

int rowCount = 1;
String columncontent;
while (uprsInventory.next()) {
System.out.println("Row " + rowCount + ": ");
for (int i = 1; i <= InventorynumberOfColumns; i++) {
    
                JOptionPane.showMessageDialog(null,
                "Column " +i);
                
                columncontent = uprsInventory.getString(i);
                
                JOptionPane.showMessageDialog(null,
                "column content " + columncontent );
                
                }
rowCount++;
 
}

Open in new window

0
 

Author Comment

by:glynco
ID: 22805821
Something like this. But I got errors.
Illegal start of expression.
int rowCount = 1;
String columncontent;
while (uprsInventory.next()) {
System.out.println("Row " + rowCount + ": ");
                
                JOptionPane.showMessageDialog(null,
                        for (int i = 1; i <= InventorynumberOfColumns; i++) {
                        columncontent = uprsInventory.getString(i);
                        "i " + i + "\n "
                        +"column content " + columncontent);                      
                        }
rowCount++;
 
}

Open in new window

0
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 22805884
You can't look within the message dialog like that.

You can show the output in a different component like a JTable or JComboBox, but if you want to use showMessageDialog you must use the for loop to build a string -- you can use the \n (or \n\r) to make multiple lines like you are trying to do above.

After you have your string variable, you can call:

JOptionPane.showMessageDialog(null, strData);
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

Author Comment

by:glynco
ID: 22805900
You mean I will concatenate all the strings?
0
 

Author Comment

by:glynco
ID: 22805926
It works.
But the page generated so big it won't fit the screen.


    int InventorynumberOfColumns = uprsInventoryMetaData.getColumnCount();
 
    String newstring1, newstring2;
newstring2 = "";
while (uprsInventory.next ()) {
for (int i=1; i<=InventorynumberOfColumns; i++) {
String columnName = uprsInventoryMetaData.getColumnLabel(i);
//System.out.print(columnName + ": ");
String columnValue = uprsInventory.getString(i);
//System.out.println(columnValue);
newstring1 = columnName + " " + columnValue;
newstring2 = newstring2 + newstring1 + "\n";
//System.out.println("String1:" + newstring1);
 
}
JOptionPane.showMessageDialog(null, newstring2);
//System.out.println("String2:" + newstring2);
//System.out.println("");
//System.out.println("");
}
 
 
stmtInventory.close();
conn.close();
}

Open in new window

0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 22805947
I more of a business objects/server-side programmer; therefore, there may be better GUI solutions than my suggestion, but you can try a JTable instead.

http://java.sun.com/j2se/1.4.2/docs/api/javax/swing/JTable.html

Hope that helps.
0

Featured Post

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
what is a "java.lang.System Property"   ? 20 67
even odd program using while loop 3 43
JavaFX TableView not displaying correctly 3 20
mysql jsp example issue 32 38
An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question