useradd.java

java 开发的图书管理系统~~~。可以实现很多功能

package bookmanager;
import javax.swing.*;
import java.awt.event.*;
import java.awt.GridLayout;
import java.sql.*;

public class userAdd extends JFrame implements ActionListener
{
	public userAdd()
	{
		setTitle("添加用户");
		setSize(200,200);
		gl=new GridLayout(5,2,20,20);
		JPanel panel=new JPanel();
		panel.setLayout(gl);
		userlbl=new JLabel("用户名");
		passwordlbl=new JLabel("密码(如果是借阅用户则密码为1)");
		confirmlbl=new JLabel("确认密码");
		powerlbl=new JLabel("登陆权限");
		usertex=new JTextField("");
		passwordtex=new JPasswordField("");
		confirmtex=new JPasswordField("");
		String[] str={"管理员","借阅操作员","书籍管理员","借阅用户"};
		powercob=new JComboBox(str);
		addbtn=new JButton("确认");
		cancelbtn=new JButton("取消");
		panel.add(userlbl);
		panel.add(usertex);
		panel.add(passwordlbl);
		panel.add(passwordtex);
		panel.add(confirmlbl);
		panel.add(confirmtex);
		panel.add(powerlbl);
		panel.add(powercob);
		panel.add(addbtn);
		panel.add(cancelbtn);
		getContentPane().add(panel);
		addbtn.addActionListener(this);
		cancelbtn.addActionListener(this);
		
		
	}
	public void actionPerformed(ActionEvent e)
	{
		Object source=e.getSource();
		if(source==addbtn)
		{
			if(usertex.getText().trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"用户名不能为空!");
			return;
		}
		String  s=new String(passwordtex.getPassword()).trim();
		if(s.equals(""))
		{
			JOptionPane.showMessageDialog(null,"密码名不能为空!");
			return;
		}
		String confirm=new String(confirmtex.getPassword()).trim();
		if(confirm.equals("")||!(confirm.equals(s)))
		{
			JOptionPane.showMessageDialog(null,"密码不一样");
			confirmtex.setText("");
			usertex.setText("");
			passwordtex.setText("");
			return;
		}
		String power=(String)powercob.getSelectedItem();
		if(power.equals("借阅用户"))
		{
			String strsql;
			strsql=("insert into user(username) values ('"+usertex.getText().trim()+"')");
			System.out.println(strsql);
			boolean success=db.executeSql(strsql);
			//判断结果是否正确
			if(!success){
				JOptionPane.showMessageDialog(null,"添加用户不成功，请从新再添加");
			}
			else{
				JOptionPane.showMessageDialog(null,"添加成功");
			}
			this.dispose();
		}
		else
		{
			String strsql=("insert into admin(username,password,power) values ('"+usertex.getText().trim()+"','"+s+"','"+power+"')");
			System.out.println(strsql);
			boolean success=db.executeSql(strsql);
			//判断结果是否正确
			if(!success){
				JOptionPane.showMessageDialog(null,"添加用户不成功，请从新再添加");
			}
			else{
				JOptionPane.showMessageDialog(null,"添加成功");
			}
			this.dispose();
		}
		if(source==cancelbtn)
		{
			this.dispose();
			return;
		}
	}
		/*
			String user=usertex.getText();
			ch=passwordtex.getPassword();
			String password=new String(ch);
			if(user.trim().equals(""))
			{
			JOptionPane.showMessageDialog(null,"用户名不能为空!");
			return;
		}
		if(password.trim().equals(""))
		{
			JOptionPane.showMessageDialog(null,"密码名不能为空!");
			return;
		}
			if(user.equals("admin")&&password.equals("admin"))
			{
				myBook.setEnabled("管理员");
			}
			if(user.equals("borrowcontrol")&&password.equals("borrowcontrol"))
			{
				myBook.setEnabled("借阅操作员");
			}
			if(user.equals("bookcontrol")&&password.equals("bookcontrol"))
			{
				myBook.setEnabled("书籍管理员");
			}
			this.dispose();
		}*/
		if(source==cancelbtn)
		{
			
			this.dispose();
			return;
		}
		}
	
	private JLabel userlbl;
	private JLabel passwordlbl;
	private JLabel confirmlbl;
	private JLabel powerlbl;
	private JTextField usertex;
	private JPasswordField passwordtex;
	private JPasswordField confirmtex;
	private JComboBox powercob;
	private JButton addbtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private ResultSet rs;
	private DBManager db=new DBManager();
}