This tutorial will teach you how to find the account holder balance using Key Release Event Java and Mysql.
Key Release Event Search
Select the txtaccountno textfield right click ->Key->Event->KeyReleased
past the code inside the KeyReleased 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 | private void txtaccnoKeyReleased(java.awt.event.KeyEvent evt) { Connection con; PreparedStatement pst; ResultSet rs; String accno = txtaccno.getText(); try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost/vbank","root",""); pst = con.prepareStatement("select accno,bal from account where accno = ?"); pst.setString(1, accno); rs = pst.executeQuery(); if(rs.next() == true) { String balance = rs.getString(2); txtbal.setText(balance); } else { txtbal.setText(""); } } catch (ClassNotFoundException ex) { } catch (SQLException ex) { } } |
I have attached the video tutorial below it will help you to do this step by step.
