Key Release Event Java and Mysql

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.