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
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.
