新建 文本文档.txt

来自「学生成绩管理」· 文本 代码 · 共 466 行 · 第 1/2 页

        catch(SQLException ex){
            System.out.println("\nERROR:-----SQLException-----\n");
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
        }
    }
}

void deleteButoon_actionPerformed(ActionEvent e){
    try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        String url="jdbc:odbc:student";
        connection=DriverManager.getConnection(url);
        statement=connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        String sql="select *from studentbase whrer="+Integer.parseInt(stunumField.getText())+" ";
        rSet=statement.executeQuery(sql);
        if(rSet.next()==false){
            JOptionPane msg=new JOptionPane();
            JOptionPane.showMessageDialog(StuAddQuerySysFrame.this,"","",1);
        }
        else{
        String sql1="delete from studentbase where ="+Integer.parseInt(stunumField.getText())+" ";
        statement.executeUpdate(sql1);
        String sql2="delete from studentaddress where ="+Integer.parseInt(stunumField.getText())+" ";
        statement.executeUpdate(sql2);
        stunumField.setText("");
        nameField.setText("");
        ageField.setText("");
        sexField.setText("");
        departmentField.setText("");
        teleField.setText("");
        emailField.setText("");
    }
    }
    catch(SQLException ex){
        System.out.println("\nERROR:-----SQLException-----\n");
        while(ex!=null){
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
            ex=ex.getNextException();
        }        
    }
    catch(Exception ex){
        ex.printStackTrace();
    }
    finally{
        try{
            if(statement !=null){
                statement.close();
            }
            if(connection !=null){
                connection.close();
            }
        }
        catch(SQLException ex){
            System.out.println("\nERROR:-----SQLException-----\n");
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
        }
    }
}

void refreshButoon_actionPerformed(ActionEvent e){
    try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        String url="jdbc:odbc:student";
        connection=DriverManager.getConnection(url);
        statement=connection.createStatement();
        String sql1="update studentbase set='"+nameField.getText()+"',="+Integer.parseInt(ageField.getText())
                +" ,="+sexField.getText()+"',='"+departmentField.getText()+"' where ="+
                Integer.parseInt(stunumField.getText())+" ";
        statement.executeUpdate(sql1);
        String sql2="Update studentaddress set ='"+teleField.getText()+"',email ='"+departmentField.getText()
                +"' where ="+Integer.parseInt(stunumField.getText())+" ";
        statement.executeUpdate(sql2);
        stunumField.setText("");
        nameField.setText("");
        ageField.setText("");
        sexField.setText("");
        departmentField.setText("");
        teleField.setText("");
        emailField.setText("");
    }
    catch(SQLException ex){
        System.out.println("\nERROR:-----SQLException-----\n");
        while(ex!=null){
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
            ex=ex.getNextException();
        }        
    }
    catch(Exception ex){
        ex.printStackTrace();
    }
    finally{
        try{
            if(statement !=null){
                statement.close();
            }
            if(connection !=null){
                connection.close();
            }
        }
        catch(SQLException ex){
            System.out.println("\nERROR:-----SQLException-----\n");
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
        }
    }
}

void stunumqueryButoon_actionPerformed(ActionEvent e){
    try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        String url="jdbc:odbc:student";
        connection=DriverManager.getConnection(url);
        statement=connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        String sql="select *from studentbase whrer="+Integer.parseInt(stunumField.getText())+" ";
        rSet=statement.executeQuery(sql);
        if(rSet.next()==false){
            JOptionPane msg=new JOptionPane();
            JOptionPane.showMessageDialog(StuAddQuerySysFrame.this,"","",1);
        }
        else{
        sql="select studentbase.,,,,,,email from studen tbase inner join studentaddress on +(studentbase.=studentaddress.)where studentbase.="
                +Integer.parseInt(stunumField.getText())+" ";
        ResultSet rs=statement.executeQuery(sql);
        stunumField.setText("");
        vector.removeAllElements();
        tm.fireTableStructureChanged();
        while(rs.next()){
            Vector rec_vector=new Vector();
            rec_vector.addElement(String.valueOf(rs.getInt(1)));
            rec_vector.addElement(rs.getString(2));
            rec_vector.addElement(String.valueOf(rs.getInt(3)));
            rec_vector.addElement(rs.getString(4));
            rec_vector.addElement(rs.getString(5));
            rec_vector.addElement(rs.getString(6));
            rec_vector.addElement(rs.getString(7));
            vector.addElement(rec_vector);
        }
        tm.fireTableStructureChanged();
        }
    }
    catch(SQLException ex){
        System.out.println("\nERROR:-----SQLException-----\n");
        while(ex!=null){
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
            ex=ex.getNextException();
        }        
    }
    catch(Exception ex){
        ex.printStackTrace();
    }
    finally{
        try{
            if(statement !=null){
                statement.close();
            }
            if(connection !=null){
                connection.close();
            }
        }
        catch(SQLException ex){
            System.out.println("\nERROR:-----SQLException-----\n");
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
        }
    }
}

void allrecordButton_actionPerformed(ActionEvent e){
    try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        String url="jdbc:odbc:student";
        connection=DriverManager.getConnection(url);
        statement=connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        String sql="select studentbase.,,,,,,email from studentbase inner join studentaddress on(studentbase.=studentaddress.)";
        rSet=statement.executeQuery(sql);
        vector.removeAllElements();
        tm.fireTableStructureChanged();
        while(rSet.next()){
            Vector rec_vector=new Vector();
            rec_vector.addElement(String.valueOf(rSet.getInt(1)));
            rec_vector.addElement(rSet.getString(2));
            rec_vector.addElement(String.valueOf(rSet.getInt(3)));
            rec_vector.addElement(rSet.getString(4));
            rec_vector.addElement(rSet.getString(5));
            rec_vector.addElement(rSet.getString(6));
            rec_vector.addElement(rSet.getString(7));
            vector.addElement(rec_vector);
        }
        tm.fireTableStructureChanged();
        }
 catch(SQLException ex){
        System.out.println("\nERROR:-----SQLException-----\n");
        while(ex!=null){
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
            ex=ex.getNextException();
        }        
    }
    catch(Exception ex){
        ex.printStackTrace();
    }
    finally{
        try{
            if(statement !=null){
                statement.close();
            }
            if(connection !=null){
                connection.close();
            }
        }
        catch(SQLException ex){
            System.out.println("\nERROR:-----SQLException-----\n");
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
        }
    }
}
}