mainframe.java

学生档案管理系统

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package 学生档案管理系统;

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowEvent;
import java.io.File;
import javax.swing.*;
import java.sql.*;

/**
 *
 * @author Administrator
 */
public class MainFrame extends JFrame {
    JPanel contentPane;
    Connection con;
    Statement ps;
    ResultSet rs;
    String userName;
    String psd;
    
    public static String strSNum;
    
    JMenuBar jMenuBar = new JMenuBar();
    
    JMenu jMenuSystem = new JMenu();
    JMenuItem jMenuItemLog = new JMenuItem();
    JMenuItem jMenuItemAddUser = new JMenuItem();
    JMenuItem jMenuItemChange = new JMenuItem();
    JMenuItem jMenuItemExit = new JMenuItem();
    
    JMenu jMenuHelp = new JMenu();
    JMenuItem jMenuItemInfo = new JMenuItem();
    
    JMenu jMenuAdd = new JMenu();
    JMenuItem jMenuItemAddBaseInfo = new JMenuItem();
    JMenuItem jMenuItemAddFamily = new JMenuItem();
    JMenuItem jMenuItemAddAward = new JMenuItem();
    
    JMenu jMenuSque = new JMenu();
    JMenuItem jMenuItemSqueBaseInfo = new JMenuItem();
    JMenuItem jMenuItemSqueFamily = new JMenuItem();
    JMenuItem jMenuItemSqueAward = new JMenuItem();
    
    JMenu jMenuDelete = new JMenu();
    JMenuItem jMenuItemDeleteBaseInfo = new JMenuItem();
    JMenuItem jMenuItemDeleteFamily = new JMenuItem();
    JMenuItem jMenuItemDeleteAward = new JMenuItem();
    
    JMenu jMenuChange = new JMenu();
    JMenuItem jMenuItemChangeBaseInfo = new JMenuItem();
    JMenuItem jMenuItemChangeFamily = new JMenuItem();
    JMenuItem jMenuItemChangeAward = new JMenuItem();
    
    ImageIcon icon = new ImageIcon("images" + File.separator+"a.jpg");
    JLabel jLabel1 = new JLabel(icon, JLabel.CENTER);
    
