Here is a demonstration of the project that this post will discuss.

---

1. Features of the Project:

• Add Item: Allows adding a new item to the inventory
• Clear Form: Clears all fields or resets the form to its default state.
• Search Item: Enables searching for specific items within the inventory.
• Update Item: Allows updating the details or quantities of existing items.
• Delete Item: Removes an item from the inventory.
• Show Inventory: Displays the current list of items in the inventory.
• Sell Items: Facilitates the process of selling items from the inventory.

---

2. Watch this Complete One Shot Video Tutorial to build this project [This tutorial will provide excellent assistance]

---

3. Build Connection Code

public void buildConnection() {
		
	try {
		con = DriverManager.getConnection("jdbc:mysql://localhost:3306/SwingProjectDatabase", "root", "root@123");
		System.out.println("Done with the stable conncetion");
	} catch (SQLException e) {
		e.printStackTrace();
	}
		
}

---

4. Load Table Code

public void loadTable() {
		
	try {
		prestm = con.prepareStatement("select * from InventoryTable");
		
		rst = prestm.executeQuery();
		
		table.setModel(DbUtils.resultSetToTableModel(rst));
		
		
	} catch (SQLException e) {
		e.printStackTrace();
	}
		
}

---

5. Add Item in the Inventory Code

JButton btnAddItem = new JButton("Add Item");
btnAddItem.setFont(new Font("Lucida Grande", Font.PLAIN, 16));
btnAddItem.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent e) {
		
		String name,quantity, price;
		
		name = txtPname.getText();
		quantity = txtQuantity.getText();
		price = txtPrice.getText();
		
		
		try {
			prestm = con.prepareStatement("insert into InventoryTable(ProductName, Quantity, PricePerItem)values(?,?,?)");
			
			prestm.setString(1, name);
			prestm.setString(2, quantity);
			prestm.setString(3, price);
			
			
			prestm.executeUpdate();
			
			JOptionPane.showMessageDialog(null,"Item Added!!");
			
			loadTable();
			
			txtPname.setText("");
			txtQuantity.setText("");
			txtPrice.setText("");
			
			txtPname.requestFocus();
			
					
		
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		

		
	}
});
btnAddItem.setBounds(18, 202, 123, 40);
panel.add(btnAddItem);

---

6. Clear Data Code

JButton btnClear = new JButton("Clear");
btnClear.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent e) {
		
		txtPname.setText("");
		txtQuantity.setText("");
		txtPrice.setText("");
		
		txtPname.requestFocus();
		
	}
});
btnClear.setFont(new Font("Lucida Grande", Font.PLAIN, 16));
btnClear.setBounds(146, 202, 123, 40);
panel.add(btnClear);

---

7. Search Item in the inventory Code

JButton btnSearch = new JButton("Search");
btnSearch.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent e) {
		
		String searchId = txtSearchId.getText();
		
		try {
			prestm = con.prepareStatement("select * from InventoryTable where ID=?");
			
			prestm.setString(1, searchId);

			rst = prestm.executeQuery();
			
			if(rst.next()) {
				
				txtPname.setText(rst.getString(2));
				txtQuantity.setText(rst.getString(3));
				txtPrice.setText(rst.getString(4));
				
			}else {
				txtPname.setText("");
				txtQuantity.setText("");
				txtPrice.setText("");
				
				txtPname.requestFocus();
			}
			
			
			
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		
		
		
	}
});
btnSearch.setFont(new Font("Lucida Grande", Font.PLAIN, 16));
btnSearch.setBounds(72, 71, 123, 40);
panel_1.add(btnSearch);

---

8. Update Inventory Item Code

