Display JTable with mysql

[philip dobson]

Hello,
Sorry for my english.
I need help, please. I want to populate JTable with mysql, but my code don't work.
Please can anyone help me?
my code:

package principal;

import javax.swing.*;

import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.*;
import java.util.*;

public class Coucou extends JPanel {
	public Connection con = null;
	public Statement requete = null;
	public ResultSet rs = null;
	public Coucou(){
		try{
			String url = "jdbc:mysql://localhost/databasegui";
			String login = "root";
			String paswordd = "frenchy";	
			con = DriverManager.getConnection(url,login,paswordd);
			requete = con.createStatement();
			rs = requete.executeQuery("SELECT * FROM x_objet_visite");
			ResultSetMetaData md = rs.getMetaData();
			int columnCount = md.getColumnCount();
	
			Vector columns = new Vector(columnCount);
	
			//store column names
			for(int i=1; i<=columnCount; i++)
			    columns.add(md.getColumnName(i));
			Vector data = new Vector();
			Vector row;
	
			//store row data
			while(rs.next())
			{
			    row = new Vector(columnCount);
			    for(int i=1; i<=columnCount; i++)
			    {
			        row.add(rs.getString(1));
			    }
			    data.add(row);
			}
			JTable table = new JTable(data, columns);
	        table.setPreferredScrollableViewportSize(new Dimension(500, 70));
	        table.setFillsViewportHeight(true);
	        table.setVisible(true);
	        table.validate();

		}
		catch(SQLException sqle){
			//cf Comment gérer les erreurs ? 
			System.out.println(sqle);
			sqle.printStackTrace();
		}
	}	

    public static void main(String[] args) {
        //Schedule a job for the event-dispatching thread:
        //creating and showing this application's GUI.
		JFrame frame = new JFrame("View Doctors");
		JScrollPane scrollPane = new JScrollPane(new Coucou());
		frame.getContentPane().add(scrollPane);
		frame.setSize(300, 400);
    	frame.setVisible(true);
    }
}

I don't see the result. Please explain me.

[Paul Clapham]

You create a JTable (and it looks like you're doing it right) but you never add it to your GUI. That's why you don't see it.

[philip dobson]

Thank you Paul,
Good help .