Java JDBC Search using Mysql Database

This tutorial will teach you Jdbc Search step by step.

Establish the database connection

Connection con;
    PreparedStatement pst;

    
    public void Connect()
    {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost/studcrud","root","");
            
        } catch (ClassNotFoundException ex) {
          
        } catch (SQLException ex) {
          
        }

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

search button.

try {      
            pst = con.prepareStatement("select id,stname,course from records where id=? ");
            int id = Integer.parseInt(txtid.getText());
            pst.setInt(1, id);
            ResultSet rs1 = pst.executeQuery();
            if(rs1.next()==false)
                {
                JOptionPane.showMessageDialog(this, "Sorry Record Not Found");
                                txtname.setText("");
                                txtcourse.setText("");
                                txtid.requestFocus();
                    }
                        else
                        {

            txtname.setText(rs1.getString("stname"));
                        txtcourse.setText(rs1.getString("course"));
        }
            
        } catch (SQLException ex) {
            Logger.getLogger(SearchJdbc.class.getName()).log(Level.SEVERE, null, ex);
        }