frame1.java~1~

Java数据库系统项目开发实践源程序第4章.rar

package enterpriseemployeeadministrate;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dbswing.*;
import com.borland.dx.sql.dataset.*;
import java.io.*;
import java.sql.*;

public class Frame1 extends JFrame {
  JPanel contentPane;
  BorderLayout borderLayout1 = new BorderLayout();
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenu1 = new JMenu();
  JMenuItem jMenuItem1 = new JMenuItem();
  JMenuItem jMenuItem2 = new JMenuItem();
  JMenuItem jMenuItem3 = new JMenuItem();
  JMenuItem jMenuItem4 = new JMenuItem();
  JMenu jMenu2 = new JMenu();
  JMenuItem jMenuItem6 = new JMenuItem();
  JMenuItem jMenuItem7 = new JMenuItem();
  JMenu jMenu3 = new JMenu();
  JMenuItem jMenuItem8 = new JMenuItem();
  JMenuItem jMenuItem9 = new JMenuItem();
  JMenuItem jMenuItem10 = new JMenuItem();
  JMenuItem jMenuItem11 = new JMenuItem();
  JMenuItem jMenuItem12 = new JMenuItem();
  JMenuItem jMenuItem13 = new JMenuItem();
  JMenu jMenu4 = new JMenu();
  JMenuItem jMenuItem14 = new JMenuItem();
  JToolBar jToolBar1 = new JToolBar();
  JButton jButton1 = new JButton();
  ImageIcon image1;
  ImageIcon image2;
  ImageIcon image3;
  ImageIcon image4;
  ImageIcon image5;
  ImageIcon image6;
  ImageIcon image7;
  ImageIcon image8;
  ImageIcon image9;
  XYLayout xYLayout1 = new XYLayout();
  BorderLayout borderLayout2 = new BorderLayout();
  JPanel jPanel1 = new JPanel();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  JButton jButton6 = new JButton();
  JButton jButton7 = new JButton();
  JButton jButton8 = new JButton();
  JButton jButton9 = new JButton();
  XYLayout xYLayout2 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JMenuItem jMenuItem15 = new JMenuItem();
  Database database1 = new Database();
  int userTypeInfo=0;
  static String userName="";

