private void Update_table() { try { Connection conn = getConnect(); String sql = "SELECT * FROM LoggedInPeople"; PreparedStatement pst = conn.prepareStatement(sql); ResultSet rs = pst.executeQuery(); PeopleLoggedIn.setModel(DbUtils.resultSetToTableModel(rs)); closeConnect(); } catch (Exception e) { System.out.println(e); } }
/** * This method is called from within the constructor to initialize the form. WARNING: Do NOT * modify this code. The content of this method is always regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents private void initComponents() { jPanel1 = new javax.swing.JPanel(); jButton1 = new javax.swing.JButton(); jScrollPane1 = new javax.swing.JScrollPane(); jList1 = new javax.swing.JList(); manualIn = new javax.swing.JButton(); manualOut = new javax.swing.JButton(); manualInput = new javax.swing.JTextField(); jScrollPane2 = new javax.swing.JScrollPane(); PeopleLoggedIn = new javax.swing.JTable(); jLabel1 = new javax.swing.JLabel(); editButton = new javax.swing.JButton(); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup( jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGap(0, 100, Short.MAX_VALUE)); jPanel1Layout.setVerticalGroup( jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGap(0, 100, Short.MAX_VALUE)); jButton1.setText("jButton1"); jList1.setModel( new javax.swing.AbstractListModel() { String[] strings = {"Item 1", "Item 2", "Item 3", "Item 4", "Item 5"}; public int getSize() { return strings.length; } public Object getElementAt(int i) { return strings[i]; } }); jScrollPane1.setViewportView(jList1); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); setTitle("Please Login:"******"Manually Check In"); manualIn.setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR)); manualIn.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { manualInActionPerformed(evt); } }); manualOut.setText("Manually Check Out"); manualOut.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { manualOutActionPerformed(evt); } }); manualInput.addFocusListener( new java.awt.event.FocusAdapter() { public void focusGained(java.awt.event.FocusEvent evt) { manualInputFocusGained(evt); } }); manualInput.addKeyListener( new java.awt.event.KeyAdapter() { public void keyTyped(java.awt.event.KeyEvent evt) { manualInputKeyTyped(evt); } }); PeopleLoggedIn.setModel( new javax.swing.table.DefaultTableModel( new Object[][] { {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null} }, new String[] {"Title 1", "Title 2", "Title 3", "Title 4"})); jScrollPane2.setViewportView(PeopleLoggedIn); jLabel1.setText("Input Id Below"); editButton.setText("Edit Your Information"); editButton.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { editButtonActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( javax.swing.GroupLayout.Alignment.TRAILING, layout .createSequentialGroup() .addGroup( layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout .createSequentialGroup() .addContainerGap() .addComponent( manualIn, javax.swing.GroupLayout.DEFAULT_SIZE, 219, Short.MAX_VALUE)) .addGroup( layout .createSequentialGroup() .addContainerGap() .addComponent( manualOut, javax.swing.GroupLayout.DEFAULT_SIZE, 219, Short.MAX_VALUE)) .addGroup( layout .createSequentialGroup() .addContainerGap() .addComponent( manualInput, javax.swing.GroupLayout.DEFAULT_SIZE, 219, Short.MAX_VALUE)) .addGroup( layout .createSequentialGroup() .addGap(46, 46, 46) .addComponent(jLabel1) .addGap(0, 0, Short.MAX_VALUE)) .addGroup( layout .createSequentialGroup() .addContainerGap() .addComponent( editButton, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent( jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 489, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap())); layout.setVerticalGroup( layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout .createSequentialGroup() .addContainerGap() .addGroup( layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent( jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 258, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup( layout .createSequentialGroup() .addGap(2, 2, 2) .addComponent(jLabel1) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent( manualInput, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(manualIn) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(manualOut) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(editButton))) .addContainerGap(13, Short.MAX_VALUE))); pack(); } // </editor-fold>//GEN-END:initComponents