Trouble with jtables from a database

[mitty]

I'm trying to retrieve information from a database and display it in a JTable for part of my project.

I can retrieve the information needed easily but am finding it difficult to show it in a JTable. I've looked at loads of tutorials and I can't seem to implement it into my project, In the end I kind of cheated and displayed the information into a JTextArea but this has not format to it and the information looks messy. As I'm completely new to using Swing, I downloaded Jigloo to create a GUI for my project.

I have the following code. (I've cut it short to the bit where the data is extracted from the database)

Vector columnNames = new Vector();
 Vector data = new Vector();

try {
//Read info from database
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection (Url);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
ResultSetMetaData md = rs.getMetaData();
int columns = md.getColumnCount();
//read names of columns
						
						
					    for (int i = 1; i <= columns; i++)
		                  {
					    	
		                       columnNames.addElement( md.getColumnName(i) );
		                      
		                      
		                  }
					    System.err.println(columnNames);
					    
						
					    String rowdatatotal = columnNames + "\n" + "\n";
	                      
					    while (rs.next())
		                  {
		                        Vector row = new Vector(columns);
		 
		                        for (int i = 1; i <= columns; i++)
		                        {
		                              row.addElement( rs.getObject(i) );
		                        }
		 
		                        data.addElement( row );
		                        System.out.println(row);
		                       Vector rowdata = (row);
								
								rowdatatotal = rowdatatotal + rowdata + "\n" ;
								sqloutputArea.setText (rowdatatotal);
		                  }
					    JTable table = new JTable(data, columnNames);
					    
						/*while ( rs.next ()) {
							
							firstString = rs.getString(1);
							secondString = rs.getString(2);
							thirdString = rs.getString(3);
							fourthString = rs.getString(4);
							fifthString = rs.getString(5);
							sixthString = rs.getString(6);
							seventhString = rs.getString(7);
							
							System.out.println(firstString + " " + secondString + " " + thirdString + " " + fourthString + " " + fifthString + " " +
									" " + sixthString + " " + seventhString);
							
							String rowdata = firstString + " " + secondString + " " + thirdString + " " + fourthString + " " + fifthString + " " +
							" " + sixthString + " " + seventhString;
							
							rowdatatotal = rowdatatotal + rowdata + "\n" ;
							sqloutputArea.setText (rowdatatotal + "\n");
							} //end while
						*/
						con.close();
						 //end try

could anyone point me in the right direction, I need to get this done by tomorrow :(

Thanks in advance, I appreciate your time.

[RamyaSivakanth]

Hi,
You have to format the code when posting.There are plenty of sample code in net.
Go thru this below link
Populate data from database into JTable in Netbeans | My Java Articles