Sales Profit Margin Calculation Java Mysql

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

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

public JavaIn() {
       initComponents();
       Connect();
   }

Paste the Code inside the Find Button

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();
                
            }