java atm gui_JavaGUI编程——ATM项目包含源码和程序使用说明

2019-01-24

本程序由java编写，包含了数据库，GUI等知识。

压缩文件中有程序源码，数据库文件，程序使用说明。

程序主要代码如下：

/*

*接口

*/

public ResultSet Select(String x);                  //查询

public void withDrawal(float x);                    //取款

public void Remove(String x,float y);               //转账

public void Insert(float x);                        //存款

public boolean Land(String x,String y);

/*

*实现

*/

package Link_ATM;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JFrame;

import javax.swing.JOptionPane;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.Statement;

import Windows_ATM.Windows_land;

public  class Operate implements Link_Method{

@Override

public ResultSet Select(String x){                  //查询

Link link=new Link();

Statement stmt=null;

ResultSet rs=null;

ResultSet vs = null;

Connection conn=null;

try {

conn=link.Link();

stmt=(Statement) conn.createStatement();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

String sql="select * from user where Id= "+x;

try {

rs=stmt.executeQuery(sql);

vs=rs;

} catch (SQLException e) {

e.printStackTrace();

}

return vs;

}

@Override

public void withDrawal(float x) {                      //取款

Link link=new Link();

Statement stmt=null;

ResultSet rs=null;

Connection conn=null;

float g=0f;

try {

conn=link.Link();

stmt=(Statement) conn.createStatement();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

String sql="select Money from user where Id= "+Windows_land.x;

try {

rs=stmt.executeQuery(sql);

} catch (SQLException e) {

e.printStackTrace();

}

try {

while(rs.next()) {

float money =rs.getFloat("Money");

if(money>=x) {

g=money-x;

//     取款成功！

}

}

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

String  in="UPDATE user SET Money = '"+g+"'WHERE Id = '"+Windows_land.x+"'" ;

try {

stmt.executeUpdate(in);

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

}

@Override

public void Remove(String x,float y) {                     //转账

/*

* 有bug 数据库中没有目标用户时 也会进行转账操作 扣除源账户资金

*/

Link link=new Link();

Statement stmt=null;

ResultSet rs=null;

Connection conn=null;

float z=0f;                                              //当前账户金额

float out=0f;                                            //对方账户金额

try {

conn=link.Link();

stmt=(Statement) conn.createStatement();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

/*

* 查询转账用户是否存在

*/

String pd="select Name from user where Id="+x;

try {

ResultSet result=stmt.executeQuery(pd);

result.next();

if(!result.getString("Name").equals(""))

{

String sql1="select * from user where Id= "+Windows_land.x;

try {

rs=stmt.executeQuery(sql1);

} catch (SQLException e) {

e.printStackTrace();

}

try {

while(rs.next()) {

float money =rs.getFloat("Money");

if(money>=y) {

z=money-y;

//      余额足够转账

}

}

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

/*

* 当前用户金额减少

*/

String  in="UPDATE user SET Money = '"+z+"'WHERE Id = '"+Windows_land.x+"'" ;

try {

stmt.executeUpdate(in);

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

/*

* 增加对方账户金额

*/

String out2="select * from user where Id= "+x;

try {

rs=stmt.executeQuery(out2);

} catch (SQLException e) {

e.printStackTrace();

}

try {

while(rs.next()) {

float money =rs.getFloat("Money");

z=money+y;

//      增加余额

}

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

String  out1="UPDATE user SET Money = '"+z+"'WHERE Id = '"+x+"'" ;

try {

stmt.executeUpdate(out1);

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

}

else {

JOptionPane.showMessageDialog(new JFrame().getContentPane(), "无此账户！");

}

} catch (SQLException e) {

e.printStackTrace();

}

}

@Override

public void Insert(float x) {                              //存款

Link link=new Link();

Statement stmt=null;

ResultSet rs=null;

Connection conn=null;

float y = 0;

try {

conn=link.Link();

stmt=(Statement) conn.createStatement();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

String sql="select Money from user where Id= "+Windows_land.x;

try {

rs=stmt.executeQuery(sql);

} catch (SQLException e) {

e.printStackTrace();

}

try {

while(rs.next()) {

y=rs.getFloat("Money");

y+=x;                                        //存款

}

} catch (SQLException e) {

e.printStackTrace();

}

String in="UPDATE user SET Money = '"+y+"'WHERE Id = '"+Windows_land.x+"'" ;

try {

stmt.executeUpdate(in);

} catch (SQLException e) {

e.printStackTrace();

}

}

@Override

public boolean Land(String x, String y) {             //登陆

Link link=new Link();

Connection conn=null;

Statement stmt=null;

ResultSet rs=null;

boolean back=false;

String sql="select * from user where Id="+x;

try {

conn=link.Link();

stmt=(Statement)conn.createStatement();

rs=stmt.executeQuery(sql);

} catch (ClassNotFoundException | SQLException e) {

e.printStackTrace();

}

try {

while(rs.next()) {

if(rs.getString("Password").equals(y)) {

back=true;

}

else {

back=false;

}

}

} catch (SQLException e) {

e.printStackTrace();

}

return back;

}

}

程序运行截图

下载地址：链接：https://pan.baidu.com/s/1qOuYBUX7D2o_2O3xwwi1-Q

提取码：7uht