基于MYSQL的银行存取钱系统

没花多长时间写的，仅应付期末作业…实现了增删改查功能


工具类

public class DBUtils {
    //MYSQL驱动包名
    private static final String DRIVER_NAME = "com.mysql.jdbc.Driver";
    //数据库连接地址
    private static final String URL = "jdbc:mysql://localhost:3306/student";
    //用户名
    private static final String USER_NAME = "root";//根据自己的用户名进行更改
    //密码
    private static final String PASSWORD = "lzm2019gkjy";//自己的密码

    public static void main(String[] args) {
        Connection con = null;
        try{
            //加载驱动类
            Class.forName(DRIVER_NAME);
            //获取数据库连接
            con = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
        }catch(SQLException e){
            e.printStackTrace();
        }catch(ClassNotFoundException e){
            e.printStackTrace();
        }
    }
    public static void release(PreparedStatement prst, Connection con, ResultSet rs) throws SQLException{
        rs.close();
        prst.close();
        con.close();

    }
}

用户服务（增删改查）

package Bank;
//实现学生对自己账户的登录，修改密码，取钱，存钱，余额查询的功能。

import DBUtils.DBUtils;

import java.sql.*;
import java.util.Scanner;

public class AdminService {

    private static Connection con;
    private static PreparedStatement prst;
    private static ResultSet rs;
    private static final String URL = "jdbc:mysql://localhost:3306/student";
    //用户名
    private static final String USER_NAME = "root";
    //密码
    private static final String PASSWORD = "lzm2019gkjy";
    private static AdminService as = new AdminService();
   // AdminService as = new AdminService();
    //登录
    public static void login() throws Exception {
        Scanner sca = new Scanner(System.in);

        boolean flag = false;
        try {
            con = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        System.out.println("  ----------------------");
        System.out.println(" |  欢迎来到学生存取钱业务！  |");
        System.out.println("  ----------------------");
        System.out.println("    ---请输入学生姓名---");
        String name = sca.next();

        System.out.println("     ---请输入密码---");
        String password = sca.next();

        String sql = "select * from student";
        PreparedStatement prst = con.prepareStatement(sql);
        //prst = (PreparedStatement) con.createStatement();
        //executeQuery()返回的是查询结果
        rs = prst.executeQuery(sql);
        while (rs.next()) {
            if ((name.equals(rs.getString("student_name")))
                    && password.equals(rs.getString("password"))) {
                System.out.println("登录成功！ ");
                flag = true;
                break;
            }
        }
        if (!flag) {
            System.out.println("用户名/密码错误");
            login();
        } else {
            menu();
        }
    }
    //服务菜单
    public static void menu() throws Exception {
            System.out.println("当前为服务页面，请输入服务编号！");
            System.out.println("1:存钱  2:取钱  3:查询账户余额  4:修改密码 5:退出服务");
            Scanner scanner = new Scanner(System.in);
            int num = scanner.nextInt();
            switch (num) {
                case 1:
                    depositMoney();
                    back();
                    break;
                case 2:
                    withDraw();
                    back();
                    break;

                case 3:
                    accountMoney();
                    back();
                    break;

                case 4:
                    modifyPassword();
                    back();
                    break;
                case 5:
                    exit();
                    break;
            }
        }
    //存钱
     public static void depositMoney() throws SQLException{
        con = DriverManager.getConnection(URL,USER_NAME,PASSWORD);
        //prst = (PreparedStatement) con.createStatement();
        Scanner sc = new Scanner(System.in);
        System.out.println("请输入卡号！");
        int m = sc.nextInt();
        System.out.println("请输入存款金额！");
        float money = sc.nextFloat();
        String sql1 = "update student set money = money+" + money + "where card_id = " + m;
        PreparedStatement prst = con.prepareStatement(sql1);
        int re  = prst.executeUpdate(sql1);
        if(re == 1){
            System.out.println("存款成功！");
        }else{
            System.out.println("存款失败！请重试！");
        }
    }
    //取钱
    public static void withDraw() throws SQLException {
            con = DriverManager.getConnection(URL,USER_NAME,PASSWORD);
            //PreparedStatement prst = con.prepareStatement();
            //prst = (PreparedStatement) con.createStatement();
            Scanner scan = new Scanner(System.in);
            System.out.println("请输入卡号！");
            int m = scan.nextInt();
            System.out.println("请输入取款金额！");
            float money = scan.nextFloat();
            String sql2 = "update student set money = money-" + money + "where card_id ="+m;
            PreparedStatement prst = con.prepareStatement(sql2);
            int re = prst.executeUpdate(sql2);
            String sql3 = "select money from student where card_id = "+m;
            PreparedStatement prst2 = con.prepareStatement(sql3);
            //prst.setInt(1,m);
            rs = prst2.executeQuery(sql3);
            if(re == 1){
                while(rs.next()){
                System.out.println("取款成功！账户剩余余额为："+rs.getFloat("money"));
                }
            }else{
                System.out.println("账户余额不足！取款失败！");
            }
        }

    //查询账户余额
    public static void accountMoney() throws SQLException {
        //获得数据库连接
        con = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
        //prst = (PreparedStatement) con.createStatement();

        Scanner scann = new Scanner(System.in);
        System.out.println("请输入卡号！");
        String card = scann.next();
        String sql3 = "select money from student where card_id="+card;
        PreparedStatement prst = con.prepareStatement(sql3);
        //String sql3 = "select money from student where password=" + password;
        rs = prst.executeQuery(sql3);
        while (rs.next()) {

            System.out.println("账户余额为: " + rs.getFloat("money") + "元");
        }
        DBUtils.release(prst,con,rs);
    }
    //修改密码
    public static void modifyPassword() throws Exception {

        con = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
        boolean flag1 = false;
        String sql4 = "select * from student";
        //prst = (PreparedStatement) con.createStatement();
        PreparedStatement prst = con.prepareStatement(sql4);
        Scanner scanner1 = new Scanner(System.in);
        System.out.println("请输入原始密码");
        String password1 = scanner1.next();
        System.out.println("请输入卡号");
        String card = scanner1.next();
        //String sql4 = "select password from student";
        rs = prst.executeQuery(sql4);
        while (rs.next()) {
            if ((password1.equals(rs.getString("password"))) && (card.equals(rs.getString("card_id")))) {
                System.out.println("请输入重置后的密码！");
                String passwordplus = scanner1.next();
                //String sql5 = "update student set password =  " + passwordplus + "where password =" + password;
                String sql5 = "update student set password='" + passwordplus
                        + "'where password='" + password1 + "'";
                PreparedStatement prst2 = con.prepareStatement(sql5);
                //prst2.setString(1,passwordplus);
                int ans = prst2.executeUpdate(sql5);
                if (ans == 1) {
                    System.out.println("密码修改成功！");
//                    flag1 = true;
                    menu();
                } else {
                    System.out.println("密码修改失败！");
                    System.out.println("即将返回菜单页面...");
                    menu();
                }
            }
}
        if(flag1 = false){
            System.out.println("您输入的密码与卡号可能有误，请重新输入！");
            modifyPassword();
        }
        //else {
//                System.out.println("原始密码错误，系统将自动跳转至服务菜单");
//                menu();
//            }
            DBUtils.release(prst, con, rs);
        }
    //退出
    public static void exit(){
        System.exit(0);
    }

//回跳
    public static void back() throws Exception {
        Scanner scanner3 = new Scanner(System.in);
        System.out.println("1: 返回登录页面 2:返回服务菜单 3:退出系统");
        int num = scanner3.nextInt();
        switch (num){
            case 1:
                login();
            case 2:
                menu();
            case 3:
                exit();
        }
    }
}

测试类

public class TestBank {
    public static void main(String[] args) throws Exception {
        AdminService.login();
    }
}

自己建个库连接就完事了

这里要说下注意statemenImpl与preparedstatementImpl存在类型转换异常
然后就没啥了… 修改密码那里的代码有点小瑕疵，懒得动了，不影响大局hh