ATM柜员机模拟系统-代码

1、.-.优选.优选-Win.javapublic class Win e*tends JFrame implements ActionListener JTe*tField te*t=new JTe*tField6;JTe*tArea show=new JTe*tArea(9,30);JTable table;/标签utton insert,update,select,delete,C,Q;Win() setLayout(new FlowLayout(); for(int i=0;i5;i+) te*ti=new JTe*tField(10);add(new JLabel(卡号：);add(te

2、*t0);add(new JLabel(*：);add(te*t1);add(new JLabel(密码：);add(te*t2);add(new JLabel(余额：);add(te*t3);add(new JLabel(序号：);add(te*t4);C=new utton(存款); C.addActionListener(this);add(C);Q=new utton(取款); Q.addActionListener(this);add(Q);update=new utton(修改密码);update.addActionListener(this);add(update);insert

3、=new utton(添加新用户);insert.addActionListener(this);add(insert);select=new utton(查询用户信息);select.addActionListener(this); add(select);delete=new utton(删除用户信息);delete.addActionListener(this); add(delete);add(new JScrollPane(show);add(new JLabel(提示:11005000元，支取金额不允许透支);add(new JLabel(2.存款金额不能为负存款);add(new

4、 JLabel(366况);setVisible(true); setDefaultCloseOperation(JFrame.E*IT_ON_CLOSE);public void actionPerformed(ActionEvent e) Operation modify=new Operation();modify.setDatasourceName(*);if(e.getSource()=insert)modify.setSQL(INSERT INTO * VALUES (+te*t4.getTe*t()+,+te*t0.getTe*t()+,+te*t1.getTe*t()+,+te

5、* t2.getTe*t()+,+te*t3.getTe*t()+);String backMess=modify.modifyRecord();show.append(添加新用户+backMess);else if(e.getSource()=C)Connection con=null;Statement sql; ResultSet rs = null;trydouble n=2000; con=DriverManager.getConnection(jdbc:odbc:*,); con.setAutomit(false);sql=con.createStatement();rs=sql.

6、e*ecuteQuery(SELECT * FROM * WHERE=123456);/查询rs.ne*t();double money=rs.getDouble(5);double money1=money+n;sql.e*ecuteUpdate/存款*额(UPDATE * SET 余额=+money1+ WHERE 卡号=123456); /存款后更con.mit();con.setAutomit(true); /提交事务结果到数据库sql=con.createStatement();/创立数据库操作对象catch(SQLE*ception e1)try con.rollback(); /

7、假如操作失败则完毕事务catch(SQLE*ception e*p)else if(e.getSource()=Q)Connection con=null;Statement sql; ResultSet rs = null;trydouble n=5000; con=DriverManager.getConnection(jdbc:odbc:*,); con.setAutomit(false);sql=con.createStatement();rs=sql.e*ecuteQuery(SELECT * FROM * WHERE=123456);rs.ne*t();double money=r

8、s.getDouble(5);double money2=money-n;sql.e*ecuteUpdate/取款*额(UPDATE * SET 余额=+money2+ WHERE 卡号=123456); /取款后更con.mit(); con.setAutomit(true); sql=con.createStatement();catch(SQLE*ception e1)try con.rollback(); catch(SQLE*ception e*p)else if(e.getSource()=update)modify.setSQL(UPDATE * SET *.密码 =+te*t2

9、.getTe*t()+WHERE (*.卡号)=+te*t0.getTe*t()+););String backMess=modify.modifyRecord();show.append(修改密码+backMess);else if(e.getSource()=delete)modify.setSQL(DELETE * FROM * WHERE (*.卡号)=+te*t0.getTe*t()+););String backMess=modify.modifyRecord();show.append(删除用户信息+backMess);else if(e.getSource()=select)Q

10、uery query =new Query(); query.setDatasoureName(*);query.setTableName(*);Object a=query.getRecord();String b=序号,卡号,*,密码,余额;table=new JTable(a,b);JFrame frame=new JFrame(); frame.add(new JScrollPane(table);frame.setVisible(true); frame.setBounds(400,400,600,200);public void setBounds(int i, int j, in

11、t k, int l) Operation.javapublic class OperationString datasourceName=;/数据源名称String SQL,message=;/表名public Operation()/增删改的主代码catch(E*ception e)public void setSQL(String SQL)/建立一个新的数据源 this.SQL=SQL; public void setDatasourceName(String s)datasourceName=s.trim(); public String modifyRecord()Connectio

12、n con=null;Statement sql=null;try String uri=jdbc:odbc:+datasourceName;String id=;String password=; con=DriverManager.getConnection(uri,id,password); sql=con.createStatement();sql.e*ecute(SQL); message=操作成功;con.close();catch(SQLE*ception e) message=e.toString(); return message;/*数据源读取初始化*/public voi

13、d setTableName(String string) /表名public Object getRecord() /存放操作结果数组 return null; Query.javapublic class QueryStringdatasourceName=; /数据源名String tableName=;/表名Object a;public Query()catch(ClassNotFoundE*ceptione)public void setDatasoureName(String s)datasourceName=s.trim(); public void setTableName(

14、String s) tableName=s.trim();public Object getRecord() /猎取表中记录Connection con;PreparedStatement sql; /预处理命令ResultSet rs;/结果集tryString uri=jdbc:odbc:+datasourceName;String number=;String password=;con=DriverManager.getConnection(uri,number,password);接/初始化连DatabaseMetaData metadata=con.getMetaData();/g

15、etMetaData()方法返回一个DatabaseMetaDataResultSet rs1=metadata.getColumns(null,null,tableName,null);/将表中的字段信息以行列的形式存储在Result 中int 字段个数=0;while(rs1.ne*t() 字段个数+; int n=getAmount();a=new Objectn字段个数;sql=con.prepareStatement(SELECT * FROM +tableName);rs=sql.e*ecuteQuery();int m=0;while(rs.ne*t()/输出结果集中的数据for

16、(int k=1;k=字段个数;k+)amk-1=rs.getString(k);m+;con.close();/查询表名catch(SQLE*ception e)return a;public int getAmount()Connection con;Statement sql; ResultSet rs; tryString uri=jdbc:odbc:+datasourceName;String id=;String password=; con=DriverManager.getConnection(uri,id,password);sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_RE AD_ONLY);/以只读方式滚动查询rs=sql.e*ecuteQuery(SELECT * FROM +tableName);行/猎取所在r