Java银行管理系统源代码Word格式文档下载.docx
- 文档编号:5607401
- 上传时间:2023-05-05
- 格式:DOCX
- 页数:54
- 大小:26KB
Java银行管理系统源代码Word格式文档下载.docx
《Java银行管理系统源代码Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《Java银行管理系统源代码Word格式文档下载.docx(54页珍藏版)》请在冰点文库上搜索。
publicStringgetPersonId(){
returnpersonId;
publicvoidsetPersonId(StringpersonId){
this.personId=personId;
publicintgetAccountType(){
returnaccountType;
publicvoidsetAccountType(intaccountType){
this.accountType=accountType;
publicdoublegetBalance(){
returnbalance;
publicvoidsetBalance(doublebalance){
this.balance=balance;
publicintgetId(){
returnid;
publicvoidsetId(intid){
this.id=id;
publicdoublegetCeiling(){
returnceiling;
publicvoidsetCeiling(doubleceiling){
this.ceiling=ceiling;
//无参数构造方法
publicaccounts(){
//构造方法
publicaccounts(Stringpassword,Stringname,StringpersonId,intaccountType,
doublebalance,doubleceiling){
super();
//存款
publicvoiddeposit(doublemoney){
balance+=money;
//取款
publicvoidwithdraw(doublemoney){
if(accountType==1){
if((balance+ceiling)<
money){
System.out.println("
对不起,已超出您的信用额度!
"
);
}
else{
balance-=money;
}else{
if(balance<
对不起,账户余额不足!
}else{
}
}
DBoper.java
packageDB;
importjava.sql.*;
importjava.util.ArrayList;
importAccount.accounts;
publicclassDBoper{
privateConnectionconn=null;
privateStatementst=null;
privatePreparedStatementpstmt=null;
privateResultSetrs=null;
privateArrayList<
accounts>
result;
//连接数据库
publicConnectiongetConnection(){
try{
Class.forName("
com.mysql.jdbc.Driver"
conn=DriverManager.getConnection("
jdbc:
mysql:
//localhost:
3306/bankmanager?
useUnicode=true&
characterEncoding=utf8"
"
root"
xuewei"
}catch(Exceptione){
System.out.println("
数据库连接失败"
returnconn;
}
//修改删除用户数据
publicbooleanaccountDataUpdate(Stringsql){
conn=getConnection();
pstmt=conn.prepareStatement(sql);
pstmt.executeUpdate();
//System.out.println("
数据更新成功"
conn.close();
returntrue;
}catch(SQLExceptione){
e.printStackTrace();
更新失败"
returnfalse;
//依据id来修改记录
publicbooleandataupdateid(accountsuser,intid){
conn=getConnection();
try{
Stringsql="
updateaccountsetusername=?
userpwd=?
personId=?
accountType=?
balance=?
ceiling=?
whereid="
+id;
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,user.getName());
pstmt.setString(2,user.getPassword());
pstmt.setString(3,user.getPersonId());
pstmt.setInt(4,user.getAccountType());
pstmt.setDouble(5,user.getBalance());
pstmt.setDouble(6,user.getCeiling());
操作成功"
catch(SQLExceptione){
操作失败"
//插入用户数据
publicbooleanaccountDataInsert(accountsaccount){
pstmt=conn.prepareStatement("
insertintoaccount(username,userpwd,personId,accountType,balance,ceiling)values(?
?
)"
pstmt.setString(1,account.getName());
pstmt.setString(2,account.getPassword());
pstmt.setString(3,account.getPersonId());
pstmt.setInt(4,account.getAccountType());
pstmt.setDouble(5,account.getBalance());
pstmt.setDouble(6,account.getCeiling());
新用户数据插入成功"
插入失败"
//查询数据
publicResultSetdataquery(Stringsql){
rs=pstmt.executeQuery();
检索失败"
returnrs;
publicResultSettestlist(){
select*fromaccountwhereid=1001"
;
System.out.println(sql);
}catch(SQLExceptione){
publicArrayList<
testt(intid){
ArrayList<
list=newArrayList<
();
select*fromaccountwhereid="
+id;
while(rs.next()){
accountsuser=newaccounts();
user.setName(rs.getString("
username"
));
user.setPassword(rs.getString("
userpwd"
user.setPersonId(rs.getString("
personId"
user.setAccountType(rs.getInt("
accountType"
user.setBalance(rs.getDouble("
balance"
user.setCeiling(rs.getDouble("
ceiling"
list.add(user);
returnlist;
//根据卡号和密码验证用户是否存在
publicbooleanverify(intid,Stringpassword){
select*fromaccountwhereid=?
anduserpwd=?
pstmt.setInt(1,id);
pstmt.setString(2,password);
rs=pstmt.executeQuery();
if(rs.next()){
returntrue;
returnfalse;
/**
*登录验证
*/
publicaccountsverifyAccount(intid,Stringpassword){
booleanflag=verify(id,password);
if(flag){
accountsaccount=queryByIDandPassword(id,password);
returnaccount;
else
{
用户不存在!
returnnull;
//根据卡号和密码查询信息
publicaccountsqueryByIDandPassword(intid,Stringpassword){
accountsaccount=newaccounts();
while(rs.next()){
account.setId(rs.getInt("
id"
account.setName(rs.getString("
account.setPassword(rs.getString("
account.setPersonId(rs.getString("
account.setAccountType(rs.getInt("
account.setBalance(rs.getDouble("
account.setCeiling(rs.getDouble("
//根据卡号查询信息
publicaccountsqueryByID(intid){
publicstaticvoidmain(String[]args){
//TODOAuto-generatedmethodstub
DBoperop=newDBoper();
list=op.testt(1001);
for(inti=0;
i<
list.size();
i++){
accountsuser=newaccounts();
user=list.get(i);
System.out.println(user.getName());
System.out.println(user.getPassword());
System.out.println(user.getPersonId());
System.out.println(user.getAccountType());
System.out.println(user.getBalance());
System.out.println(user.getCeiling());
//图像界面文件夹
DN_SYSTEM
Default.java//主界面
packageDN_SYSTEM;
importjava.awt.Color;
importjava.awt.Container;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjavax.swing.JButton;
importjavax.swing.JFrame;
importjavax.swing.JLabel;
importjavax.swing.JOptionPane;
importjavax.swing.JPanel;
importjavax.swing.WindowConstants;
importDB.DBoper;
publicclassDefaultextendsJFrameimplementsActionListener{
accountsaccount=DN_ATM.client;
DBoperdb=newDBoper();
privateJFramejf;
privateJButtonbtn0,btn1,btn2,btn3,btn4,btn5;
privateContainerc;
publicvoiddefaltDemo(){
//添加主界面卡片
//DN_ATM.id;
intid=DN_ATM.id;
//account=db.queryByID(id);
jf=newJFrame("
DEFAULT"
c=jf.getContentPane();
c.setLayout(null);
c.setBackground(newColor(119,119,253));
JLabellblwel=newJLabel("
欢迎"
+account.getName()+"
用达能银行ATM系统"
lblwel.setBounds(20,15,350,30);
c.add(lblwel);
JLabellblwel1=newJLabel("
请选择您需要的交易类型"
lblwel1.setBounds(120,45,350,30);
c.add(lblwel1);
btn1=newJButton("
取款服务"
btn1.addActionListener(this);
btn1.setBounds(70,90,100,30);
c.add(btn1);
btn2=newJButton("
存款服务"
btn2.addActionListener(this);
btn2.setBounds(210,90,100,30);
c.add(btn2);
btn3=newJButton("
查询余额"
btn3.addActionListener(this);
btn3.setBounds(70,150,100,30);
c.add(btn3);
btn4=newJButton("
转账服务"
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Java 银行 管理 系统 源代码