This is just part of the code as am new here and don't know exactly what to do. Just need to add data logs to my panel in netbeans so I can see all new updates I made going to product table that have column "stock". Will need to include data if possible time toenter image description here. Need help.
Am a novice as well.
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// SAVE PRODUCT
String name = p_name.getText();
String qty = p_qty.getText();
try {
Statement s = db.mycon().createStatement();
//`pid`, `Product_Name`, `Bar_code`, `Price`, `Qty`, `Sid`
s.executeUpdate("INSERT INTO product (Product_Name,Qty) VALUES('"+name+"','"+qty+"')");
JOptionPane.showMessageDialog(null, "Data Saved");
} catch (SQLException e) {
System.out.println(e);
}
tb_load();
}
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
// search product:
String search = p_src.getText();
try {
Statement s = db.mycon().createStatement();
ResultSet rs = s.executeQuery("SELECT * FROM product WHERE pid = '"+search+"'");
if (rs.next()){
p_name.setText(rs.getString("Product_Name"));
p_qty.setText(rs.getString("Qty"));
}
} catch (SQLException e) {
System.out.println(e);
}
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String id = p_src.getText();
String name = p_name.getText();
String qty = p_qty.getText();
try {
Statement s = db.mycon().createStatement();
//pid Product_Name Bar_code Price Qty Sid
s.executeUpdate("UPDATE product SET Product_Name='"+name+"',Qty='"+qty+"' WHERE pid ='"+id+"' ");
JOptionPane.showMessageDialog(null, "Data Updated");
} catch (SQLException e) {
}
tb_load();
}
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
// delete btw code:
String id =p_src.getText();
try {
Statement s = db.mycon().createStatement();
s.executeUpdate("DELETE FROM product WHERE pid = '"+id+"' ");
JOptionPane.showMessageDialog(null, "Delect Successfull");
} catch (HeadlessException | SQLException e) {
System.out.println(e);
}
tb_load();
}
private void jTable1KeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here
}
private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
int r = jTable1.getSelectedRow();
String id =jTable1.getValueAt(r, 0).toString();
String name =jTable1.getValueAt(r, 1).toString();
String qty =jTable1.getValueAt(r, 5).toString();
p_src.setText(id);
p_name.setText(name);
p_qty.setText(qty);
}
private void c_search_tbActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void c_search_tbKeyReleased(java.awt.event.KeyEvent evt) {
String name = c_search_tb.getText();
try {
DefaultTableModel dt = (DefaultTableModel) jTable1.getModel();
dt.setRowCount(0);
Statement s = db.mycon().createStatement();
ResultSet rs = s.executeQuery("SELECT * FROM product WHERE Product_Name LIKE '%"+name+"%' ");
while (rs.next()) {
Vector v = new Vector();
v.add(rs.getString(1));
v.add(rs.getString(2));
v.add(rs.getString(3));
dt.addRow(v);
}
} catch (SQLException e) {
tb_load();
}
}