mnetframe.java

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

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

class WinMNet extends Frame implements ActionListener 
{
	TextField text1,text2;
	Button conf,back;
	Connection Con=null;
	Statement Stmt=null;
	WinMNet()
	{
        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('*');
		conf=new Button("注销网上银行");
		conf.addActionListener(this);
		back=new Button("返回");
		back.addActionListener(this);
		Box boxH1,boxH2,boxH3,boxH4,boxH5;
		boxH1=Box.createHorizontalBox();
		boxH2=Box.createHorizontalBox();
		boxH3=Box.createHorizontalBox();
		boxH4=Box.createHorizontalBox();
		boxH5=Box.createHorizontalBox();
		boxH1.add(new Label("请输入您的帐号和密码:"));
		boxH2.add(new Label("帐号:"));
		boxH2.add(text1);
		boxH3.add(new Label("密码:"));
		boxH3.add(text2);
		boxH4.add(Box.createHorizontalStrut(50));
		boxH4.add(conf);
		boxH5.add(Box.createHorizontalStrut(50));
		boxH5.add(back);
		Box baseBox;
		baseBox=Box.createVerticalBox();
		baseBox.add(boxH1);
		baseBox.add(boxH2);
		baseBox.add(boxH3);
		baseBox.add(boxH4);
		baseBox.add(boxH5);
		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={"调用"};
			ManageFrame.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("网上银行");
			if(帐号.equals(text1.getText())&&密码.equals(text2.getText()))
			{
				if(网上银行.equals("Y"))
				{
				    long l1=Long.parseLong(帐号);
				    long l2=Long.parseLong(密码);
				    String temp;
				    temp="UPDATE 银行卡数据库 SET 网上银行 = 'N' WHERE 帐号 = "+l1;
					Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		            Stmt=Con.createStatement();
		            Stmt.executeUpdate(temp);
					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 MNetFrame
{
	public static void main(String args[])
	{
		WinMNet window=new WinMNet();
		window.setBounds(100,100,300,300);
		window.setVisible(true);
		window.addWindowListener(new WindowAdapter()
		{
			public void windowClosing(WindowEvent e)
			{
				System.exit(0);
			}
		});
	}
}