register.java

用java实现图书资料管理系统 操作系统：Windows 数据库：Windows Access 数据库 开发平台：NetBeans 开发语言：Java 语言

/*
 * register.java
 *
 * Created on 2007年12月18日, 下午11:12
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

/**
 *
 * @author Owner
 */
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.ButtonGroup;
import java.sql.*;
import java.util.*;
import java.util.Date;

public class register extends JPanel implements ActionListener
{
    Box basebox,box1,box2,box3,sexbox;
    JButton submit,reset;
    JTextField id,name,email,phone,address,post;
    JPasswordField password1,password2;
    Checkbox female,male;
    CheckboxGroup sex;
    /** Creates a new instance of register */
    public register() {
        id=new JTextField(15);
        password1=new JPasswordField(15);
        password2=new JPasswordField(15);
        name=new JTextField(15);
        email=new JTextField(15);
        phone=new JTextField(15);
        address=new JTextField(15);
        post=new JTextField(15);
        sex=new CheckboxGroup();
        female=new Checkbox("女",false,sex);
        male=new Checkbox("男",true,sex);
        submit=new JButton("提交");
        reset=new JButton("重设");
        submit.addActionListener(this);
        reset.addActionListener(this);

        sexbox=Box.createHorizontalBox();
        sexbox.add(male);
        sexbox.add(female);
        
        box1=Box.createVerticalBox();
        box1.add(new Label("用户名"));
        box1.add(Box.createVerticalStrut(8));
        box1.add(new Label("密码"));
        box1.add(Box.createVerticalStrut(8));
        box1.add(new Label("再一次输入密码"));
        box1.add(Box.createVerticalStrut(8));
        box1.add(new Label("姓名"));
        box1.add(Box.createVerticalStrut(8));
        box1.add(new Label("性别"));
        box1.add(Box.createVerticalStrut(8));
        box1.add(new Label("电子邮件"));
        box1.add(Box.createVerticalStrut(8));
        box1.add(new Label("电话"));
        box1.add(Box.createVerticalStrut(8));
        box1.add(new Label("地址"));
        box1.add(Box.createVerticalStrut(8));
        box1.add(new Label("邮编"));
        box1.add(Box.createVerticalStrut(15));
        box1.add(submit);
        
        box2=Box.createVerticalBox();
        box2.add(Box.createVerticalStrut(8));
        box2.add(id);
        box2.add(Box.createVerticalStrut(8));
        box2.add(password1);
        box2.add(Box.createVerticalStrut(8));
        box2.add(password2);
        box2.add(Box.createVerticalStrut(8));
        box2.add(name);
        box2.add(Box.createVerticalStrut(8));
        box2.add(sexbox);
        box2.add(Box.createVerticalStrut(8));
        box2.add(email);
        box2.add(Box.createVerticalStrut(8));
        box2.add(phone);
        box2.add(Box.createVerticalStrut(8));
        box2.add(address);
        box2.add(Box.createVerticalStrut(8));
        box2.add(post);
        box2.add(Box.createVerticalStrut(15));
        box2.add(reset);
        
        box3=Box.createHorizontalBox();
        box3.add(box1);
        box3.add(box2);
        
        basebox=Box.createVerticalBox();
        basebox.add(new Label("请如实填写下列信息:"));
        basebox.add(Box.createVerticalStrut(15));
        basebox.add(box3);
        add(basebox);
    }
    public void actionPerformed(ActionEvent e)
    {
        if(e.getSource()==submit)
        {
            if(id.getText().equals(""))
            {
                JOptionPane.showMessageDialog(this,"用户名不能为空");
            }
            else  if(password1.getText().equals(""))
            {
                JOptionPane.showMessageDialog(this,"密码不能为空");
            }
            else  if(password2.getText().equals(""))
            {
                JOptionPane.showMessageDialog(this,"密码不能为空");
            }
            else if(!password1.getText().equals(password2.getText()))
            {
                JOptionPane.showMessageDialog(this,"密码不一致,请重新输入并验证密码");
                password1.setText(null);
                password2.setText(null);
            }
            else  if(name.getText().equals(""))
            {
                JOptionPane.showMessageDialog(this,"姓名不能为空");
            }
            else  if(email.getText().equals(""))
            {
                JOptionPane.showMessageDialog(this,"电子邮箱不能为空");
            }
            else  if(phone.getText().equals(""))
            {
                JOptionPane.showMessageDialog(this,"电话不能为空");
            }
            else  if(address.getText().equals(""))
            {
                JOptionPane.showMessageDialog(this,"地址不能为空");
            }
            else  if(post.getText().equals(""))
            {
                JOptionPane.showMessageDialog(this,"邮编不能为空");
            }
            else
            {
                String sexstr;
                if(male.getState()==true)
                    sexstr="male";
                else
                    sexstr="female";
                reg insert=new reg(this,id.getText(),password1.getText(),name.getText(),sexstr,email.getText(),phone.getText(),address.getText(),post.getText());
                insert.importdata();
                
            }
        }
        else if(e.getSource()==reset)
        {
            id.setText(null);
            password1.setText(null);
            password2.setText(null);
            phone.setText(null);
            post.setText(null);
            name.setText(null);
            address.setText(null);
            email.setText(null);
        }
    }
}

class reg
{
    String id,password,name,phone,post,address,email,sex;
    register regist;
    Connection con;
    Statement sql;
    ResultSet rs;
    reg(register regist,String id,String password,String name,String sex,String email,String phone,String address,String post){
        this.regist=regist;
        this.id=id;
        this.password=password;
        this.name=name;
        this.sex=sex;
        this.email=email;
        this.phone=phone;
        this.address=address;
        this.post=post;
    }
    public void importdata()
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }
        catch(ClassNotFoundException e2){}
        try
        {
            con=DriverManager.getConnection("jdbc:odbc:sample","std","123");
            sql=con.createStatement();
            Date date=new Date();
            String instr;
            instr="select * from user";
            rs=sql.executeQuery(instr);
            boolean flag=false;
            while(rs.next())
            {
                if(rs.getString("id").equals(id)){
                    JOptionPane.showMessageDialog(regist,id+"已经被人占用");
                    flag=true;
                }
            }
            if(flag==false)
            {
                instr="insert into user values('"+id+"','"+password+"','"+name+"','"+sex+"','"+email+"','"+address+"','"+phone+"','"+post+"','"+date.toString()+"')";
                sql.executeUpdate(instr);
                JOptionPane.showMessageDialog(regist,id+"注册成功");
            }
        }
        catch(SQLException e3)
        {
            System.out.println(e3);
        }
    }
}