addadmin.java

来自「用Jsp实现的图书管理系统代码」· Java 代码 · 共 86 行

//源程序名：AddAdmin.java
//这是添加管理员的类
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class AddAdmin extends JFrame implements ActionListener{
	JLabel lbUser=new JLabel("帐号:");
	JLabel lbPass=new JLabel("密码:");
	JLabel lbPass9=new JLabel("确认密码:");
	String AdminName[]={"当前已存在的管理员"};
	List listAllAdmin=new List();
	JTextField tfUser=new JTextField(7);
	JTextField tfPass=new JTextField(7);
	JTextField tfPass9=new JTextField(7);
	JButton btnAdd=new JButton("添加");
	JButton btnClose=new JButton("取消");
	JPanel jpanel=new JPanel();
	JPanel pNorth=new JPanel();
	JPanel pCenter=new JPanel();
	JPanel pWest=new JPanel();
	JTextArea ta=new JTextArea(10,10);
	AddAdmin(){
		super("添加管理员");
		setSize(500,400);
		setContentPane(jpanel);
		jpanel.setLayout(new BorderLayout());
        jpanel.add("Center",pCenter);pCenter.setLayout(new GridLayout(3,1));pCenter.add(listAllAdmin);listAllAdmin.add("当前已存在的管理员");pCenter.add(ta);
		jpanel.add("North",pNorth);
		pNorth.add(lbUser);pNorth.add(tfUser);
		pNorth.add(lbPass);pNorth.add(tfPass);
		pNorth.add(lbPass9);pNorth.add(tfPass9);
		pNorth.add(btnAdd);pCenter.add(btnClose);
		setLocation(200,150);
		setVisible(true);
		validate();
		btnAdd.addActionListener(this);
		btnClose.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e)
		{
		    DatabaseConn addadmin=new DatabaseConn();
			if (e.getSource()==btnAdd)
			{
				String sql="";
				
				String strUser=tfUser.getText();
				String strPass=tfPass.getText();
				String strPass9=tfPass9.getText();
                            if(!strPass.equals(strPass9)){
						
						
						
						validate();
						return;
							}
						else if (strUser==""||strPass=="")
							{
								removeAll();
						        add(new JLabel("帐号和密码都不能为空！请重新输入"));
						        
						        validate();
						return;
							}

              else
                sql="insert into admin(admin_username,admin_userpass)values('"+strUser+"','"+strPass+"')";
				System.out.println(sql);
				addadmin.executeUpdate(sql);
				ta.append("添加新管理员成功!");
				
			}
			else if (e.getSource()==btnClose)
			{
				String sql="select * from admin";
				try{
				ResultSet rs=addadmin.executeQuery(sql);
				while (rs.next())
				{
					listAllAdmin.add(rs.getString(2));
					}
				}
				catch(Exception ex){}
				//addadmin.close();
				//dispose();
			}}}