  //Construct the frame
  public Frame1() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  //Component initialization
  private void jbInit() throws Exception  {
    image1= new ImageIcon(enterpriseemployeeadministrate.Frame1.class.getResource("help.png"));
    image2= new ImageIcon(enterpriseemployeeadministrate.Frame1.class.getResource("ovalHotspot.png"));
    image3= new ImageIcon(enterpriseemployeeadministrate.Frame1.class.getResource("media.png"));
    image4= new ImageIcon(enterpriseemployeeadministrate.Frame1.class.getResource("image.png"));
    image5= new ImageIcon(enterpriseemployeeadministrate.Frame1.class.getResource("Rollover.png"));
    image6= new ImageIcon(enterpriseemployeeadministrate.Frame1.class.getResource("Snippets.png"));
    image7= new ImageIcon(enterpriseemployeeadministrate.Frame1.class.getResource("Image Viewer.png"));
    image8= new ImageIcon(enterpriseemployeeadministrate.Frame1.class.getResource("Text Field.png"));
    image9= new ImageIcon(enterpriseemployeeadministrate.Frame1.class.getResource("Image Field.png"));
    contentPane = (JPanel) this.getContentPane();
    contentPane.setLayout(borderLayout2);
    this.setSize(new Dimension(400, 300));
    this.setTitle("Frame Title");
    this.setJMenuBar(jMenuBar1);
    jMenu1.setText("文件");
    jMenu1.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem1.setText("修改密码（w）");
    jMenuItem1.addActionListener(new Frame1_jMenuItem1_actionAdapter(this));
    jMenuItem1.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem1.setMnemonic('w');
    jMenuItem2.setText("打印查询结果（n）");
    jMenuItem2.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem2.setMnemonic('n');
    jMenuItem3.setText("打印员工资料（p）");
    jMenuItem3.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem3.setMnemonic('p');
    jMenuItem4.setText("退出（e）");
    jMenuItem4.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem4.setMnemonic('e');
    jMenuItem4.addActionListener(new Frame1_jMenuItem4_actionAdapter(this));
    jMenu2.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenu2.setText("操作");
    jMenuItem6.setText("添加记录（a）");
    jMenuItem6.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem6.setMnemonic('a');
    jMenuItem7.setText("删除记录（d）");
    jMenuItem7.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem7.setMnemonic('d');
    jMenu3.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenu3.setText("设置");
    jMenuItem8.setText("修改记录（t）");
    jMenuItem8.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem8.setMnemonic('t');
    jMenuItem9.setText("增加字段（v）");
    jMenuItem9.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem9.setMnemonic('v');
    jMenuItem10.setText("删除字段（l）");
    jMenuItem10.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem10.setMnemonic('l');
    jMenuItem11.setText("设置权限（u）");
    jMenuItem11.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem11.setMnemonic('u');
    jMenuItem12.setText("数据库日志（g）");
    jMenuItem12.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem12.setMnemonic('g');
    jMenuItem13.setText("数据备份（r）");
    jMenuItem13.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem13.setMnemonic('r');
    jMenu4.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenu4.setText("帮助");
    jMenuItem14.setText("帮助信息（h）");
    jMenuItem14.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem14.setMnemonic('h');
    jButton1.setToolTipText("help");
    jButton1.setText("");
    jButton1.setIcon(image1);
    jButton2.setText("");
    jButton2.setToolTipText("print view");
    jButton2.setIcon(image2);
    jButton3.setText("");
    jButton3.setToolTipText("print");
    jButton3.setIcon(image3);
    jButton4.setText("");
    jButton4.setToolTipText("alter infomation");
    jButton4.setIcon(image4);
    jButton5.setText("");
    jButton5.setToolTipText("delete infomation");
    jButton5.setIcon(image5);
    jButton6.setText("");
    jButton6.setToolTipText("add infomation");
    jButton6.setIcon(image6);
    jButton7.setText("");
    jButton7.setToolTipText("select accord to ID");
    jButton7.setIcon(image7);
    jButton8.setText("");
    jButton8.setToolTipText("delete value");
    jButton8.setIcon(image8);
    jButton9.setText("");
    jButton9.setToolTipText("add value");
    jButton9.setIcon(image9);
    contentPane.setBackground(Color.pink);
    contentPane.setForeground(Color.pink);
    jPanel1.setBackground(Color.pink);
    jPanel1.setForeground(Color.pink);
    jPanel1.setLayout(xYLayout2);
    jToolBar1.setBackground(Color.pink);
    jLabel1.setFont(new java.awt.Font("Dialog", 3, 17));
    jLabel1.setText(" Enterprise Administrate System");
    jLabel2.setFont(new java.awt.Font("Dialog", 3, 17));
    jLabel2.setText("Welcom To");
    jMenuItem15.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem15.setText("管理用户信息(u）");
    jMenuItem15.setMnemonic('u');
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:person", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    jMenuItem16.addActionListener(new Frame1_jMenuItem16_actionAdapter(this));
    jMenuItem16.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuItem16.setText("登录（l）");
    jMenuItem16.setMnemonic('l');
    jMenu5.setEnabled(false);
    jMenu5.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenu5.setMnemonic('s');
    jMenu5.setText("查询信息（s）");
    jMenuItem5.setText("按职工号");
    jMenuBar1.add(jMenu1);
    jMenuBar1.add(jMenu2);
    jMenuBar1.add(jMenu3);
    jMenuBar1.add(jMenu4);
    jMenu1.addSeparator();
    jMenu1.add(jMenuItem16);
    jMenu1.addSeparator();
    jMenu1.add(jMenuItem1);
    jMenu1.addSeparator();
    jMenu1.add(jMenuItem2);
    jMenu1.add(jMenuItem3);
    jMenu1.addSeparator();
    jMenu1.add(jMenuItem4);
    jMenu2.add(jMenu5);
    jMenu2.addSeparator();
    jMenu2.add(jMenuItem6);
    jMenu2.add(jMenuItem7);
    jMenu2.add(jMenuItem8);
    jMenu2.addSeparator();
    jMenu2.add(jMenuItem9);
    jMenu2.add(jMenuItem10);
    jMenu3.add(jMenuItem11);
    jMenu3.addSeparator();
    jMenu3.add(jMenuItem12);
    jMenu3.addSeparator();
    jMenu3.add(jMenuItem13);
    jMenu3.add(jMenuItem15);
    jMenu4.add(jMenuItem14);
    contentPane.add(jToolBar1, BorderLayout.NORTH);
   // jPanel1.add(tableScrollPane1, null);
   //tableScrollPane1.getViewport().add(jdbTable1, null);
    jToolBar1.add(jButton9, null);
    jToolBar1.add(jButton8, null);
    jToolBar1.add(jButton7, null);
    jToolBar1.add(jButton6, null);
    jToolBar1.add(jButton5, null);
    jToolBar1.add(jButton4, null);
    jToolBar1.add(jButton3, null);
    jToolBar1.add(jButton2, null);
    jToolBar1.add(jButton1, null);
    contentPane.add(jPanel1, BorderLayout.CENTER);
    jPanel1.add(jLabel1,                 new XYConstraints(49, 111, 315, 71));
    jPanel1.add(jLabel2,     new XYConstraints(140, 65, 129, 43));
    jMenu5.add(jMenuItem5);
    jMenu2.setEnabled(false);
    jMenu3.setEnabled(false);
    jMenu4.setEnabled(true);
    jMenuItem1.setEnabled(false);
    jMenuItem2.setEnabled(false);
    jMenuItem3.setEnabled(false);
    jMenuItem6.setEnabled(false);
    jMenuItem7.setEnabled(false);
    jMenuItem8.setEnabled(false);
    jMenuItem9.setEnabled(false);
    jMenuItem10.setEnabled(false);
    jMenuItem11.setEnabled(false);
    jMenuItem12.setEnabled(false);
    jMenuItem13.setEnabled(false);
    jMenuItem14.setEnabled(true);
    jMenuItem15.setEnabled(false);
    jLabel1.setVisible(false);
    jLabel2.setVisible(false);
  }



  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }

  void jMenuItem4_actionPerformed(ActionEvent e) {
   System.exit(0);
  }

  JMenuItem jMenuItem16 = new JMenuItem();
  JMenu jMenu5 = new JMenu();
  JMenuItem jMenuItem5 = new JMenuItem();

  void jMenuItem16_actionPerformed(ActionEvent e) {
Login login=new Login(this);
login.setVisible(true);
userName=login.getUserName();
switch(userTypeInfo)
  {
  case 0: JOptionPane.showMessageDialog(this,"wrong user infomation");
          System.exit(0);
          break;
        case 1: jMenu2.setEnabled(true);
        jMenu3.setEnabled(true);
        jMenu4.setEnabled(true);
        jMenuItem1.setEnabled(true);
        jMenuItem2.setEnabled(true);
        jMenuItem3.setEnabled(true);
        jMenuItem5.setEnabled(true);
        jMenuItem6.setEnabled(true);
        jMenuItem7.setEnabled(true);
        jMenuItem8.setEnabled(true);
        jMenuItem9.setEnabled(true);
        jMenuItem10.setEnabled(true);
        jMenuItem11.setEnabled(true);
        jMenuItem12.setEnabled(true);
        jMenuItem13.setEnabled(true);
        jMenuItem14.setEnabled(true);
        jMenuItem15.setEnabled(true);
        jLabel1.setVisible(true);
        jLabel2.setVisible(true);
        jMenuItem16.setEnabled(false);
        break;
      case 2: jMenu2.setEnabled(true);
            jMenu3.setEnabled(true);
            jMenu4.setEnabled(true);
            jMenuItem1.setEnabled(true);
            jMenuItem2.setEnabled(true);
            jMenuItem3.setEnabled(true);
            jMenuItem5.setEnabled(true);
            jMenuItem6.setEnabled(true);
            jMenuItem7.setEnabled(true);
            jMenuItem8.setEnabled(true);
            jMenuItem9.setEnabled(true);
            jMenuItem10.setEnabled(true);
            jMenuItem11.setEnabled(true);
            jMenuItem14.setEnabled(true);
            jMenuItem16.setEnabled(false);
            jLabel1.setVisible(true);
            jLabel2.setVisible(true);
            break;
          case 3: jMenu2.setEnabled(true);
                  jMenu3.setEnabled(true);
                  jMenu4.setEnabled(true);
                  jMenuItem1.setEnabled(true);
                    jMenuItem2.setEnabled(true);
                    jMenuItem3.setEnabled(true);
                    jMenuItem5.setEnabled(true);
                    jMenuItem6.setEnabled(true);
                    jMenuItem7.setEnabled(true);
                    jMenuItem8.setEnabled(true);
                    jMenuItem9.setEnabled(true);
                    jMenuItem10.setEnabled(true);
                    jMenuItem14.setEnabled(true);
                    jMenuItem16.setEnabled(false);
                    jLabel1.setVisible(true);
                    jLabel2.setVisible(true);
                     break;
  }


}

  void jMenuItem1_actionPerformed(ActionEvent e) {
    JOptionPane.showMessageDialog(this,"do you really want to change your password!","changing password ",JOptionPane.INFORMATION_MESSAGE);
    String newPassword=JOptionPane.showInputDialog(this,"input new password");
    if(newPassword!="") {
    PreparedStatement np=null;
    np=database1.createPreparedStatement("UPDATE user_info SET user_password='"+newPassword+"'  WHERE user_name='"+userName+"'");
    try{ np.execute();}
    catch(SQLException sqlException){sqlException.printStackTrace();}
    try{np.close();}catch(SQLException sql){;}
    JOptionPane.showMessageDialog(this,"you have changed your password","change success",JOptionPane.INFORMATION_MESSAGE);
  }
    else JOptionPane.showMessageDialog(this,"password can not be null","password is wrong",JOptionPane.INFORMATION_MESSAGE);
  }




}

class Frame1_jMenuItem4_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem4_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem4_actionPerformed(e);
  }
}

class Frame1_jMenuItem1_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem1_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem1_actionPerformed(e);
  }
}

class Frame1_jMenuItem16_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem16_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem16_actionPerformed(e);
  }
}