银行管理系统(控制台版)，数据库用mysql

AdminServie.java

package service;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

import view.TestBank;
import BankUtil.DbUtil;
import domain.Admin;
import domain.Customer;

public class AdminService {
	private static DbUtil db;
	private static Admin ad;
	private static Customer cu;
	private static Connection conn;
	private static Statement stmt;
	private static PreparedStatement ps;
	private static ResultSet rs;
	private static AdminService as = new AdminService();

	public static void login() throws Exception {
		Scanner input = new Scanner(System.in);
		db = new DbUtil();
		boolean flag = false;
		conn = db.getConnection();
		System.out.println("请输入用户名：");
		String name = input.next();
		ad.setAdminName(name);
		System.err.println("请输入密码");
		String pwd = input.next();
		ad.setAdminPwd(pwd);
		String sql = "select * from admin";
		stmt = conn.createStatement();
		rs = stmt.executeQuery(sql);
		while (rs.next()) {
			if ((ad.getAdminName().equals(rs.getString(3)))
					&& ad.getAdminPwd().equals(rs.getString(2))) {
				System.out.println("登录成功！");
				flag = true;
				break;
			}
		}
		if (!flag) {
			System.out.println("用户名/密码错误");
		} else {
			// System.out.println("登录成功");
			as.menu();
		}

	}

	public static void menu() throws Exception {
		System.out.println("银行系统：[管理员]");
		System.out
				.println("1、添加顾客         2、计算储蓄总额         3、富豪排行榜            4、退出");
		System.out.println("请选择：");
		Scanner menuInput = new Scanner(System.in);
		int num = menuInput.nextInt();
		switch (num) {
		case 1:
			System.out.println("当前---->管理员---->添加顾客");
			addCust();
			break;
		case 2:
			System.out.println("当前---->管理员---->计算储蓄总额");
			countMoney();
			break;
		case 3:
			System.out.println("当前---->管理员---->富豪排行榜");
			order();
			break;
		case 4:
			System.out.println("当前---->管理员---->退出");
			exit();
			break;

		default:
			break;
		}
	}

	public static void addCust() throws Exception {
		System.out.println();
		Scanner addInput = new Scanner(System.in);
		System.out.print("请输入顾客银行卡号：");
		String custNum = addInput.next();
		cu.setCu