Java 类javax.swing.table.DefaultTableModel 实例源码

public void loadTableBD(int num) {
    Result res = db.execute("MATCH (n:`Avion`{numero:"+num+"}) RETURN n.numero, n.type, n.capacite");
    DefaultTableModel dtm = new DefaultTableModel(0,0);
    String header[] = {"Numero", "Type", "Capacite"};
    String test[] = {"n.numero", "n.type", "n.capacite"};
    dtm.setColumnIdentifiers(header);
    jTable1.setModel(dtm);
    while(res.hasNext()) {
        Map<String, Object> row = res.next();
        Map<String, Object> obj = new LinkedHashMap();
        for (String t:test) {
            obj.put(t, null);
        }
        for(Map.Entry<String, Object> col : row.entrySet()) {
             obj.put(col.getKey(),col.getValue());   
        }

        dtm.addRow(obj.values().toArray());
}
}

public Soru3() {
    initComponents();

    dtm = new DefaultTableModel();
    dtm.setColumnIdentifiers(new Object[]{"ID", "ADI", "SOYADI", "MAAS"});
    jTable1.setModel(dtm);
    try {
        // bağlantı için
        Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/PERSONELDB", "sa", "as");
        // iletişimi acıyor
        Statement stmt = con.createStatement();
        // veritabanında sorgu çalıştırıp bize geri tablo döndürüyor.
        ResultSet rs = stmt.executeQuery("SELECT * FROM PERSONEL");

        while (rs.next()) {
            int id = rs.getInt("ID");
            String adi = rs.getString("ADI");
            String soyadi = rs.getString("SOYADI");
            int maas = rs.getInt("MAAS");
            dtm.addRow(new Object[]{id, adi, soyadi, maas});
        }

    } catch (SQLException ex) {
        Logger.getLogger(NewClass.class.getName()).log(Level.SEVERE, null, ex);
    }
}

public ControlerHistorico(Historico historico) {
    this.historico = historico;

    this.historico.getTbl_Historico().getColumnModel().getColumn(2).setPreferredWidth(170);
    this.historico.getTbl_Historico().getColumnModel().getColumn(4).setPreferredWidth(485);
    dtm = (DefaultTableModel) this.historico.getTbl_Historico().getModel();

    this.historico.getBtn_Cancelar().addActionListener(this);
    this.historico.getBtn_Ok().addActionListener(this);
    this.historico.getRbt_Data().addActionListener(this);
    this.historico.getRbt_Todas().addActionListener(this);

    getDados();
    preencheTabela();

    this.historico.setVisible(true);
}

public QueryResultViewer() {
    resultSet = null;
    tableModel = new DefaultTableModel();
    emptyResultLabel = new JLabel(EMPTY_RESULT_MSG);
    mainContainer = new JPanel();

    setLayout(new BorderLayout());
    tableSP = new JScrollPane(graphicTable,
            JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED, 
            JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
    tableSP.setBorder(BorderFactory.createEmptyBorder());

    graphicTable.setModel(tableModel);
    graphicTable.setFillsViewportHeight(true);
    graphicTable.setEnabled(false);

    addComponentListener(new ComponentAdapter() {
        public void componentResized(ComponentEvent e) {
            resizeColumnWidth(COL_MIN_WIDTH);          
        }
    });

    mainContainer.add(tableSP);
    setLayout(new GridLayout(1,1));
    add(tableSP);
}

private void populatePostPayTable(DefaultTableModel model) {

        // import all customers from database
        final PostingDaoImpl postingDaoImpl = new PostingDaoImpl();
        List<Posting> postingList = postingDaoImpl.getAllPostingsByRoomNumber(roomNumber, hotelSystemStatus.getDateTime().toString());

        final PaymentDaoImpl paymentDaoImpl = new PaymentDaoImpl();
        List<Payment> paymentlist = paymentDaoImpl.getAllPaymentsByRoomNumber(roomNumber, hotelSystemStatus.getDateTime().toString());

        // clean table model
        model.setRowCount(0);

        for (Posting pos : postingList) {

            model.addRow(new Object[] { pos.getId(), pos.getPostType(), pos.getTitle(), pos.getPrice(),
                    pos.getCurrency(), pos.getExplanation(), pos.getDateTime() });
        }

        for (Payment pay : paymentlist) {

            model.addRow(new Object[] { pay.getId(), pay.getPaymentType(), pay.getTitle(), pay.getPrice(),
                    pay.getCurrency(), pay.getExplanation(), pay.getDateTime() });
        }
    }

private void addAction() {
    VariableEditDialog dialog = new VariableEditDialog();
    dialog.setTitle("Create New Variable");
    dialog.getButtonOK().addActionListener(it -> {
        String key = dialog.getKeyTextField().getText().trim();
        String value = dialog.getValueTextField().getText().trim();
        DefaultTableModel tableModel = (DefaultTableModel) varTable.getModel();
        String[] rowValues = {key, value};
        tableModel.addRow(rowValues);
        dialog.setVisible(false);
    });

    dialog.setSize(300, 150);
    dialog.setAlwaysOnTop(true);
    dialog.setLocationRelativeTo(rootPanel);
    dialog.setModalityType(Dialog.ModalityType.APPLICATION_MODAL);
    dialog.setResizable(false);
    dialog.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE);
    dialog.setVisible(true);
}