    public MainFrame() {
        enableEvents(AWTEvent.WINDOW_EVENT_MASK);
        try {
            jbInit();
        }
        catch (Exception e) {
            e.printStackTrace();
        }
     }
    private void jbInit() throws Exception {
        contentPane = (JPanel)this.getContentPane();
        contentPane.setLayout(null);
        this.setResizable(false);
        this.setTitle("学生档案管理系统");
        
        //系统菜单
        jMenuSystem.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuSystem.setForeground(Color.black);
        jMenuSystem.setText(" 系统 ");
        jMenuItemLog.setFont(new java.awt.Font("Dialog",0,15));
        jMenuItemLog.setText("用户登录");
        jMenuItemLog.addActionListener(new MainFrame_jMenuItemLog_actionAdapter(this));
        jMenuItemChange.setFont(new java.awt.Font("Dialog",0,15));
        jMenuItemChange.setText("修改密码");
        jMenuItemChange.addActionListener(new MainFrame_jMenuItemChange_actionAdapter(this));
        jMenuItemAddUser.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemAddUser.setText("添加用户");
        jMenuItemAddUser.addActionListener(new MainFrame_jMenuItemAddUser_actionAdapter(this));
        jMenuItemExit.setFont(new java.awt.Font("Dialog",0,15));
        jMenuItemExit.setText("退出系统");
        jMenuItemExit.addActionListener(new MainFrame_jMenuItemExit_actionAdapter(this));
        jMenuSystem.add(jMenuItemLog);
        jMenuSystem.add(jMenuItemChange);
        jMenuSystem.add(jMenuItemAddUser);
        jMenuSystem.add(jMenuItemExit);
        
        //帮助菜单
        jMenuHelp.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuHelp.setText(" 帮助  ");
        jMenuItemInfo.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemInfo.setText("系统帮助   ");
        jMenuItemInfo.addActionListener(new MainFrame_jMenuItemInfo_ActionAdapter(this));
        jMenuHelp.add(jMenuItemInfo);
        
        //添加学生档案菜单
        jMenuAdd.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuAdd.setText(" 添加学生档案  ");
        jMenuItemAddBaseInfo.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemAddBaseInfo.setText("添加基本信息");
        jMenuItemAddBaseInfo.addActionListener(new MainFrame_jMenuItemAddBaseInfo_actionAdapter(this));
        jMenuItemAddFamily.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemAddFamily.setText("添加家庭信息");
        jMenuItemAddFamily.addActionListener(new MainFrame_jMenuItemAddFamily_actionAdapter(this));
        jMenuItemAddAward.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemAddAward.setText("添加奖惩信息");
        jMenuItemAddAward.addActionListener(new MainFrame_jMenuItemAddAward_actionAdapter(this));
        jMenuAdd.add(jMenuItemAddBaseInfo);
        jMenuAdd.add(jMenuItemAddFamily);
        jMenuAdd.add(jMenuItemAddAward);
        
        //修改学生档案菜单
        jMenuChange.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuChange.setText(" 修改学生档案  ");
        jMenuItemChangeBaseInfo.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemChangeBaseInfo.setText("修改基本信息");
        jMenuItemChangeBaseInfo.addActionListener(new MainFrame_jMenuItemChangeBaseInfo_actionAdapter(this));
        jMenuItemChangeFamily.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemChangeFamily.setText("修改家庭信息");
        jMenuItemChangeFamily.addActionListener(new MainFrame_jMenuItemChangeFamily_actionAdapter(this));
        jMenuItemChangeAward.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemChangeAward.setText("修改奖惩信息");
        jMenuItemChangeAward.addActionListener(new MainFrame_jMenuItemChangeAward_actionAdapter(this));
        jMenuChange.add(jMenuItemChangeBaseInfo);
        jMenuChange.add(jMenuItemChangeFamily);
        jMenuChange.add(jMenuItemChangeAward);
        
        //删除学生档案菜单
        jMenuDelete.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuDelete.setText(" 删除学生档案  ");
        jMenuItemDeleteBaseInfo.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemDeleteBaseInfo.setText("删除基本信息");
        jMenuItemDeleteBaseInfo.addActionListener(new MainFrame_jMenuItemDeleteBaseInfo_actionAdapter(this));
        jMenuItemDeleteFamily.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemDeleteFamily.setText("删除家庭信息");
        jMenuItemDeleteFamily.addActionListener(new MainFrame_jMenuItemDeleteFamily_actionAdapter(this));
        jMenuItemDeleteAward.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemDeleteAward.setText("删除奖惩信息");
        jMenuItemDeleteAward.addActionListener(new MainFrame_jMenuItemDeleteAward_actionAdapter(this));
        jMenuDelete.add(jMenuItemDeleteBaseInfo);
        jMenuDelete.add(jMenuItemDeleteFamily);
        jMenuDelete.add(jMenuItemDeleteAward);
        
        //查询学生档案菜单
        jMenuSque.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuSque.setText(" 查询学生档案  ");
        jMenuItemSqueBaseInfo.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemSqueBaseInfo.setText("查询基本信息");
        jMenuItemSqueBaseInfo.addActionListener(new MainFrame_jMenuItemSqueBaseInfo_actionAdapter(this));
        jMenuItemSqueFamily.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemSqueFamily.setText("查询家庭信息");
        jMenuItemSqueFamily.addActionListener(new MainFrame_jMenuItemSqueFamily_actionAdapter(this));
        jMenuItemSqueAward.setFont(new java.awt.Font("Dialog", 0, 15));
        jMenuItemSqueAward.setText("查询奖惩信息");
        jMenuItemSqueAward.addActionListener(new MainFrame_jMenuItemSqueAward_actionAdapter(this));
        jMenuSque.add(jMenuItemSqueBaseInfo);
        jMenuSque.add(jMenuItemSqueFamily);
        jMenuSque.add(jMenuItemSqueAward);
        
        jMenuBar.add(jMenuSystem);
        jMenuBar.add(jMenuAdd);
        jMenuBar.add(jMenuSque);
        jMenuBar.add(jMenuChange);
        jMenuBar.add(jMenuDelete);
        jMenuBar.add(jMenuHelp);
        this.setJMenuBar(jMenuBar);
        jMenuAdd.setEnabled(false);
        jMenuChange.setEnabled(false);
        jMenuDelete.setEnabled(false);
        jMenuSque.setEnabled(false);
        jMenuItemChange.setEnabled(false);
        jMenuItemAddUser.setEnabled(false);
        contentPane.add(jLabel1, null);
        jLabel1.setText("");
        jLabel1.setBounds(new Rectangle(1, 0, 800, 603));
        this.setBounds(100, 100, 800, 600);
        this.setVisible(true);
    }
    public static void main(String args[]) {
        MainFrame main = new MainFrame();
    }
    
    public void jMenuItemExit_actionPerformed(ActionEvent e) {
        System.exit(0);
    }
    
    public void jMenuItemInfo_actionPerformed(ActionEvent e) {
       JOptionPane.showMessageDialog(null, "欢迎使用本系统，本系统是课程设计时设计的，有多不成熟之处。");
    }
    
    @Override
    protected void processWindowEvent(WindowEvent e) {
        super.processWindowEvent(e);
        if (e.getID() == WindowEvent.WINDOW_CLOSING) {
            jMenuItemExit_actionPerformed(null);
        }
    }
    
    void jMenuItemAddUser_actionPerformed(ActionEvent e) {
        new AddUserFrame();
    }
    
    void jMenuItemChange_actionPerformed(ActionEvent e){
        new ChangePwd();
    }
    
    void jMenuItemLog_actionPerformed(ActionEvent e){
        
    }
    
    void jMenuItemAddBaseInfo_actionPerformed(ActionEvent e){
         new AddBaseInfo();
    }
    
    void jMenuItemAddFamily_actionPerformed(ActionEvent e){
        strSNum = JOptionPane.showInputDialog(this, "请输入学号");
        if(!(strSNum==null)){
            try {//连接数据库，验证用户
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:学生档案","", "");
            ps = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
                try {
                    rs = ps.executeQuery("select * from 基本档案信息表 where 学号='" +strSNum + "' "); //读取数据库
                    if (!rs.next()){
                        JOptionPane.showMessageDialog(null, "不存在此学生！");
                    }
                    else{
                         new AddFamily();
                    }
                }
                catch (SQLException sqle) {
                        String error = sqle.getMessage();
                        JOptionPane.showMessageDialog(null, error);
                        sqle.printStackTrace();
                }
            }
            catch (Exception err) {
            //  err.getMessage();
            String error = err.getMessage();
            JOptionPane.showMessageDialog(null, error);
            }
        }   
    }
    
    void jMenuItemAddAward_actionPerformed(ActionEvent e){
        strSNum = JOptionPane.showInputDialog(this, "请输入学号");
        if(!(strSNum==null)){
            try {//连接数据库，验证用户
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:学生档案","", "");