transframe.java

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

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

class WinTran extends Frame implements ActionListener 
{
	TextField text1,text2;
	TextField txtPWord1,txtPWord2;
	TextField txtMoney;
	Button conf,back;
	Connection Con=null;
	Statement Stmt=null;
	WinTran()
	{
        try
        {
        	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }	
        catch(ClassNotFoundException ee)
        {}
		try
		{
			Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		    Stmt=Con.createStatement();
		}
		catch(SQLException ee)
		{}
		Panel p=new Panel();
		text1=new TextField();
		text2=new TextField();
		text2.setEchoChar('*');
		txtPWord1=new TextField();
		txtPWord2=new TextField();
		txtMoney=new TextField();
		conf=new Button("转帐");
		back=new Button("返回");
		conf.addActionListener(this);
		back.addActionListener(this);
		Box boxH1,boxH2,boxH3,boxH4,boxH5,boxH6,boxH7,boxH8;
		boxH1=Box.createHorizontalBox();
		boxH2=Box.createHorizontalBox();
		boxH3=Box.createHorizontalBox();
		boxH4=Box.createHorizontalBox();
		boxH5=Box.createHorizontalBox();
		boxH6=Box.createHorizontalBox();
		boxH7=Box.createHorizontalBox();
		boxH8=Box.createHorizontalBox();
		boxH1.add(new Label("请输入您的帐号和密码:"));
		boxH2.add(new Label("您的帐号:"));
		boxH2.add(text1);
		boxH3.add(new Label("您的密码:"));
		boxH3.add(text2);
		boxH4.add(new Label("对方帐号:"));
		boxH4.add(txtPWord1);
		boxH5.add(new Label("重复帐号:"));
		boxH5.add(txtPWord2);
		boxH6.add(new Label("转帐金额:"));
		boxH6.add(txtMoney);
		boxH7.add(Box.createHorizontalStrut(40));
		boxH7.add(conf);
		boxH8.add(Box.createHorizontalStrut(40));
		boxH8.add(back);
		Box baseBox;
		baseBox=Box.createVerticalBox();
		baseBox.add(boxH1);
		baseBox.add(boxH2);
		baseBox.add(boxH3);
		baseBox.add(boxH4);
		baseBox.add(boxH5);
		baseBox.add(boxH6);
		baseBox.add(boxH7);
		baseBox.add(boxH8);
		p.add(baseBox);
		add(p);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==conf)
		{
			try
			{
				Trans();
			}
			catch(SQLException ee)
			{
				JOptionPane.showMessageDialog(this,"对不起,数据库连接失败,请稍候再试",
		    	"Warning",JOptionPane.WARNING_MESSAGE);
			}
		}	
		else if(e.getSource()==back)
		{
			String[] s={"调用"};
			UserFrame.main(s);
		}
		
	}
	public void Trans()throws SQLException
	{
		if(!txtPWord1.getText().equals(txtPWord2.getText()))
		{
			JOptionPane.showMessageDialog(this,"您两次输入的对方帐号不一致,请重新输入",
		   	"Warning",JOptionPane.WARNING_MESSAGE);
		}
		else 
		{
			String 帐号1,密码1,余额1,挂失1;
			String 帐号2,余额2,挂失2;
			long l1=0,l2=0;
			long money1=0,money2=0;
			ResultSet rs1=Stmt.executeQuery("SELECT * FROM 银行卡数据库");
			boolean boo1=false;
			boolean boo2=false;
			while((boo1=rs1.next())==true)
			{
				帐号1=rs1.getString("帐号");
				密码1=rs1.getString("密码");
				余额1=rs1.getString("余额");
				挂失1=rs1.getString("挂失");
				if(帐号1.equals(text1.getText())&&密码1.equals(text2.getText()))
				{
					if(挂失1.equals("Y"))
					{
						JOptionPane.showMessageDialog(this,"对不起,您的卡已经挂失,请先取消挂失!",
						"Warning",JOptionPane.WARNING_MESSAGE);
						return;
					}
					l1=Long.parseLong(帐号1);
					money1=Long.parseLong(余额1);
					break;
				}
			}
			if(!boo1)
			{
				JOptionPane.showMessageDialog(this,"您还没有注册或帐号密码有错,请检查",
				"Warning",JOptionPane.WARNING_MESSAGE);
			}
			ResultSet rs2=Stmt.executeQuery("SELECT * FROM 银行卡数据库");
			while((boo2=rs2.next())==true)
			{
				帐号2=rs2.getString("帐号");
				余额2=rs2.getString("余额");
				挂失2=rs2.getString("挂失");
				if(帐号2.equals(txtPWord1.getText()))
				{
					if(挂失2.equals("Y"))
					{
						JOptionPane.showMessageDialog(this,"对不起,对方的卡已经挂失!",
						"Warning",JOptionPane.WARNING_MESSAGE);
						return;
					}
					l2=Long.parseLong(帐号2);
					money2=Long.parseLong(余额2);
					break;
				}
			}
			if(boo1&&(!boo2))
			{
				JOptionPane.showMessageDialog(this,"您要转入的帐号不存在,请检查",
				"Warning",JOptionPane.WARNING_MESSAGE);
			}
			if(boo1&&boo2)
			{
				try
				{
					money1=money1-Long.parseLong(txtMoney.getText());
					money2=money2+Long.parseLong(txtMoney.getText());
					String temp1,temp2;
					temp1="UPDATE 银行卡数据库 SET 余额 = "+money1+" WHERE 帐号 = "+l1;
			    	temp2="UPDATE 银行卡数据库 SET 余额 = "+money2+" WHERE 帐号 = "+l2;
			    	Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		           	Stmt=Con.createStatement();
		           	Stmt.executeUpdate(temp1);
		           	Stmt.executeUpdate(temp2);
		           	JOptionPane.showMessageDialog(this,"您已成功转帐,欢迎下次使用!",
		  			"Warning",JOptionPane.WARNING_MESSAGE);
				}
				catch(NumberFormatException e)
				{
					JOptionPane.showMessageDialog(this,"请输入正确的金额,谢谢合作!",
					"Warning",JOptionPane.WARNING_MESSAGE);
				}
			}
			Con.close();
		}
	}
}

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