mainframe.java

学生档案管理系统

            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 AddAward();
                    }
                }
                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 jMenuItemSqueBaseInfo_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 SqueBaseInfo();
                    }
                }
                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 jMenuItemSqueFamily_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 SqueFamily();
                    }
                }
                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 jMenuItemSqueAward_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 SqueAward();
                    }
                }
                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 jMenuItemChangeBaseInfo_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 ChangeBaseInfo();
                    }
                }
                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 jMenuItemChangeFamily_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 ChangeFamily();
                    }
                }
                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 jMenuItemChangeAward_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 ChangeAward();
                    }
                }
                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 jMenuItemDeleteBaseInfo_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 DeleteBaseInfo();
                    }
                }
                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 jMenuItemDeleteFamily_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 DeleteFamily();
                    }
                }
                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);
            }
        }