adduser.java

这是一个用java语言开发的运动员成绩统计系统

package com.userManager;
import com.DBManager.MyDB;
import com.MainFrame;
import java.awt.Dimension;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.Box;
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.JTextField;


/**
 * @author  Laiger
 */
public class AddUser extends JFrame implements ActionListener {
	

	JPanel p=new JPanel();
	JLabel userID=new JLabel("帐号");
	JLabel name=new JLabel("姓名");
	JLabel sex=new JLabel("性别");
	JLabel password=new JLabel("密码");
	JLabel password2=new JLabel("确认密码");
	
	JLabel power=new JLabel("权限");
	JTextField t_userID=new JTextField(10);
	JTextField t_username=new JTextField(10);
    JComboBox combo_sex;
	TextField t_pass=new TextField(10);
    TextField t_pass2=new TextField(10);
    JComboBox combo;
    Box base;
    Box box1;
    Box box2;
	JButton confirm=new JButton("添加");
	JButton cancel=new JButton("取消");
	private MainFrame m;
	private MyDB db=new MyDB();
	public AddUser(MainFrame m){
		
		super("Add User");
		this.m=m;
		initialize();
		String[] power_type={"管理员","操作员"};
		String[] s_sex={"男","女"};
		 combo=new JComboBox(power_type);
		 combo.setEditable(false);
		 this.setResizable(false);
		 combo_sex=new JComboBox(s_sex);
		 
		this.setBounds(300,300,300,250);
		this.setVisible(true);
		t_pass.setEchoChar('*');
		t_pass2.setEchoChar('*');
		confirm.addActionListener(this);
		cancel.addActionListener(this);
		box1=Box.createVerticalBox();
		box2=Box.createVerticalBox();
		base=Box.createHorizontalBox();
		box1.add(userID);
		box1.add(Box.createVerticalStrut(5));
		box1.add(name);
		
		box1.add(Box.createVerticalStrut(5));
		box1.add(password);
		box1.add(Box.createVerticalStrut(5));
		box1.add(password2);
		box1.add(Box.createVerticalStrut(5));
		box1.add(sex);
		box1.add(Box.createVerticalStrut(5));
		box1.add(power);
		box1.add(Box.createVerticalStrut(50));
		box1.add(confirm);
		
		box2.add(t_userID);
		box2.add(t_username);
		box2.add(t_pass);
		box2.add(t_pass2);
		box2.add(combo_sex);
		box2.add(combo);
		
		box2.add(Box.createVerticalStrut(45));
		box2.add(cancel);
		
		
		base.add(box1);
		base.add(Box.createHorizontalStrut(20));
		base.add(box2);
		p.add(base);
		add(p);
		
		
		this.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				dispose();
			}
		});
	}
	/**
	 * This method initializes this
	 * 
	 */
	private void initialize() {
        this.setSize(new Dimension(351, 310));
        this.setTitle("添加用户");
			
	}
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==cancel){
			m.setVisible(true);
			this.dispose();
		}
		else
		{
			 if(t_userID.getText().trim().equals(""))
			  {
			   JOptionPane.showMessageDialog(this, "帐号不可为空！");
			   return;
			  }
			  if(t_pass.getText().trim().equals(""))
			  {
				  JOptionPane.showMessageDialog(this, "密码不可为空！");
				   return;
			  }
			  if(t_username.getText().trim().equals("")){
				  JOptionPane.showMessageDialog(this, "姓名不可为空！");
				  return;
			  }
			  if(t_pass2.getText().trim().equals(""))
			  {
				  JOptionPane.showMessageDialog(this, "第二次输入的密码不可为空！");
				   return; 
			  }
			  if(!t_pass.getText().trim().equals(t_pass2.getText().trim()))
			  {
				  JOptionPane.showMessageDialog(this, "两次输入的密码不同！");
				   return; 
			  }
			  
			String  strSQL="select * from user where userID='"+t_userID.getText().trim()+"'";
			 db.connectDB();
		int count=db.rowCount(strSQL);
			
			 if(count>=1){
				 JOptionPane.showMessageDialog(this, "用户已经存在！");  
			 }
			 else {
				 strSQL ="insert into user(userId,Power,name,password,sex) values('";
				 strSQL+=t_userID.getText().trim()+"','";
				 strSQL+=combo.getSelectedItem().toString().trim()+"','";
				 strSQL+=t_username.getText().trim()+"','";
				 strSQL+=t_pass.getText().trim()+"','";
				 strSQL+=combo_sex.getSelectedItem().toString().trim()+"')";
				 if(db.executeUpdate(strSQL))
				 {
					 JOptionPane.showMessageDialog(this, "添加成功！");
					   this.dispose();   
				 }
				 else{
					 JOptionPane.showMessageDialog(this, "添加失败，请重新操作！"); 
				 }
			 }
			 db.close();
		}
		
	}
}  //  @jve:decl-index=0:visual-constraint="10,10"