@Override
public void preencheTabela() {
    dtm = (DefaultTableModel) this.cadastroLanche.getjTable1().getModel();

    if (this.lanches != null) {
        for (Lanche lan : lanches) {
            dtm.insertRow(dtm.getRowCount(), new Object[]{
                lan.getNome(),
                lan.getPreco()
            });
        }
    }
    this.cadastroLanche.getLista_ingredientes().setModel(dlmIng);
    this.cadastroLanche.getLista_lanche().setModel(dlmLan);

    for (int i = 0; i < this.ingredientes.size(); i++) {
        dlmIng.add(i, this.ingredientes.get(i).getNome());
    }

}

private void construtorPanelIndicador(){

        Object[] colunas = new String[]{"Pesquisa","Resultado"};

        Object[][] dados = new Object[][]{
        };

        model = new DefaultTableModel(dados , colunas ){
            public boolean isCellEditable(int row, int col){
                return false;
            }
        };
        tabela = new JTable();
        tabela.setModel(model);
        tabela.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
        painelTabela = new JScrollPane();
        painelTabela.setViewportView(tabela);

        // busca e inserção dos resultados na tabela
        this.consultaIndicadores();

    }

public void loadTableBD(String dateAuj) {
    Result res = db.execute("MATCH (a:Avion)-[r:Affecter]->(d:Depart)<-[c:Constituer]-(v:Vol) WHERE d.date='"+dateAuj+"' RETURN d.numero, d.date, v.villeDep, v.villeArr,  a.type, a.capacite, v.numero, v.heureDep, v.heureArr");
    DefaultTableModel dtm = new DefaultTableModel(0,0);
    String header[] = {"Numero", "Date","Depart", "Arriveé", "Type", "Capacite", "NumVol", "Heure De Depart", "Heure d'arrive"};
    String test[] = {"d.numero", "d.date","v.villeDep", "v.villeArr", "a.type", "a.capacite", "v.numero", "v.heureDep", "v.heureArr"};
    dtm.setColumnIdentifiers(header);
    jTable1.setModel(dtm);
    while(res.hasNext()) {
        Map<String, Object> row = res.next();
        Map<String, Object> obj = new LinkedHashMap();
        for (String t:test) {
            obj.put(t, null);
        }
        for(Map.Entry<String, Object> col : row.entrySet()) {
             obj.put(col.getKey(),col.getValue());   
        }

        dtm.addRow(obj.values().toArray());
}
}

public void addContentLine(ServerLogMessage deseriaLogMessage) {
    try {
        DefaultTableModel model = (DefaultTableModel) this.table.getModel();
        String timeStamp = new SimpleDateFormat("HH:mm:ss").format(Calendar.getInstance().getTime());
        model.addRow(new String[]{timeStamp, deseriaLogMessage.getSource().getValue(),
                deseriaLogMessage.getLogLevel().toString(), deseriaLogMessage.getContent()});
    } catch (ArrayIndexOutOfBoundsException e) {
        //Tries again n times, error was caused by 2 threads accessing the table at the same time
        int n = 10;
        int i=0;
        while (!retryAddContentLine(deseriaLogMessage) && i<n) {
            i++;

        }
        if (i==n) {
            //retrying failed
            throw e;
        }

         }
}

