📄 banksystem.java
字号:
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(200,200,500,200);
d1.show();
}
}
else {
d1=new Dialog(this,"错误",true);
Panel p1=new Panel();
p1.add(new Label("两次输入密码不一致"));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(200,200,200,100);
d1.show();
}
}
else {
d1=new Dialog(this,"错误",true);
Panel p1=new Panel();
p1.add(new Label("最小存款为10.0元"));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(200,200,200,100);
d1.show();
}
}
if(e.getSource()==pn9.pn7.btn3) //删除用户
{
d1=new Dialog(this,"真的要删除吗？",true);
Panel p1=new Panel();
p1.add(new Label("此操作将删除用户，要继续吗？"));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btnY);
p2.add(btnN);
d1.add("South",p2);
d1.setBounds(200,200,200,100);
d1.show();
}
if(e.getSource()==btnY)
{
d1.dispose();
connect1.connectdb();
try{
Connection con1=DriverManager.getConnection(conURL); //连接数据库URL
Statement st1=con1.createStatement(); //建立Statement类对象
ss2=pn9.pn2.t2.getText();
pn9.pn2.t1.setText("");
pn9.pn2.t1.setText("");
pn9.pn3.t1.setText("");
pn9.pn3.t2.setText("");
pn9.pn4.t1.setText("");
pn9.pn4.t2.setText("");
pn9.pn5.t1.setText("");
pn9.pn5.t2.setText("");
ResultSet rs1=st1.executeQuery("select * from account where sd='"+ss2+"'");
while(rs1.next())
{
pn9.pn2.t1.setText(rs1.getString(1));
pn9.pn2.t2.setText(rs1.getString(2));
pn9.pn3.t1.setText(rs1.getString(3));
pn9.pn3.t2.setText(rs1.getString(4));
pn9.pn4.t1.setText(rs1.getString(5));
pn9.pn4.t2.setText(rs1.getString(6));
pn9.pn5.t1.setText(rs1.getString(7));
pn9.pn5.t2.setText(rs1.getString(8));
}
st1.close();
con1.close();
if((pn9.pn2.t1.getText()).compareTo("")!=0)
{
connect1.connectdb();
try{
Connection con4=DriverManager.getConnection(conURL); //连接数据库URL
Statement st2=con4.createStatement(); //建立Statement类对象
ss2=pn9.pn2.t2.getText();
st2.executeUpdate("Delete * from account where sd='"+ss2+"'");
st2.close();
con4.close();
d1=new Dialog(this,"恭喜",true);
Panel p3=new Panel();
p3.add(new Label("用户成功删除!"));
d1.add("Center",p3);
Panel p4=new Panel();
p4.add(btn1);
d1.add("South",p4);
d1.setBounds(200,200,200,100);
d1.show();
}
catch(SQLException e5)
{
System.out.println("SQLException: " +e5.getMessage());
d1=new Dialog(this,"错误",true);
Panel p3=new Panel();
p3.add(new Label(e5.getMessage()));
d1.add("Center",p3);
Panel p4=new Panel();
p4.add(btn1);
d1.add("South",p4);
d1.setBounds(200,200,400,100);
d1.show();
}
}
else
{
d1=new Dialog(this,"错误",true);
Panel p1=new Panel();
p1.add(new Label("此帐号不存在"));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(200,200,200,100);
d1.show();
}
}
catch(SQLException e2)
{
System.out.println("SQLException: " +e2.getMessage());
}
}
if(e.getSource()==btnN)
{
d1.dispose();
}
if(e.getSource()==pn9.pn7.btn4)
{
pn9.pn2.t1.setText("");
pn9.pn2.t2.setText("");
pn9.pn3.t1.setText("");
pn9.pn3.t2.setText("");
pn9.pn4.t1.setText("");
pn9.pn4.t2.setText("");
pn9.pn5.t1.setText("");
pn9.pn5.t2.setText("");
}
if(e.getSource()==pn9.pn7.btn5)
{
cc.show(this,"one");
pn9.pn2.t1.setText("");
pn9.pn2.t2.setText("");
pn9.pn3.t1.setText("");
pn9.pn3.t2.setText("");
pn9.pn4.t1.setText("");
pn9.pn4.t2.setText("");
pn9.pn5.t1.setText("");
pn9.pn5.t2.setText("");
}
if(e.getSource()==pn9.pn7.btn6)
{
dispose();
System.exit(0) ;
}
if(e.getSource()==pn9.pn7.btn7)
{
cc.show(this,"three");
}
if(e.getSource()==pn9.pn6.btn2)
{
cc.show(this,"fouth");
pn10.t3.setText("0.0");
}
if(e.getSource()==pn10.btn2)//从取款界面返回
{
cc.show(this,"two");
pn10.t1.setText("");
pn10.t2.setText("");
pn10.t3.setText("");
}
if(e.getSource()==pn10.btn)
{
String ss4=" ";
double s3=Double.valueOf(pn10.t3.getText()).doubleValue();
double s5=0.0;
ss3=pn10.t1.getText();
if(ss3.compareTo("")==0)
{
d1=new Dialog(this,"警告",true);
Panel p1=new Panel();
p1.add(new Label("请输入帐号"));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(200,200,200,100);
d1.show();
}
else
{
pn10.t1.setText("");
connect1.connectdb();
try{
Connection con1=DriverManager.getConnection(conURL); //连接数据库URL
Statement st1=con1.createStatement(); //建立Statement类对象
ResultSet rs1=st1.executeQuery("select * from account where sd='"+ss3+"'");
while(rs1.next())
{
pn10.t1.setText(rs1.getString(2));
ss2=rs1.getString(5);
ss4=rs1.getString(7);
}
st1.close();
con1.close();
}
catch(SQLException e9)
{
System.out.println("SQLException: e9" +e9.getMessage());
}
if(ss2.compareTo(pn10.t2.getText())!=0)
{
d1=new Dialog(this,"警告",true);
Panel p1=new Panel();
p1.add(new Label("帐号或密码不正确"));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(200,200,200,100);
d1.show();
}
else
{
s5=Double.valueOf(ss4).doubleValue();
if(s5-s3<minrest)
{
double rest=s5-minrest;
d1=new Dialog(this,"取款失败",true);
Panel p1=new Panel();
p1.add(new Label("最大取款为："+rest));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(200,200,200,100);
d1.show();
}
else
{
double rest=s5-s3;
ss4=String.valueOf(rest).toString();
connect1.connectdb();
try{
Connection con6=DriverManager.getConnection(conURL); //连接数据库URL
Statement st1=con6.createStatement(); //建立Statement类对象
ss2=pn9.pn2.t2.getText();
st1.executeQuery("UPDATE account set yue='"+ss4+"' where sd='"+ss3+"'");
st1.close();
con6.close();
}
catch(SQLException e10)
{
System.out.println("SQLException: " +e10.getMessage());
if((e10.getMessage()).compareTo("No ResultSet was produced")==0)
{
d1=new Dialog(this,"取款成功",true);
Panel p1=new Panel();
p1.add(new Label("余额为："+rest));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(250,250,200,100);
d1.show();
}
}
}
}
}
}
if(e.getSource()==pn12.btn2)//从存款界面返回
{
cc.show(this,"two");
pn12.t1.setText("");
pn12.t3.setText("");
}
if(e.getSource()==pn12.btn)
{
String ss4=" ";
String sx="";
double s3=Double.valueOf(pn12.t3.getText()).doubleValue();
double s5=0.0;
ss3=pn12.t1.getText();
if(ss3.compareTo("")==0)
{
d1=new Dialog(this,"警告",true);
Panel p1=new Panel();
p1.add(new Label("请输入帐号"));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(200,200,200,100);
d1.show();
}
else{
connect1.connectdb();
try{
Connection con1=DriverManager.getConnection(conURL); //连接数据库URL
Statement st1=con1.createStatement(); //建立Statement类对象
ResultSet rs1=st1.executeQuery("select * from account where sd='"+ss3+"'");
while(rs1.next())
{
ss2=rs1.getString(2);
ss4=rs1.getString(7);
pn12.t1.setText(rs1.getString(2));
}
st1.close();
con1.close();
}
catch(SQLException e14)
{
System.out.println("SQLException e14:" +e14.getMessage());
sx=sx+e14.getMessage();
}
if((pn12.t1.getText()).compareTo("")==0||sx.compareTo("No data found")!=0)
{
d1=new Dialog(this,"警告",true);
Panel p1=new Panel();
p1.add(new Label("帐号不存在"));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(200,200,200,100);
d1.show();
}
else
{
s5=Double.valueOf(ss4).doubleValue();
double rest=s5+s3;
ss4=String.valueOf(rest).toString();
connect1.connectdb();
try{
Connection con6=DriverManager.getConnection(conURL); //连接数据库URL
Statement st1=con6.createStatement(); //建立Statement类对象
st1.executeQuery("UPDATE account set yue='"+ss4+"' where sd='"+ss3+"'");
st1.close();
con6.close();
}
catch(SQLException e10)
{
System.out.println("SQLException: " +e10.getMessage());
if((e10.getMessage()).compareTo("No ResultSet was produced")==0)
{
d1=new Dialog(this,"存款成功",true);
Panel p1=new Panel();
p1.add(new Label("可以继续操作了"));
d1.add("Center",p1);
Panel p2=new Panel();
p2.add(btn1);
d1.add("South",p2);
d1.setBounds(250,250,200,100);
d1.show();
}
}
}
}
}
}
}
class Logo extends JWindow implements Runnable
{
String filename;
public Logo(String name)
{
filename=name;
}
public Logo()
{
}
public void run()
{
URL imgURL = getClass().getResource(filename);
ImageIcon ig=new ImageIcon(imgURL);
JButton btn=new JButton(ig);
getContentPane().add(btn);
Toolkit kit=Toolkit.getDefaultToolkit();
Dimension screenSize=kit.getScreenSize();
setLocation(screenSize.width/8,screenSize.height/8);
setSize(ig.getIconWidth(),ig.getIconHeight());
toFront();
thread1 thread2=new thread1();
thread2.start();
//setVisible(false);
}
public void setNotVisible()
{
setVisible(false);
}
class thread1 extends Thread
{
public void run()
{
try
{
setVisible(true);
sleep(3000);
setNotVisible();
}
catch(InterruptedException e)
{
System.out.print("error occours");
}
}
}
}
class connect
{
String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //声明JDBC驱动程序对象
connect(){
}
void connectdb()
{
try {
Class.forName(JDriver); //加载JDBC-ODBC桥驱动程序
}
catch(ClassNotFoundException e10)
{
System.out.println("Driver not found!");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -