moneyframe.java

很经典的银行ATM操作系统。 可以创建账户

import java.sql.*;
import java.awt.*;
import java.applet.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;

class WinMon extends Frame implements ActionListener 
{
	TextField text1,text2,txt帐号,txt密码;
	Button button1,button2,button3;
	Panel p;
	Connection Con=null;
	Statement Stmt=null;
	ResultSet rs;
	WinMon()
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException ee)
		{}
		try
		{
			Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
			Stmt=Con.createStatement();
		}
		catch(SQLException ee){}
		p=new Panel();
		txt帐号=new TextField(8);
		txt密码=new TextField(8);
		txt密码.setEchoChar('*');
		Box boxH1,boxH2;
		boxH1=Box.createHorizontalBox();
		boxH2=Box.createHorizontalBox();
		boxH1.add(new Label("帐号"));
		boxH1.add(txt帐号);
		boxH2.add(new Label("密码"));
		boxH2.add(txt密码);
		Box boxV=Box.createVerticalBox();
		boxV.add(boxH1);boxV.add(boxH2);
		text1=new TextField(8);
		text2=new TextField(8);
		button1=new Button("确定");
		button2=new Button("确定");
		button3=new Button("返回");
		button1.addActionListener(this);
		button2.addActionListener(this);
		button3.addActionListener(this);
		Box boxH,boxV1,boxV2;
		Box boxH11,boxH21,boxH31,boxH41;
		Box boxH12,boxH22,boxH32,boxH42;
		boxH11=Box.createHorizontalBox();
		boxH11.add(new Label("存款:"));
		boxH21=Box.createHorizontalBox();
		boxH21.add(new Label("金额:"));
		boxH21.add(text1);
		boxH31=Box.createHorizontalBox();
		boxH31.add(Box.createHorizontalStrut(70));
		boxH31.add(button1);
		boxH41=Box.createHorizontalBox();
		boxH41.add(new Label());
		boxH12=Box.createHorizontalBox();
		boxH12.add(new Label("取款:"));
		boxH22=Box.createHorizontalBox();
		boxH22.add(new Label("金额:"));
		boxH22.add(text2);
		boxH32=Box.createHorizontalBox();
		boxH32.add(Box.createHorizontalStrut(70));
		boxH32.add(button2);
		boxH42=Box.createHorizontalBox();
		boxH42.add(Box.createHorizontalStrut(70));
		boxH42.add(button3);
		boxV1=Box.createVerticalBox();
		boxV1.add(boxH11);
		boxV1.add(boxH21);
		boxV1.add(boxH31);
		boxV1.add(boxH41);
		boxV2=Box.createVerticalBox();
		boxV2.add(boxH12);
		boxV2.add(boxH22);
		boxV2.add(boxH32);
		boxV2.add(boxH42);
		boxH=Box.createHorizontalBox();
		boxH.add(boxV1);
		boxH.add(Box.createHorizontalStrut(30));
		boxH.add(boxV2);
		p.add(Box.createVerticalStrut(30));
		p.add(boxV);
		p.add(boxH);
		add(p);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==button3)
		{
			String s[]={"调用"};
			UserFrame.main(s);
		}
		if(e.getSource()==button1)
		{
		    try
		    {
		    	add();
		    }
		    catch(SQLException ee)
		    {
				JOptionPane.showMessageDialog(this,"对不起,数据库连接失败,请稍候再试",
			    "Warning",JOptionPane.WARNING_MESSAGE);
			}
		}
		if(e.getSource()==button2)
		{
			try
			{
				min();
			}
			catch(SQLException ee)
		    {
				JOptionPane.showMessageDialog(this,"对不起,数据库连接失败,请稍候再试",
			    "Warning",JOptionPane.WARNING_MESSAGE);
			}
		}	
		
	}
	public void add()throws SQLException
	{
		String 帐号,密码,余额,挂失;
		Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		Stmt=Con.createStatement();
		ResultSet rs=Stmt.executeQuery("SELECT * FROM 银行卡数据库");
		boolean boo=false;
		try
	    {
	    	while((boo=rs.next())==true)
	    	{
				帐号=rs.getString("帐号");
		 		密码=rs.getString("密码");
				余额=rs.getString("余额");
				挂失=rs.getString("挂失");
				if(帐号.equals(txt帐号.getText())&&密码.equals(txt密码.getText()))
				{
					if(挂失.equals("Y"))
			        {
						JOptionPane.showMessageDialog(this,"对不起,您的卡已挂失!",
						"Warning",JOptionPane.WARNING_MESSAGE);
						break;
					}
					else
					{
						long l1=Long.parseLong(余额);
						long l2=Long.parseLong(text1.getText());
						if(l2<0)
						{
							JOptionPane.showMessageDialog(this,"对不起,存款不能为负数!",
							"Warning",JOptionPane.WARNING_MESSAGE);
							break;
						}
						else
						{
							long l3=l1+l2;
							String s="'"+String.valueOf(l3)+"'";
							long l4=Long.parseLong(帐号);
							String temp;
							temp="UPDATE 银行卡数据库 SET 余额 = "+s+" WHERE 帐号="+l4;
							Stmt.executeUpdate(temp);
							JOptionPane.showMessageDialog(this,"存款成功,欢迎下次使用!",
							"Warning",JOptionPane.WARNING_MESSAGE);
							break;
						}
					}
				}
			}
			Con.close();
			if(boo==false)
			{
				JOptionPane.showMessageDialog(this,"您还没有注册或帐号密码有错,请检查",
				"Warning",JOptionPane.WARNING_MESSAGE);
			}
		}
		catch(NumberFormatException ee)
		{
			JOptionPane.showMessageDialog(this,"请输入完整的帐号,密码及金额,这样我们才能给您提供正确的服务!",
			"Warning",JOptionPane.WARNING_MESSAGE);
		}
	}
	public void min()throws SQLException
	{
		String 帐号,密码,余额,挂失;
		Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		Stmt=Con.createStatement();
		ResultSet rs=Stmt.executeQuery("SELECT * FROM 银行卡数据库");
		boolean boo=false;
		try
		{
			while((boo=rs.next())==true)
	 		{
				帐号=rs.getString("帐号");
				密码=rs.getString("密码");
				余额=rs.getString("余额");
				挂失=rs.getString("挂失");
				if(帐号.equals(txt帐号.getText())&&密码.equals(txt密码.getText()))
				{
					if(挂失.equals("Y"))
					{
						JOptionPane.showMessageDialog(this,"对不起,您的卡已挂失!",
						"Warning",JOptionPane.WARNING_MESSAGE);
						break;
					}
					else
					{
						long l1=Long.parseLong(余额);
						long l2=Long.parseLong(text2.getText());
						if(l2<0)
						{
							JOptionPane.showMessageDialog(this,"对不起,取款不能为负数!",
							"Warning",JOptionPane.WARNING_MESSAGE);
							break;
						}
						else if(l1>=l2)
						{
							long l3=l1-l2;
							String s="'"+String.valueOf(l3)+"'";
							long l4=Long.parseLong(帐号);
							String temp;
							temp="UPDATE 银行卡数据库 SET 余额 = "+s+" WHERE 帐号="+l4;
							Stmt.executeUpdate(temp);
							JOptionPane.showMessageDialog(this,"取款成功,欢迎下次使用!",
							"Warning",JOptionPane.WARNING_MESSAGE);
							break;
						}
						else 
						{
							JOptionPane.showMessageDialog(this,"对不起,您的余额已不足!",
							"Warning",JOptionPane.WARNING_MESSAGE);
							break;
						}
					}
				}
			}
			Con.close();
			if(boo==false)
			{
				JOptionPane.showMessageDialog(this,"您还没有注册或帐号密码有错,请检查",
				"Warning",JOptionPane.WARNING_MESSAGE);
			}
		}
		catch(NumberFormatException ee)
		{
			JOptionPane.showMessageDialog(this,"请输入完整的帐号,密码及金额,这样我们才能给您提供正确的服务!",
			"Warning",JOptionPane.WARNING_MESSAGE);
		}
	}
}

public  class MoneyFrame
{
	public static void main(String args[])
	{
		WinMon window=new WinMon();
		window.setBounds(100,100,300,300);
		window.setVisible(true);
		window.addWindowListener(new WindowAdapter()
		{
			public void windowClosing(WindowEvent e)
			{
				System.exit(0);
			}
		});
	}
}