This tutorial will teach you how to make a Inventory Management System in Java mysql step by step. This system will help you to calculate the Sales Profit Margin Calculation using a best method. this examples are really helpful for face the interviews.
First Step Establish the database Connection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | Connection con; PreparedStatement pst; public void Connect() { try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/inventory","root",""); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } catch (SQLException ex) { ex.printStackTrace(); } } |
Call the Connect method inside the Constructor of the class
1 2 3 4 | public JavaIn() { initComponents(); Connect(); } |
Paste the Code inside the Find Button
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | try { int id = Integer.parseInt(txtPID.getText()); pst = con.prepareStatement("select productname,retail_price,sell_price,qty, cast(sum((sell_price-retail_price)*qty) as decimal(19,2)) from product where id= ?"); pst.setInt(1, id); Statement st=con.createStatement(); ResultSet set=pst.executeQuery(); if(set.next()) { txtName.setText(set.getString(1)); txtSPrice.setText(set.getString(2)); txtRPrice.setText(set.getString(3)); txtQty.setText(set.getString(4)); txtProft.setText(set.getString(5)); } } catch (Exception e) { e.printStackTrace(); } |