import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.table.*;

public class JTableDatabase{
public static void main(String[] args) {
JLabel lab1=new JLabel("Field1");
final JTextField text1=new JTextField(10);

JLabel lab2=new JLabel("Field2");
final JTextField text2=new JTextField(10);

 JPanel panel=new JPanel(new GridLayout(3,2));

JButton b=new JButton("View");
panel.add(lab1);
panel.add(text1);
panel.add(lab2);
panel.add(text2);
panel.add(b);
b.addActionListener(new ActionListener(){
    public void actionPerformed(ActionEvent ev){
        String v1=text1.getText();
    String v2=text2.getText();
Vector columnNames = new Vector();
Vector data = new Vector();

try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root" );
String sql = "Select "+v1+","+v2+" from data";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery( sql );
ResultSetMetaData md = rs.getMetaData();
int columns = md.getColumnCount();
for (int i = 1; i <= columns; i++) {
columnNames.addElement( md.getColumnName(i) );
}
while(rs.next()){
Vector row = new Vector(columns);
for (int i = 1; i <= columns; i++){
row.addElement( rs.getObject(i) );
}
data.addElement( row );
}
rs.close();
stmt.close();
}
catch(Exception e){
System.out.println(e);
}
JTable table = new JTable(data, columnNames);
JScrollPane scrollPane = new JScrollPane( table );
 JPanel p=new JPanel();
p.add( scrollPane );
JFrame fr=new JFrame();
fr.add(p);
fr.setSize(500,200);
fr.setVisible(true);
}
});
JFrame f=new JFrame();
f.add(panel);
f.pack();
f.setVisible(true);
}
}