private void loadUsersTable() {
    ArrayList<User> usersList = UserController.getUsersList();
    if (usersList.size() > 0) {
        DefaultTableModel def = (DefaultTableModel) users_table.getModel();
        def.setNumRows(0);

        for (User user : usersList) {
            String userName = user.getUserName();
            String userDisplayName = user.getUserDisplayName();
            UserLevel userLevel = user.getUserLevel();
            Integer userType = user.getUserType();
            Integer userStatus = user.getUserStatus();

            Vector v = new Vector();
            v.add(user);
            v.add(userDisplayName);
            v.add(userLevel.getLevelDisplayName());
            v.add(userType == 1 ? "Permanent" : "Temporary");
            v.add((userStatus == 1));
            def.addRow(v);
        }
    }
}

public void loadTableBD() {
    Result res = db.execute("MATCH (n:`Vol`) RETURN n.numero, n.villeDep, n.villeArr, n.heureDep, n.heureArr, n.distance, n.frequence ORDER BY n.numero");
    DefaultTableModel dtm = new DefaultTableModel(0,0);
    String header[] = {"n.numero", "Depart", "Arrivee", "Heure Depart", "Heure Arrivee", "Distance", "Frequence"};
    String test[] = {"n.numero", "n.villeDep", "n.villeArr", "n.heureDep", "n.heureArr", "n.distance", "n.frequence"};
    dtm.setColumnIdentifiers(header);
    jTable1.setModel(dtm);
    while(res.hasNext()) {
        Map<String, Object> row = res.next();
        Map<String, Object> obj = new LinkedHashMap();
        for (String t:test) {
            obj.put(t, null);
        }
        for(Entry<String, Object> col : row.entrySet()) {
             obj.put(col.getKey(),col.getValue());   
        }

        dtm.addRow(obj.values().toArray());
}
}

public ControlerPedidos(Pedidos pedidos) {
    this.pedidos = pedidos;

    this.pedidos.getTbl_Pedidos().getColumnModel().getColumn(0).setPreferredWidth(240);
    this.pedidos.getTbl_Pedidos().getColumnModel().getColumn(1).setPreferredWidth(585);

    this.pedidos.getBtn_Anterior().addActionListener(this);
    this.pedidos.getBtn_Cancelar().addActionListener(this);
    this.pedidos.getBtn_Entregue().addActionListener(this);
    this.pedidos.getBtn_Primeiro().addActionListener(this);
    this.pedidos.getBtn_Proximo().addActionListener(this);
    this.pedidos.getBtn_Ultimo().addActionListener(this);
    this.pedidos.getMnu_atualizar_pedidos().addActionListener(this);

    getDados();
    this.dtm = (DefaultTableModel) this.pedidos.getTbl_Pedidos().getModel();
    preencheTabela();

    this.pedidos.setVisible(true);

}

/**
 * Reads clipboard data and converts it into supported format and fills the
 * tmodel cells
 *
 * @param table the target tmodel
 */
private static void pasteFromClipboard(JTable table) {
    int startRow = table.getSelectedRows()[0];
    int startCol = table.getSelectedColumns()[0];
    String pasteString;
    try {
        pasteString = (String) (CLIPBOARD.getContents(CLIPBOARD).getTransferData(DataFlavor.stringFlavor));
    } catch (UnsupportedFlavorException | IOException ex) {
        Logger.getLogger(JtableUtils.class.getName()).log(Level.SEVERE, null, ex);
        return;
    }
    String[] lines = pasteString.split(LINE_BREAK);
    for (int i = 0; i < lines.length; i++) {
        String[] cells = lines[i].split(CELL_BREAK);
        if (table.getRowCount() <= startRow + i) {
            ((DefaultTableModel) table.getModel()).addRow(nullRow);
        }
        for (int j = 0; j < cells.length; j++) {
            if (table.getColumnCount() > startCol + j) {
                if (table.isCellEditable(startRow + i, startCol + j)) {
                    table.setValueAt(cells[j], startRow + i, startCol + j);
                }
            }
        }
    }
}

