package rfidcard;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.table.DefaultTableModel;


import java.awt.Color;

/**
 *
 * @author ACER
 */
public class schedulestu extends javax.swing.JFrame {

    /**
     * Creates new form schedulestu
     */
    public schedulestu() {
        initComponents();
        tampilkandata();

    }
    public Connection conn;

    public void koneksi() throws SQLException {
        try {
            conn=null;
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/rfid", "root", "");

        } catch (ClassNotFoundException ex) {
            Logger.getLogger(schedulestu.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException e) {
            Logger.getLogger(schedulestu.class.getName()).log(Level.SEVERE, null, e);
        } catch (Exception es) {
            Logger.getLogger(schedulestu.class.getName()).log(Level.SEVERE, null, es);


    }
    }

    public void tampilkandata() {
        DefaultTableModel tabelmapel = new DefaultTableModel();
        tabelmapel.addColumn("Day");
        tabelmapel.addColumn("Course");
        tabelmapel.addColumn("Class");
        tabelmapel.addColumn("Time");
        tabelmapel.addColumn("Room");
        try {
            koneksi();
            String sql = "select * from schedule";
            Statement stat = conn.createStatement();
            ResultSet res=stat.executeQuery(sql);
            while (res.next()) {
                tabelmapel.addRow(new Object[]{res.getString(1),res.getString(2),res.getString(3), res.getString(4), res.getString(5)});
            }
           teble.setModel(tabelmapel);
        } catch (Exception e) {
        }

    }