banksystem.java

本系统为银行管理系统完整版,包括java源文件,数据库文件,使用说明以及详细开发文档.

p33.add(l6); 
 
p44.add(l3); 

 
p55.add(l10); 
p55.add(l11); 
p55.add(l12);
p55.add(l16);
p55.add(btn);
p55.add(btn2);
p55.add(l14);
p55.add(l15);
p66.add(l13);
p77.add(l18);
p77.add(l30);
p77.add(t3);
p77.add(l19);
setLayout(new GridLayout(7,1)); 
add(p11); 
add(p22); 
add(p33); 
 
add(p77);
add(p44);
add(p66);
add(p55); 

} 
} 

class Illegalgetmoney extends Exception
{
	
	double  Iget;
	Illegalgetmoney(double count,double get)
	{
		super("余额不足");
		
		Iget=count-get;
	}
	public String toString()
	{
		String s;
		s="余额不足，最大的取款为"+Iget;
		return s;
	}
}

class user 
{ 
String username; 
String sd; 
String home; 
String id; 
String code; 
String rcode; 
String yue; 
String rate;
double rest; 
user(String x1,String x2,String x3,String x4,String x5,String x6,String x7,String x8) 
{ 
username=x1; 
sd=x2; 
home=x3; 
id=x4; 
code=x5; 
rcode=x6; 
yue=x7; 
rate=x8; 
} 
public boolean setmoney(double count,double get)
 throws Illegalgetmoney
	
	{
		if(count>get)
		{
			rest=count-get;
			return true;
		}
		else {
			throw (new Illegalgetmoney(count,get));
		
		}
	}
	
 public	boolean getmoney1(double count,double get)
	
	{
		try{
			setmoney(count,get);
		
			return true;
			
		}
		catch(Illegalgetmoney cs)
		{
		
			return false;
		}
	}
 
}

public class BankSystem
{ 
public static void main(String args[]) throws InterruptedException
{     

        	//显示logo图片
	
		Thread thread;
		Logo lg=new Logo("校门1.png");
		
		thread=new Thread(lg);
		thread.start();
		
		Thread.currentThread().sleep(3000);
		new nn(); 
} 
} 
class nn extends Frame implements ActionListener 
{ 

Button btn1,btnY,btnN; 
Dialog d1; 
p9 pn9; 
p8 pn8; 
p11 pn11;
p10 pn10;
p12 pn12;
CardLayout cc=new CardLayout(); 
nn() 
{ 
super("银行帐号管理系统"); 
pn8=new p8(); 
pn9=new p9(); 
pn10=new p10();
pn11=new p11();
pn12=new p12();
setLayout(cc); 
add("one",pn8); 
add("two",pn9); 
add("three",pn11);
add("fouth",pn10);
add("five",pn12);
btn1=new Button("确定"); 
btnY=new Button("是");
btnN=new Button("否");
pn9.pn7.btn4.addActionListener(this); 
pn9.pn6.btn1.addActionListener(this); 
pn9.pn7.btn3.addActionListener(this); 
pn9.pn7.btn2.addActionListener(this); 
pn9.pn7.btn1.addActionListener(this); 
pn9.pn7.btn5.addActionListener(this); 
pn9.pn7.btn6.addActionListener(this);
pn9.pn7.btn7.addActionListener(this);
pn9.pn6.btn2.addActionListener(this);
pn11.btn.addActionListener(this);
pn11.btn2.addActionListener(this);
pn8.btn.addActionListener(this); 
pn8.btn2.addActionListener(this);
pn8.btn3.addActionListener(this);  
pn8.btn4.addActionListener(this); 
pn10.btn.addActionListener(this);
pn10.btn2.addActionListener(this);
pn12.btn.addActionListener(this);
pn12.btn2.addActionListener(this);
btn1.addActionListener(this); 
btnY.addActionListener(this); 
btnN.addActionListener(this); 
setBounds(200,200,600,300);

show(); 
} 
public void actionPerformed(ActionEvent e) 
{ 
final double minrest=10.00;
 String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //声明JDBC驱动程序对象
 String conURL="jdbc:odbc:银行管理系统";
 String ss2=" ";
 String str1=" ";
 String ss3=" ";
 connect connect1=new connect();


if(e.getSource()==pn8.btn) 
{ 
        String ss="10001";
        ss3=pn8.t1.getText();
         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(5);
                
                }
             	 
                st1.close();
				con1.close();
			  }
					catch(SQLException e9) 
	 	      {
			
                System.out.println("SQLException: " +e9.getMessage());
              }
              

if(ss.compareTo(pn8.t1.getText())==0&&ss2.compareTo(pn8.t2.getText())==0) 
{
	cc.show(this,"two"); 
	pn9.pn6.btn1.setEnabled(true);
	pn9.pn6.btn2.setEnabled(true);
	pn9.pn7.btn2.setEnabled(true);
	pn9.pn7.btn3.setEnabled(true);
    pn9.pn7.btn7.setEnabled(true);
	pn8.t1.setText("");
	pn8.t2.setText("");
	}
else if((pn8.t1.getText()).compareTo("admin")==0)
{
	cc.show(this,"two"); 
	pn9.pn6.btn1.setEnabled(false);
	pn9.pn7.btn2.setEnabled(false);
	pn9.pn7.btn3.setEnabled(false);
	pn9.pn7.btn7.setEnabled(false);
	pn9.pn6.btn2.setEnabled(false);
	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("帐号或密码不正确")); 
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()==pn8.btn2) 
{
	dispose();
	System.exit(0);
}
if(e.getSource()==pn8.btn3) 
{
	pn8.t1.setText("");
	pn8.t2.setText("");
}
if(e.getSource()==pn8.btn4) 
{
 d1=new Dialog(this,"关于银行管理系统",true); 
Panel p1=new Panel(); 

p1.setLayout(new GridLayout(2,1));
p1.add(new Label("本系统由范成林、罗剑锋、陈杰等设计，如有问题，请与我们联系")); 
p1.add(new Label("联系地址：南华大学数理学院0401班"));
d1.add("Center",p1); 

Panel p2=new Panel(); 
p2.add(btn1); 
d1.add("South",p2); 
d1.setBounds(200,200,400,200); 
d1.show(); 
}