public void listarItensNPC() {
    final String sql = ("SELECT * FROM item WHERE fk_personagem = (?)");
    try {
        PreparedStatement stmt = c.prepareStatement(sql);
        stmt.setInt(1, pegarPk_personagem(nomePersonagem));
        ResultSet rs = stmt.executeQuery();
        DefaultTableModel model = (DefaultTableModel) TelaNPC.tabela.getModel();
        while (rs.next()) {
            int id = rs.getInt("pk_item");
            String nomeIcon = rs.getString("icone_ite");
            ImageIcon icon = (new ImageIcon(getClass().getResource("/ItemIcons/" + nomeIcon)));
            String nome = rs.getString("nome_ite");
            String atibutos = rs.getString("atributos_ite");
            String descricao = rs.getString("descricao_ite");
            int quantidade = rs.getInt("quantidade_ite");
            Object[] item = {id, quantidade, icon, nome, null, atibutos, descricao};
            model.addRow(item);
        }

    } catch (Exception e) {
        e.printStackTrace();
    }
}

@SuppressWarnings("unchecked")
private void updateTableFromEditor() {
    synchronized (this) {
        if (updateing) {
            return;
        }
        updateing = true;
        DefaultTableModel dtm = (DefaultTableModel) propertyTable.getModel();
        Vector columns = new Vector(2);
        Vector values = new Vector();
        columns.add(dtm.getColumnName(0));
        columns.add(dtm.getColumnName(1));
        if (value != null) {
            for (String key : value.stringPropertyNames()) {
                Vector row = new Vector(2);
                row.add(key);
                row.add(value.getProperty(key, ""));
                values.add(row);
            }
        }
        dtm.setDataVector(values, columns);
        updateing = false;
    }
}

private void storeRoots( SourceRoots roots, DefaultTableModel tableModel ) throws MalformedURLException {
    Vector data = tableModel.getDataVector();
    URL[] rootURLs = new URL[data.size()];
    String []rootLabels = new String[data.size()];
    final LinkedList<URL> oldRootURLs = new LinkedList<URL>(Arrays.asList (roots.getRootURLs (false)));
    final LinkedList<String> oldRootLabels = new LinkedList<String>(Arrays.asList(roots.getRootNames()));
    final LinkedList<String> oldRootProps = new LinkedList<String>(Arrays.asList (roots.getRootProperties()));
    boolean rootsAreSame = true;
    for (int i=0; i<data.size();i++) {
        File f = (File) ((Vector)data.elementAt(i)).elementAt(0);
        rootURLs[i] = Utilities.toURI(f).toURL();
        if (!rootURLs[i].toExternalForm().endsWith("/")) {  //NOI18N
            rootURLs[i] = new URL(rootURLs[i]+"/");
        }
        validateURL(rootURLs[i],f);
        rootLabels[i] = (String) ((Vector)data.elementAt(i)).elementAt(1);
        rootsAreSame &= !oldRootURLs.isEmpty() &&
                        oldRootURLs.removeFirst().equals(rootURLs[i]) &&
                        roots.getRootDisplayName(oldRootLabels.removeFirst(), oldRootProps.removeFirst()).equals(rootLabels[i]);
    }
    if (!rootsAreSame || !oldRootURLs.isEmpty ()) {
        roots.putRoots(rootURLs,rootLabels);
    }
}

public Soru1() {
    initComponents();

    ///SORGULAMA
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("BP2_LAB2PU");
    EntityManager em = emf.createEntityManager();

    Query q = em.createQuery("SELECT d FROM Doktor d");
    doktorlar = q.getResultList();
    for (Doktor dr : doktorlar) {
        cmb_doktorlar.addItem(dr.getAdi() + " " + dr.getSoyadi());
    }

    dtm = new DefaultTableModel();
    dtm.setColumnIdentifiers(new Object[]{"ID", "ADI", "SOYADI", "DOkTOR ID"});
    q = em.createQuery("SELECT h FROM Hasta h");
    List<Hasta> hastalar = q.getResultList();
    for (Hasta hs : hastalar) {
        dtm.addRow(new Object[]{hs.getId(), hs.getAdi(), hs.getSoyadi(), hs.getIdDoktor()});
    }
    tbl_hastalar.setModel(dtm);
    /////
}

private void setDataToTable(List<Eat> eats) {
    DefaultTableModel df = (DefaultTableModel) jTable1.getModel();
    df.getDataVector().removeAllElements();
    df.fireTableDataChanged();
    for (Eat eat : eats) {
        List<String> foods = new ArrayList<>();
        for (Food food : eat.getFoods()) {
            foods.add(food.getFood());
        }
        Object[] row = new Object[]{
            eat.getId(),
            eat.getName(),
            foods.toString()
        };
        df.addRow(row);
    }
    df.fireTableDataChanged();
}

