Connection conn;
    DefaultTableModel tabModel;

    public Quiz_A() {
        initComponents();
        conn = koneksi.getConnection();
        setJTable();
    }

    public void setJTable(){
    String [] JudulKolom = {"No","nim","kodematkul","uts","uas","na"};
    tabModel = new DefaultTableModel (null, JudulKolom){
               boolean[] canEdit = new boolean [] { false, false, false, false, false, false};
               @Override
               public boolean isCellEditable (int rowIndx, int columnIndex){
                   return canEdit [columnIndex];
               }
    };
    TA.setModel(tabModel);
    TA.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
    TA.getColumnModel().getColumn(0).setPreferredWidth(30);
    TA.getColumnModel().getColumn(1).setPreferredWidth(100);
    TA.getColumnModel().getColumn(2).setPreferredWidth(100);
    TA.getColumnModel().getColumn(3).setPreferredWidth(100);
    TA.getColumnModel().getColumn(4).setPreferredWidth(100);
    TA.getColumnModel().getColumn(5).setPreferredWidth(100);
    getData();
}


    public void getData(){
        try{
       String sql="Select * from nilai_mhs";
        PreparedStatement st=conn.prepareStatement(sql);
        ResultSet rs=st.executeQuery();
        String nim,kodematkul,uts,uas,na;
        int no=0;
        while(rs.next()){
         no=no+1;
         nim=rs.getString("nim");
         kodematkul=rs.getString("kodematkul");
         uts=rs.getString("uts");
         uas=rs.getString("uas");
         na=rs.getString("na");

         Object Data[]={no,nim,kodematkul,uts,uas,na};
         tabModel.addRow(Data);
        }
    }
    catch (SQLException sqle) {
           System.out.println("Proses Query Gagal = " + sqle);
           System.exit(0);
    }
    catch(Exception e){
           System.out.println("Koneksi Access Gagal " +e.getMessage());
           System.exit(0);
    }
}

    void simpanData(){
     try{
            String sql="Insert into nilai_mhs values(?,?,?,?,?)";
            PreparedStatement st=conn.prepareStatement(sql);
                st.setString(1, txtNim.getText());
                st.setString(2, txtKodeMatkul.getText());
                st.setString(3, txtUTS.getText());
                st.setString(4, txtUAS.getText());
                st.setString(5, txtNA.getText());
            int rs=st.executeUpdate();

            if(rs>0){
            JOptionPane.showMessageDialog(this,"Input Berhasil");
      	    setJTable();
            }
        }
        catch (SQLException sqle) {
           JOptionPane.showMessageDialog(this,"Input  Gagal = " + sqle.getMessage());
        }
        catch(Exception e){
           JOptionPane.showMessageDialog(this,"Koneksi Gagal " +e.getMessage());
        }
    }

    public void hapusIsiJTable() {
    int row = tabModel.getRowCount();
    for (int i = 0; i < row; i++) {
      tabModel.removeRow(0);
    }
   }

    public void tampilDataKeJTable() {
    hapusIsiJTable();
    try {
        String sql="Select * from nilai_mhs";
        PreparedStatement st=conn.prepareStatement(sql);
        ResultSet rs=st.executeQuery();
        String nim,kodematkul,uts,uas,na;
        int no=0;
        while(rs.next()){
         no=no+1;
         nim=rs.getString("nim");
         kodematkul=rs.getString("kodematkul");
         uts=rs.getString("uts");
         uas=rs.getString("uas");
         na=rs.getString("na");

         Object Data[]={no,nim,kodematkul,uts,uas,na};
         tabModel.addRow(Data);
      }
  }
    catch (Exception e) {
    JOptionPane.showMessageDialog(this,"Tampil");}  // Isi informasi eksepsi
 }