New Topic/Question
Reply
this is my full code: http://pastebin.com/112K8jzn
Edited by Dogstopper
Please post your code here, between code tags:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/**
*
* @author RC
*/
import java.awt.BorderLayout;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.JOptionPane;
import net.proteanit.sql.DbUtils;
import java.sql.*;
import net.sf.jasperreports.engine.design.*;
import net.sf.jasperreports.view.JasperViewer;
import net.sf.jasperreports.engine.*;
import javax.swing.*;
import javax.swing.table.DefaultTableCellRenderer;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
public class FormJFrame extends javax.swing.JFrame {
Connection conn = null;
ResultSet rs = null;
PreparedStatement pst = null;
private void FillCombo(){
String sql = "SELECT * FROM equipment";
try{
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
while (rs.next()){
String nme = rs.getString("Equipment_Name");
comboequip.addItem(nme);
}
}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
private void UpdateJTable(){
String sql = "SELECT Student_ID,Student_FN, Student_LN, Student_MI, Address, Course, Year, Contact_No, Equipment_Name, Quantity, Date_Borrowed FROM student";
try{
pst = conn.prepareStatement(sql);
rs = pst.executeQuery(sql);
jTable1.setModel(DbUtils.resultSetToTableModel(rs));
}
catch (Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
//PreparedStatement pst2 = null;
/**
* Creates new form FormJFrame
*/
public FormJFrame() {
initComponents();
}
/**
* 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">
private void initComponents() {
jTabbedPane1 = new javax.swing.JTabbedPane();
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
txtlast = new javax.swing.JTextField();
txtfirst = new javax.swing.JTextField();
txtinitial = new javax.swing.JTextField();
jLabel4 = new javax.swing.JLabel();
txtaddress = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
txtid = new javax.swing.JTextField();
jLabel6 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
itemcourse = new javax.swing.JComboBox();
itemyear = new javax.swing.JComboBox();
jLabel8 = new javax.swing.JLabel();
txtcontact = new javax.swing.JTextField();
jLabel9 = new javax.swing.JLabel();
comboequip = new javax.swing.JComboBox();
jLabel10 = new javax.swing.JLabel();
itemquantity = new javax.swing.JComboBox();
cmdadd = new javax.swing.JButton();
jLabel22 = new javax.swing.JLabel();
jDateChooser2 = new com.toedter.calendar.JDateChooser();
jPanel4 = new javax.swing.JPanel();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jLabel11 = new javax.swing.JLabel();
updateid = new javax.swing.JTextField();
jLabel12 = new javax.swing.JLabel();
updatelast = new javax.swing.JTextField();
jLabel13 = new javax.swing.JLabel();
updatefirst = new javax.swing.JTextField();
jLabel14 = new javax.swing.JLabel();
updateinitial = new javax.swing.JTextField();
jLabel15 = new javax.swing.JLabel();
updateaddress = new javax.swing.JTextField();
jLabel16 = new javax.swing.JLabel();
updatecourse = new javax.swing.JTextField();
jLabel17 = new javax.swing.JLabel();
updateyear = new javax.swing.JTextField();
jLabel18 = new javax.swing.JLabel();
updatecontact = new javax.swing.JTextField();
jLabel19 = new javax.swing.JLabel();
updateequip = new javax.swing.JTextField();
jLabel20 = new javax.swing.JLabel();
updatequantity = new javax.swing.JTextField();
cmdupdate = new javax.swing.JButton();
cmddelete = new javax.swing.JButton();
jLabel21 = new javax.swing.JLabel();
txtsearch = new javax.swing.JTextField();
cmdPrintAll = new javax.swing.JButton();
jLabel23 = new javax.swing.JLabel();
updateborrowed = new javax.swing.JTextField();
jPanel3 = new javax.swing.JPanel();
jScrollPane2 = new javax.swing.JScrollPane();
jTable2 = new javax.swing.JTable();
jLabel24 = new javax.swing.JLabel();
jLabel27 = new javax.swing.JLabel();
jLabel26 = new javax.swing.JLabel();
jMenuBar1 = new javax.swing.JMenuBar();
jMenu1 = new javax.swing.JMenu();
jMenuItem2 = new javax.swing.JMenuItem();
jMenu2 = new javax.swing.JMenu();
aboutclick = new javax.swing.JMenuItem();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowOpened(java.awt.event.WindowEvent evt) {
formWindowOpened(evt);
}
});
jTabbedPane1.setBackground(new java.awt.Color(102, 102, 102));
jLabel1.setText("Last Name:");
jLabel2.setText("First Name:");
jLabel3.setText("Middle Initial:");
txtlast.setBackground(new java.awt.Color(204, 255, 204));
txtfirst.setBackground(new java.awt.Color(204, 255, 204));
txtinitial.setBackground(new java.awt.Color(204, 255, 204));
jLabel4.setText("Address:");
txtaddress.setBackground(new java.awt.Color(204, 255, 204));
jLabel5.setText("Student ID:");
txtid.setBackground(new java.awt.Color(204, 255, 204));
jLabel6.setText("Course:");
jLabel7.setText("Year:");
itemcourse.setBackground(new java.awt.Color(204, 255, 204));
itemcourse.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "BSCS", "BSIT", "NMCA", "BSECE", "BSCoe", "BS Biology", "aCon" }));
itemcourse.setSelectedItem(null);
itemyear.setBackground(new java.awt.Color(204, 255, 204));
itemyear.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "I", "II", "III", "IV", "V" }));
itemyear.setSelectedItem(null);
jLabel8.setText("Contact No:");
txtcontact.setBackground(new java.awt.Color(204, 255, 204));
jLabel9.setText("Equipment to Borrow:");
comboequip.setBackground(new java.awt.Color(204, 255, 204));
jLabel10.setText("Quantity:");
itemquantity.setBackground(new java.awt.Color(204, 255, 204));
itemquantity.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "1", "2", "3", "4", "5", "6", "7", "8", "9", "10" }));
cmdadd.setIcon(new javax.swing.ImageIcon("C:\\Users\\RC\\Documents\\NetBeansProjects\\AdzuSGov\\pictures\\Folder-Add-icon.png")); // NOI18N
cmdadd.setText("Add");
cmdadd.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
cmdaddMouseClicked(evt);
}
});
jLabel22.setText("Date Borrowed:");
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(20, 20, 20)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel22)
.addGap(18, 18, 18)
.addComponent(jDateChooser2, javax.swing.GroupLayout.PREFERRED_SIZE, 189, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel5)
.addGap(18, 18, 18)
.addComponent(txtid, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel1)
.addComponent(jLabel4)
.addComponent(jLabel6)
.addComponent(jLabel8))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(txtaddress, javax.swing.GroupLayout.PREFERRED_SIZE, 165, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtcontact, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel10)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(txtlast, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(txtfirst, javax.swing.GroupLayout.PREFERRED_SIZE, 118, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(18, 18, 18)
.addComponent(jLabel3)
.addGap(18, 18, 18)
.addComponent(txtinitial, javax.swing.GroupLayout.PREFERRED_SIZE, 101, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(itemcourse, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(32, 32, 32)
.addComponent(jLabel7)
.addGap(18, 18, 18)
.addComponent(itemyear, javax.swing.GroupLayout.PREFERRED_SIZE, 63, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel9)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(comboequip, javax.swing.GroupLayout.PREFERRED_SIZE, 186, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(405, 405, 405)
.addComponent(itemquantity, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(303, 303, 303)
.addComponent(cmdadd)))
.addContainerGap(316, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(24, 24, 24)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5)
.addComponent(txtid, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(txtlast, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2)
.addComponent(txtfirst, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3)
.addComponent(txtinitial, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(txtaddress, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel6)
.addComponent(jLabel7)
.addComponent(itemcourse, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(itemyear, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel8)
.addComponent(txtcontact, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(30, 30, 30)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel9)
.addComponent(comboequip, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel10)
.addComponent(itemquantity, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(33, 33, 33)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel22)
.addGap(49, 49, 49)
.addComponent(cmdadd))
.addComponent(jDateChooser2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(70, Short.MAX_VALUE))
);
jTabbedPane1.addTab("Add Information", jPanel1);
jTable1.setBackground(new java.awt.Color(204, 255, 204));
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"Student ID", "Last Name", "First Name", "Middle Initial", "Address", "Course", "Year", "Contact No", "Borrowed Equip", "Quantity", "DateBorrowed"
}
) {
Class[] types = new Class [] {
java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Object.class, java.lang.Long.class
};
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
});
jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jTable1MouseClicked(evt);
}
});
jScrollPane1.setViewportView(jTable1);
jLabel11.setText("Student ID:");
updateid.setBackground(new java.awt.Color(204, 255, 204));
jLabel12.setText("Last Name:");
updatelast.setBackground(new java.awt.Color(204, 255, 204));
jLabel13.setText("First Name:");
updatefirst.setBackground(new java.awt.Color(204, 255, 204));
jLabel14.setText("Middle Initial:");
updateinitial.setBackground(new java.awt.Color(204, 255, 204));
jLabel15.setText("Address:");
updateaddress.setBackground(new java.awt.Color(204, 255, 204));
jLabel16.setText("Course:");
updatecourse.setBackground(new java.awt.Color(204, 255, 204));
jLabel17.setText("Year:");
updateyear.setBackground(new java.awt.Color(204, 255, 204));
jLabel18.setText("Contact No.");
updatecontact.setBackground(new java.awt.Color(204, 255, 204));
jLabel19.setText("Borrowed Equipment:");
updateequip.setBackground(new java.awt.Color(204, 255, 204));
jLabel20.setText("Quantity:");
updatequantity.setBackground(new java.awt.Color(204, 255, 204));
cmdupdate.setIcon(new javax.swing.ImageIcon("C:\\Users\\RC\\Documents\\NetBeansProjects\\AdzuSGov\\pictures\\Actions-document-edit-icon.png")); // NOI18N
cmdupdate.setText("Update");
cmdupdate.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
cmdupdateMouseClicked(evt);
}
});
cmddelete.setIcon(new javax.swing.ImageIcon("C:\\Users\\RC\\Documents\\NetBeansProjects\\AdzuSGov\\pictures\\delete-icon.png")); // NOI18N
cmddelete.setText("Delete");
cmddelete.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
cmddeleteMouseClicked(evt);
}
});
jLabel21.setText("Search Keyword:");
txtsearch.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyReleased(java.awt.event.KeyEvent evt) {
txtsearchKeyReleased(evt);
}
});
cmdPrintAll.setIcon(new javax.swing.ImageIcon("C:\\Users\\RC\\Documents\\NetBeansProjects\\AdzuSGov\\pictures\\Device-Printer-icon.png")); // NOI18N
cmdPrintAll.setText("Print All");
cmdPrintAll.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
cmdPrintAllMouseClicked(evt);
}
});
jLabel23.setText("Date Borrowed: ");
javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
jPanel4.setLayout(jPanel4Layout);
jPanel4Layout.setHorizontalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(21, 21, 21)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(jLabel18)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(updatecontact, javax.swing.GroupLayout.PREFERRED_SIZE, 145, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel4Layout.createSequentialGroup()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel12)
.addComponent(jLabel15)
.addComponent(jLabel16))
.addGap(18, 18, 18)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(updateaddress, javax.swing.GroupLayout.PREFERRED_SIZE, 190, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(updatecourse, javax.swing.GroupLayout.PREFERRED_SIZE, 117, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(30, 30, 30)
.addComponent(jLabel17)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(updateyear, javax.swing.GroupLayout.PREFERRED_SIZE, 69, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel4Layout.createSequentialGroup()
.addComponent(updatelast, javax.swing.GroupLayout.PREFERRED_SIZE, 128, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel13)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(updatefirst, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 22, Short.MAX_VALUE)
.addComponent(jLabel14)
.addGap(12, 12, 12))))
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(jLabel11)
.addGap(18, 18, 18)
.addComponent(updateid, javax.swing.GroupLayout.PREFERRED_SIZE, 126, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)))
.addComponent(updateinitial, javax.swing.GroupLayout.PREFERRED_SIZE, 73, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel4Layout.createSequentialGroup()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(jLabel19)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(updateequip, javax.swing.GroupLayout.PREFERRED_SIZE, 186, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(55, 55, 55)
.addComponent(jLabel20)
.addGap(10, 10, 10)
.addComponent(updatequantity, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(167, 167, 167)
.addComponent(cmdupdate)
.addGap(62, 62, 62)
.addComponent(cmddelete)))
.addGap(38, 38, 38)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(cmdPrintAll)
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(jLabel23)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(updateborrowed, javax.swing.GroupLayout.PREFERRED_SIZE, 149, javax.swing.GroupLayout.PREFERRED_SIZE))))))
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(209, 209, 209)
.addComponent(jLabel21)
.addGap(18, 18, 18)
.addComponent(txtsearch, javax.swing.GroupLayout.PREFERRED_SIZE, 191, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap())
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel4Layout.createSequentialGroup()
.addGap(0, 0, Short.MAX_VALUE)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 873, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(74, 74, 74))
);
jPanel4Layout.setVerticalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(24, 24, 24)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel11)
.addComponent(updateid, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel12)
.addComponent(updatelast, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel13)
.addComponent(updatefirst, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel14)
.addComponent(updateinitial, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel15)
.addComponent(updateaddress, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel16)
.addComponent(updatecourse, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel17)
.addComponent(updateyear, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel18)
.addComponent(updatecontact, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel19)
.addComponent(updateequip, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel20)
.addComponent(updatequantity, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel23)
.addComponent(updateborrowed, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(27, 27, 27)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(cmdupdate)
.addComponent(cmddelete)
.addComponent(cmdPrintAll))
.addGap(18, 18, 18)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtsearch, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel21))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jTabbedPane1.addTab("Update Information", jPanel4);
jTable2.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null, null, null},
{null, null, null, null, null, null, null, null, null, null}
},
new String [] {
"Student ID", "Last Name", "First Name", "Middle Initial", "Address", "Course", "Year", "Contact No.", "Borrowed Equip.", "Quantity"
}
));
jScrollPane2.setViewportView(jTable2);
javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addGap(38, 38, 38)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 877, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addGap(52, 52, 52)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 266, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(135, Short.MAX_VALUE))
);
jTabbedPane1.addTab("Overdue", jPanel3);
jLabel24.setIcon(new javax.swing.ImageIcon(getClass().getResource("/adzu.png"))); // NOI18N
jLabel27.setIcon(new javax.swing.ImageIcon(getClass().getResource("/seal(1).png"))); // NOI18N
jLabel26.setIcon(new javax.swing.ImageIcon(getClass().getResource("/glossy_stripe.png"))); // NOI18N
jLabel26.setVerticalAlignment(javax.swing.SwingConstants.TOP);
jMenu1.setText("File");
jMenuItem2.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_X, java.awt.event.InputEvent.CTRL_MASK));
jMenuItem2.setText("Exit");
jMenuItem2.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jMenuItem2MouseClicked(evt);
}
});
jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jMenuItem2ActionPerformed(evt);
}
});
jMenu1.add(jMenuItem2);
jMenuBar1.add(jMenu1);
jMenu2.setText("Help");
aboutclick.setText("About");
aboutclick.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
aboutclickMouseClicked(evt);
}
});
aboutclick.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
aboutclickActionPerformed(evt);
}
});
jMenu2.add(aboutclick);
jMenuBar1.add(jMenu2);
setJMenuBar(jMenuBar1);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap(73, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 928, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(116, 116, 116))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addComponent(jLabel26)
.addGap(26, 26, 26)
.addComponent(jLabel24, javax.swing.GroupLayout.PREFERRED_SIZE, 484, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel27)
.addGap(241, 241, 241))))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel27)
.addGroup(layout.createSequentialGroup()
.addGap(38, 38, 38)
.addComponent(jLabel24, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jLabel26))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 481, Short.MAX_VALUE)
.addGap(23, 23, 23))
);
pack();
}// </editor-fold>
private void formWindowOpened(java.awt.event.WindowEvent evt) {
// TODO add your handling code here:
conn = mysqlconnect.ConnectDB();
UpdateJTable();
FillCombo();
setTitle("Student Government Borrowing System");
setExtendedState(MAXIMIZED_BOTH);
//setUndecorated(true);
setLocationRelativeTo(null);
}
private void txtsearchKeyReleased(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
String sql = "SELECT * FROM student WHERE Student_ID = ? OR Student_LN LIKE ? OR Student_FN LIKE ? OR Student_MI LIKE ? OR Address LIKE ? OR Course LIKE ? OR Year LIKE ? OR Contact_No LIKE ? OR Equipment_Name LIKE ? OR Quantity LIKE ?";
try {
pst = conn.prepareStatement(sql);
pst.setString(1, txtsearch.getText() + "%");
pst.setString(2, txtsearch.getText() + "%");
pst.setString(3, txtsearch.getText() + "%");
pst.setString(4, txtsearch.getText() + "%");
pst.setString(5, txtsearch.getText() + "%");
pst.setString(6, txtsearch.getText() + "%");
pst.setString(7, txtsearch.getText() + "%");
pst.setString(8, txtsearch.getText() + "%");
pst.setString(9, txtsearch.getText() + "%");
pst.setString(10, txtsearch.getText() + "%");
rs = pst.executeQuery();
jTable1.setModel(DbUtils.resultSetToTableModel(rs));
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void cmddeleteMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
String sql = "DELETE FROM student WHERE Student_ID = ?";
try {
pst = conn.prepareStatement(sql);
pst.setString(1, updateid.getText());
pst.execute();
JOptionPane.showMessageDialog(null, "Deletion Succesful");
UpdateJTable();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void cmdupdateMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
String sql = "UPDATE student SET Student_LN = ?, Student_FN = ?, Student_MI = ?, Address = ?, Course = ?, Year = ?, Contact_No = ?, Equipment_Name = ?, Quantity = ?, Date_Borrowed = ? WHERE Student_ID = ?";
try {
pst = conn.prepareStatement(sql);
pst.setString(1, updatelast.getText());
pst.setString(2, updatefirst.getText());
pst.setString(3, updateinitial.getText());
pst.setString(4, updateaddress.getText());
pst.setString(5, updatecourse.getText());
pst.setString(6, updateyear.getText());
pst.setString(7, updatecontact.getText());
pst.setString(8, updateequip.getText());
pst.setString(9, updatequantity.getText());
pst.setString(10, updateid.getText());
pst.setString(11, updateborrowed.getText());
pst.executeUpdate();
JOptionPane.showMessageDialog(null, "Update Successful!");
UpdateJTable();
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
int row = jTable1.getSelectedRow();
updateid.setText(jTable1.getModel().getValueAt(row, 0).toString());
updatelast.setText(jTable1.getModel().getValueAt(row, 1).toString());
updatefirst.setText(jTable1.getModel().getValueAt(row, 2).toString());
updateinitial.setText(jTable1.getModel().getValueAt(row, 3).toString());
updateaddress.setText(jTable1.getModel().getValueAt(row, 4).toString());
updatecourse.setText(jTable1.getModel().getValueAt(row, 5).toString());
updateyear.setText(jTable1.getModel().getValueAt(row, 6).toString());
updatecontact.setText(jTable1.getModel().getValueAt(row, 7).toString());
updateequip.setText(jTable1.getModel().getValueAt(row, 8).toString());
updatequantity.setText(jTable1.getModel().getValueAt(row, 9).toString());
updateborrowed.setText(jTable1.getModel().getValueAt(row, 10).toString());
}
private void cmdaddMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
String sql = "INSERT INTO student (Student_ID, Student_LN, Student_FN, Student_MI, Address, Course, Year, Contact_No, Equipment_Name, Quantity, Date_Borrowed) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
try {
pst = conn.prepareStatement(sql);
pst.setString(1, txtid.getText());
pst.setString(2, txtlast.getText());
pst.setString(3, txtfirst.getText());
pst.setString(4, txtinitial.getText());
pst.setString(5, txtaddress.getText());
pst.setObject(6, itemcourse.getSelectedItem());
pst.setObject(7, itemyear.getSelectedItem());
pst.setString(8, txtcontact.getText());
pst.setObject(9, comboequip.getSelectedItem());
pst.setObject(10, itemquantity.getSelectedItem());
pst.setDate(11, new java.sql.Date(System.currentTimeMillis()));
if(txtid.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "Please specify Student ID");
}
else if (txtlast.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "Please specify Last Name");
}
else if (txtfirst.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "Please specify First Name");
}
else if (txtinitial.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "Please specify Middle Inital");
}
else if (txtaddress.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "Please specify Address");
}
else if (itemcourse.getSelectedItem().equals("")){
JOptionPane.showMessageDialog(null, "Please specify Course");
}
else if (itemyear.getSelectedItem().equals("")){
JOptionPane.showMessageDialog(null, "Please specify Year");
}
else if (txtcontact.getText().trim().equals("")){
JOptionPane.showMessageDialog(null, "Please specify Contact No.");
}
else if (comboequip.getSelectedItem().equals("")){
JOptionPane.showMessageDialog(null, "Please specify Equipment");
}
else if (itemquantity.getSelectedItem().equals("")){
JOptionPane.showMessageDialog(null, "Please specify Quantity");
}
else{
pst.execute();
UpdateJTable();
JOptionPane.showMessageDialog(null, "Information Saved!");
txtid.setText("");
txtlast.setText("");
txtfirst.setText("");
txtinitial.setText("");
txtaddress.setText("");
itemcourse.setSelectedItem("");
itemyear.setSelectedItem("");
txtcontact.setText("");
comboequip.setSelectedItem("");
itemquantity.setSelectedItem("");
}
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void aboutclickMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
aboutJFrame a = new aboutJFrame();
a.setVisible(true);
}
private void aboutclickActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
aboutJFrame s = new aboutJFrame();
s.setVisible(true);
}
private void cmdPrintAllMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
try{
JasperDesign jasperDesign = JRXmlLoader.load("AdzuSGReport.jrxml");
String sql = "select * from student";
JRDesignQuery newQuery = new JRDesignQuery();
newQuery.setText(sql);
jasperDesign.setQuery(newQuery);
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, conn);
JasperViewer.viewReport(jasperPrint);
} catch (Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
private void jMenuItem2MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
System.exit(0);
}
private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
System.exit(0);
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/*
* Set the Nimbus look and feel
*/
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/*
* If Nimbus (introduced in Java SE 6) is not available, stay with the
* default look and feel. For details see
* http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(FormJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(FormJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(FormJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(FormJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/*
* Create and display the form
*/
java.awt.EventQueue.invokeLater(new Runnable() {
@Override
public void run(){
new FormJFrame().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JMenuItem aboutclick;
private javax.swing.JButton cmdPrintAll;
private javax.swing.JButton cmdadd;
private javax.swing.JButton cmddelete;
private javax.swing.JButton cmdupdate;
private javax.swing.JComboBox comboequip;
private javax.swing.JComboBox itemcourse;
private javax.swing.JComboBox itemquantity;
private javax.swing.JComboBox itemyear;
private com.toedter.calendar.JDateChooser jDateChooser2;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel12;
private javax.swing.JLabel jLabel13;
private javax.swing.JLabel jLabel14;
private javax.swing.JLabel jLabel15;
private javax.swing.JLabel jLabel16;
private javax.swing.JLabel jLabel17;
private javax.swing.JLabel jLabel18;
private javax.swing.JLabel jLabel19;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel20;
private javax.swing.JLabel jLabel21;
private javax.swing.JLabel jLabel22;
private javax.swing.JLabel jLabel23;
private javax.swing.JLabel jLabel24;
private javax.swing.JLabel jLabel26;
private javax.swing.JLabel jLabel27;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JMenu jMenu1;
private javax.swing.JMenu jMenu2;
private javax.swing.JMenuBar jMenuBar1;
private javax.swing.JMenuItem jMenuItem2;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel3;
private javax.swing.JPanel jPanel4;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JTabbedPane jTabbedPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTable jTable2;
private javax.swing.JTextField txtaddress;
private javax.swing.JTextField txtcontact;
private javax.swing.JTextField txtfirst;
private javax.swing.JTextField txtid;
private javax.swing.JTextField txtinitial;
private javax.swing.JTextField txtlast;
private javax.swing.JTextField txtsearch;
private javax.swing.JTextField updateaddress;
private javax.swing.JTextField updateborrowed;
private javax.swing.JTextField updatecontact;
private javax.swing.JTextField updatecourse;
private javax.swing.JTextField updateequip;
private javax.swing.JTextField updatefirst;
private javax.swing.JTextField updateid;
private javax.swing.JTextField updateinitial;
private javax.swing.JTextField updatelast;
private javax.swing.JTextField updatequantity;
private javax.swing.JTextField updateyear;
// End of variables declaration
}
MultiQuote
| 