package Model;

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


public class TableFromDatabase extends JFrame
{
    public TableFromDatabase()
    {
        Vector columnNames = new Vector();
        Vector data = new Vector();

        try
        {

            //  Verbinding met database

            String driver = "com.mysql.jdbc.Driver";
            String url = "jdbc:mysql://localhost/project-registratie";
            String userid = "root";
            String password = "";

           Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection connection = DriverManager.getConnection( url, userid, password );

            //  data uit tabel lezen

            String sql = "Select * from project";
            Statement stmt = connection.createStatement();
            ResultSet rs = stmt.executeQuery( sql );
            ResultSetMetaData md = rs.getMetaData();
            int columns = md.getColumnCount();

            //  column namen ophalen.

            for (int i = 1; i <= columns; i++)
            {
                columnNames.addElement( md.getColumnName(i) );
            }

            //  row data ophalen

            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();
            connection.close();
        }
        catch(Exception e)
        {
            System.out.println( e );
        }

        //  tabel maken + informatie van database er in zetten

        JTable table = new JTable(data, columnNames)
        {
            @Override
            public Class getColumnClass(int column)
            {
                for (int row = 0; row < getRowCount(); row++)
                {
                    Object o = getValueAt(row, column);

                    if (o != null)
                    {
                        return o.getClass();
                    }
                }

                return Object.class;
            }
        };

        JScrollPane scrollPane = new JScrollPane( table );
        getContentPane().add( scrollPane );



        JPanel buttonPanel = new JPanel();
        getContentPane().add( buttonPanel, BorderLayout.SOUTH );


    }

}