// Stupid SQL Table Parser by Atrinax, 2009

import javax.swing.SwingUtilities;
import java.awt.BorderLayout;
import javax.swing.JPanel;
import javax.swing.JFrame;
import java.awt.FlowLayout;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import javax.swing.JButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;

import java.sql.*;


public class StupidSQLTableParser extends JFrame {

    private static final long serialVersionUID = 1L;
    private JPanel jContentPane = null;
    private JPanel jButtonPanel = null;
    private JTextField jServerField = null;
    private JTextField jDatabaseField = null;
    private JTextField jTableField = null;
    private JTextField jUserField = null;
    private JPasswordField jPasswordField = null;
    private JButton jParseButton = null;
    private JScrollPane jScrollPane = null;
    private JTable jTable = null;
    /**
     * This method initializes jButtonPanel
     *
     * @return javax.swing.JPanel
     */
    private JPanel getJButtonPanel() {
        if (jButtonPanel == null) {
            jButtonPanel = new JPanel();
            jButtonPanel.setLayout(new FlowLayout());
            jButtonPanel.add(getJServerField(), null);
            jButtonPanel.add(getJDatabaseField(), null);
            jButtonPanel.add(getJTableField(), null);
            jButtonPanel.add(getJUserField(), null);
            jButtonPanel.add(getJPasswordField(), null);
            jButtonPanel.add(getJParseButton(), null);

        }
        return jButtonPanel;
    }

    /**
     * This method initializes jServerField
     *
     * @return javax.swing.JTextField
     */
    private JTextField getJServerField() {
        if (jServerField == null) {
            jServerField = new JTextField();
            jServerField.setText("localhost");
                    }
        return jServerField;
    }

    /**
     * This method initializes jDatabaseField
     *
     * @return javax.swing.JTextField
     */
    private JTextField getJDatabaseField() {
        if (jDatabaseField == null) {
            jDatabaseField = new JTextField();
            jDatabaseField.setText("mysql");
        }
        return jDatabaseField;
    }

    /**
     * This method initializes jTableField
     *
     * @return javax.swing.JTextField
     */
    private JTextField getJTableField() {
        if (jTableField == null) {
            jTableField = new JTextField();
            jTableField.setText("help_category");
        }
        return jTableField;
    }

    /**
     * This method initializes jUserField
     *
     * @return javax.swing.JTextField
     */
    private JTextField getJUserField() {
        if (jUserField == null) {
            jUserField = new JTextField();
            jUserField.setText("root");
        }
        return jUserField;
    }

    /**
     * This method initializes jPasswordField
     *
     * @return javax.swing.JPasswordField
     */
    private JPasswordField getJPasswordField() {
        if (jPasswordField == null) {
            jPasswordField = new JPasswordField();
            jPasswordField.setText("*********");
        }
        return jPasswordField;
    }

    /**
     * This method initializes jParseButton
     *
     * @return javax.swing.JButton
     */
    private JButton getJParseButton(){
        if (jParseButton == null){
            jParseButton = new JButton();
            jParseButton.setText("Parse");
            jParseButton.addActionListener(new java.awt.event.ActionListener() {
                @SuppressWarnings("deprecation")
                public void actionPerformed(java.awt.event.ActionEvent e) {
                    TableModel dataModel = new TableModel();
                    Database database = new Database(jServerField.getText(), jDatabaseField.getText(), jUserField.getText(), jPasswordField.getText());
                    dataModel.updateData(database.Query("*", jTableField.getText()));
                    jTable.setModel(dataModel);
                }
            });

        }
        return jParseButton;
    }

    /**
     * This method initializes jScrollPane
     *
     * @return javax.swing.JScrollPane
     */
    private JScrollPane getJScrollPane() {
        if (jScrollPane == null) {
            jScrollPane = new JScrollPane();
            jScrollPane.setViewportView(getJTable());
        }
        return jScrollPane;
    }