public void listarArmasNPC() {
    final String sql = ("SELECT * FROM itemWeapon WHERE fk_personagem = (?)");
    try {
        PreparedStatement stmt = c.prepareStatement(sql);
        stmt.setInt(1, pegarPk_personagem(nomePersonagem));
        ResultSet rs = stmt.executeQuery();
        DefaultTableModel model = (DefaultTableModel) TelaNPC.tabela.getModel();
        while (rs.next()) {
            int id = rs.getInt("pk_itemWeapon");
            String nomeIcon = rs.getString("icone_itWea");
            ImageIcon icon = (new ImageIcon(getClass().getResource("/WeaponIcons/" + nomeIcon)));
            String nome = rs.getString("nome_itWea");
            int dano = rs.getInt("danoBase_itWea");
            String atibutos = rs.getString("atributos_itWea");
            String descricao = rs.getString("descricao_itWea");
            int quantidade = rs.getInt("quantidade_itWea");
            Object[] arma = {id, quantidade, icon, nome, dano, atibutos, descricao};
            model.addRow(arma);
        }

    } catch (Exception e) {
        e.printStackTrace();
    }
}

private void loadModuleInTable(TestMgModule testModule) {
    DefaultTableModel model = (DefaultTableModel) moduleTable.getModel();
    model.setRowCount(0);
    List<Option> option = testModule.getOptions();
    for (Option op : option) {
        model.addRow(new Object[]{op.getName(), op.getValue()});
    }
}

public void BuscarPaciente(DefaultTableModel modelo, String Apellidos) {
        Conexion nuevaConexion = new Conexion();
        Connection conex;
        ResultSet Consulta = null;
        try {
            nuevaConexion.Conectar();
            conex = nuevaConexion.getConexion();
            Statement comando = conex.createStatement();

            Consulta = comando.executeQuery("select pacientes.idPaciente, pacientes.Nombre, pacientes.Apellidos, pacientes.DIreccion, pacientes.Telefono from pacientes where pacientes.Apellidos='"+Apellidos+"'");
                String pacientes[] = new String[5];
            while(Consulta.next()==true){
                pacientes[0]=Consulta.getString("idPaciente");
                pacientes[1]=Consulta.getString("Nombre");
                pacientes[2]=Consulta.getString("Apellidos");
                pacientes[3]=Consulta.getString("DIreccion");
                pacientes[4]=Consulta.getString("Telefono");
                modelo.addRow(pacientes);
            }

            {
                JDBuscarPacientes.jtPacientes.setModel(modelo);
            }

      } catch (Exception e) {
            JOptionPane.showMessageDialog(null,"error"+ e);
      } 
}

private void jTableProyectsMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTableProyectsMouseClicked
    int row = jTableProyects.rowAtPoint(evt.getPoint());
    DefaultTableModel tablaproyect = (DefaultTableModel) jTableProyects.getModel();
    String dato=String.valueOf(tablaproyect.getValueAt(jTableProyects.getSelectedRow(), 0));
    select = dato;
    //select = Integer.toString(row+1);

    //JOptionPane.showMessageDialog(null, dato);
    //select = (String)jTableEquipment.getValueAt(row, 1);
    //select = (String)jTableEquipment.getValueAt(row, 0);
    modificar();
}

private void jrb_ModeloActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jrb_ModeloActionPerformed
    // TODO add your handling code here:        
    ArrayList<VendaVeiculo> aux = NegocioFacade.listaVeiculos();        
    Collections.sort(aux, new ModeloVeiculoComparator());

    DefaultTableModel model = (DefaultTableModel)jtb_Veiculos.getModel();
    model.setRowCount(0);
    for(VendaVeiculo a : aux){
        model.addRow(new Object[]{ a.getVeiculo().getMarca(), a.getVeiculo().getModelo(),
                               a.getVeiculo().getCor(), a.getVeiculo().getAno(), a.getPreco()});
    }

    jtb_Veiculos.setModel(model);

}

