usermanage.java

一个商品的进存销信息管理系统

//package jxc;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.BufferedReader;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.util.StringTokenizer;
import java.util.Vector;
import java.sql.ResultSetMetaData;
import java.util.Enumeration;
import javax.swing.event.*;

public class usermanage
    extends JDialog {
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JTabbedPane jTabbedPane1 = new JTabbedPane();
  JPanel jPanel1 = new JPanel();
  JLabel jLabel2 = new JLabel();
  JCheckBox jCheckBox2 = new JCheckBox();
  JCheckBox jCheckBox4 = new JCheckBox();
  JPasswordField jPasswordField1 = new JPasswordField();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JCheckBox jCheckBox1 = new JCheckBox();
  JCheckBox jCheckBox3 = new JCheckBox();
  JButton jButton3 = new JButton();
  JPanel jPanel2 = new JPanel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JPasswordField jPasswordField2 = new JPasswordField();
  JButton jButton4 = new JButton();
  JCheckBox jCheckBox5 = new JCheckBox();
  JCheckBox jCheckBox6 = new JCheckBox();
  JCheckBox jCheckBox7 = new JCheckBox();
  JCheckBox jCheckBox8 = new JCheckBox();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JScrollPane jScrollPane1 = new JScrollPane();
  JList jList1 = new JList();
  int i;
  String config[] = {
      "", "", "", "", "", ""};
  Connection conn;
  Statement stmt;
  static Vector columnHeads = new Vector();
  static Vector rows = new Vector();
  static Vector currentRow = new Vector();
  static Vector list = new Vector();
  static ResultSet ResultSet;
  String SelectValue;

  public usermanage() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    setModal(true);
    jButton1.setBounds(new Rectangle(210, 238, 77, 27));
    jButton1.setText("确 定");
    jButton1.addActionListener(new usermanage_jButton1_actionAdapter(this));
    this.setResizable(false);
    this.setSize(new Dimension(400, 330));
    this.addWindowListener(new usermanage_this_windowAdapter(this));
    this.setTitle("用户管理");
    this.getContentPane().setLayout(null);
    jButton2.setBounds(new Rectangle(302, 238, 77, 27));
    jButton2.setText("取 消");
    jButton2.addActionListener(new usermanage_jButton2_actionAdapter(this));
    jTabbedPane1.setBounds(new Rectangle(143, 16, 234, 212));
    jLabel2.setText("密码");
    jLabel2.setBounds(new Rectangle(21, 43, 38, 22));
    jCheckBox2.setBackground(SystemColor.control);
    jCheckBox2.setActionCommand("销售");
    jCheckBox2.setText("销售");
    jCheckBox2.setBounds(new Rectangle(21, 149, 61, 24));
    jCheckBox4.setBackground(SystemColor.control);
    jCheckBox4.setForeground(Color.red);
    jCheckBox4.setText("系统管理员");
    jCheckBox4.setBounds(new Rectangle(101, 95, 98, 24));
    jPasswordField1.setSelectionStart(15);
    jPasswordField1.setText("");
    jPasswordField1.setBounds(new Rectangle(72, 43, 140, 22));
    jLabel1.setText("用户");
    jLabel1.setBounds(new Rectangle(21, 13, 38, 22));
    jLabel3.setText("用户权限");
    jLabel3.setBounds(new Rectangle(21, 70, 56, 24));
    jTextField1.setEditable(false);
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(72, 13, 140, 22));
    jCheckBox1.setBackground(SystemColor.control);
    jCheckBox1.setActionCommand("库存");
    jCheckBox1.setText("库存");
    jCheckBox1.setBounds(new Rectangle(21, 122, 61, 24));
    jCheckBox3.setBackground(SystemColor.control);
    jCheckBox3.setActionCommand("采购");
    jCheckBox3.setSelected(false);
    jCheckBox3.setText("采购");
    jCheckBox3.setVerticalAlignment(SwingConstants.CENTER);
    jCheckBox3.setBounds(new Rectangle(21, 95, 61, 24));
    jPanel1.setDebugGraphicsOptions(0);
    jPanel1.setLayout(null);
    jButton3.setBounds(new Rectangle(122, 138, 77, 27));
    jButton3.setText("删 除");
    jButton3.addActionListener(new usermanage_jButton3_actionAdapter(this));
    jPanel2.setDebugGraphicsOptions(0);
    jPanel2.setLayout(null);
    jLabel4.setText("用户");
    jLabel4.setBounds(new Rectangle(21, 13, 38, 22));
    jLabel5.setText("密码");
    jLabel5.setBounds(new Rectangle(21, 43, 38, 22));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(72, 13, 140, 22));
    jPasswordField2.setText("");
    jPasswordField2.setBounds(new Rectangle(72, 43, 140, 22));
    jButton4.setBounds(new Rectangle(122, 138, 77, 27));
    jButton4.setText("添 加");
    jButton4.addActionListener(new usermanage_jButton4_actionAdapter(this));
    jCheckBox5.setBounds(new Rectangle(21, 149, 61, 24));
    jCheckBox5.setText("销售");
    jCheckBox5.setBackground(SystemColor.control);
    jCheckBox5.setActionCommand("销售");
    jCheckBox6.setBounds(new Rectangle(101, 95, 98, 24));
    jCheckBox6.setText("系统管理员");
    jCheckBox6.setForeground(Color.red);
    jCheckBox6.setBackground(SystemColor.control);
    jCheckBox7.setBounds(new Rectangle(21, 122, 61, 24));
    jCheckBox7.setText("库存");
    jCheckBox7.setBackground(SystemColor.control);
    jCheckBox7.setActionCommand("库存");
    jCheckBox8.setBounds(new Rectangle(21, 95, 61, 24));
    jCheckBox8.setText("采购");
    jCheckBox8.setBackground(SystemColor.control);
    jCheckBox8.setActionCommand("采购");
    jCheckBox8.setSelected(false);
    jLabel6.setText("用户权限");
    jLabel6.setBounds(new Rectangle(21, 70, 56, 24));
    jLabel7.setToolTipText("");
    jLabel7.setText("用户列表");
    jLabel7.setBounds(new Rectangle(18, 12, 54, 22));
    jScrollPane1.setBounds(new Rectangle(18, 35, 110, 190));
    jList1.addListSelectionListener(new usermanage_jList1_listSelectionAdapter(this));
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jTabbedPane1, null);
    this.getContentPane().add(jLabel7, null);
    this.getContentPane().add(jScrollPane1, null);
    jScrollPane1.getViewport().add(jList1, null);
    jPanel1.add(jLabel1, null);
    jPanel1.add(jLabel3, null);
    jPanel1.add(jTextField1, null);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jPasswordField1, null);
    jPanel1.add(jCheckBox3, null);
    jPanel1.add(jCheckBox4, null);
    jPanel1.add(jButton3, null);
    jPanel1.add(jCheckBox1, null);
    jPanel1.add(jCheckBox2, null);
    jTabbedPane1.add("添加用户", jPanel2);
    jPanel2.add(jButton4, null);
    jPanel2.add(jCheckBox6, null);
    jPanel2.add(jCheckBox8, null);
    jPanel2.add(jCheckBox7, null);
    jPanel2.add(jCheckBox5, null);
    jPanel2.add(jTextField2, null);
    jPanel2.add(jLabel4, null);
    jPanel2.add(jLabel6, null);
    jPanel2.add(jLabel5, null);
    jPanel2.add(jPasswordField2, null);
    jTabbedPane1.add("编辑用户", jPanel1);
    jCheckBox1.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jCheckBox2.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jCheckBox3.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jCheckBox4.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jCheckBox5.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jCheckBox6.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jCheckBox7.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jCheckBox8.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jPasswordField1.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jPasswordField2.addActionListener(new usermanage_jButton1_actionAdapter(this));
    jTextField2.addActionListener(new usermanage_jButton1_actionAdapter(this));
    //读取SQL用户表,以验证用户密码
    //读取配置文件
    BufferedReader br = new BufferedReader(new FileReader("config.dll"));
    while (br.ready()) {
      config[i] = br.readLine().toString();
      i++;
     }

  }

  private void displayResultSet(ResultSet rs) throws SQLException {
    //定位到达第一条记录
    boolean moreRecords = rs.next();
    //如果没有记录，则提示一条消息
    if (!moreRecords) {
      JOptionPane.showMessageDialog(this,"结果集中无记录");
      setTitle("无记录显示");
      return;
    }
    try {
      //获取字段的名称
      ResultSetMetaData rsmd = rs.getMetaData();
      for (int i = 1; i <= rsmd.getColumnCount(); ++i) {
        columnHeads.addElement(rsmd.getColumnName(i));
        //获取记录集
      }
      do {
        rows.addElement(getNextRow(rs, rsmd));
      }
      while (rs.next());
    }
    catch (SQLException sqlex) {
      sqlex.printStackTrace();
    }
  }

  private Vector getNextRow(ResultSet rs,ResultSetMetaData rsmd) throws SQLException 
  { Vector currentRow = new Vector();
    for (int i = 1; i <= rsmd.getColumnCount(); ++i) {
      currentRow.addElement(rs.getString(i));
      //返回一条记录
    }
    return currentRow;
  }

  void jButton2_actionPerformed(ActionEvent e) {
    hide();
  }

  void jButton1_actionPerformed(ActionEvent e) {

  }

  void jButton3_actionPerformed(ActionEvent e) {

  }

  void this_windowActivated(WindowEvent e) {
    try {
      //JDBC驱动
      try {
      // Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      }
      catch (ClassNotFoundException ex) {
      }
     /* //地址
      conn = DriverManager.getConnection(
          "jdbc:microsoft:sqlserver://"
          + config[0] + ":"
          + config[1] + ";User="
          + config[2] + ";Password="
          + config[3] + ";DatabaseName="
          + config[4]);
    */
	  conn=DriverManager.getConnection("jdbc:odbc:dic","","");
      stmt = conn.createStatement();
      ResultSet ResultSet = stmt.executeQuery("select * from 用户");
      //取值
      displayResultSet(ResultSet);
    }
    catch (SQLException ex1) {System.out.print(ex1);  }

    for (int i = 0; i < rows.size(); i++)
     { list.add(i, ( (Vector) rows.elementAt(i)).elementAt(0));   }
    jList1.setListData(list);
  }

  void jList1_valueChanged(ListSelectionEvent e)
 {  SelectValue = jList1.getSelectedValue().toString();
    System.out.print(columnHeads + "\n" + rows + "\n" + currentRow + "\n" +list);
    jTextField1.setText(SelectValue);
    jTextField2.setText(SelectValue);
    i = jList1.getSelectedIndex();
    jPasswordField1.setText( ( (Vector) rows.elementAt(i)).elementAt(1).
                            toString());
    jPasswordField2.setText( ( (Vector) rows.elementAt(i)).elementAt(1).
                            toString());

    try {
      ResultSet ResultSet = stmt.executeQuery("select * from 用户 where 用户名='" +
                                              SelectValue + "'");
      while (ResultSet.next()) {
        jCheckBox3.setSelected(ResultSet.getBoolean("采购权限"));
        jCheckBox8.setSelected(ResultSet.getBoolean("采购权限"));
        jCheckBox1.setSelected(ResultSet.getBoolean("库存权限"));
        jCheckBox7.setSelected(ResultSet.getBoolean("库存权限"));
        jCheckBox5.setSelected(ResultSet.getBoolean("销售权限"));
        jCheckBox2.setSelected(ResultSet.getBoolean("销售权限"));
        jCheckBox6.setSelected(ResultSet.getBoolean("系统管理员"));
        jCheckBox4.setSelected(ResultSet.getBoolean("系统管理员"));
      }
    }
    catch (SQLException ex) {
    }

  }

  void jButton4_actionPerformed(ActionEvent e) {
    if (jTextField1.getText().equals(SelectValue))
    {    }
  }

  void this_windowDeactivated(WindowEvent e) {
    //窗口闲置状态,初始化所有变量
    try {
      stmt.close();
      conn.close();
    }
    catch (SQLException ex) {
    }

  }
}

