addpanel.java

这是一个超市管理系统

package file2;
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
public class addPanel extends JPanel implements ActionListener{
	private DBConnection con=null;
	private JLabel tip=null;
	private JLabel name=null;
	private JLabel password=null;
	private JLabel rePassword=null;
	private JTextField nameTextField=null;
	private JTextField rePasswordTextField=null;
	private JTextField passwordTextField=null;
	private JButton confirm=null;
	private JButton reset=null;
	private JPanel tipPanel=null;//用来装载tip标签
	private JPanel nameAndPasswordPanel=null;
	private JPanel buttonsPanel=null;
	private JPanel echoPanel=null;//用来装载nameAndPasswordPanel和buttonsPanel
	public addPanel(){
		tip=new JLabel("请在下面输入要添加的管理员的名字和密码.");
		name=new JLabel("名字:");
		password=new JLabel("密码:");
		rePassword=new JLabel("再次输入密码:");
		nameTextField=new JTextField(20);
		passwordTextField=new JTextField(20);
		rePasswordTextField=new JTextField(20);
		confirm=new JButton("确定");
		reset=new JButton("重置");
		//添加tipPanel
		tipPanel=new JPanel();
		tipPanel.setLayout(new FlowLayout(FlowLayout.CENTER));
		tipPanel.add(tip);
		//添加nameAndPasswordPanel
		nameAndPasswordPanel=new JPanel();
		nameAndPasswordPanel.setLayout(new GridLayout(3,2));
		nameAndPasswordPanel.add(name);
		nameAndPasswordPanel.add(nameTextField);
		nameAndPasswordPanel.add(password);
		nameAndPasswordPanel.add(passwordTextField);
		nameAndPasswordPanel.add(rePassword);
		nameAndPasswordPanel.add(rePasswordTextField);
		//添加buttonsPanel
		buttonsPanel=new JPanel();
		buttonsPanel.setLayout(new FlowLayout(FlowLayout.CENTER));
		buttonsPanel.add(confirm);
		buttonsPanel.add(reset);
		//添加nameAndPasswordPanel和buttonsPanel
		echoPanel=new JPanel();
		echoPanel.setLayout(new GridLayout(2,1));
		echoPanel.add(nameAndPasswordPanel);
		echoPanel.add(buttonsPanel);
		this.setLayout(new GridLayout(2,1));
		this.add(tipPanel);
		this.add(echoPanel);
		confirm.addActionListener(this);
		reset.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e){
		if(e.getSource()==reset){
			nameTextField.setText("");
			passwordTextField.setText("");
			rePasswordTextField.setText("");
			return;
		}
		if(e.getSource()==confirm){
			String name=nameTextField.getText().trim();
			String password=passwordTextField.getText().trim();
			String rePassword=rePasswordTextField.getText().trim();
			if(!(password.equals(rePassword))){
				JOptionPane.showMessageDialog(null, "两次输入的密码不一致，请您重新输入!", "警告",JOptionPane.ERROR_MESSAGE);
				return;
			}
			String querySql="select* from administrator where administrator='"+name+"' and password='"+password+"'";
			String insertSql="insert into administrator values('"+name+"','"+password+"')";
			con=new DBConnection();
			try{
				ResultSet rs=con.executeSelect(querySql);
				if(rs.next()){
					JOptionPane.showMessageDialog(null, "该管理员已经存在，请您重新输入!", "警告",JOptionPane.ERROR_MESSAGE);
					return;
				} 
				con.executeDML(insertSql);
				JOptionPane.showMessageDialog(null, "该管理员已经添加成功!", "提示",JOptionPane.INFORMATION_MESSAGE);
				return;
			}catch(SQLException sqle){
				JOptionPane.showMessageDialog(null, "插入过程中发生错误，请您重新输入!", "提示",JOptionPane.ERROR_MESSAGE);
				return;
			}
		}
	}
}