java
package com.company;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Scanner;

/**
 * Created by ttc on 18-1-23.
 */
public class personmanagement {
    public static void main(String[] args) throws SQLException {
        while (true){
            System.out.println("歡迎使用用戶管理系統(tǒng)");
            System.out.println("==================================");
            System.out.println("用戶登錄----------------1");
            System.out.println("用戶注冊(cè)----------------2");
            System.out.println("退出程序----------------3");
            Scanner scanner = new Scanner(System.in);
            String input = scanner.next();

            if (input.equals("1")) {
                System.out.println("用戶登錄頁面");
                System.out.println("=================================");
                System.out.println("請(qǐng)輸入您的用戶名");
                String username = scanner.next();
                System.out.println("請(qǐng)輸入您的密碼");
                int password = scanner.nextInt();

                Sort sort = null;
                sort = JDBCDemoFinal.loc(username,password);

                if (sort != null) {
                    System.out.println("登錄成功");
                    System.out.println("===============================");
                    System.out.println("歡迎登錄主頁");
                    if (sort.getRole() == 0){
                        System.out.println(username+"您好！"+"\t\t"+"您的權(quán)限是:普通用戶");
                        System.out.println("====================================");
                        System.out.println("修改自己的信息----------------------1");
                        System.out.println("查詢自己的信息----------------------2");
                        System.out.println("程序退出----------------------------3");
                        String input1 = scanner.next();
                        if (input1.equals("1")){
                            System.out.println("您現(xiàn)在的信息是：");
                            System.out.println(sort);

                            System.out.println("請(qǐng)輸入要修改的用戶名");
                            String name = scanner.next();
                            sort.setUsername(name);
                            System.out.println("請(qǐng)輸入要修改的密碼");
                            int key = scanner.nextInt();

                            sort.setUsername(name);
                            sort.setPassword(key);
                            JDBCDemoFinal.updateSort(sort);
                            System.out.println("修改成功");
                            System.out.println("修改后的信息是"+sort);


                        }
                        else if (input1.equals("2")){
                            JDBCDemoFinal.getSortByID(sort.getSid());
                            System.out.println(sort);
                        }
                        else {

                        }
                    }
                    else {
                        System.out.println(username+"您好锋恬！"+"\t\t"+"您的權(quán)限是：管理員用戶");
                        System.out.println("========================================");
                        System.out.println("添加用戶---------------------------1");
                        System.out.println("刪除用戶---------------------------2");
                        System.out.println("修改用戶---------------------------3");
                        System.out.println("查詢用戶---------------------------4");
                        System.out.println("程序退出---------------------------5");

                        String input1 = scanner.next();
                        if (input1.equals("1")){
                            System.out.println("請(qǐng)輸入名字");
                            String name = scanner.next();
                            System.out.println("請(qǐng)輸入用戶名");
                            String uname = scanner.next();
                            System.out.println("請(qǐng)輸入密碼");
                            int key = scanner.nextInt();
                            System.out.println("請(qǐng)輸入郵箱");
                            String mail = scanner.next();
//                        System.out.println("請(qǐng)輸入生日");

                            Sort sort1 = new Sort();
                            sort1.setSname(name);
                            sort1.setUsername(uname);
                            sort1.setPassword(key);
                            sort1.setMail(mail);

                            JDBCDemoFinal.AddSort(sort1);
                            System.out.println("添加用戶成功");
                            System.out.println(sort1);
                        }
                        else if (input1.equals("2")){
                            System.out.println("請(qǐng)輸入要?jiǎng)h除的用戶ID");
                            int id = scanner.nextInt();
                            JDBCDemoFinal.deleteSortByID(id);
                            System.out.println("刪除成功");
                        }
                        else if (input1.equals("3")){
                            System.out.println("請(qǐng)輸入要修改的ID");
                            int id = scanner.nextInt();
                            System.out.println("請(qǐng)輸入要修改的用戶名");
                            String username1 = scanner.next();
                            System.out.println("請(qǐng)輸入要修改的密碼");
                            int key = scanner.nextInt();

                            Sort sort1 = JDBCDemoFinal.getSortByID(id);
                            sort1.setUsername(username1);
                            sort1.setPassword(key);
                            JDBCDemoFinal.updateSort(sort1);
                            System.out.println("修改成功");
                            System.out.println(sort1);

                        }
                        else if (input1.equals("4")){
                            System.out.println("查詢?nèi)坑脩?--------------1");
                            System.out.println("查詢指定ID用戶---------------2");
                            System.out.println("查詢指定姓名用戶---------------3");
                            System.out.println("請(qǐng)輸入您的命令");
                            int key = scanner.nextInt();
                            if (key == 2){
                                System.out.println("請(qǐng)輸入ID");
                                int key1 = scanner.nextInt();
                                Sort sort1 = JDBCDemoFinal.getSortByID(key1);
                                System.out.println(sort1);
                            }
                            else if (key == 1){
                                System.out.println("全部信息表");
                                List<Sort> sortList = JDBCDemoFinal.getAllSorts();
                                for (Sort sort1:sortList){
                                    System.out.println(sort1);
                                }
                            }
                            else if (key == 3){
                                System.out.println("請(qǐng)輸入要查詢的姓名");
                                String name = scanner.next();
                                List<Sort> sortList = JDBCDemoFinal.getSortBysname(name);
                                for (Sort sort1:sortList){
                                    System.out.println(sort1);
                                }

                            }
                        }
                        else if (input1.equals("5")){
                            System.out.println("退出程序");
                            break;
                        }

                    }

                } else {
                    System.out.println("登錄失敗");
                }


            }
            else if (input.equals("2")){
                System.out.println("歡迎來到用戶注冊(cè)頁面");
                System.out.println("=============================");
                System.out.println("請(qǐng)輸入用戶名");
                String name = scanner.next();
                System.out.println("請(qǐng)輸入密碼");
                int password = scanner.nextInt();

                Sort sort1 = new Sort();
                sort1.setUsername(name);
                sort1.setPassword(password);
                JDBCDemoFinal.AddSort(sort1);
                System.out.println("注冊(cè)成功");
                System.out.println("================================");
            }
            else {
                System.out.println("退出程序");
                break;
            }
        }
        
    }

}