资费管理系统（register）

package Tariff;

import java.awt.Container;
import java.awt.Dialog; 
import java.awt.GridLayout; 
import java.awt.event.ActionEvent; 
import java.awt.event.ActionListener; 
import java.awt.event.ItemEvent; 
import java.awt.event.ItemListener; 
import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.SQLException; 
import java.sql.Statement; 
import javax.swing.ButtonGroup; 
import javax.swing.JButton; 
import javax.swing.JComboBox; 
import javax.swing.JFrame; 
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel; 
import javax.swing.JPasswordField; 
import javax.swing.JRadioButton;
import javax.swing.JTextField; 
public class register extends JFrame 
implements ActionListener,ItemListener {
	private JFrame app; 
	private JTextField 用户名,密码,确认密码,姓名,联系电话,e_mail地址; 
	private JRadioButton 男,女; 
	private JRadioButton 银行转账,现金支付,邮政汇款,其它;
	private JComboBox 省份,开通状态; 
	private JButton 下一步,重新填写; 
	private Dialog dialog; 
	public register() {
	app=new JFrame("现在注册"); 
	app.setSize(600,500); 
	app.setLocation(200,140); 
	app.setDefaultCloseOperation(EXIT_ON_CLOSE); 
	Container c=app.getContentPane(); 
    c.setLayout(new GridLayout(1,3));
    JPanel p1=new JPanel();       
    p1.setLayout(new GridLayout(12,1,0,10));
    p1.add(new JLabel("注册步骤"));
    p1.add(new JLabel("一、阅读并同意协议"));
    p1.add(new JLabel("二，填写表单"));
    p1.add(new JLabel("三、完成注册"));   
    c.add(p1);
    
    JPanel p2=new JPanel();
    JPanel p3=new JPanel();
    c.add(p2);
    c.add(p3);
    p2.setLayout(new GridLayout(12,1,0,10));
    p3.setLayout(new GridLayout(12,1,0,10));
    
    p2.add(new JLabel("用户名"));        
    用户名=new JTextField(10);
    p3.add(用户名);
    p2.add(new JLabel("性 别"));
    ButtonGroup 性别=new ButtonGroup();
    男=new JRadioButton("男",true);
    性别.add(男);
    女=new JRadioButton("女",false);
    性别.add(女);
    JPanel p31=new JPanel();
    p31.setLayout(new GridLayout(1,2));
    p31.add(男);
    p31.add(女);
    
    p3.add(p31);
    p2.add(new JLabel("密 码"));
    密码=new JPasswordField(10);
    p3.add(密码);
    p2.add(new JLabel("确认密码"));
    确认密码=new JPasswordField(10);
    p3.add(确认密码);
    
    p2.add(new JLabel("姓名："));
    姓名=new JTextField(10);
    p3.add(姓名);
    p2.add(new JLabel("联系电话："));
    联系电话=new JTextField(10);
    p3.add(联系电话);
    p2.add(new JLabel("省份："));
    
    Object province[]={"北京","上海","河南"};
    省份=new JComboBox(province);
    p3.add(省份);
    p2.add(new JLabel("付款方式"));
    ButtonGroup 方式=new ButtonGroup();
    银行转账=new JRadioButton("银行转账");
    方式.add(银行转账);
    现金支付=new JRadioButton("现金支付");
    方式.add(现金支付);
    邮政汇款=new JRadioButton("邮政汇款");
    方式.add(邮政汇款);
    其它=new JRadioButton("其它");
    方式.add(其它);
    JPanel p32=new JPanel();
    p32.setLayout(new GridLayout(1,4));
    p32.add(银行转账);
    p32.add(现金支付);
    p32.add(邮政汇款);
    p32.add(其它);
    
    p3.add(p32);
    p2.add(new JLabel("开通状态"));
    Object zhuangtai[]={"开通","未开通"};
    开通状态=new JComboBox(zhuangtai);
    p3.add(开通状态);
    开通状态.addItemListener(this);
    
    p2.add(new JLabel("E-mail地址"));
    e_mail地址=new JTextField(10);
    p3.add(e_mail地址);
    下一步=new JButton("下一步");
    p2.add(下一步);        
    下一步.addActionListener(this);
    重新填写=new JButton("重新填写");   
    p3.add(重新填写);
    重新填写.addActionListener(this);
    app.setVisible(true);
}
public void itemStateChanged(ItemEvent f)
{
    
}
public void actionPerformed(ActionEvent e)
{
    if(密码.getText().equals(确认密码.getText()))
    {
        if(e.getSource()==下一步)
        {
            Connection con;
            Statement stmt;
            try
            {
                Class.forName("com.mysql.jdbc.Driver");
            }
            catch(ClassNotFoundException ce)
            {
                 System.out.println("SQLException:"+ce.getLocalizedMessage());
            }
            try
            {
                con=DriverManager.getConnection("jdbc:mysql://localhost:3000/ipttm","root","123456");
                stmt=con.createStatement();
                
                String xb="";
                if(男.isSelected())
                    xb=男.getText();
                if(女.isSelected())
                    xb=女.getText();
                String sf="";
                if(省份.getSelectedIndex()==0)
                    sf="河南省";
                if(省份.getSelectedIndex()==1)
                    sf="北京";
                if(省份.getSelectedIndex()==2)
                    sf="上海";
                String fs="";     
                if(银行转账.isSelected())
                    fs="银行转账";
                if(现金支付.isSelected())
                    fs="现金支付";
                if(邮政汇款.isSelected())
                    fs="邮政汇款";
                if(其它.isSelected())
                    fs="其它";
                String zt="";
                if(开通状态.getSelectedIndex()==0)
                    zt="开通";
                if(开通状态.getSelectedIndex()==1)
                    zt="未开通";
                String sqlstr="INSERT INTO consumer"+"(id,sex,password,name,telephone,province,methord,state,mail)"+
                        "VALUES ("+"'"+用户名.getText()+"'"+","+"'"+xb+"'"+","+"'"+密码.getText()+"'"+
                             ","+"'"+姓名.getText()+"'"+","+"'"+联系电话.getText()+"'"+","+"'"+sf+"'"+","+"'"+fs+"'"+
                        ","+"'"+zt+"'"+","+"'"+e_mail地址.getText()+"'"+")";
                stmt.executeUpdate(sqlstr);                    
                stmt.close();
                con.close();                    
                new login();
                app.setVisible(false);
            }
            catch(SQLException f)
            {
                System.out.println("SQLException:"+f.getMessage());
            }
        }
    }
    else
    {
        JOptionPane.showMessageDialog(this,"对不起!两次密码输入不同，请重新输入！",
                                  "系统提示",JOptionPane.INFORMATION_MESSAGE); 
        用户名.setText("");
        密码.setText("");
        确认密码.setText("");
        姓名.setText("");
        联系电话.setText("");
        e_mail地址.setText("");
        this.setVisible(false);
    }
    if(e.getSource()==重新填写)
    {
        用户名.setText("");
        密码.setText("");
        确认密码.setText("");
        姓名.setText("");
        联系电话.setText("");
        e_mail地址.setText("");
    }
}
}