ඉක්මණින්ම ST II Assignment ගොඩ දාගන්නත් එපැයිනේ - Part 7

මුලින්ම දීපු table එක වෙනස් කරලා දැන් අළුත් table එකක්නේ තියෙන්නේ.
reserve table එකට isApproved කියල Boolean attribute එකක් එකතු කරලා. ඉතින් අපි බලමු කොහොමද Approve reservation එක කරන්නේ කොහොමද කියලා.



True --> 1
False --> 0

Quick - Set Approve, make true or false
Download File Size - 4.57MB
After Extract File - 478MB
Duration - 08min 17s

http://www.mediafire.com/?u6p804d229efy12

පරණ database එකට හදන අය ඉන්නවනම්, ඒ අයට මේක,

http://www.mediafire.com/?u34x8a7zi68d7d2

////////////////////////////////////////////////////////////////////////////////////////////////
    final void showPending(){ //displays what are waiting for approve
        try {
            ResultSet rst = DB_Access.getData("select * from reserve where isApproved = 0");
            DefaultTableModel dtm = (DefaultTableModel) jTable1.getModel();
            int row = dtm.getRowCount();
            for(int i=0;i<row;i++){
                dtm.removeRow(0);
            }
            while(rst.next()){
                Object ob[] = {rst.getString(1),rst.getString(2),rst.getString(3),rst.getString(4)};
                dtm.addRow(ob);
            }
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(this, "No Approve Waiting reservations");
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Home_TO.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
         String vehicle = (String) jTable1.getValueAt(jTable1.getSelectedRow(), 0);
        String travel_guide = (String) jTable1.getValueAt(jTable1.getSelectedRow(), 1);
        String from_date = (String) jTable1.getValueAt(jTable1.getSelectedRow(), 2);
        String to_date = (String) jTable1.getValueAt(jTable1.getSelectedRow(), 3);
        try {
            DB_Access.setData("update reserve set approved_officer='"+jTextField1.getText()+"', approved_date_time='"+jTextField2.getText()+"', isApproved = true where vehicle='"+vehicle+"' and travel_guide='"+travel_guide+"' and from_date='"+from_date+"' and to_date='"+to_date+"'");
            JOptionPane.showMessageDialog(this, "Succeded");
            showPending();
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(this, "SQL Errror");
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Home_TO.class.getName()).log(Level.SEVERE, null, ex);
        }
           
    }