jdbc & sql related project

Hi Friend,

Try the following code:

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;

public class Application{
private JScrollPane scrollpane = null;
JList list;
DefaultListModel model;

public Application(){
model = new DefaultListModel();

JFrame frame = new JFrame("Databases");
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306";, "root", "root");
Statement st = con.createStatement();
ResultSet rs=st.executeQuery("SHOW DATABASES");
while(rs.next()){
model.addElement(rs.getString("Database"));
}
rs.close();
st.close();
con.close();
}catch(Exception ex){}
list = new JList(model);
scrollpane=new JScrollPane(list);
list.addListSelectionListener(new ListSelectionListener(){
public void valueChanged(ListSelectionEvent e) {
if (!e.getValueIsAdjusting()) {
String selection = list.getSelectedValue().toString();
try{
final Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/"+selection,"root";, "root");
DatabaseMetaData meta = con.getMetaData();
ResultSet rs = meta.getTables(null, null, "%", null);
DefaultListModel model1 = new DefaultListModel();
while(rs.next()){
model1.addElement(rs.getString(3));
}
final JList list1 = new JList(model1);
JScrollPane scrollpane1=new JScrollPane(list1);
JFrame f=new JFrame("Tables in the selected database");
f.add(scrollpane1);
f.pack();
f.setVisible(true);
list1.addListSelectionListener(new ListSelectionListener(){
public void valueChanged(ListSelectionEvent event) {
if (!event.getValueIsAdjusting()) {
String table = list1.getSelectedValue().toString();
try{
Statement st=con.createStatement();
ResultSet res=st.executeQuery("select * from "+table);
while(res.next()){
System.out.println(res.getString(1)+" "+res.getString(2));

}
}
catch(Exception exc){}
}
}
});
}
catch(Exception ex){}
}
}
});
JPanel panel = new JPanel();
panel.add(scrollpane);

frame.add(panel);
frame.setSize(400, 400);
frame.setVisible(true);
}
public static void main(String[] args){
Application tt = new Application();
}
}

Hope that it will be helpful for you.
Thanks