private void checksActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_checksActionPerformed
         String url="jdbc:mysql://localhost:3306/pharmacy?zeroDateTimeBehavior=convertToNull";
         String user="root";
         String pass="root";       
         String l="select * from revenue";

        try (Connection con=DriverManager.getConnection(url,user,pass);
                 PreparedStatement stmt=con.prepareStatement(l))
         {                   
        ResultSet rs=stmt.executeQuery();             
        DefaultTableModel model = new DefaultTableModel(new String[]{"BILL NO", "Total"}, 0);

        while(rs.next())
        {
           String d = rs.getString("bill_no");
           String n = rs.getString("total");

           model.addRow(new Object[]{d, n});  
             //JTable ta=new JTable(data,column);  
              sales.setModel(model); 
            // ta.setBounds(30,40,200,300); 
            //JScrollPane sp=new JScrollPane(add_table);
            //setVisible(true);
         }
         }
     catch(Exception e)
         {
             System.err.println(e.getMessage());
         }


}

/**
 * Loads the Data Array into the tmodel
 *
 * @param table to be populated
 * @param header column header
 * @param rows nullRoww data
 * @return populated tmodel
 */
public static JTable populatetable(JTable table, String[] header, List<String[]> rows) {
    removeRowSelection(table);
    DefaultTableModel tablemodel = (DefaultTableModel) table.getModel();
    tablemodel.setRowCount(0);
    for (String col : header) {
        tablemodel.addColumn(col);
    }
    for (String[] row : rows) {
        tablemodel.addRow(row);
    }
    table.setModel(tablemodel);
    return table;
}

private void init()
{
    model = new DefaultTableModel()
    {
        private static final long serialVersionUID = 1L;

        @Override
        public Class<?> getColumnClass(int c)
        {
            Object value = getValueAt(0, c);
            Class<?> cs = null;
            if( value != null )
            {
                cs = value.getClass();
            }
            else
            {
                cs = super.getColumnClass(c);
            }
            return cs;
        }
    };
    model.setColumnIdentifiers(getColumnNames());
    table = new JTable(model);
    table.getSelectionModel().addListSelectionListener(this);
    table.setRowHeight(20);

    int count = model.getColumnCount();
    for( int i = 0; i < count; i++ )
    {
        TableColumn column = table.getColumnModel().getColumn(i);
        processTableColumn(column, i);
    }
    table.doLayout();

    this.setLayout(new BorderLayout());
    this.add(new JScrollPane(table), BorderLayout.CENTER);
    this.add(createBottom(), BorderLayout.SOUTH);
}

public RSSContentPanel(){
    setLayout(new BorderLayout());
    stories = new ArrayList<>();
    String[] columns = {"Title", "Author", "Description", "Date", "Feed"};
    model = new DefaultTableModel(null, columns);
    table = new JTable(model);
    table.addMouseListener(new Listener());
    pane = new JScrollPane(table);
    //article = new JPanel();
    add(pane, BorderLayout.NORTH);
    //add(article, BorderLayout.SOUTH);
}

public void UpdateRecord() {
    Object[][] arrTmp = {}; // �趨�����ֶ�
    Vector vec = new Vector(1, 1);
    model = new DefaultTableModel(arrTmp, arrField);
    jTable1 = new JTable(model);
    jScrollPane1.getViewport().add(jTable1, null);
    try {
        ResultSet rs = sta.getRs(sql);
        int i = 1;
        while (rs.next()) {
            vec = new Vector();
            vec.add(String.valueOf(rs.getString("scoreId")));
            vec.add(String.valueOf(rs.getString("stuNumber")));
            ResultSet rsTemp = sta.getRs("select stuName from tb_student where stuNumber='"
                    + String.valueOf(rs.getString("stuNumber")) + "'");
            while (rsTemp.next()) {
                vec.add(String.valueOf(rsTemp.getString("stuName")));
            }
            vec.add(String.valueOf(rs.getString("courceName")));
            vec.add(String.valueOf(rs.getString("score")));
            model.addRow(vec);
        }
        rs.close();
    } catch (Exception ce) {
        System.out.println(ce);
    }
    jScrollPane1.getHorizontalScrollBar();
    jTable1.setGridColor(Color.blue);
    jTable1.setDragEnabled(true);
    jTable1.setSelectionForeground(Color.red);
    jTable1.setSelectionBackground(Color.green);
    jTable1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
    jTable1.setRowSelectionAllowed(true);
    jTable1.setShowVerticalLines(true);
}

/**
 * Check out rules for matching
 */