if(e.getSource()==btn1) 
{ 
d1.dispose(); 
} 
if(e.getSource()==pn11.btn2) 
{
	cc.show(this,"two"); 
	pn11.t1.setText("");
	pn11.t2.setText("");
	pn11.t3.setText("");
}
if(e.getSource()==pn11.btn)
{
	 String ss4=" ";
	 ss3=pn11.t1.getText();
	 ss4=pn11.t3.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
        {
        	pn11.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()) 
			    {
			    pn11.t1.setText(rs1.getString(2));
			    ss2=rs1.getString(5);
                
                }
             	 
                st1.close();
				con1.close();
			  }
					catch(SQLException e9) 
	 	      {
			
                System.out.println("SQLException: " +e9.getMessage());
              }
               
	    if(ss2.compareTo(pn11.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 
        {
        
          connect1.connectdb();
		   try{ 
		       Connection con6=DriverManager.getConnection(conURL); //连接数据库URL
               Statement st1=con6.createStatement(); //建立Statement类对象
  
				st1.executeQuery("UPDATE account set code='"+ss4+"',rcode='"+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(); 
                }
               }
              }

        }
    }

if(e.getSource()==pn9.pn6.btn1) 
{
	cc.show(this,"five");
	pn12.t3.setText("0.0");
	
}

if(e.getSource()==pn9.pn7.btn1) 
{ 

              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.pn3.t2.getText()).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
		   {
		   	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()==pn9.pn7.btn2) 
{ 
			String m1,m2,m3,m4,m5,m6,m7,m8; 
			m1=pn9.pn2.t1.getText(); 
			m2=pn9.pn2.t2.getText(); 
			m3=pn9.pn3.t1.getText(); 
			m4=pn9.pn3.t2.getText(); 
			m5=pn9.pn4.t1.getText(); 
			m6=pn9.pn4.t2.getText(); 
			m7=pn9.pn5.t1.getText(); 
			m8=pn9.pn5.t2.getText(); 

            connect1.connectdb();
            
            double xx=Double.valueOf(m7).doubleValue();
            if(xx>=minrest)
            {
            	if(m5.compareTo(m6)==0)
		      {
		      	
		       
		        try{ 
		        Connection con2=DriverManager.getConnection(conURL); //连接数据库URL
                Statement st1=con2.createStatement(); //建立Statement类对象
                
               
                str1="INSERT INTO account"+"(username,home,sd,id,code,rcode,yue,rate)";
           		str1=str1+"VALUES ('"+m1+"','";
           		str1=str1+m3+"',";
           		str1=str1+m2+",";
           		str1=str1+m4+",";
           		str1=str1+m5+",";
           		str1=str1+m6+",";
           		str1=str1+m7+",";
           		str1=str1+m8+")";
           		st1.executeUpdate(str1);
                st1.close();
				con2.close();
                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 e3) 
	 	      {
			
                System.out.println("SQLException: " +e3.getMessage());
                d1=new Dialog(this,"错误",true); 
				Panel p1=new Panel(); 
				p1.add(new Label(e3.toString()));