This tutorial will teach Online Payment System using Java Mysql step by step.
First enter cardno if the cardno is correct it will allow you to enter the amount
CardNo textfield keypress Event
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | public void keyPressed(KeyEvent arg0) { if(arg0.getKeyCode() == KeyEvent.VK_ENTER) { String accno = txtcardno.getText(); try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/card","root",""); pst = con.prepareStatement("select * from details where cardno = ?"); pst.setString(1, accno); ResultSet rs; rs = pst.executeQuery(); if(rs.next() == false) { JOptionPane.showMessageDialog(null,"Card No no found"); } else { txtamt.requestFocus(); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } } |
Paste the code inside the Paynow Button
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/card","root",""); String sqlupdate= "update details set amount= amount- ? where cardno=? "; pst=con.prepareStatement(sqlupdate); pst.setString(1,txtamt.getText()); pst.setString(2,txtcardno.getText()); pst.executeUpdate(); JOptionPane.showMessageDialog(null,"Paid...!!!!"); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } |
i have attached the video link below. which will do this tutorials step by step.
