try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException ex) {
            System.out.println(ex);
        }
        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3311/Books","root","root");
            Statement statement = con.createStatement();
            String sql ="select * from student where studid=+"+txtID.getText()+"'";
            ResultSet rs= statement.executeQuery(sql);
            if(re.first()){
                 txtFName.setText(rs.getString("Fname"));
                 txtLName.setText(rs.getString("Lname"));
                 txtCourse.setText(rs.getString("Course"));
                 txtYear.setText(rs.getString("yr"));
            }
            else
                JOptionPane.showMessageDialog(this, "Id number does not exist.");

            statement.execute(sql);
        } catch (SQLException ex) {
            System.out.println(ex);
        }