package test;
import java.awt.BorderLayout;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
class MySQLTable {
  private static Connection con = null;
  private static String URL = "jdbc:mysql://localhost:3306/finder";
  private static String driver = "com.mysql.jdbc.Driver";
  private static String user = "root";
  private static String pass = "starfire";
  public static void main(String[] args) throws SQLException  {
    Statement stmt;
    String query;
    ResultSet rs;
    Object rowData[][] = {{"Row1-Column1", "Row1-Column2", "Row1-Column3"}};
    Object columnNames[] = {"Name", "Pay", "Graph", "Sex", "Education", "Age", "Exp"};
    DefaultTableModel mTableModel = new DefaultTableModel(rowData, columnNames);
    JTable table = new JTable(mTableModel);
    try {
      Class.forName(driver).newInstance();
      con = DriverManager.getConnection(URL, user, pass);
    } catch (Exception e) {
      System.err.println("Exception: " + e.getMessage());
    }
    query = "SELECT * FROM vacancy";
    stmt = con.createStatement();
    rs = stmt.executeQuery(query);
    JFrame frame = new JFrame();
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    frame.add(new JScrollPane(table), BorderLayout.CENTER);
    frame.setSize(700, 300);
    frame.setVisible(true);
    mTableModel.removeRow(0);
    Object[] rows;
    while (rs.next()) {
      rows = new Object[]{rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getString(6), rs.getString(7)};
      mTableModel.addRow(rows);
    }
  }
}