adduser.java

用Java实现的图书馆的管理系统

import java.util.*;
import java.awt.*;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;

class Adduser extends JDialog implements ActionListener {
	JLabel l_addname, l_fenge, l_name, l_pass, l_enter, l_unit;
	JTextField t_aname;
	Choice c_aunit;
	JButton b_addname, b_cancle;
	JPanel pan1, pan2, pan3, pan4, pan5, pan6, pan7;
	JPasswordField t_apass, t_aenter;

	Statement str;
	ResultSet rs;

	Adduser(Frame f, String s) {
		super(f, s);
		l_addname = new JLabel("添加用户         ");
		l_fenge = new JLabel(
				"---------------------------------------------------");
		l_name = new JLabel("名字：");
		l_pass = new JLabel("密码：");
		l_enter = new JLabel("确认：");
		l_unit = new JLabel("权限：");
		t_aname = new JTextField("", 10);
		t_apass = new JPasswordField("", 10);
		t_apass.setEchoChar('*');
		t_aenter = new JPasswordField("", 10);
		t_aenter.setEchoChar('*');
		c_aunit = new Choice();
		c_aunit.add("1");
		c_aunit.add("2");
		c_aunit.add("3");
		c_aunit.add("4");
		b_addname = new JButton("添加");
		b_addname.addActionListener(this);
		b_cancle = new JButton("取消");
		b_cancle.addActionListener(this);
		pan1 = new JPanel();
		pan2 = new JPanel();
		pan3 = new JPanel();
		pan4 = new JPanel();
		pan5 = new JPanel();
		pan6 = new JPanel();
		pan7 = new JPanel();
		pan1.add(l_addname);
		pan2.add(l_fenge);
		pan2.add(l_name);
		pan2.add(t_aname);
		pan3.add(l_pass);
		pan3.add(t_apass);
		pan4.add(l_enter);
		pan4.add(t_aenter);
		pan5.add(b_addname);
		pan5.add(b_cancle);
		pan6.add(l_fenge);
		pan7.add(l_unit);
		pan7.add(c_aunit);

		setLayout(new GridLayout(7, 1));
		add(pan1);
		add(pan6);
		add(pan2);
		add(pan3);
		add(pan4);
		add(pan7);
		add(pan5);
		setBounds(450, 150, 250, 300);

	}

	public void actionPerformed(ActionEvent e) {
		String JDriver = "sun.Jdbc.Odbc.JdbcOdbcDriver";
		String conURL = "jdbc:odbc:abc";
		try {
			Class.forName(JDriver);
		} catch (java.lang.ClassNotFoundException e1) {
			System.out.println("forname:" + e1.getMessage());
		}
		try {
			Connection con = DriverManager.getConnection(conURL);
			str = con.createStatement();
		} catch (SQLException e1) {
			System.out.println("SQLException:" + e1.getMessage());
		}
		if (e.getSource() == b_cancle) {
			dispose();
		} else if (e.getSource() == b_addname) {
			String s = t_aenter.getText().trim();
			if (t_apass.getText().trim().equalsIgnoreCase("")
					|| t_aname.getText().trim().equalsIgnoreCase("")
					|| t_aname.getText().trim().length() < 1) {
				JOptionPane.showMessageDialog(b_addname,
						"请认真填写，每一项均不能为空，且密码长度至少为5位");
			} else {
				if (t_apass.getText().trim().equals(s)) {

					try {
						rs = str
								.executeQuery("SELECT * FROM users where username="
										+ "'" + t_aname.getText() + "'");
						if (rs.next()) {

							l_addname.setText("用户已经存在,添加失败！");

						} else {
							String s2 = "'" + t_aname.getText().trim() + "'";
							String s3 = "'" + t_apass.getText().trim() + "'";
							String s4 = "'" + c_aunit.getSelectedItem().trim()
									+ "'";
							String temp = "INSERT INTO users (username, password, unit) VALUES ("
									+ s2 + "," + s3 + "," + s4 + ")";
							str.executeUpdate(temp);
							l_addname.setText("用户添加成功");
						}
					} catch (SQLException e1) {

						e1.printStackTrace();
					}

				} else {
					l_addname.setText("两次输入的密码不一致！");
					t_apass.setText("");
					t_aenter.setText("");
				}
			}
		}
	}
}