银行管理系统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;
//私有构造方法，外部不能new
private 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型数组PADDING
static 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; // 初始化为0
resultStr = "";// 初始化resultStr字符串为空
for(int i=0;i<16;i++) digest[i]=0;//初始化digest数组元素为0
return;
}
//定义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;
} else
i = 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型数组,长度为len
private 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型数组，长度为len
private 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;
= 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) {
= 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;
}
@Override
public 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.internal.codegen.CompileUnit;
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();//575268328
account.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());
}
}
}
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
