openframe.java

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

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

class WinOpen extends Frame implements ActionListener 
{
	TextField txtName,txtP1,txtP2,txtCont,txtAdd;
	Button conf,back;
	Connection Con=null;
	Statement Stmt=null;
	WinOpen()
	{
		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();
		conf=new Button("开户");
		back=new Button("返回");
		conf.addActionListener(this);
		back.addActionListener(this);
		txtName=new TextField();
		txtP1=new TextField();
		txtP2=new TextField();
		txtCont=new TextField();
		txtAdd=new TextField();
		txtP1.setEchoChar('*');
		txtP2.setEchoChar('*');
		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(txtP1);
		Box box4=Box.createHorizontalBox();
		box4.add(new Label("确认密码:"));
		box4.add(txtP2);
		Box box5=Box.createHorizontalBox();
		box5.add(new Label("联系方式:"));
		box5.add(txtCont);
		Box box6=Box.createHorizontalBox();
		box6.add(new Label("家庭住址:"));
		box6.add(txtAdd);
		Box box7=Box.createHorizontalBox();
		box7.add(Box.createHorizontalStrut(100));
		box7.add(conf);
		Box box8=Box.createHorizontalBox();
		box8.add(Box.createHorizontalStrut(100));
		box8.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);
		p.add(baseBox);add(p);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==conf)
		{
			try
			{
				open();
			}
			catch(SQLException ee)
			{
				JOptionPane.showMessageDialog(this,"对不起,数据库连接失败,请稍候再试",
		    	"Warning",JOptionPane.WARNING_MESSAGE);
		    }
		}
		else if(e.getSource()==back)
		{
			String [] s={"调用"};
			UserFrame.main(s);
		}
	}
	public void open()throws SQLException
	{
		try
		{
			if(!txtP1.getText().equals(txtP2.getText()))
			{
				JOptionPane.showMessageDialog(this,"您两次输入的密码不一致,请查证后再输入!",
		     	"Warning",JOptionPane.WARNING_MESSAGE);
			}
			else 
			{
				long 帐,帐max;
				帐max=0;
				boolean boo=false;
				ResultSet rs=Stmt.executeQuery("SELECT * FROM 银行卡数据库");;
				while((boo=rs.next())==true)
				{
					String zhanghao=rs.getString("帐号");
					帐=Long.parseLong(zhanghao);
					if(帐>帐max)
					{
						帐max=帐;
					}
				}
				帐max=帐max+1;
				String number="'"+String.valueOf(帐max)+"'";
				String name="'"+txtName.getText()+"'";
				String passWord="'"+txtP1.getText()+"'";
				String contact="'"+txtCont.getText()+"'";
				String address="'"+txtAdd.getText()+"'";
				String temp;
				String n="'"+"N"+"'";
				temp="INSERT INTO 银行卡数据库 VALUES ("+number+","+name+","+passWord+","
				      +'0'+","+contact+","+address+","+n+","+n+","+'0'+")";
				Con=DriverManager.getConnection("jdbc:odbc:Bank","杨高","yanggao");
		  	    Stmt=Con.createStatement();
		  	    Stmt.executeUpdate(temp);
		        JOptionPane.showMessageDialog(this,"祝贺您,您已成功开户!您的帐号是"+
		         number+"请保留好您的密码!","Warning",JOptionPane.WARNING_MESSAGE);
		    }
		}
		catch(NumberFormatException e1)
		{
			JOptionPane.showMessageDialog(this,"请您完整填写您的个人信息!",
		   	"Warning",JOptionPane.WARNING_MESSAGE);
		}
	}
}

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