Login

private static void Login() {
        try{
            System.out.println("Username :");
            String username = input.readLine().trim();
            System.out.println("Password");
            String password = input.readLine().trim();

            String login ="SELECT*FROM login WHERE username='%s' AND password='%s'";
            login = String.format(login, username, password);
            rs = stmt.executeQuery(login);

            if(rs.next()){
                if(rs.getString("role").equals("admin")){
                      showAdmin();
                }else if(rs.getString("role").equals("member")){
                    showMember();
                }
            }
        }catch (Exception e){
            e.printStackTrace();
        }
    }