Category form
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import net.miginfocom.swing.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.Vector;
/*
* Created by JFormDesigner on Sat Jul 31 22:34:33 PDT 2021
*/
/**
* @author CJ Clem
*/
public class Category extends JFrame {
Connection1 con = new Connection1();
Connection conobj = con.connect();
public static void main(String[] args) throws SQLException, ClassNotFoundException {
Category form1 = new Category();
form1.updateTable();
form1.setVisible(true);
public void updateTable() throws SQLException {
String quer1 = "Select * from category";
PreparedStatement query = conobj.prepareStatement(quer1);
ResultSet rs = query.executeQuery();
ResultSetMetaData Res = rs.getMetaData();
int c = Res.getColumnCount();
DefaultTableModel df = (DefaultTableModel) jtdata.getModel();
df.setRowCount(0);
rs.last();
int z = rs.getRow();
rs.beforeFirst();
String[][] array = new String[0][];
if(z>0) {
array= new String[z][2];
}
int j=0;
while(rs.next()) {
array[j][0] = rs.getString("catcode");
array[j][1] = rs.getString("catdesc");
++j;
String[] cols = {"Category Code", "Category Description"};
DefaultTableModel model = new DefaultTableModel(array,cols);
jtdata.setModel(model);
jtdata.setDefaultEditor(Object.class, null);
public Category() throws SQLException, ClassNotFoundException {
initComponents();
private void btnaddActionPerformed(ActionEvent e) throws SQLException {
String catcode, catdesc;
catcode = txtcatcode.getText();
catdesc = txtcatdesk.getText();
String quer1 = "Select * from category where catcode=?";
PreparedStatement query = conobj.prepareStatement(quer1);
query.setString(1, catcode);
ResultSet rs = query.executeQuery();
if(rs.isBeforeFirst()) { //res.isBeforeFirst() is true if the cursor
JOptionPane.showMessageDialog(null, "The catcode you are trying to enter already exists ");
txtcatcode.setText("");
txtcatdesk.setText("");
txtcatcode.requestFocus();
return;
String quer2 = "INSERT INTO Category VALUES ( ?, ? )";
query = conobj.prepareStatement(quer2);
query.setString(1, catcode);
query.setString(2, catdesc);
query.executeUpdate();
JOptionPane.showMessageDialog(null, "One record added ");
updateTable();
private void jtdataMouseClicked(MouseEvent e) {
DefaultTableModel df = (DefaultTableModel) jtdata.getModel();
int index1 = jtdata.getSelectedRow();
txtcatcode.setText(df.getValueAt(index1,0).toString());
txtcatdesk.setText(df.getValueAt(index1,1).toString());
private void btneditActionPerformed(ActionEvent e) throws SQLException {
//get old value
DefaultTableModel df = (DefaultTableModel) jtdata.getModel();
int index1 = jtdata.getSelectedRow();
String catcode, catdesc;
catcode = txtcatcode.getText();
catdesc = txtcatdesk.getText();
String oldvalue=df.getValueAt(index1,0).toString();
PreparedStatement query;
query = conobj.prepareStatement("Update category set catcode=?, catdesc=? where catcode = ?");
query.setString(1, catcode);
query.setString(2, catdesc);
query.setString(3, oldvalue);
query.executeUpdate();
JOptionPane.showMessageDialog(null, "One record edited ");
updateTable();
private void btndeleteActionPerformed(ActionEvent e) throws SQLException {
String catcode, catdesc;
catcode = txtcatcode.getText();
catdesc = txtcatdesk.getText();
int result = JOptionPane.showConfirmDialog(null,"Are you sure you want to delete?", "Delete",
JOptionPane.YES_NO_OPTION,
JOptionPane.QUESTION_MESSAGE);
if(result == JOptionPane.NO_OPTION){
return;
PreparedStatement query;
query = conobj.prepareStatement("Delete from category where catcode = ?");
query.setString(1, catcode);
query.executeUpdate();
JOptionPane.showMessageDialog(null, "One record deleted ");
updateTable();
private void initComponents() {
// JFormDesigner - Component initialization - DO NOT MODIFY //GEN-BEGIN:initComponents
// Generated using JFormDesigner non-commercial license
label1 = new JLabel();
txtcatcode = new JTextField();
label2 = new JLabel();
txtcatdesk = new JTextField();
scrollPane1 = new JScrollPane();
jtdata = new JTable();
btnadd = new JButton();
btnedit = new JButton();
btndelete = new JButton();
//======== this ========
var contentPane = getContentPane();
contentPane.setLayout(new MigLayout(
"hidemode 3",
// columns
"[fill]" +
"[fill]",
// rows
"[]" +
"[]" +
"[]" +
"[]"));
//---- label1 ----
label1.setText("Enter the category code");
contentPane.add(label1, "cell 0 0");
//---- txtcatcode ----
txtcatcode.setColumns(17);
contentPane.add(txtcatcode, "cell 1 0");
//---- label2 ----
label2.setText("Enter the category description");
contentPane.add(label2, "cell 0 1");
contentPane.add(txtcatdesk, "cell 1 1");
//======== scrollPane1 ========
{
//---- jtdata ----
jtdata.addMouseListener(new MouseAdapter() {
@Override
public void mouseClicked(MouseEvent e) {
jtdataMouseClicked(e);
}
});
scrollPane1.setViewportView(jtdata);
}
contentPane.add(scrollPane1, "cell 1 2");
//---- btnadd ----
btnadd.setText("Add");
btnadd.addActionListener(e -> {
try {
btnaddActionPerformed(e);
} catch (SQLException ex) {
throw new RuntimeException(ex);
}
});
contentPane.add(btnadd, "cell 1 3");
//---- btnedit ----
btnedit.setText("Edit");
btnedit.addActionListener(e -> {
try {
btneditActionPerformed(e);
} catch (SQLException ex) {
throw new RuntimeException(ex);
}
});
contentPane.add(btnedit, "cell 1 3");
//---- btndelete ----
btndelete.setText("Delete");
btndelete.addActionListener(e -> {
try {
btndeleteActionPerformed(e);
} catch (SQLException ex) {
throw new RuntimeException(ex);
}
});
contentPane.add(btndelete, "cell 1 3");
pack();
setLocationRelativeTo(getOwner());
// JFormDesigner - End of component initialization //GEN-END:initComponents
}
// JFormDesigner - Variables declaration - DO NOT MODIFY //GEN-BEGIN:variables
// Generated using JFormDesigner non-commercial license
private JLabel label1;
private JTextField txtcatcode;
private JLabel label2;
private JTextField txtcatdesk;
private JScrollPane scrollPane1;
private JTable jtdata;
private JButton btnadd;
private JButton btnedit;
private JButton btndelete;
// JFormDesigner - End of variables declaration //GEN-END:variables
}
Connection 1
import java.sql.DriverManager;
import java.sql.SQLException;
public class Connection1 {
public java.sql.Connection connect() throws SQLException, ClassNotFoundException {
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con1 = DriverManager.getConnection("jdbc:mysql://localhost/inventory", "root", "");
return con1;