class usermanage_jButton2_actionAdapter
    implements java.awt.event.ActionListener {
  usermanage adaptee;

  usermanage_jButton2_actionAdapter(usermanage adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class usermanage_jButton1_actionAdapter
    implements java.awt.event.ActionListener {
  usermanage adaptee;

  usermanage_jButton1_actionAdapter(usermanage adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class usermanage_jButton3_actionAdapter
    implements java.awt.event.ActionListener {
  usermanage adaptee;

  usermanage_jButton3_actionAdapter(usermanage adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class usermanage_this_windowAdapter
    extends java.awt.event.WindowAdapter {
  usermanage adaptee;

  usermanage_this_windowAdapter(usermanage adaptee) {
    this.adaptee = adaptee;
  }

  public void windowActivated(WindowEvent e) {
    adaptee.this_windowActivated(e);
  }

  public void windowDeactivated(WindowEvent e) {
    adaptee.this_windowDeactivated(e);
  }
}

class usermanage_jList1_listSelectionAdapter
    implements javax.swing.event.ListSelectionListener {
  usermanage adaptee;

  usermanage_jList1_listSelectionAdapter(usermanage adaptee) {
    this.adaptee = adaptee;
  }

  public void valueChanged(ListSelectionEvent e) {
    adaptee.jList1_valueChanged(e);
  }
}

class usermanage_jButton4_actionAdapter
    implements java.awt.event.ActionListener {
  usermanage adaptee;

  usermanage_jButton4_actionAdapter(usermanage adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}