mforgetframe.java

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

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

class WinFor extends Frame implements ActionListener
{
	TextField number,name;
	Button conf,back;
	Connection Con=null;
	Statement Stmt=null;
	WinFor()
	{
		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();
		number=new TextField();
		name=new TextField();
		conf=new Button("确定挂失");
		back=new Button("返回");
		conf.addActionListener(this);
		back.addActionListener(this);
		Box box1=Box.createHorizontalBox();
		box1.add(new Label("帐号:"));
		box1.add(number);
		Box box2=Box.createHorizontalBox();
		box2.add(new Label("用户名"));
		box2.add(name);
		Box box3=Box.createHorizontalBox();
		box3.add(Box.createHorizontalStrut(100));
		box3.add(conf);
		Box box4=Box.createHorizontalBox();
		box4.add(Box.createHorizontalStrut(100));
		box4.add(back);
		Box baseBox=Box.createVerticalBox();
		baseBox.add(box1);baseBox.add(box2);
		baseBox.add(box3);baseBox.add(box4);
		p.add(baseBox);add(p);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==conf)
		{
			try
			{
				forget();
			}
			catch(SQLException e1)
			{
				JOptionPane.showMessageDialog(this,"对不起,数据库连接失败,请稍候再试!",
		  		"Warning",JOptionPane.WARNING_MESSAGE);
			}
			catch(NumberFormatException e2)
			{
				JOptionPane.showMessageDialog(this,"请完整输入您的帐号密码信息!",
		  		"Warning",JOptionPane.WARNING_MESSAGE);
			}
		}
		else if(e.getSource()==back)
		{
			String[] s={"调用"};
			ManageFrame.main(s);
		}	
	}
	public void forget()throws SQLException
	{
		String 帐号,用户名,挂失;
		Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		Stmt=Con.createStatement();
		ResultSet rs=Stmt.executeQuery("SELECT * FROM 银行卡数据库");
		boolean boo=false;
		while((boo=rs.next())==true)
	    {
	    	帐号=rs.getString("帐号");
	    	用户名=rs.getString("用户名");
	    	挂失=rs.getString("挂失");
	    	if(帐号.equals(number.getText())&&用户名.equals(name.getText()))
	    	{
	    		if(挂失.equals("Y"))
	    		{
	    			JOptionPane.showMessageDialog(this,"您的卡本已挂失!",
		  		    "Warning",JOptionPane.WARNING_MESSAGE);
		  		    break;
	    		}
	    		else
	    		{
	    			long l1=Long.parseLong(帐号);
	    			String temp;
			    	temp="UPDATE 银行卡数据库 SET 挂失 = 'Y' WHERE 帐号 = "+l1;
					Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		        	Stmt=Con.createStatement();
		        	Stmt.executeUpdate(temp);
	     			JOptionPane.showMessageDialog(this,"您已成功挂失,欢迎下次使用!",
		  			"Warning",JOptionPane.WARNING_MESSAGE);
		  			break;
		  		}
		  	}
	    }
	    Con.close();
		if(boo==false)
		{
			JOptionPane.showMessageDialog(this,"您还没有注册或帐号用户名有错,请检查",
			"Warning",JOptionPane.WARNING_MESSAGE);
		}
	}
}

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