Tutusfunny

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.