Tutusfunny

This tutorial will teach you how to make a Inventory Management System in Java and Mysql special discount calculation . This system will helpful you to learn Inventory Management System.

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

Paste the Code inside the Find Button

try {
            int id = Integer.parseInt(txtPID.getText());
            pst = con.prepareStatement("select sell_price,discount, sum(cast(round((sell_price*qty)-(sell_price*qty)/100*discount,2) as decimal(19,2))) as gross from product where id= ?");
           
            pst.setInt(1, id);
            Statement st=con.createStatement();
            ResultSet set=pst.executeQuery();

            if(set.next())
            {
                txtPrice.setText(set.getString(1));
                txtDis.setText(set.getString(2));
                txtTot.setText(set.getString(3));
            }
        } catch (SQLException ex) {
             ex.printStackTrace();
        }

 

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