Java JDBC Search using Postgresql Database

This tutorial will teach you Jdbc Search step by step.

Establish the database connection


  Connection con;
    PreparedStatement pst;
    ResultSet rs;

    public void Connect()
    {  
        try {
            Class.forName("org.postgresql.Driver");
             con = DriverManager.getConnection("jdbc:postgresql://localhost:5434/LBBank", "postgres", "123" );
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(Account.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(Account.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

The System Shall be able to search the record by entering the relavent student id.paste the code inside the

search button.


String accno = txtAcc.getText();
        
        try {
            pst = con.prepareStatement("select * from account where accountno=?");
            pst.setString(1, accno);
                    rs = pst.executeQuery();
                    
                    if(rs.next()==false)
                    {
                        JOptionPane.showMessageDialog(this,"Account not Found");
                    }
                    else
                    {
                        int balance = Integer.parseInt(rs.getString("balance"));
                      
                        
                        
                        txtBal.setText(String.valueOf(balance));
                     
                        
                    }
        } catch (SQLException ex) {
            Logger.getLogger(Account.class.getName()).log(Level.SEVERE, null, ex);
        }