public void loadRules() {
    Unirest.get(BURP_API_URL)
            .routeParam("path", "rules")
            .asJsonAsync(new VulnersRestCallback(callbacks) {

                @Override
                public void onSuccess(JSONObject data) {
                    JSONObject rules = data.getJSONObject("rules");
                    Iterator<String> ruleKeys = rules.keys();

                    DefaultTableModel ruleModel = tabComponent.getRulesTable().getDefaultModel();
                    ruleModel.setRowCount(0); //reset table
                    while (ruleKeys.hasNext()) {
                        String key = ruleKeys.next();
                        final JSONObject v = rules.getJSONObject(key);

                        ruleModel.addRow(new Object[]{key, v.getString("regex"), v.getString("alias"), v.getString("type")});

                        try {
                            Pattern pattern = Pattern.compile(v.getString("regex"));
                            System.out.println("[NEW] " + pattern);

                            burpExtender.getMatchRules().put(key, new HashMap<String, String>() {{
                                put("regex", v.getString("regex"));
                                put("alias", v.getString("alias"));
                                put("type", v.getString("type"));
                            }});
                            // Match group 1 - is important
                            burpExtender.addMatchRule(new MatchRule(pattern, 1, key, ScanIssueSeverity.LOW, ScanIssueConfidence.CERTAIN));
                        } catch (PatternSyntaxException pse) {
                            callbacks.printError("Unable to compile pattern: " + v.getString("regex") + " for: " + key);
                            burpExtender.printStackTrace(pse);
                        }
                    }

                }
            });
}

public void UpdateRecord() {
    Object[][] arrTmp = {};
    Vector vec = new Vector(1, 1);
    model = new DefaultTableModel(arrTmp, arrField);
    jTable1 = new JTable(model);
    jScrollPane1.getViewport().add(jTable1, null);
    try {
        ResultSet rs3 = conn.getRs(sql);
        while (rs3.next()) {
            vec = new Vector();
            vec.add(String.valueOf(rs3.getInt("classId")));
            vec.add(rs3.getString("departName").trim());
            vec.add(rs3.getString("specName"));
            vec.add(rs3.getString("className"));
            model.addRow(vec);
        }
        rs3.close();
    } catch (Exception e) {
        System.out.println(e.getMessage());
    }
    jScrollPane1.getHorizontalScrollBar();
    jTable1.setGridColor(Color.blue);
    jTable1.setDragEnabled(true);
    jTable1.setSelectionForeground(Color.red);
    jTable1.setSelectionBackground(Color.green);
    jTable1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
    jTable1.setRowSelectionAllowed(true);
    jTable1.setShowVerticalLines(true);

}

private static TableModel createModel(final Map<String,String> callbacks) {
    final Object[][] data = new Object[callbacks.size()][];
    final Iterator<Map.Entry<String,String>> it = callbacks.entrySet().iterator();
    for (int i=0; it.hasNext(); i++) {
        final Map.Entry<String,String> entry = it.next();
        data[i] = new Object[] {entry.getKey(),entry.getValue()};
    }
    return new DefaultTableModel(
        data,
        new String[] {
            NbBundle.getMessage(JFXDownloadModePanel.class, "JFXJavaScriptCallbacksPanel.tableCallbacks.columnModel.title0"), //NOI18N
            NbBundle.getMessage(JFXDownloadModePanel.class, "JFXJavaScriptCallbacksPanel.tableCallbacks.columnModel.title1") //NOI18N
        }) {
        @Override
        public boolean isCellEditable(int row, int column) {
            return column != 0;
        }

        @Override
        public Class<?> getColumnClass(int columnIndex) {
            switch (columnIndex) {
                case 0:
                    return String.class;
                case 1:
                    return String.class;
                default:
                    throw new IllegalStateException();
            }
        }

    };
}

