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) {

        }

    }