银行储蓄管理系统【控制台+MySQL】（Java课设）

import java.io.FileWriter; import java.io.IOException; import java.sql.*; import java.text.SimpleDateFormat; import java.util.Date; import java.util.Scanner; public class AdminManage { //创建Scanner对象来进行键盘输入 public static Scanner scanner = new Scanner(System.in); public static void selectAllDeposit() throws SQLException { //注册驱动 使用驱动连接数据库 Connection con = null; Statement stmt = null; ResultSet rs = null; try { //数据库的连接 con = JDBCUtils.getConnection(); //调用Connection对象的createStatement方法得到一个Statement对象 stmt = con.createStatement(); //返回一个结果集 rs =stmt.executeQuery("select * from depositrecord"); System.out.println("---------------------查询所有存款记录结果如下所示---------------------"); while(rs.next()){ System.out.println(); System.out.println("存款编号："+rs.getString("id")+"\t用户名："+rs.getString("username")+"\t\t存款额度："+rs.getString("num")+"\t账户余额："+rs.getString("total")+"\t存款时间："+rs.getString("time")); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } UserManage.adminMenu(); } public static void selectAllWithdrawal() throws SQLException { //注册驱动 使用驱动连接数据库 Connection con = null; Statement stmt = null; ResultSet rs = null; try { //数据库的连接 con = JDBCUtils.getConnection(); //调用Connection对象的createStatement方法得到一个Statement对象 stmt = con.createStatement(); //返回一个结果集 rs =stmt.executeQuery("select * from withdrawal"); System.out.println("---------------------查询所有取款记录结果如下所示---------------------"); while(rs.next()){ System.out.println(); System.out.println("取款编号："+rs.getString("id")+"\t用户名："+rs.getString("username")+"\t\t取款额度："+rs.getString("num")+"\t\t账户余额："+rs.getString("total")+"\t取款时间："+rs.getString("time")); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } UserManage.adminMenu(); } public static void selectByAccount() throws SQLException { System.out.println("----------账户查询----------"); System.out.println("请输入需要查询的账号"); String num = scanner.next(); //注册驱动 使用驱动连接数据库 String sql = "select * from account where account = ?"; PreparedStatement pst = null; ResultSet rs = null; Connection conn = JDBCUtils.getConnection(); try { pst = conn.prepareStatement(sql); pst.setString(1, num); rs = pst.executeQuery(); while(rs.next()){ System.out.println(); System.out.println("账号："+rs.getString("account")+"\t密码："+rs.getString("password")+"\t\t用户名："+rs.getString("username")+"\t账户余额："+rs.getString("balance")+"\t创建时间："+rs.getString("time")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } UserManage.adminMenu(); } public static void deposit() throws SQLException { System.out.println("----------存款----------"); System.out.println("请输入存款账号"); String account = scanner.next(); System.out.println("请输入存款额度"); int num= scanner.nextInt(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { con = JDBCUtils.getConnection(); //注册驱动 使用驱动连接数据库 String sql1 = "select * from account where account = ?"; stmt = con.prepareStatement(sql1); stmt.setString(1, account); rs = stmt.executeQuery(); while(rs.next()){ int balance = rs.getInt("balance"); String sql2 = "update account set balance=? where account=?"; stmt = con.prepareStatement(sql2); stmt.setInt(1, balance+num); stmt.setString(2, account); stmt.execute(); //定义一个sql语句 String sql3 = "insert into depositrecord(username,num,total,time) values(?,?,?,?)"; // 执行sql语句 stmt = con.prepareStatement(sql3); //定义每个？号对用的参数 stmt.setString(1, rs.getString("username")); stmt.setInt(2, num); stmt.setInt(3, balance+num); stmt.setString(4, new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date())); //执行数据库操作 stmt.executeUpdate(); System.out.println("存款成功！！！"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } UserManage.adminMenu(); } public static void withdrawal() throws SQLException { System.out.println("----------取款----------"); System.out.println("请输入取款账号"); String account = scanner.next(); System.out.println("请输入取款额度"); int num= scanner.nextInt(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { con = JDBCUtils.getConnection(); //注册驱动 使用驱动连接数据库 String sql1 = "select * from account where account = ?"; stmt = con.prepareStatement(sql1); stmt.setString(1, account); rs = stmt.executeQuery(); while(rs.next()){ int balance = rs.getInt("balance"); if (balance>=num){ String sql2 = "update account set balance=? where account=?"; stmt = con.prepareStatement(sql2); stmt.setInt(1, balance-num); stmt.setString(2, account); stmt.execute(); //定义一个sql语句 String sql3 = "insert into withdrawal(username,num,total,time) values(?,?,?,?)"; // 执行sql语句 stmt = con.prepareStatement(sql3); //定义每个？号对用的参数 stmt.setString(1, rs.getString("username")); stmt.setInt(2, num); stmt.setInt(3, balance-num); stmt.setString(4, new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date())); //执行数据库操作 stmt.executeUpdate(); System.out.println("取款成功！！！"); }else { System.out.println("账户余额不足！！！"); } } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } UserManage.adminMenu(); } }