mainframe.java.bak

java+access学籍管理系统 适合做毕业设计 和对数据库的操作时用！@

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

/**
 * <p>Title: 河南财经学院学籍管理系统</p>
 * <p>Description: 毕业设计</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * @author 任明辉
 * @version 1.0
 */

public class MainFrame
    extends JFrame {
  boolean login = false;
  JPanel contentPane;
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenuFile = new JMenu();
  JMenuItem jMenuFileExit = new JMenuItem();
  JMenu jMenuHelp = new JMenu();
  JMenuItem jMenuHelpAbout = new JMenuItem();
  Label label1 = new Label();
  Label label2 = new Label();
  TextField textField1 = new TextField();
  TextField textField2 = new TextField();
  Button button1 = new Button();
  Label label3 = new Label();
  Button button2 = new Button();
  Button button3 = new Button();
  Button button4 = new Button();
  Button button5 = new Button();
  JMenuItem jMenuItem1 = new JMenuItem();
  JMenuItem jMenuItem2 = new JMenuItem();
  JMenuItem jMenuItem3 = new JMenuItem();
  JMenuItem jMenuItem4 = new JMenuItem();
  JMenuItem jMenuItem5 = new JMenuItem();
  Label label4 = new Label();

  //Construct the frame
  public MainFrame() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  //Component initialization
  private void jbInit() throws Exception {
    contentPane = (JPanel)this.getContentPane();
    contentPane.setLayout(null);
    this.setForeground(Color.black);
    this.setResizable(false);
    this.setSize(new Dimension(400, 300));
    this.setTitle("河南财经学院学籍管理系统");
    jMenuFile.setVerifyInputWhenFocusTarget(true);
    jMenuFile.setActionCommand("文件");
    jMenuFile.setText("文件");
    jMenuFileExit.setText("退出");
    jMenuFileExit.addActionListener(new MainFrame_ActionAdapter(this));
    jMenuHelp.setText("帮助");
    jMenuHelpAbout.setText("关于");
    jMenuHelpAbout.addActionListener(new MainFrame_ActionAdapter(this));
    contentPane.setEnabled(false);
    contentPane.setOpaque(true);
    contentPane.setPreferredSize(new Dimension(1, 1));
    contentPane.setRequestFocusEnabled(true);
    jMenuBar1.setEnabled(true);
    jMenuBar1.setBorderPainted(true);
    label1.setFont(new java.awt.Font("Dialog", 1, 15));
    label1.setText("用  户:");
    label1.setBounds(new Rectangle(123, 25, 49, 16));
    label2.setBounds(new Rectangle(123, 62, 49, 16));
    label2.setText("密  码:");
    label2.setFont(new java.awt.Font("Dialog", 1, 15));
    textField1.setText("");
    textField1.setBounds(new Rectangle(192, 24, 62, 18));
    textField2.setBounds(new Rectangle(192, 61, 62, 18));
    textField2.setEchoChar('*');
    textField2.setText("");
    button1.setFont(new java.awt.Font("Dialog", 1, 15));
    button1.setLabel("进入系统");
    button1.setBounds(new Rectangle(150, 104, 101, 22));
    button1.addActionListener(new MainFrame_ActionAdapter(this));
    label3.setFont(new java.awt.Font("Dialog", 1, 15));
    label3.setForeground(Color.red);
    label3.setText("请选择操作项");
    label3.setVisible(false);
    label3.setBounds(new Rectangle(158, 92, 84, 16));
    button2.setFont(new java.awt.Font("Dialog", 1, 15));
    button2.setLabel("添加信息");
    button2.setVisible(false);
    button2.setBounds(new Rectangle(74, 136, 97, 33));
    button3.setBounds(new Rectangle(226, 136, 97, 33));
    button3.setLabel("修改信息");
    button3.setVisible(false);
    button3.setFont(new java.awt.Font("Dialog", 1, 15));
    button4.setBounds(new Rectangle(74, 185, 97, 33));
    button4.setLabel("信息查询");
    button4.setVisible(false);
    button4.setFont(new java.awt.Font("Dialog", 1, 15));
    button5.setBounds(new Rectangle(226, 185, 97, 33));
    button5.setLabel("删除信息");
    button5.setVisible(false);
    button5.setFont(new java.awt.Font("Dialog", 1, 15));
    jMenuItem1.setText("添加信息");
    jMenuItem2.setText("信息查询");
    jMenuItem3.setText("修改信息");
    jMenuItem4.setText("删除信息");
    jMenuItem5.setText("帮助");
    label4.setFont(new java.awt.Font("Dialog", 1, 30));
    label4.setText("学籍管理系统");
    label4.setVisible(false);
    label4.setBounds(new Rectangle(70, 37, 261, 33));
    jMenuFile.add(jMenuItem1);
    jMenuItem1.setEnabled(false);
    jMenuItem1.addActionListener(new MainFrame_ActionAdapter(this));
    jMenuItem2.setEnabled(false);
    jMenuFile.add(jMenuItem2);
    jMenuItem2.addActionListener(new MainFrame_ActionAdapter(this));
    jMenuItem3.setEnabled(false);
    jMenuFile.add(jMenuItem3);
    jMenuItem3.addActionListener(new MainFrame_ActionAdapter(this));
    jMenuItem4.setEnabled(false);
    jMenuFile.add(jMenuItem4);
    jMenuItem4.addActionListener(new MainFrame_ActionAdapter(this));
    jMenuFile.add(jMenuFileExit);
    jMenuHelp.add(jMenuItem5);
    jMenuHelp.add(jMenuHelpAbout);
    jMenuBar1.add(jMenuFile);
    jMenuBar1.add(jMenuHelp);
    contentPane.add(label1, null);
    contentPane.add(label2, null);
    contentPane.add(textField1, null);
    contentPane.add(textField2, null);
    contentPane.add(label3, null);
    contentPane.add(button2, null);
    button2.addActionListener(new MainFrame_ActionAdapter(this));
    contentPane.add(button4, null);
    button4.addActionListener(new MainFrame_ActionAdapter(this));
    contentPane.add(button3, null);
    button3.addActionListener(new MainFrame_ActionAdapter(this));
    contentPane.add(button5, null);
    button5.addActionListener(new MainFrame_ActionAdapter(this));
    contentPane.add(button1, null);
    contentPane.add(label4, null);
    this.setJMenuBar(jMenuBar1);
  }

  //File | Exit action performed
  public void jMenuFileExit_actionPerformed(ActionEvent e) {
    System.exit(0);
  }

  //Help | About action performed
  public void jMenuHelpAbout_actionPerformed(ActionEvent e) {
  }

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

  void button1_actionPerformed(ActionEvent e) {
    String user = textField1.getText().trim();
    String pass = textField2.getText().trim();
    try {
      String strurl =
          "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/student.mdb";
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection conn = DriverManager.getConnection(strurl);
      Statement stmt = conn.createStatement();
      if (user.equals("")|| pass.equals(""))
        JOptionPane.showMessageDialog(null, "用户名或密码不能为空", "警告",
                                      JOptionPane.WARNING_MESSAGE);
      else {
        ResultSet rs = stmt.executeQuery("select * from admin where username='" +
                                         user + "' AND password='" + pass + "'");
        if (rs.next()) {
          JOptionPane.showMessageDialog(null, "登陆成功");
          login = true;
          label1.setVisible(false);
          textField1.setVisible(false);
          label2.setVisible(false);
          textField2.setVisible(false);
          button1.setVisible(false);
          label3.setVisible(true);
          label4.setVisible(true);
          button2.setVisible(true);
          button3.setVisible(true);
          button4.setVisible(true);
          button5.setVisible(true);
          jMenuItem1.setEnabled(true);
          jMenuItem2.setEnabled(true);
          jMenuItem3.setEnabled(true);
          jMenuItem4.setEnabled(true);
        }
        else
          JOptionPane.showMessageDialog(null, "登陆失败", "警告",
                                        JOptionPane.WARNING_MESSAGE);
      }
    }
    catch (Exception eg)

    {
      eg.printStackTrace();
    }

  }
}

