Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- static void signUp(){
- System.out.println("nSign Up For a Classn");
- try {
- Scanner input = new Scanner(System.in);
- System.out.println("Enter Student ID: ");
- String user_entered_student_id = input.nextLine();
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ClassSelector", "", "");
- Statement myStmt = con.createStatement();
- ResultSet rs;
- rs = myStmt.executeQuery("SELECT student_name FROM ClassSelector.students WHERE student_id = user_entered_student_id");
- while(rs.next()){
- String userEnterId = rs.getString("student_name");
- System.out.println("Is " + userEnterId + " the correct student?");
- }
- }
- catch (Exception exc){
- exc.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement