studentview.java

使用指定的编程工具编写一个班级成绩管理系统

                  politics=rs.getFloat("politics");
                  algebra=rs.getFloat("algebra");
                  probability=rs.getFloat("probability");
                  logic=rs.getFloat("logic");
                  Object temp1[]={id,name,math,english,politics,algebra,probability,logic};
                  jTableabc.addRow(temp1);
              }        
            rs.close();
            stmt.close();
            con.close();
        }
        catch(Exception e){e.printStackTrace();} 
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
        int temp1;Float temp2;String temp3;
        temp3=jTextField18.getText();
        temp2=Float.parseFloat(temp3);
        if(jTextField17.getText().equals("")){
            JOptionPane.showMessageDialog(null,"学号不能为空");
        }else{
            temp1=jComboBox1.getSelectedIndex();
            try{
                 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                 Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=denghan","sa","");
                 Statement stmt =con.createStatement(
                 ResultSet.TYPE_SCROLL_SENSITIVE,
                 ResultSet.CONCUR_UPDATABLE);
                 ResultSet rs=null;
                  String ID=jTextField17.getText();
                 rs=stmt.executeQuery(
                 "SELECT * FROM new WHERE id="+ID);
                 rs.last();
                 switch(temp1){
                    case 0:
                         rs.updateString("math", temp3);
                        break;
                     case 1:
                         rs.updateString("English", temp3);
                         break;
                     case 2:
                         rs.updateString("politics", temp3);
                         break;
                     case 3:
                         rs.updateString("algebra", temp3);
                         break;
                     case 4:
                         rs.updateString("probability", temp3);
                         break;
                     case 5:
                         rs.updateString("logic", temp3);
                         break;
                 }
                 rs.updateRow();
                 JOptionPane.showMessageDialog(null, "修改成功", "修改", JOptionPane.INFORMATION_MESSAGE);
                 rs.close();
                 stmt.close();
                 con.close();
             }
             catch(Exception ee){
                 ee.printStackTrace();
             }
            DefaultTableModel jTableabc=(DefaultTableModel)jTable1.getModel();
            jTableabc.setRowCount(0);
            try{
              Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
              Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=denghan","sa","");
              Statement stmt =con.createStatement();
              String  in="insert into new";
 //stmt.executeUpdate(in);
              ResultSet rs =stmt.executeQuery("select *   from new");
              while (rs.next()){
                  id=rs.getString("id");
                  name=rs.getString("name");
                  math=rs.getFloat("math");
                  english=rs.getFloat("English");
                  politics=rs.getFloat("politics");
                  algebra=rs.getFloat("algebra");
                  probability=rs.getFloat("probability");
                  logic=rs.getFloat("logic");
                  Object temp[]={id,name,math,english,politics,algebra,probability,logic};
                  jTableabc.addRow(temp);
              }
              rs.close();
             // stmt.close();
              con.close();
          }catch(Exception e){
              e.printStackTrace();
          }
        }
    }//GEN-LAST:event_jButton3ActionPerformed

    private void exitMenuItemActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_exitMenuItemActionPerformed
        // TODO add your handling code here:
        System.exit(0);
    }//GEN-LAST:event_exitMenuItemActionPerformed

    private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem4ActionPerformed
        DefaultTableModel jTableabc=(DefaultTableModel)jTable1.getModel();
        jTableabc.setRowCount(0);
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=denghan","sa","");
          
            Statement stmt = con.createStatement();
            ResultSet rs =stmt.executeQuery("select *   from new order by id");
              while (rs.next()){
                  id=rs.getString("id");
                  name=rs.getString("name");
                  math=rs.getFloat("math");
                  english=rs.getFloat("English");
                  politics=rs.getFloat("politics");
                  algebra=rs.getFloat("algebra");
                  probability=rs.getFloat("probability");
                  logic=rs.getFloat("logic");
                  Object temp1[]={id,name,math,english,politics,algebra,probability,logic};
                  jTableabc.addRow(temp1);
              }        
            rs.close();
            stmt.close();
            con.close();
        }
        catch(Exception e){e.printStackTrace();} 
    }//GEN-LAST:event_jMenuItem4ActionPerformed

    private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem5ActionPerformed
        DefaultTableModel jTableabc=(DefaultTableModel)jTable1.getModel();
        jTableabc.setRowCount(0);
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=denghan","sa","");
          
            Statement stmt = con.createStatement();
            ResultSet rs =stmt.executeQuery("select *   from new order by math desc");
              while (rs.next()){
                  id=rs.getString("id");
                  name=rs.getString("name");
                  math=rs.getFloat("math");
                  english=rs.getFloat("English");
                  politics=rs.getFloat("politics");
                  algebra=rs.getFloat("algebra");
                  probability=rs.getFloat("probability");
                  logic=rs.getFloat("logic");
                  Object temp1[]={id,name,math,english,politics,algebra,probability,logic};
                  jTableabc.addRow(temp1);
              }        
            rs.close();
            stmt.close();
            con.close();
        }
        catch(Exception e){e.printStackTrace();} 
    }//GEN-LAST:event_jMenuItem5ActionPerformed

    private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem6ActionPerformed
       DefaultTableModel jTableabc=(DefaultTableModel)jTable1.getModel();
        jTableabc.setRowCount(0);
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=denghan","sa","");
          
            Statement stmt = con.createStatement();
            ResultSet rs =stmt.executeQuery("select *   from new order by English desc");
              while (rs.next()){
                  id=rs.getString("id");
                  name=rs.getString("name");
                  math=rs.getFloat("math");
                  english=rs.getFloat("English");
                  politics=rs.getFloat("politics");
                  algebra=rs.getFloat("algebra");
                  probability=rs.getFloat("probability");
                  logic=rs.getFloat("logic");
                  Object temp1[]={id,name,math,english,politics,algebra,probability,logic};
                  jTableabc.addRow(temp1);
              }        
            rs.close();
            stmt.close();
            con.close();
        }
        catch(Exception e){e.printStackTrace();} 
    }//GEN-LAST:event_jMenuItem6ActionPerformed

    private void jMenuItem7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem7ActionPerformed
        DefaultTableModel jTableabc=(DefaultTableModel)jTable1.getModel();
        jTableabc.setRowCount(0);
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=denghan","sa","");
          
            Statement stmt = con.createStatement();
            ResultSet rs =stmt.executeQuery("select *   from new order by politics desc");
              while (rs.next()){
                  id=rs.getString("id");
                  name=rs.getString("name");
                  math=rs.getFloat("math");
                  english=rs.getFloat("English");
                  politics=rs.getFloat("politics");
                  algebra=rs.getFloat("algebra");
                  probability=rs.getFloat("probability");
                  logic=rs.getFloat("logic");
                  Object temp1[]={id,name,math,english,politics,algebra,probability,logic};
                  jTableabc.addRow(temp1);
              }        
            rs.close();
            stmt.close();
            con.close();
        }
        catch(Exception e){e.printStackTrace();} 
    }//GEN-LAST:event_jMenuItem7ActionPerformed

    private void jMenuItem8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem8ActionPerformed
        DefaultTableModel jTableabc=(DefaultTableModel)jTable1.getModel();
        jTableabc.setRowCount(0);
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=denghan","sa","");
          
            Statement stmt = con.createStatement();
            ResultSet rs =stmt.executeQuery("select *   from new order by algebra desc");
              while (rs.next()){
                  id=rs.getString("id");
                  name=rs.getString("name");
                  math=rs.getFloat("math");
                  english=rs.getFloat("English");
                  politics=rs.getFloat("politics");
                  algebra=rs.getFloat("algebra");
                  probability=rs.getFloat("probability");
                  logic=rs.getFloat("logic");
                  Object temp1[]={id,name,math,english,politics,algebra,probability,logic};
                  jTableabc.addRow(temp1);
              }        
            rs.close();
            stmt.close();
            con.close();
        }
        catch(Exception e){e.printStackTrace();}
    }//GEN-LAST:event_jMenuItem8ActionPerformed

    private void jMenuItem9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem9ActionPerformed
        DefaultTableModel jTableabc=(DefaultTableModel)jTable1.getModel();
        jTableabc.setRowCount(0);
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=denghan","sa","");
          
            Statement stmt = con.createStatement();
            ResultSet rs =stmt.executeQuery("select *   from new order by probability desc");
              while (rs.next()){
                  id=rs.getString("id