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

i have attached the video link below. which will do this tutorials step by step

Sales Profit Margin Calculation Java Mysql Project

Share

Watch on

Sales Profit Margin Calculation Java Mysql Project