changeframe.java

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

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

class WinCha extends Frame implements ActionListener 
{
	Button change,back;
	TextField txtName,txtWord;
	TextField txtNWord1,txtNWord2;
	TextField txtCont,txtAdd;
	Connection Con=null;
	Statement Stmt=null;
	WinCha()
	{
		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();
		change=new Button("更新");
		back=new Button("返回");
		change.addActionListener(this);
		back.addActionListener(this);
		txtName=new TextField();
		txtWord=new TextField();
		txtWord.setEchoChar('*');
		txtNWord1=new TextField();
		txtNWord2=new TextField();
		txtNWord1.setEchoChar('*');
		txtNWord2.setEchoChar('*');
		txtCont=new TextField();
		txtAdd=new TextField();
		Box box1=Box.createHorizontalBox();
		box1.add(new Label("旧  信  息:"));
		Box box2=Box.createHorizontalBox();
		box2.add(new Label("帐      号:"));
		box2.add(txtName);
		Box box3=Box.createHorizontalBox();
		box3.add(new Label("密      码:"));
		box3.add(txtWord);
		Box box4=Box.createHorizontalBox();
		box4.add(new Label("新  信  息:"));
		Box box5=Box.createHorizontalBox();
		box5.add(new Label("新  密  码:"));
		box5.add(txtNWord1);
		Box box6=Box.createHorizontalBox();
		box6.add(new Label("确认密码:"));
		box6.add(txtNWord2);
		Box box7=Box.createHorizontalBox();
		box7.add(new Label("如果要修改密码,以上两项都要填写."));
		Box box8=Box.createHorizontalBox();
		box8.add(new Label("联系方式:"));
		box8.add(txtCont);
		Box box9=Box.createHorizontalBox();
		box9.add(new Label("家庭住址:"));
		box9.add(txtAdd);
		Box box10=Box.createHorizontalBox();
		box10.add(Box.createHorizontalStrut(100));
		box10.add(change);
		Box box11=Box.createHorizontalBox();
		box11.add(Box.createHorizontalStrut(100));
		box11.add(back);
		Box baseBox=Box.createVerticalBox();
		baseBox.add(box1);baseBox.add(box2);baseBox.add(box3);
		baseBox.add(box4);baseBox.add(box5);baseBox.add(box6);
		baseBox.add(box7);baseBox.add(box8);baseBox.add(box9);
		baseBox.add(box10);baseBox.add(box11);
		p.add(baseBox);add(p);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==change)
		{
			try
			{
				if(txtNWord1.getText().equals("")&&txtNWord2.getText().equals("")&&
				    txtCont.getText().equals("")&&txtAdd.getText().equals(""))
				{
					JOptionPane.showMessageDialog(this,"请输入新信息!",
		        	"Warning",JOptionPane.WARNING_MESSAGE);
				}
				else if(!txtNWord1.getText().equals("")&&txtNWord2.getText().equals(""))
				{
					JOptionPane.showMessageDialog(this,"请同时输入新密码和确认密码!",
		        	"Warning",JOptionPane.WARNING_MESSAGE);
				}
				else if(txtNWord1.getText().equals("")&&!txtNWord2.getText().equals(""))
				{
					JOptionPane.showMessageDialog(this,"请同时输入新密码和确认密码!",
		        	"Warning",JOptionPane.WARNING_MESSAGE);
				}
				else if(!txtNWord1.getText().equals(txtNWord2.getText()))
				{
					JOptionPane.showMessageDialog(this,"您两次输入登录码不一致,请重新输入!",
			  		"Warning",JOptionPane.WARNING_MESSAGE);
				}
				else
				{
					Change();
				}
			}
			catch(SQLException ee)
			{
				JOptionPane.showMessageDialog(this,"对不起,数据库连接失败,请稍候再试",
		    	"Warning",JOptionPane.WARNING_MESSAGE);
			}
			catch(NumberFormatException e2){}
		}
		else if(e.getSource()==back)
		{
			String [] s={"调用"};
			UserFrame.main(s);
		}
	}
	public void Change()throws SQLException
	{
		try
		{
			String 帐号,密码,挂失,联系方式,家庭住址;
			ResultSet rs=Stmt.executeQuery("SELECT * FROM 银行卡数据库");
			boolean boo=false;
			while((boo=rs.next())==true)
			{
				帐号=rs.getString("帐号");
				密码=rs.getString("密码");
				挂失=rs.getString("挂失");
				if(帐号.equals(txtName.getText())&&密码.equals(txtWord.getText()))
				{
					if(挂失.equals("Y"))
					{
						JOptionPane.showMessageDialog(this,"对不起,您的卡已挂失,请先取消挂失!",
		  		   	    "Warning",JOptionPane.WARNING_MESSAGE);
		  		   	    break;
		  		   	}
		  		   	else
		  		   	{
						long l1=Long.parseLong(帐号);
				     	long l2=Long.parseLong(密码);
				   		String temp;
				   		if(!txtNWord1.getText().equals(""))
				    	{
				    		String word="'"+txtNWord1.getText()+"'";
			  		    	temp="UPDATE 银行卡数据库 SET 密码 = "+word+" WHERE 帐号 ="+l1;
			    			Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		    	  	    	Stmt=Con.createStatement();
		    	  	    	Stmt.executeUpdate(temp);
		    	  		}
		    			if(!txtCont.getText().equals(""))
		    			{
		    				String cont="'"+txtCont.getText()+"'";
		    				temp="UPDATE 银行卡数据库 SET 联系方式 = "+cont+" WHERE 帐号 ="+l1;
		    				Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		    		    	Stmt=Con.createStatement();
		    		    	Stmt.executeUpdate(temp);
		    			}
		    			if(!txtAdd.getText().equals(""))
		    			{
		    				String add="'"+txtAdd.getText().trim()+"'";
		    				temp="UPDATE 银行卡数据库 SET 家庭住址 = "+add+" 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);
			}
		}
		catch(NumberFormatException e1){}
	}
}

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