JButton btnUpdate = new JButton("Update");
btnUpdate.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent e) {
		
		String name,quantity, price, id;
		
		name = txtPname.getText();
		quantity = txtQuantity.getText();
		price = txtPrice.getText();
		
		id = txtSearchId.getText();
		
		
		
		try {
			prestm = con.prepareStatement("update InventoryTable set ProductName=?, Quantity=?, PricePerItem=? where ID=?");
			
			prestm.setString(1, name);
			prestm.setString(2, quantity);
			prestm.setString(3, price);
			prestm.setString(4, id);
			
			
			prestm.executeUpdate();
			
			JOptionPane.showMessageDialog(null,"Item Updated!!");
			
			loadTable();
			
			txtPname.setText("");
			txtQuantity.setText("");
			txtPrice.setText("");
			
			txtPname.requestFocus();
			
					
		
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		
		
	}
});
btnUpdate.setBounds(19, 23, 96, 40);
btnUpdate.setFont(new Font("Lucida Grande", Font.PLAIN, 16));
panel_2.add(btnUpdate);

---

9. Delete Inventory Item Code

JButton btnDelete = new JButton("Delete");
btnDelete.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent e) {
		
		String id = txtSearchId.getText();
		
		try {
			prestm = con.prepareStatement("delete from InventoryTable where ID=?");
			prestm.setString(1, id);
			
			prestm.executeUpdate();
			
			JOptionPane.showMessageDialog(null,"Item Deleted!!");
			
			loadTable();
			
			txtPname.setText("");
			txtQuantity.setText("");
			txtPrice.setText("");
			
			txtPname.requestFocus();
			
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		
		
	}
});
btnDelete.setFont(new Font("Lucida Grande", Font.PLAIN, 16));
btnDelete.setBounds(144, 24, 105, 39);
panel_2.add(btnDelete);

---

10. Exit the Application Code

JButton btnExit = new JButton("Exit");
btnExit.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent e) {
		
		System.exit(0);
		
	}
});

---

11. Sell Item from the Inventory Code

JButton btnSellItem = new JButton("Sell Item");
btnSellItem.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent e) {
		
		String name,quantity, price, id;
		
		name = txtPname.getText();
		quantity = txtQuantity.getText();
		price = txtPrice.getText();
		
		id = txtSellId.getText();
		String sellQuantity = txtSellQuantity.getText();
		
		Integer diffQuantity = Integer.parseInt(quantity) - Integer.parseInt(sellQuantity);
		
		
		
		try {
			prestm = con.prepareStatement("update InventoryTable set Quantity=? where ID=?");
			
			prestm.setString(1, diffQuantity.toString());
			prestm.setString(2, id);
			
			prestm.executeUpdate();
			
			JOptionPane.showMessageDialog(null,"Items Sold!!");
			
			loadTable();
			
			txtPname.setText("");
			txtQuantity.setText("");
			txtPrice.setText("");
			
			txtPname.requestFocus();
			
					
		
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		
		
		
		
	}
});
btnSellItem.setFont(new Font("Lucida Grande", Font.PLAIN, 16));
btnSellItem.setBounds(132, 142, 123, 40);
panel_4.add(btnSellItem);

---

12. Quantity Available in the Inventory Code

txtSellQuantity = new JTextField();
txtSellQuantity.addKeyListener(new KeyAdapter() {
	@Override
	public void keyReleased(KeyEvent e) {
		
		
		String sellId = txtSellId.getText();
		String sellQuantity = txtSellQuantity.getText();
		
		try {
			prestm = con.prepareStatement("select * from InventoryTable where ID=?");
			
			prestm.setString(1, sellId);

			rst = prestm.executeQuery();
			
			
			
			if(rst.next()) {
				
				if(Integer.parseInt(sellQuantity)<=Integer.parseInt(rst.getString(3))) {
					txtPname.setText(rst.getString(2));
					txtQuantity.setText(rst.getString(3));
					txtPrice.setText(rst.getString(4));
				}else {
					txtPname.setText("");
					txtQuantity.setText("");
					txtPrice.setText("");
					
					txtPname.requestFocus();
				}
				
			}else {
				txtPname.setText("");
				txtQuantity.setText("");
				txtPrice.setText("");
				
				txtPname.requestFocus();
			}
			
			
			
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		
	}
});
txtSellQuantity.setColumns(10);
txtSellQuantity.setBorder(new LineBorder(new Color(0, 0, 0)));
txtSellQuantity.setBounds(199, 87, 102, 26);
panel_4.add(txtSellQuantity);

---