This tutorial will teach you Jdbc Search step by step.
Establish the database connection
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | 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.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | 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); } |
i have attached the video link below. which will do this tutorials step by step.
