netframe.java

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

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

class WinNet extends Frame implements ActionListener 
{
	TextField text1,text2;
	TextField txtPWord1,txtPWord2;
	Button conf,back;
	Connection Con=null;
	Statement Stmt=null;
	WinNet()
	{
        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();
		conf=new Button("开通网上银行");
		back=new Button("返回");
		conf.addActionListener(this);
		back.addActionListener(this);
		Box boxH1,boxH2,boxH3,boxH4,boxH5,boxH6,boxH7;
		boxH1=Box.createHorizontalBox();
		boxH2=Box.createHorizontalBox();
		boxH3=Box.createHorizontalBox();
		boxH4=Box.createHorizontalBox();
		boxH5=Box.createHorizontalBox();
		boxH6=Box.createHorizontalBox();
		boxH7=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(Box.createHorizontalStrut(40));
		boxH6.add(conf);
		boxH7.add(Box.createHorizontalStrut(40));
		boxH7.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);
		p.add(baseBox);
		add(p);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==conf)
		{
			try
			{
				Lost();
			}
			catch(SQLException ee)
			{
				JOptionPane.showMessageDialog(this,"对不起,数据库连接失败,请稍候再试",
		    	"Warning",JOptionPane.WARNING_MESSAGE);
			}
		}	
		else if(e.getSource()==back)
		{
			String[] s={"调用"};
			UserFrame.main(s);
		}
		
	}
	public void Lost()throws SQLException
	{
		String 帐号,密码,网上银行,挂失;
		ResultSet rs=Stmt.executeQuery("SELECT * FROM 银行卡数据库");
		boolean boo=false;
		while((boo=rs.next())==true)
		{
			帐号=rs.getString("帐号");
			密码=rs.getString("密码");
			网上银行=rs.getString("网上银行");
			挂失=rs.getString("挂失");
			if(帐号.equals(text1.getText())&&密码.equals(text2.getText()))
			{
				if(挂失.equals("Y"))
				{
					JOptionPane.showMessageDialog(this,"对不起,您的卡已挂失,请先取消挂失!",
		  			"Warning",JOptionPane.WARNING_MESSAGE);
		  			break;
				}
				else if(网上银行.equals("N"))
				{
				    long l1=Long.parseLong(帐号);
				    long l2=Long.parseLong(密码);
				    long l3=Long.parseLong(txtPWord1.getText());
				    long l4=Long.parseLong(txtPWord2.getText());
				    if(l3!=l4)
				    {
				   	 	JOptionPane.showMessageDialog(this,"您两次输入登录码不一致,请重新输入!",
		  				"Warning",JOptionPane.WARNING_MESSAGE);
		  				break;
				    }
				    String temp1,temp2;
				    temp1="UPDATE 银行卡数据库 SET 网上银行 = 'Y' WHERE 帐号 = "+l1;
				    temp2="UPDATE 银行卡数据库 SET 网上银行登录码= "+l3+" WHERE 帐号="+l1;
					Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		            Stmt=Con.createStatement();
		            Stmt.executeUpdate(temp1);
		            Stmt.executeUpdate(temp2);
					JOptionPane.showMessageDialog(this,"您已成功开通网上银行,欢迎下次使用!",
		  			"Warning",JOptionPane.WARNING_MESSAGE);
		  			break;
				}
				else if(网上银行.equals("Y"))
				{
					JOptionPane.showMessageDialog(this,"您的卡已经拥有网上银行业务,请查证!",
		  			"Warning",JOptionPane.WARNING_MESSAGE);
		  			break;
				}
			}
		}
		Con.close();
		if(boo==false)
		{
			JOptionPane.showMessageDialog(this,"您还没有注册或帐号密码有错,请检查",
			"Warning",JOptionPane.WARNING_MESSAGE);
		}
	}
}

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