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);
}i have attached the video link below. which will do this tutorials step by step.
