Solved

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

Posted on 2008-10-25
6
300 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
recursion example 16 111
Need to track down Infection in a Server 2008 domain user profile 7 48
thymeleaf natural templating vs JSP 2 67
xampp tool 12 25
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now