class MainFrame_ActionAdapter
    implements ActionListener {
  MainFrame adaptee;

  MainFrame_ActionAdapter(MainFrame adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == adaptee.jMenuFileExit)
      adaptee.jMenuFileExit_actionPerformed(e);
    else if (e.getSource() == adaptee.jMenuItem1 ||
             e.getSource() == adaptee.button2) {
      AddInf addInf = new AddInf();
      addInf.setSize(400, 300);
      addInf.setVisible(true);
    }
    else if (e.getSource() == adaptee.jMenuItem3 ||
             e.getSource() == adaptee.button3) {
      ChangeInf changeInf = new ChangeInf();
      changeInf.setSize(400, 300);
      changeInf.setVisible(true);
    }
    else if (e.getSource() == adaptee.jMenuItem2 ||
             e.getSource() == adaptee.button4) {
      SearchInf searchInf = new SearchInf();
      searchInf.setSize(400, 300);
      searchInf.setVisible(true);
    }
    else if (e.getSource() == adaptee.jMenuItem4 ||
             e.getSource() == adaptee.button5) {
      DelInf delInf = new DelInf();
      delInf.setSize(400, 300);
      delInf.setVisible(true);
    }
    else if (e.getSource() == adaptee.jMenuHelpAbout)
      adaptee.jMenuHelpAbout_actionPerformed(e);
    else if (e.getSource() == adaptee.button1)
      adaptee.button1_actionPerformed(e);
  }
}