银行管理系统java+mysql8，实现了转账，存钱，取钱，查询账户，开户，登录，自动生成密码账号等功能
文章目录
银行管理系统java+mysql8，实现了转账，存钱，取钱，查询账户，开户，登录，自动生成密码账号等功能dbcp.properties工具类随机生成卡号和密码Dao层entity实体exception自定义异常service层test测试view视图层资源连接自动生成密码和银行账号
在sql客户客户端中的atm数据库中创建了两个表
account表 用户信息表，用户的密码经过MD5Util加密
re_account记录操作
项目结构
dbcp.properties
#配置驱动类driverClassName=com.mysql.cj.jdbc.Driver#配置连接字符串url=jdbc:mysql://localhost:3308/atm?useSSL=false&characterEncoding=utf-8&serverTimezone=Asia/Shanghai#登录数据库的用户名username=root#登录数据库的密码password=root#最大活动连接数，设为0为没有限制maxActive=50#最大空闲连接数，设为0为没有限制maxIdle=20#最大等待毫秒数，设为-1为没有限制maxWait=60000#配置文件的键不能随便写成别的名称，因为在与源码中有对应的信息
工具类
ConnUtil连接数据库
public class ConnUtil {//每个线程使用自己的ThreadLocal对象private static ThreadLocal<Connection> threadLocal = new ThreadLocal<>();//数据源对象private static DataSource ds;//私有构造方法，外部不能newprivate ConnUtil() {}static {//加载数据源ds对象InputStream is = ConnUtil.class.getResourceAsStream("/dbcp.properties");Properties properties = new Properties();try {properties.load(is);ConnUtil.ds = BasicDataSourceFactory.createDataSource(properties);} catch (IOException e) {e.printStackTrace();} catch (Exception e) {e.printStackTrace();}}public static Connection getConn() throws SQLException {//从threadLocal中取出Connection conn = threadLocal.get();if (conn == null || conn.isClosed()) {//创建数据库连接conn = ds.getConnection();threadLocal.set(conn);//将连接放入当前线程}return conn;}public static void closeConn() {Connection conn = threadLocal.get();try {if (conn != null && !conn.isClosed()) {try {conn.close();//在使用DBCP时，释放连接对象} catch (SQLException throwables) {throwables.printStackTrace();}threadLocal.set(null);//清空当前线程中的连接}} catch (SQLException throwables) {throwables.printStackTrace();}}}
加密工具类MD5Util
package com.demo.util;/********************************************************************************** MD5数据加密类*/加密工具类MD5Util public class MD5Util {public static void main(String[] args) {String md5 = getMd5Str("zs");System.out.println(md5);}private static MD5Util md5Util = new MD5Util();public static String getMd5Str(String str){return md5Util.getMD5ofStr(str);}// RFC1321中定义的标准4*4矩阵的常量定义。static final int S11 = 9,S12 = 12,S13 = 17, S14 = 22;static final int S21 = 5,S22 = 9, S23 = 14, S24 = 20;static final int S31 = 4,S32 = 11,S33 = 16, S34 = 23;static final int S41 = 4 ,S42 = 10,S43 = 15, S44 = 21;// 按RFC1321标准定义不可变byte型数组PADDINGstatic final byte[] PADDING = {-128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0,0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 0, 0,0, 0, 0, 0, 0, 0, 0 };// MD5计算过程中的3组核心数据，采用数组形式存放private long[] state = new long[4]; // 计算状态(分别对应a b c d)private byte[] buffer = new byte[64]; // 分配64个字节私有缓冲区private long[] count = new long[2]; // 位个数// 最新一次计算结果的16进制ASCII字符串表示，代表了16个字符串形式的MD5值public String resultStr;// 最新一次计算结果的2进制数组表示，一共16个字节，代表了128bit形式的MD5值public byte[] digest = new byte[16];// MD5_Encoding类提供的主要的接口函数getMD5ofStr，用来进行数据加密变换。调用其可对任意字符串进行加密运算，并以字符串形式返回加密结果。public String getMD5ofStr(String in) {md5Init(); // 初始化md5Update(in.getBytes(), in.length());// 调用MD5的主计算过程md5Final(); // 输出结果到digest数组中for (int i = 0; i < 16; i++) {resultStr += byteToHEX(digest[i]); // 将digest数组中的每个byte型数据转为16进制形式的字符串}return resultStr;}// 标准的构造函数，调用md5Init函数进行初始化工作private MD5Util() {md5Init();return;}// md5初始化函数.初始化核心变量.private void md5Init() {state[0] = 0x67452301L; // 定义state为RFC1321中定义的标准幻数state[1] = 0xefcdab89L; // 定义state为RFC1321中定义的标准幻数state[2] = 0x98badcfeL; // 定义state为RFC1321中定义的标准幻数state[3] = 0x10325476L; // 定义state为RFC1321中定义的标准幻数count[0] = count[1] =0L; // 初始化为0resultStr = "";// 初始化resultStr字符串为空for(int i=0;i<16;i++) digest[i]=0;//初始化digest数组元素为0return;}//定义F G H I 为4个基数 ，即为4个基本的MD5函数,进行简单的位运算private long F(long x, long y, long z) {return (x & y) | ((~x) & z);}private long G(long x, long y, long z) {return (x & z) | (y & (~z));}private long H(long x, long y, long z) {return x ^ y ^ z;}private long I(long x, long y, long z) {return y ^ (x | (~z));}// FF,GG,HH和II调用F,G,H,I函数进行进一步变换private long FF(long a, long b, long c, long d, long x, long s, long ac) {a += F(b, c, d) + x + ac;a = ((int) a << s) | ((int) a >>> (32 - s)); //这里long型数据右移时使用无符号右移运算符>>>a += b;return a;}private long GG(long a, long b, long c, long d, long x, long s, long ac) {a += G(b, c, d) + x + ac;a = ((int) a << s) | ((int) a >>> (32 - s)); //这里long型数据右移时使用无符号右移运算符>>>a += b;return a;}private long HH(long a, long b, long c, long d, long x, long s, long ac) {a += H(b, c, d) + x + ac;a = ((int) a << s) | ((int) a >>> (32 - s));//这里long型数据右移时使用无符号右移运算符>>>a += b;return a;}private long II(long a, long b, long c, long d, long x, long s, long ac) {a += I(b, c, d) + x + ac;a = ((int) a << s) | ((int) a >>> (32 - s));//这里long型数据右移时使用无符号右移运算符>>>a += b;return a;}// MD5的主计算过程，input是需要变换的二进制字节串，inputlen是长度private void md5Update(byte[] input, int inputLen) {int i=0, index, partLen;byte[] block = new byte[64]; // 分配64个字节缓冲区//根据count计算index值。这里long型数据右移时使用无符号右移运算符>>>index = (int) (count[0] >>> 3) & 0x3F;if ((count[0] += (inputLen << 3)) < (inputLen << 3))count[1]++;count[1] += (inputLen >>> 29); //这里int型数据右移时使用无符号右移运算符>>>partLen = 64 - index; //计算partLen值if (inputLen >= partLen) {md5Memcpy(buffer, input, index, 0, partLen);md5Transform(buffer);for (i = partLen; i + 63 < inputLen; i += 64) {md5Memcpy(block, input, 0, i, 64);md5Transform(block);}index = 0;} elsei = 0;md5Memcpy(buffer, input, index, i, inputLen - i);}// 整理和填写输出结果，结果放到数组digest中。private void md5Final() {byte[] bits = new byte[8];int index, padLen;Encode(bits, count, 8);index = (int) (count[0] >>> 3) & 0x3f; //这里long型数据右移时使用无符号右移运算符>>>padLen = (index < 56) ? (56 - index) : (120 - index);md5Update(PADDING, padLen);md5Update(bits, 8);Encode(digest, state, 16);}// byte数组的块拷贝函数，将input数组中的起始位置为inpos，长度len的数据拷贝到output数组起始位置outpos处。private void md5Memcpy(byte[] output, byte[] input, int outpos, int inpos,int len) {int i;for (i = 0; i < len; i++)output[outpos + i] = input[inpos + i];}// MD5核心变换计算程序，由md5Update函数调用，block是分块的原始字节数组private void md5Transform(byte block[]) {long a = state[0], b = state[1], c = state[2], d = state[3];long[] x = new long[16];Decode(x, block, 64);// 进行4级级联运算// 第1级a = FF(a, b, c, d, x[0], S11, 0xd76aa478L); /* 1 */d = FF(d, a, b, c, x[1], S12, 0xe8c7b756L); /* 2 */c = FF(c, d, a, b, x[2], S13, 0x242070dbL); /* 3 */b = FF(b, c, d, a, x[3], S14, 0xc1bdceeeL); /* 4 */a = FF(a, b, c, d, x[4], S11, 0xf57c0fafL); /* 5 */d = FF(d, a, b, c, x[5], S12, 0x4787c62aL); /* 6 */c = FF(c, d, a, b, x[6], S13, 0xa8304613L); /* 7 */b = FF(b, c, d, a, x[7], S14, 0xfd469501L); /* 8 */a = FF(a, b, c, d, x[8], S11, 0x698098d8L); /* 9 */d = FF(d, a, b, c, x[9], S12, 0x8b44f7afL); /* 10 */c = FF(c, d, a, b, x[10], S13, 0xffff5bb1L); /* 11 */b = FF(b, c, d, a, x[11], S14, 0x895cd7beL); /* 12 */a = FF(a, b, c, d, x[12], S11, 0x6b901122L); /* 13 */d = FF(d, a, b, c, x[13], S12, 0xfd987193L); /* 14 */c = FF(c, d, a, b, x[14], S13, 0xa679438eL); /* 15 */b = FF(b, c, d, a, x[15], S14, 0x49b40821L); /* 16 */// 第2级a = GG(a, b, c, d, x[1], S21, 0xf61e2562L); /* 17 */d = GG(d, a, b, c, x[6], S22, 0xc040b340L); /* 18 */c = GG(c, d, a, b, x[11], S23, 0x265e5a51L); /* 19 */b = GG(b, c, d, a, x[0], S24, 0xe9b6c7aaL); /* 20 */a = GG(a, b, c, d, x[5], S21, 0xd62f105dL); /* 21 */d = GG(d, a, b, c, x[10], S22, 0x2441453L); /* 22 */c = GG(c, d, a, b, x[15], S23, 0xd8a1e681L); /* 23 */b = GG(b, c, d, a, x[4], S24, 0xe7d3fbc8L); /* 24 */a = GG(a, b, c, d, x[9], S21, 0x21e1cde6L); /* 25 */d = GG(d, a, b, c, x[14], S22, 0xc33707d6L); /* 26 */c = GG(c, d, a, b, x[3], S23, 0xf4d50d87L); /* 27 */b = GG(b, c, d, a, x[8], S24, 0x455a14edL); /* 28 */a = GG(a, b, c, d, x[13], S21, 0xa9e3e905L); /* 29 */d = GG(d, a, b, c, x[2], S22, 0xfcefa3f8L); /* 30 */c = GG(c, d, a, b, x[7], S23, 0x676f02d9L); /* 31 */b = GG(b, c, d, a, x[12], S24, 0x8d2a4c8aL); /* 32 */// 第3级a = HH(a, b, c, d, x[5], S31, 0xfffa3942L); /* 33 */d = HH(d, a, b, c, x[8], S32, 0x8771f681L); /* 34 */c = HH(c, d, a, b, x[11], S33, 0x6d9d6122L); /* 35 */b = HH(b, c, d, a, x[14], S34, 0xfde5380cL); /* 36 */a = HH(a, b, c, d, x[1], S31, 0xa4beea44L); /* 37 */d = HH(d, a, b, c, x[4], S32, 0x4bdecfa9L); /* 38 */c = HH(c, d, a, b, x[7], S33, 0xf6bb4b60L); /* 39 */b = HH(b, c, d, a, x[10], S34, 0xbebfbc70L); /* 40 */a = HH(a, b, c, d, x[13], S31, 0x289b7ec6L); /* 41 */d = HH(d, a, b, c, x[0], S32, 0xeaa127faL); /* 42 */c = HH(c, d, a, b, x[3], S33, 0xd4ef3085L); /* 43 */b = HH(b, c, d, a, x[6], S34, 0x4881d05L); /* 44 */a = HH(a, b, c, d, x[9], S31, 0xd9d4d039L); /* 45 */d = HH(d, a, b, c, x[12], S32, 0xe6db99e5L); /* 46 */c = HH(c, d, a, b, x[15], S33, 0x1fa27cf8L); /* 47 */b = HH(b, c, d, a, x[2], S34, 0xc4ac5665L); /* 48 */// 第4级a = II(a, b, c, d, x[0], S41, 0xf4292244L); /* 49 */d = II(d, a, b, c, x[7], S42, 0x432aff97L); /* 50 */c = II(c, d, a, b, x[14], S43, 0xab9423a7L); /* 51 */b = II(b, c, d, a, x[5], S44, 0xfc93a039L); /* 52 */a = II(a, b, c, d, x[12], S41, 0x655b59c3L); /* 53 */d = II(d, a, b, c, x[3], S42, 0x8f0ccc92L); /* 54 */c = II(c, d, a, b, x[10], S43, 0xffeff47dL); /* 55 */b = II(b, c, d, a, x[1], S44, 0x85845dd1L); /* 56 */a = II(a, b, c, d, x[8], S41, 0x6fa87e4fL); /* 57 */d = II(d, a, b, c, x[15], S42, 0xfe2ce6e0L); /* 58 */c = II(c, d, a, b, x[6], S43, 0xa3014314L); /* 59 */b = II(b, c, d, a, x[13], S44, 0x4e0811a1L); /* 60 */a = II(a, b, c, d, x[4], S41, 0xf7537e82L); /* 61 */d = II(d, a, b, c, x[11], S42, 0xbd3af235L); /* 62 */c = II(c, d, a, b, x[2], S43, 0x2ad7d2bbL); /* 63 */b = II(b, c, d, a, x[9], S44, 0xeb86d391L); /* 64 *///分别累加到state[0],state[1],state[2],state[3]state[0] += a;state[1] += b;state[2] += c;state[3] += d;}// 把byte型数据转换为无符号long型数据private static long byteToul(byte b) {return b >0 ?b : ( b & 0x7F + 128);}// 把byte类型的数据转换成十六进制ASCII字符表示private static String byteToHEX(byte in) {char[] DigitStr = {'0', '1', '2', '3', '4', '5', '6', '7', '8', '9','A', 'B', 'C', 'D', 'E', 'F' };char[] out = new char[2];out[0] = DigitStr[(in >> 4) & 0x0F]; //取高4位out[1] = DigitStr[in & 0x0F]; //取低4位String s = new String(out);return s;}// 将long型数组按顺序拆成byte型数组,长度为lenprivate void Encode(byte[] output, long[] input, int len) {int i, j;for (i = 0, j = 0; j < len; i++, j += 4) {output[j] = (byte) (input[i] & 0xffL);output[j + 1] = (byte) ((input[i] >>> 8) & 0xffL);output[j + 2] = (byte) ((input[i] >>> 16) & 0xffL);output[j + 3] = (byte) ((input[i] >>> 24) & 0xffL);}}// 将byte型数组按顺序合成long型数组，长度为lenprivate void Decode(long[] output, byte[] input, int len) {int i, j;for (i = 0, j = 0; j < len; i++, j += 4)output[i] = byteToul(input[j])| (byteToul(input[j + 1]) << 8)| (byteToul(input[j + 2]) << 16)| (byteToul(input[j + 3]) << 24);return;}}
随机生成卡号和密码
AccountIdUtil
public class AccountIdUtil {/*** 随机生成卡号* @return*/public static String accountId(){StringBuilder strB = new StringBuilder();Random random = new Random();for (int i = 0; i < 15; i++) {strB.append(random.nextInt(10));}String str = strB.toString();return str;}/*** 随机生成密码* @return*/public static String accountPassword(){StringBuilder strB = new StringBuilder();Random random = new Random();for (int i = 0; i < 9; i++) {strB.append(random.nextInt(10));}String s = strB.toString();return s;}/* public static void main(String[] args) {System.out.println(accountPassword());}*/}
Dao层
AccountDao
public class AccountDao {/*** 通过姓名查询账户信息* @param name* @return*/public Account selectAccountByName(String name) throws SQLException {Account account = null;Connection conn = ConnUtil.getConn();String sql = "select * from account where name = ?";PreparedStatement stmt = conn.prepareStatement(sql);stmt.setString(1,name);ResultSet rs = stmt.executeQuery();while(rs.next()){account = new Account();account.setcId(rs.getString("cid"));account.setName(rs.getString("name"));account.setPassword(rs.getString("password"));account.setBalance(rs.getDouble("balance"));}return account;}/*** 开户账户* @param account* @throws SQLException*/public void createNewAccount(Account account) throws SQLException {Connection conn = ConnUtil.getConn();String sql = "insert into account values(?,?,?,0.0)";PreparedStatement stmt = conn.prepareStatement(sql);stmt.setString(1,account.getcId());stmt.setString(2,account.getName());stmt.setString(3, MD5Util.getMd5Str(account.getPassword()));stmt.executeUpdate();}/*** 通过银行卡号账户信息* @param cId* @return*/public Account selectAccountByCidPassword(String cId) throws SQLException {Account account = null;Connection conn = ConnUtil.getConn();String sql = "select * from account where cid = ?";PreparedStatement stmt = conn.prepareStatement(sql);stmt.setString(1,cId);ResultSet rs = stmt.executeQuery();while(rs.next()){account = new Account();account.setcId(rs.getString("cid"));account.setName(rs.getString("name"));account.setPassword(rs.getString("password"));account.setBalance(rs.getDouble("balance"));}return account;}/*** 查询余额* @param account* @return*/public double selectAmountByAcc(Account account) throws SQLException {Connection conn = ConnUtil.getConn();String sql = "select * from account where cid = ?";PreparedStatement stmt = conn.prepareStatement(sql);stmt.setString(1,account.getcId());ResultSet rs = stmt.executeQuery();double amount = 0;if(rs.next()){amount = rs.getDouble("balance");}return amount;}/*** 存钱* @param cId* @param amount* @throws SQLException*/public void depositAccount(String cId,double amount) throws SQLException {Connection conn = ConnUtil.getConn();String sql = "update account set balance = balance + ? where cid = ?";PreparedStatement stmt = conn.prepareStatement(sql);stmt.setDouble(1,amount);stmt.setString(2,cId);stmt.executeUpdate();}/*** 取钱* @param account* @param amount*/public void withdrawAccount(Account account, double amount) throws SQLException {Connection conn = ConnUtil.getConn();String sql = "update account set balance = balance - ? where cid = ?";PreparedStatement stmt = conn.prepareStatement(sql);stmt.setDouble(1,amount);stmt.setString(2,account.getcId());stmt.executeUpdate();}/*** 转账* @param account* @param cId* @param amount*/public void transferAccount(Account account, String cId, double amount) throws SQLException {//转出withdrawAccount(account,amount);depositAccount(cId,amount);}/*** 修改密码* @param account* @param newPassword* @throws SQLException*/public void modifyPassword(Account account,String newPassword) throws SQLException {Connection conn = ConnUtil.getConn();String sql = "update account set password = ? where cid = ?";PreparedStatement stmt = conn.prepareStatement(sql);stmt.setString(1,newPassword);stmt.setString(2,account.getcId());stmt.executeUpdate();}}
AccountRecordDao
public class AccountRecordDao {/*** 账户记录* @param accountRecord* @throws SQLException*/public void insertAccRecord(AccountRecord accountRecord) throws SQLException {Connection conn = ConnUtil.getConn();String sql = "insert into re_account values(null,?,?,?,?)";PreparedStatement stmt = conn.prepareStatement(sql);stmt.setString(1,accountRecord.getReAccId().getcId());stmt.setString(2,accountRecord.getReAction());stmt.setString(3,accountRecord.getReAccToId().getcId());stmt.setDouble(4,accountRecord.getAmount());stmt.executeUpdate();}}
entity实体
Account
package com.demo.entity;//用户信息类public class Account {private String cId;//银行账号private String name;private String password;private double balance;//余额public Account() {}public Account(String cId, String name, String password, double balance) {this.cId = cId;this.name = name;this.password = password;this.balance = balance;}public Account(String cId, String password) {this.cId = cId;this.password = password;}public String getcId() {return cId;}public void setcId(String cId) {this.cId = cId;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public double getBalance() {return balance;}public void setBalance(double balance) {this.balance = balance;}@Overridepublic String toString() {return "Account{" +"cId='" + cId + '\'' +", name='" + name + '\'' +", password='" + password + '\'' +", balance=" + balance +'}';}}
AccountRecord
package com.demo.entity;//转账类public class AccountRecord {private String reId;//主键private Account reAccId;//转账账户private String reAction;//操作private Account reAccToId;//操作对象private double amount;//操作金额public AccountRecord() {}public AccountRecord(String reId, Account reAccId, String reAction, Account reAccToId, double amount) {this.reId = reId;this.reAccId = reAccId;this.reAction = reAction;this.reAccToId = reAccToId;this.amount = amount;}public String getReId() {return reId;}public void setReId(String reId) {this.reId = reId;}public String getReAction() {return reAction;}public void setReAction(String reAction) {this.reAction = reAction;}public Account getReAccId() {return reAccId;}public void setReAccId(Account reAccId) {this.reAccId = reAccId;}public Account getReAccToId() {return reAccToId;}public void setReAccToId(Account reAccToId) {this.reAccToId = reAccToId;}public double getAmount() {return amount;}public void setAmount(double amount) {this.amount = amount;}}
exception自定义异常
AccountException
package com.demo.exception;public class AccountException extends Exception{public AccountException() {}public AccountException(String message) {super(message);}}
AccountRecordException
package com.demo.exception;public class AccountRecordException extends Exception{public AccountRecordException() {}public AccountRecordException(String message) {super(message);}}
service层
package com.demo.service;import com.demo.dao.AccountDao;import com.demo.dao.AccountRecordDao;import com.demo.entity.Account;import com.demo.entity.AccountRecord;import com.demo.exception.AccountRecordException;import com.demo.util.AccountIdUtil;import com.demo.util.ConnUtil;import jdk.nashorn.pileUnit;import javax.security.auth.login.AccountException;import java.sql.SQLException;import java.util.Objects;public class AccountService {private AccountDao accountDao = new AccountDao();private AccountRecordDao accountRecordDao = new AccountRecordDao();/*** 开户账户* @param account*/public Account createNewAccount(Account account) throws AccountRecordException {try {Account account1 = null;String name = account.getName();Account acc = accountDao.selectAccountByName(name);if(Objects.isNull(acc)){ConnUtil.getConn().setAutoCommit(false);//默认不提交AccountRecord accountRecord = new AccountRecord();account1 = new Account();account1.setcId(AccountIdUtil.accountId());//随机卡号account1.setPassword(AccountIdUtil.accountPassword());//随机密码account1.setName(name);accountRecord.setReAccId(account1);accountRecord.setReAction("开户");accountRecord.setReAccToId(account1);accountRecord.setAmount(0.0);accountDao.createNewAccount(account1);accountRecordDao.insertAccRecord(accountRecord);ConnUtil.getConn().commit();//提交}else{System.out.println("该用户已存在，请重新录入");}return account1;} catch (SQLException throwables) {try {ConnUtil.getConn().rollback();//回滚} catch (SQLException e) {e.printStackTrace();}throw new AccountRecordException("开户失败！");}finally {ConnUtil.closeConn();}}/*** 通过银行卡号,和密码查询账户信息* @param cId* @return*/public Account selectAccountByCidPassword(String cId,String password) throws AccountException {Account account = null;try {account = accountDao.selectAccountByCidPassword(cId);if(Objects.isNull(account)){throw new AccountException("账户不存在");}else{if(!password.equals(account.getPassword())){throw new AccountException("卡号或密码不正确");}}} catch (SQLException throwables) {throwables.printStackTrace();}finally {ConnUtil.closeConn();}return account;}/*** 查询余额* @param account* @return* @throws AccountRecordException*/public double selectAmountByAcc(Account account) throws AccountRecordException {double amount = 0;try {Account acc = accountDao.selectAccountByCidPassword(account.getcId());amount = accountDao.selectAmountByAcc(account);ConnUtil.getConn().setAutoCommit(false);AccountRecord accountRecord = new AccountRecord();accountRecord.setAmount(amount);accountRecord.setReAccId(account);accountRecord.setReAccToId(account);accountRecord.setReAction("查询余额");accountRecordDao.insertAccRecord(accountRecord);ConnUtil.getConn().commit();} catch (SQLException throwables) {try {ConnUtil.getConn().rollback();} catch (SQLException e) {e.printStackTrace();}throw new AccountRecordException("查询有误");}finally {ConnUtil.closeConn();}return amount;}/*** 存钱* @param account* @param amount*/public void depositAccount(Account account, double amount) throws AccountRecordException {try {ConnUtil.getConn().setAutoCommit(false);accountDao.depositAccount(account.getcId(),amount);AccountRecord accountRecord = new AccountRecord();accountRecord.setAmount(amount);accountRecord.setReAccId(account);accountRecord.setReAccToId(account);accountRecord.setReAction("存钱");accountRecordDao.insertAccRecord(accountRecord);ConnUtil.getConn().commit();} catch (SQLException throwables) {try {ConnUtil.getConn().rollback();} catch (SQLException e) {e.printStackTrace();}finally {ConnUtil.closeConn();}throw new AccountRecordException("存钱有误！");}}/*** 取钱* @param account* @param amount*/public void withdrawAccount(Account account, double amount) throws AccountRecordException {try {ConnUtil.getConn().setAutoCommit(false);if(account.getBalance()>=amount) {accountDao.withdrawAccount(account, amount);AccountRecord accountRecord = new AccountRecord();accountRecord.setAmount(amount);accountRecord.setReAccId(account);accountRecord.setReAccToId(account);accountRecord.setReAction("取钱");accountRecordDao.insertAccRecord(accountRecord);}else{System.out.println("金额不足");}ConnUtil.getConn().commit();} catch (SQLException throwables) {try {ConnUtil.getConn().rollback();} catch (SQLException e) {e.printStackTrace();}finally {ConnUtil.closeConn();}throw new AccountRecordException("取钱有误！");}}/*** 转账* @param accountOut* @param cId* @param amount*/public void transferAccount(Account accountOut, String cId, double amount) throws AccountRecordException {try {ConnUtil.getConn().setAutoCommit(false);if(accountOut.getBalance()>=amount) {accountDao.transferAccount(accountOut,cId,amount);AccountRecord accountRecord = new AccountRecord();accountRecord.setAmount(amount);accountRecord.setReAccId(accountOut);Account acc = new Account();acc.setcId(cId);accountRecord.setReAccToId(acc);accountRecord.setReAction("转账");accountRecordDao.insertAccRecord(accountRecord);}else{System.out.println("金额不足");}ConnUtil.getConn().commit();} catch (SQLException throwables) {try {ConnUtil.getConn().rollback();} catch (SQLException e) {e.printStackTrace();}finally {ConnUtil.closeConn();}throw new AccountRecordException("转账失败！");}}/*** 修改密码* @param account* @param newPassword* @throws SQLException*/public void modifyPassword(Account account,String newPassword) throws AccountRecordException {try {ConnUtil.getConn().setAutoCommit(false);accountDao.modifyPassword(account,newPassword);AccountRecord accountRecord = new AccountRecord();accountRecord.setAmount(0);accountRecord.setReAccId(account);accountRecord.setReAccToId(account);accountRecord.setReAction("修改密码");accountRecordDao.insertAccRecord(accountRecord);ConnUtil.getConn().commit();} catch (SQLException throwables) {try {ConnUtil.getConn().rollback();} catch (SQLException e) {e.printStackTrace();}finally {ConnUtil.closeConn();}throw new AccountRecordException("修改密码失败！");}}}
test测试
public class testCreate {public static void main(String[] args) {String password = MD5Util.getMd5Str("222222");Account account = new Account("3123123213221234","李莉",password,0.0);AccountDao accountDao = new AccountDao();try {accountDao.createNewAccount(account);} catch (SQLException throwables) {throwables.printStackTrace();}}}
view视图层
StartView
package com.demo.view;import com.demo.entity.Account;import com.demo.exception.AccountRecordException;import com.demo.service.AccountService;import com.demo.util.MD5Util;import javax.security.auth.login.AccountException;import java.util.Objects;import java.util.Scanner;public class StartView {private static AccountService accountService = new AccountService();public static void main(String[] args) {Scanner sc = new Scanner(System.in);System.out.println("*************欢迎使用XXX银行ATM系统*************");int choice;do{System.out.println("1.开户");System.out.println("2.登录");System.out.println("3.退出系统");System.out.println("请选择（1-3）：");choice = sc.nextInt();if(choice<1||choice>3){System.out.println("输入数字错误，请重新输入！");continue;}break;}while(true);switch (choice){case 1://开户createNewAcount();break;case 2://登录login();break;case 3:System.out.println("感谢您的使用，欢迎下次继续光临！");System.exit(0);//退出系统break;}}/*** 开户*/private static void createNewAcount() {Scanner sc = new Scanner(System.in);System.out.println("请输入您的姓名：");String name = sc.next();Account account = new Account();//575268328account.setName(name);try {Account account1 = accountService.createNewAccount(account);// System.out.println("开户成功!");System.out.println(account1.toString());} catch (AccountRecordException e) {//开户失败System.out.println(e.getMessage());}}/*** 登录*/private static void login(){Scanner scan = new Scanner(System.in);System.out.println("请输入银行卡号:");String cId = scan.next();System.out.println("请输入密码");String password = scan.next();try {Account account = accountService.selectAccountByCidPassword(cId, MD5Util.getMd5Str(password));if(Objects.nonNull(account)) {System.out.println("登录成功！");UserView userView = new UserView(account);userView.menu();}} catch (AccountException e) {System.out.println(e.getMessage());}}}
UserView
package com.demo.view;import com.demo.entity.Account;import com.demo.exception.AccountRecordException;import com.demo.service.AccountService;import com.demo.util.MD5Util;import java.util.Scanner;public class UserView {private AccountService accountService = new AccountService();private Account account;public UserView() {}public UserView(Account account) {this.account = account;}public void menu(){Scanner sc = new Scanner(System.in);System.out.println("*************欢迎使用XXX银行ATM系统*************");int choice;do{System.out.println("1.查询余额");System.out.println("2.存款");System.out.println("3.取款");System.out.println("4.转账");System.out.println("5.修改密码");System.out.println("6.返回");System.out.println("请选择（1-6）：");choice = sc.nextInt();if(choice<1||choice>6){System.out.println("输入数字错误，请重新输入！");continue;}switch (choice){case 1:selectAmount();//查询余额continue;case 2:updateAcountBlance();//存钱continue;case 3:withdrale();//取钱continue;case 4:transferAccount();//转账continue;case 5:modifyPassword();//修改密码continue;case 6:break;}}while(true);}/*** 1.查询余额*/private void selectAmount() {System.out.println("余额:");try {double amount = accountService.selectAmountByAcc(account);System.out.println(amount);} catch (AccountRecordException e) {System.out.println(e.getMessage());}}/*** 2.存钱*/private void updateAcountBlance() {Scanner scan = new Scanner(System.in);System.out.println("请输入存入余额：");double amount = scan.nextDouble();try {accountService.depositAccount(account,amount);} catch (AccountRecordException e) {System.out.println(e.getMessage());}System.out.println("存钱成功");}/*** 3.取钱*/private void withdrale() {Scanner scan = new Scanner(System.in);System.out.println("请输入取出金额：");double amount = scan.nextDouble();try {accountService.withdrawAccount(account,amount);System.out.println("取钱成功");} catch (AccountRecordException e) {System.out.println(e.getMessage());}}/*** 4.转账*/private void transferAccount() {Scanner scan = new Scanner(System.in);System.out.println("请输入转账目标账号：");String cId = scan.next();System.out.println("请转账金额：");double amount = scan.nextDouble();try {accountService.transferAccount(account,cId,amount);System.out.println("转账成功");} catch (AccountRecordException e) {System.out.println(e.getMessage());}}/*** 5.修改密码*/private void modifyPassword() {Scanner scan = new Scanner(System.in);System.out.println("请输入新的密码：");String newPassword = MD5Util.getMd5Str(scan.next());try {accountService.modifyPassword(account,newPassword);System.out.println("修改成功");} catch (AccountRecordException e) {System.out.println(e.getMessage());}}}
资源连接
/download/C19150872001/85501948?spm=1001..3001.5503
如果觉得《银行管理系统java+mysql8 实现了转账 存钱 取钱 查询账户 开户 登录 自动生成密码账号等功能》对你有帮助，请点赞、收藏，并留下你的观点哦！
