java银行账户系统_用java编的银行账户系统代码

展开全部

package pack.money.persistent;import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;import pack.money.entity.Client;

import pack.money.entity.ClientMessage;

public class ClientPersistent {

//private static int a=0;

private static String t,b;//t是password b是clinetname

private static ClientPersistent sp;

public static ClientPersistent getClientPersistent() {

if (sp == null) {

sp = new ClientPersistent();

}

return sp;

}

private ClientMessage getClientMessage(ResultSet rs) throws Exception{

ClientMessage student=new ClientMessage();

student.setMoney(rs.getFloat("money"));

student.setType(rs.getString("type"));

student.setClientName(rs.getString("ClientName"));

student.setTransactionID(rs.getInt("TransactionID"));

return student;

}

public Client login(Connection con,String ClientName,String password) throws Exception{

String sql="select balance,password,ClientName from Client where ClientName=? and password=?";

PreparedStatement ps=con.prepareStatement(sql);

ps.setString(1, ClientName);

ps.setString(2, password);

ResultSet rs=ps.executeQuery();

t=password;

b=ClientName;

System.out.println(t);

System.out.println(b);

if(rs.next()){

Client client=new Client();

client.setClientName(rs.getString("ClientName"));

client.setPassword(rs.getString("password"));

return client; }

throw new Exception("Can not login, the accountID or password has error. ");

} public void save(Connection con ,String money)throws Exception

{ // a++;

String s="save";

float g=Float.parseFloat(money);

String sql="update Client set balance=balance+? where ClientName=?";

String sql1="insert into ATMTransaction(ClientName,Type,money) values(?,?,?) ";

PreparedStatement ps=con.prepareStatement(sql);

PreparedStatement ps1=con.prepareStatement(sql1);

ps.setFloat(1, g);

ps.setString(2,b);

//ps1.setInt(1,a);

ps1.setString(1,b);

ps1.setString(2,s);

ps1.setFloat(3,g);

ps.executeUpdate();

ps1.executeUpdate();

}

public void withDraw (Connection con ,String money)throws Exception

{ //a++;

String s="WithDraw";

float x=Float.parseFloat(money);

String sql="update Client set balance=balance-? where ClientName=?";

String sql1="insert into ATMTransaction(ClientName,Type,money) values(?,?,?)";

PreparedStatement ps=con.prepareStatement(sql);

PreparedStatement ps1=con.prepareStatement(sql1);

ps.setFloat(1, x);

ps.setString(2,b);

//ps1.setInt(1,a);

ps1.setString(1,b);

ps1.setString(2,s);

ps1.setFloat(3,x);

ps.executeUpdate();

ps1.executeUpdate();

}

public String changePassword(Connection con, String OldPassWord,String newPassWord1,String newPassWord2)

throws Exception

{

if(t.equals(OldPassWord))

{

if(newPassWord1.equals(newPassWord2))

{

String sql="update Client set password=? where ClientName=?";

PreparedStatement ps=con.prepareStatement(sql);

ps.setString(1, newPassWord1);

ps.setString(2,b);

ps.executeUpdate();

String j="dsfasdf";

return j;

}

else

{System.out.print("确认密码e5a48de588b63231313335323631343130323136353331333332626635错误！");
return null;}

}

else

{ return null;

}

}

public ArrayList disPlayAll(Connection con ) throws Exception

{

String sql="select * from ATMTransaction where ClientName=? ";

PreparedStatement ps=con.prepareStatement(sql);

ps.setString(1,b);

System.out.println(b+"****b****");

ResultSet rs=ps.executeQuery();

ArrayList message=new ArrayList();

while(rs.next()){

message.add(this.getClientMessage(rs));

}

return message;

}

public float showBalance(Connection con ) throws Exception

{

String sql="select balance from Client where ClientName=?";

PreparedStatement ps=con.prepareStatement(sql);

ps.setString(1, b);

ResultSet rs=ps.executeQuery();

if(rs.next())

{

float s;

s=rs.getFloat("balance");

return s;

}

else return 0 ;

}

}

本回答由网友推荐

已赞过

已踩过<

你对这个回答的评价是？

评论

收起