studentview.java

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

        jComboBox1.setName("jComboBox1"); // NOI18N

        jTextField18.setText(resourceMap.getString("jTextField18.text")); // NOI18N
        jTextField18.setName("jTextField18"); // NOI18N

        javax.swing.GroupLayout jDialog1Layout = new javax.swing.GroupLayout(jDialog1.getContentPane());
        jDialog1.getContentPane().setLayout(jDialog1Layout);
        jDialog1Layout.setHorizontalGroup(
            jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jDialog1Layout.createSequentialGroup()
                .addGap(10, 10, 10)
                .addGroup(jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jDialog1Layout.createSequentialGroup()
                        .addGroup(jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jDialog1Layout.createSequentialGroup()
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addComponent(jLabel3))
                            .addGroup(jDialog1Layout.createSequentialGroup()
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 107, javax.swing.GroupLayout.PREFERRED_SIZE)))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jTextField18, javax.swing.GroupLayout.PREFERRED_SIZE, 80, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jTextField17, javax.swing.GroupLayout.PREFERRED_SIZE, 80, javax.swing.GroupLayout.PREFERRED_SIZE))))
                .addContainerGap())
        );
        jDialog1Layout.setVerticalGroup(
            jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jDialog1Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel3)
                    .addComponent(jTextField17, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jDialog1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jTextField18, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jButton3)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        setComponent(mainPanel);
        setMenuBar(menuBar);
        setStatusBar(statusPanel);
    }// </editor-fold>//GEN-END:initComponents

    private void helpMenuActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_helpMenuActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_helpMenuActionPerformed

    private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem1ActionPerformed
        // TODO add your handling code here:
        if (jDialog2 == null) {
            JFrame mainFrame = StudentApp.getApplication().getMainFrame();
            jDialog2 = new StudentAboutBox(mainFrame);
            jDialog2.setLocationRelativeTo(mainFrame);
        }
        StudentApp.getApplication().show(jDialog2);
    }//GEN-LAST:event_jMenuItem1ActionPerformed

    private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem2ActionPerformed
       if (jDialog3 == null) {
            JFrame mainFrame = StudentApp.getApplication().getMainFrame();
            jDialog3 = new StudentAboutBox(mainFrame);
            jDialog3.setLocationRelativeTo(mainFrame);
        }
        StudentApp.getApplication().show(jDialog3);
        // TODO add your handling code here:
    }//GEN-LAST:event_jMenuItem2ActionPerformed

    private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem3ActionPerformed
      if (jDialog1 == null) {
            JFrame mainFrame = StudentApp.getApplication().getMainFrame();
            jDialog1 = new StudentAboutBox(mainFrame);
            jDialog1.setLocationRelativeTo(mainFrame);
        }
        StudentApp.getApplication().show(jDialog1); // TODO add your handling code here:
    }//GEN-LAST:event_jMenuItem3ActionPerformed
String id;String name;Float math,english,politics,algebra,probability,logic;
    private void jMenuItem12ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jMenuItem12ActionPerformed
             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");
              DefaultTableModel jTableabc=(DefaultTableModel)jTable1.getModel();
              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_jMenuItem12ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        if(jTextField1.getText().equals("")){
            JOptionPane.showMessageDialog(null,"学号不能为空");
        }else if(jTextField2.getText().equals("")){
            JOptionPane.showMessageDialog(null,"姓名不能为空");
        }else if(jTextField3.getText().equals("")){
            JOptionPane.showMessageDialog(null,"请填写数学分析成绩");
        }else if(jTextField4.getText().equals("")){
            JOptionPane.showMessageDialog(null,"请填写大学英语成绩");
        }else if(jTextField5.getText().equals("")){
            JOptionPane.showMessageDialog(null,"请填写政治成绩");
        }else{
            id=jTextField1.getText();
            name=jTextField2.getText();
            math=Float.parseFloat(jTextField3.getText());
            english=Float.parseFloat(jTextField4.getText());
            politics=Float.parseFloat(jTextField5.getText());
            if(jTextField6.getText().equals("")){
                algebra=(float)0;
            }else{
                algebra=Float.parseFloat(jTextField6.getText());
            }
            if(jTextField7.getText().equals("")){
                probability=(float)0;
            }else{
                probability=Float.parseFloat(jTextField7.getText());
            }
            if(jTextField8.getText().equals("")){
                logic=(float)0;
            }else{
               logic=Float.parseFloat(jTextField8.getText());
            }
            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 where id = "+"'"+id+"'" );
              if(rs.next()){
                  JOptionPane.showMessageDialog(null,"学号不能重复");
                  return;
              }
            }
            catch(Exception e){
                e.printStackTrace();
            } 
            try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=denghan","sa","");
            PreparedStatement stmt=null;
            stmt=con.prepareStatement(
                 "INSERT INTO new VALUES(?,?,?,?,?,?,?,?)");//SQL语言        
            stmt.setString(1,id);
            stmt.setString(2,name);
            stmt.setFloat(3,math);
            stmt.setFloat(4,english);                                
            stmt.setFloat(5,politics);
            stmt.setFloat(6,algebra);
            stmt.setFloat(7,probability);
            stmt.setFloat(8,logic);
            DefaultTableModel jTableabc=(DefaultTableModel)jTable1.getModel();
            Object temp[]={id,name,math,english,politics,algebra,probability,logic};
            jTableabc.addRow(temp);
     
            stmt.executeUpdate();//提交SQL语言
            stmt.clearParameters();
            stmt.close();
            stmt.close();
            con.close();
            }
            catch(Exception e){
                e.printStackTrace();
            } 
        }
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
        String temp="";

        if(!(jTextField9.getText().equals(""))){
            id=jTextField9.getText();
            temp="id = "+id;
        }
        if(!(jTextField10.getText().equals(""))){
            if(!(temp.equals(""))){
                temp=temp+" AND";
            }
            name=jTextField10.getText();
            temp=temp+" name = "+"'"+name+"'";
        }
        if(!(jTextField11.getText().equals(""))){
            if(!(temp.equals(""))){
                temp=temp+" AND";
            }
            math=Float.parseFloat(jTextField11.getText());
            temp=temp+" math = "+"'"+math+"'";
        }
        if(!(jTextField12.getText().equals(""))){
            if(!(temp.equals(""))){
                temp=temp+" AND";
            }
            english=Float.parseFloat(jTextField12.getText());
            temp=temp+" English = "+"'"+english+"'";
        }
        if(!(jTextField13.getText().equals(""))){
            if(!(temp.equals(""))){
                temp=temp+" AND";
            }
            politics=Float.parseFloat(jTextField13.getText());
            temp=temp+" politics = "+"'"+politics+"'";
        }
        if(!(jTextField14.getText().equals(""))){
            if(!(temp.equals(""))){
                temp=temp+" AND";
            }
            algebra=Float.parseFloat(jTextField14.getText());
            temp=temp+" algebra = "+"'"+algebra+"'";
        }
        if(!(jTextField15.getText().equals(""))){
            if(!(temp.equals(""))){
                temp=temp+" AND";
            }
            probability=Float.parseFloat(jTextField15.getText());
            temp=temp+" probability = "+"'"+probability+"'";
        }
        if(!(jTextField16.getText().equals(""))){
            if(!(temp.equals(""))){
                temp=temp+" AND";
            }
            logic=Float.parseFloat(jTextField16.getText());
            temp=temp+" logic = "+"'"+logic+"'";
        }
        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 where "+temp );
              while (rs.next()){
                  id=rs.getString("id");
                  name=rs.getString("name");
                  math=rs.getFloat("math");
                  english=rs.getFloat("English");