    /**
     * This method initializes jTable
     *
     * @return javax.swing.JTable
     */
    private JTable getJTable() {
        if (jTable == null) {
            jTable = new JTable();
        }
        return jTable;
    }

    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        SwingUtilities.invokeLater(new Runnable() {
            public void run() {
                StupidSQLTableParser thisClass = new StupidSQLTableParser();
                thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
                thisClass.setVisible(true);
            }
        });
    }

    /**
     * This is the default constructor
     */
    public StupidSQLTableParser() {
        super();
        initialize();
    }

    /**
     * This method initializes this
     *
     * @return void
     */
    private void initialize() {
        this.setSize(678, 387);
        this.setContentPane(getJContentPane());
        this.setTitle("StupidSQLTableParser");
    }

    /**
     * This method initializes jContentPane
     *
     * @return javax.swing.JPanel
     */
    private JPanel getJContentPane() {
        if (jContentPane == null) {
            jContentPane = new JPanel();
            jContentPane.setLayout(new BorderLayout());
            jContentPane.add(getJButtonPanel(), BorderLayout.NORTH);
            jContentPane.add(getJScrollPane(), BorderLayout.CENTER);
        }
        return jContentPane;
    }

}  //  @jve:decl-index=0:visual-constraint="10,10"

class Database {
    private Statement sqlStatement = null;
    private ResultSet sqlResults = null;
    private Connection sqlConnection = null;

    Database(String ServerAddress, String db, String username, String password){
        try {
            sqlConnection = DriverManager.getConnection("jdbc:mysql://"+ ServerAddress + "/"+ db, username, password);
            //System.out.println("jdbc:mysql://"+ ServerAddress + "/"+ db + " "+ username + " " + password);
            sqlStatement = sqlConnection.createStatement();
            } catch (SQLException sqlException) {
            // TODO Auto-generated catch block
            sqlException.printStackTrace();
        }
}
    public ResultSet Query(String columns, String table){
        ResultSet sqlResults = null;
        try {
            sqlResults = sqlStatement.executeQuery("SELECT " + columns + "FROM " + table);
        } catch (SQLException sqlException) {
            // TODO Auto-generated catch block
            sqlException.printStackTrace();
        }
        return sqlResults;

    }

public void ConnectionClose(){
    try {
        if (sqlResults != null)
            {
            if (sqlResults.isClosed() == false)
                {
                sqlResults.close();
                sqlResults = null;
                }
            }
        else
            {
            sqlResults = null;
            }

        if (sqlStatement != null)
        {
        if (sqlStatement.isClosed() == false)
            {
            sqlStatement.close();
            sqlStatement = null;
            }
        }
    else
        {
        sqlResults = null;
        }

        if (sqlConnection != null)
        {
        if (sqlConnection.isClosed() == false)
            {
            sqlConnection.close();
            sqlConnection = null;
            }
        }
    else
        {
        sqlResults = null;
        }
            } catch (SQLException sqlException) {
        // TODO Auto-generated catch block
        sqlException.printStackTrace();
    }
}
}
class TableModel extends AbstractTableModel
{
    /**
     *
     */
    private static final long serialVersionUID = 7134095982055865140L;
    private ResultSet data = null;

    public void updateData(ResultSet l)
    {
        data = l;
        fireTableDataChanged();
    }

    public ResultSet getData()
    {
        return data;
    }

    public int getRowCount()
    {
        int returnVal = 0;
        if (data != null){
        try {
            data.last();
            returnVal = data.getRow();

        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        }
        return returnVal;
    }

    public int getColumnCount()
    {
        int returnVal = 0;
        if (data != null){ try {
            ResultSetMetaData MetaData = data.getMetaData();

            returnVal = MetaData.getColumnCount();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        }
        return returnVal;
    }

    public String getColumnName(int col)
    {
        String returnVal = "undefined";
        if (data != null){
            try {
                ResultSetMetaData MetaData = data.getMetaData();
                returnVal = MetaData.getColumnName(col + 1);
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        return returnVal;
    }

    public Object getValueAt(int row, int col)
    {
        Object returnVal = (String)"undefined";
        if (data != null){
            try {
                data.absolute(row + 1);
                returnVal = data.getObject(col +1);
                } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        return returnVal;
    }

}