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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | 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
