mdiuser.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 Mdiuser extends Dialog implements ActionListener {
	JLabel l_addname, l_fenge, l_name, l_pass, l_enter, l_unit;
	JTextField t_mname;
	Choice c_munit;
	JPasswordField t_mpass, t_menter;
	JButton b_mdiname, b_cancle;
	JPanel pan1, pan2, pan3, pan4, pan5, pan6, pan7;

	Statement s,s1;
	ResultSet rs;
	String a1, a2, a3, a4, a5;

	Mdiuser(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_mname = new JTextField("", 10);
		t_mpass = new JPasswordField("", 10);
		t_menter = new JPasswordField("", 10);
		t_menter.setEchoChar('*');
		c_munit = new Choice();
		c_munit.add("1");
		c_munit.add("2");
		c_munit.add("3");
		c_munit.add("4");
		b_mdiname = new JButton("修改");
		b_mdiname.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_mname);
		pan3.add(l_pass);
		pan3.add(t_mpass);
		pan4.add(l_enter);
		pan4.add(t_menter);
		pan5.add(b_mdiname);
		pan5.add(b_cancle);
		pan6.add(l_fenge);
		pan7.add(l_unit);
		pan7.add(c_munit);

		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);
			s = con.createStatement();
			
		} catch (SQLException e1) {
			System.out.println("SQLException:" + e1.getMessage());
		}
		if (e.getSource() == b_cancle) {
			dispose();
		} else if (e.getSource() == b_mdiname) {

			try {
				rs = s.executeQuery("SELECT * FROM users where username=" + "'"
						+ t_mname.getText() + "'");
				while (rs.next()) {
					a2 = rs.getString(2);
					if (t_mpass.getText().equals(a2)) {
						String JDriver1 = "sun.Jdbc.Odbc.JdbcOdbcDriver";
						String conURL1 = "jdbc:odbc:abc";
						try {
							Class.forName(JDriver1);
						} catch (java.lang.ClassNotFoundException e1) {
							System.out.println("forname:" + e1.getMessage());
						}
						try {
							Connection con = DriverManager.getConnection(conURL1);
							s1 = con.createStatement();
							
						} catch (SQLException e1) {
							System.out.println("SQLException:" + e1.getMessage());
						}
						a3 = "'" + t_mname.getText().trim() + "'";
						a4 = "'" + t_menter.getText().trim() + "'";
						a5 = "'" + c_munit.getSelectedItem().trim() + "'";
						String tem = "UPDATE users SET password=" + a4
								+ ",unit=" + a5 + " WHERE username=" + a3;
						s1.executeUpdate(tem);
						System.out.println("ssssssss");
						l_addname.setText("用户修改成功");

					} else {
						l_addname.setText("用户名或密码错误！");
					}
				}

			} catch (SQLException e2) {
			}

		}*/
	}

}