public Soru3() {
        try {
            initComponents();

            dtm = new DefaultTableModel();
            dtm.setColumnIdentifiers(new Object[]{"ID", "MUSTERİ ID", "MUSTERİ ADI", "MALZEME ID", "MALZEME ADI", "SATIS", "ADET", "TUTAR"});
            tbl_liste.setModel(dtm);
// bağlantı için
            Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/DEPO", "sa", "as");
            // iletişimi acıyor
            Statement stmt = con.createStatement();
            // veritabanında sorgu çalıştırıp bize geri tablo döndürüyor.
            ResultSet rs = stmt.executeQuery("SELECT * FROM MALZEME");
            while (rs.next()) {

                String malzemeadi = rs.getString("ADI");
                malzemeid.add(rs.getInt("ID"));
                cmb_malzeme.addItem(malzemeadi);
            }

            rs = stmt.executeQuery("SELECT * FROM MUSTERI");
            while (rs.next()) {

                String adi = rs.getString("ADI");
                musteriid.add(rs.getInt("ID"));
                cmb_musteri.addItem(adi);
            }

        } catch (SQLException ex) {
            Logger.getLogger(Soru3.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

private void filtersUncheckAllButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_filtersUncheckAllButtonActionPerformed
    DefaultTableModel model = (DefaultTableModel) filterClassesTable.getModel();
    for (int i = 0; i < model.getRowCount(); i++) {
        model.setValueAt(Boolean.FALSE, i, 0);
    }
    filterClassesTable.repaint();
}

public static void loadFileinTable(File file, JTable table) {
    if (file.exists()) {
        try (Reader in = new FileReader(file)) {
            CSVParser parser = CSVFormat.EXCEL.withHeader().withSkipHeaderRecord().withIgnoreEmptyLines().parse(in);
            if (!parser.getHeaderMap().isEmpty()) {
                DefaultTableModel model = (DefaultTableModel) table.getModel();
                for (String columnHeader : parser.getHeaderMap().keySet()) {
                    if (!columnHeader.trim().isEmpty()) {
                        model.addColumn(columnHeader);
                    }
                }
                List<CSVRecord> records = parser.getRecords();
                for (CSVRecord record : records) {
                    Object[] row = new Object[record.size()];
                    for (int i = 0; i < record.size(); i++) {
                        row[i] = record.get(i);
                    }
                    model.addRow(row);
                }
            }
        } catch (IOException ex) {
            LOGGER.log(Level.SEVERE, null, ex);
        }
    } else {
        LOGGER.log(Level.SEVERE, "File [{0}] doesn''t exist", file.getAbsolutePath());
    }
}

private void moveDownVarButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_moveDownVarButtonActionPerformed
    int index = childrenVariablesTable.getSelectedRow();
    if (index < 0) return ;
    DefaultTableModel model = (DefaultTableModel) childrenVariablesTable.getModel();
    if (index >= (model.getRowCount() - 1)) return ;
    Object[] row = new Object[] { model.getValueAt(index, 0), model.getValueAt(index, 1) };
    model.removeRow(index);
    model.insertRow(index + 1, row);
    childrenVariablesTable.getSelectionModel().setSelectionInterval(index + 1, index + 1);
}

private void deleteVariableButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_deleteVariableButtonActionPerformed
    DefaultTableModel model = (DefaultTableModel) buildargsTable.getModel();
    int selectedRowId = buildargsTable.getSelectedRow();
    if (selectedRowId != -1) {
        model.removeRow(selectedRowId);
    }
}

@Override
public void preencheTabela() {

    dtm = (DefaultTableModel) this.cadastroFuncionario.getjTable1().getModel();
    for (Funcionarios func : funcionarios) {
        dtm.insertRow(dtm.getRowCount(), new Object[]{
            func.getNome(),
            func.getCpf(),
            func.getTelefone(),
            (func.getNivel_acesso() == 1) ? "Vendedor" : "Gerente"
        });
    }

}

/**
 * Sets the chart setting model data to the form.
 */
public void setChartSettingModelData() {

    this.getTfChartTitle().setText(this.chartSettingModel.getChartTitle());
    this.getTfXAxisLabel().setText(this.chartSettingModel.getChartXAxisLabel());
    this.getTfYAxisLabel().setText(this.chartSettingModel.getChartYAxisLabel());
    this.getCbRendererType().setSelectedItem(this.chartSettingModel.getRenderType());

    DefaultTableModel tbModel = this.chartSettingModel.getTableModelSeriesSettings();
    if (tbModel!=this.getTblSeriesSettings().getModel()) {
        this.getTblSeriesSettings().setModel(tbModel);
        this.refreshRenderEditorTblSeriesSettings();    
    }
}

private void addAlternative() {
    String category = (String) table.getValueAt(row, 2);
    ShortcutAction action = ((ActionHolder) table.getValueAt(row, 0)).getAction();
    Object[] newRow = new Object[]{new ActionHolder(action, true), "", category, ""};
    ((DefaultTableModel) ((TableSorter) table.getModel()).getTableModel()).insertRow(row + 1, newRow);
    pm.setVisible(false);
    table.editCellAt(row + 1, 1);
}