mainframe.java

学生档案管理系统

    }
    
    void jMenuItemDeleteAward_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 DeleteAward();
                    }
                }
                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 jMenuItemLog_actioinPerformed(ActionEvent e){
        userName = JOptionPane.showInputDialog(this, "请输入用户名");
        psd = JOptionPane.showInputDialog(this, "请输入密码");
        if (! (userName == null && psd == 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 用户名='" + userName + "' "); //读取数据库
                    if (!rs.next()){
                        JOptionPane.showMessageDialog(null, "不存在此用户！");
                    }
                    else if (! (rs.getString("用户密码").trim().equals(psd))) {
                        JOptionPane.showMessageDialog(null, "密码错误！");         
                    }
                    else {
                        jMenuAdd.setEnabled(true);
                        jMenuChange.setEnabled(true);
                        jMenuSque.setEnabled(true);
                        jMenuDelete.setEnabled(true);
                        jMenuItemAddUser.setEnabled(true);
                        jMenuItemChange.setEnabled(true);
                        jMenuItemLog.setEnabled(false);
                    }
                }
                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);
            }
        }
    }   
}

class MainFrame_jMenuItemLog_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemLog_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemLog_actioinPerformed(e);
    } 
}

class MainFrame_jMenuItemChange_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemChange_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemChange_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemAddUser_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemAddUser_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemAddUser_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemExit_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemExit_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
     public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemExit_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemInfo_ActionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemInfo_ActionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
     public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemInfo_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemAddBaseInfo_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemAddBaseInfo_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemAddBaseInfo_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemAddFamily_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemAddFamily_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemAddFamily_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemAddAward_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemAddAward_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemAddAward_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemDeleteBaseInfo_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemDeleteBaseInfo_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemDeleteBaseInfo_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemDeleteFamily_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemDeleteFamily_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemDeleteFamily_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemDeleteAward_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemDeleteAward_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemDeleteAward_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemChangeBaseInfo_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemChangeBaseInfo_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemChangeBaseInfo_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemChangeFamily_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemChangeFamily_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemChangeFamily_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemChangeAward_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemChangeAward_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemChangeAward_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemSqueBaseInfo_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemSqueBaseInfo_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemSqueBaseInfo_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemSqueFamily_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemSqueFamily_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemSqueFamily_actionPerformed(e);
    } 
}

class MainFrame_jMenuItemSqueAward_actionAdapter implements ActionListener{
    MainFrame adaptee;
    MainFrame_jMenuItemSqueAward_actionAdapter(MainFrame adaptee){
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
       //throw new UnsupportedOperationException("Not supported yet.");
        adaptee.jMenuItemSqueAward_actionPerformed(e);
    } 
}