teachingsystem.java

学生成绩管理系统

        }
     }  
    }
    if(temp==1){
    int t1=0;
              sql="UPDATE 学生 SET 登录=1 WHERE 学生编号='"+string1+"'";
             t1=statement.executeUpdate(sql);}
    }
    else
    {
        JOptionPane.showMessageDialog(null, "用户名不正确","错误",JOptionPane.ERROR_MESSAGE);
    }
    }
    catch(SQLException sqlException){
        JOptionPane.showMessageDialog(null,sqlException.getMessage(),"Database Error",JOptionPane.ERROR_MESSAGE);
        System.exit(1);}

   catch(ClassNotFoundException classNotFound){
       JOptionPane.showMessageDialog(null,classNotFound.getMessage(),"Driver Not Found",JOptionPane.ERROR_MESSAGE);
        System.exit(1); }// TODO add your handling code here:       
}
else if( type == "教师" )
{        
     Statement statement;
   String string1=new String(jTextField1.getText());  
   String string2=new String(jPasswordField1.getPassword()); 
   String string3,string4;
   int t=-1;
try{
     Conect conect=new Conect();
     statement=conect.dbConn.createStatement(); 
     
     String sql="UPDATE 教师 SET 登录=0 WHERE 登录=1";
     int t0=statement.executeUpdate(sql);
     
     
 
    string3="SELECT 教师编号 FROM 教师";/*该编号的正确密码*/
    ResultSet resultSet1=statement.executeQuery(string3);
    ResultSetMetaData metaData1=resultSet1.getMetaData();
    int numberOfColumns1=metaData1.getColumnCount();
    while(resultSet1.next()){
       for(int i=1;i<=numberOfColumns1;i++)
       { if(resultSet1.getObject(i).equals(string1))
          t++;
       }
     }
    
    if(t==0) {
    {dispose();
     string4="SELECT 密码 FROM 教师 WHERE 教师编号='"+string1+"'";
     ResultSet resultSet2=statement.executeQuery(string4);
    
    ResultSetMetaData metaData2=resultSet2.getMetaData();
    int numberOfColumns2=metaData2.getColumnCount();
    
    while(resultSet2.next()){
       for(int i=1;i<=numberOfColumns2;i++)
        { 
           if(string2.equals(resultSet2.getObject(i).toString()))
           { 
              temp=1; 
             new Teacher().setVisible(true);
           }  
           else JOptionPane.showMessageDialog(null,"用户密码不正确","错误",JOptionPane.ERROR_MESSAGE);
        }
     }  
    }
    if(temp==1){
    int t1=0;
              sql="UPDATE 教师 SET 登录=1 WHERE 教师编号='"+string1+"'";
             t1=statement.executeUpdate(sql);}
    }
    else
    {
        JOptionPane.showMessageDialog(null, "用户名不正确","错误",JOptionPane.ERROR_MESSAGE);
    }
    }
    catch(SQLException sqlException){
        JOptionPane.showMessageDialog(null,sqlException.getMessage(),"Database Error",JOptionPane.ERROR_MESSAGE);
        System.exit(1);}

   catch(ClassNotFoundException classNotFound){
       JOptionPane.showMessageDialog(null,classNotFound.getMessage(),"Driver Not Found",JOptionPane.ERROR_MESSAGE);
        System.exit(1);
   }
}
   else if(type=="教务管理员")
   {
    Statement statement;
   String string1=new String(jTextField1.getText());  
   String string2=new String(jPasswordField1.getPassword()); 
   String string3,string4;
   int t=-1;
try{
     Conect conect=new Conect();
     statement=conect.dbConn.createStatement(); 
     
     String sql="UPDATE 教务管理员 SET 登录=0 WHERE 登录=1";
     int t0=statement.executeUpdate(sql);
     
     
 
    string3="SELECT 教务管理员编号 FROM 教务管理员";/*该编号的正确密码*/
    ResultSet resultSet1=statement.executeQuery(string3);
    ResultSetMetaData metaData1=resultSet1.getMetaData();
    int numberOfColumns1=metaData1.getColumnCount();
    while(resultSet1.next()){
       for(int i=1;i<=numberOfColumns1;i++)
       { if(resultSet1.getObject(i).equals(string1))
          t++;
       }
     }
    
    if(t==0) {
    {dispose();
     string4="SELECT 密码 FROM 教务管理员 WHERE 教务管理员编号='"+string1+"'";
     ResultSet resultSet2=statement.executeQuery(string4);
    
    ResultSetMetaData metaData2=resultSet2.getMetaData();
    int numberOfColumns2=metaData2.getColumnCount();
    
    while(resultSet2.next()){
       for(int i=1;i<=numberOfColumns2;i++)
        { 
           if(string2.equals(resultSet2.getObject(i).toString()))
           { 
              temp=1; 
             new Assistant().setVisible(true);
           }  
           else JOptionPane.showMessageDialog(null,"用户密码不正确","错误",JOptionPane.ERROR_MESSAGE);
        }
     }  
    }
    if(temp==1){
    int t1=0;
              sql="UPDATE 教务管理员 SET 登录=1 WHERE 教务管理员编号='"+string1+"'";
             t1=statement.executeUpdate(sql);}
    }
    else
    {
        JOptionPane.showMessageDialog(null, "用户名不正确","错误",JOptionPane.ERROR_MESSAGE);
    }
    }
    catch(SQLException sqlException){
        JOptionPane.showMessageDialog(null,sqlException.getMessage(),"Database Error",JOptionPane.ERROR_MESSAGE);
        System.exit(1);}

   catch(ClassNotFoundException classNotFound){
       JOptionPane.showMessageDialog(null,classNotFound.getMessage(),"Driver Not Found",JOptionPane.ERROR_MESSAGE);
        System.exit(1); }// TODO add your handling code here:       
}// TODO add your handling code here:
    }//GEN-LAST:event_enter

    private void student(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_student
type = jRadioButton1.getText();// TODO add your handling code here:
    }//GEN-LAST:event_student
    
    /**
     * @param args the command line arguments
     */
 
public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Teachingsystem().setVisible(true);
           
            }
        });                                          
}
    
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JPasswordField jPasswordField1;
    private javax.swing.JRadioButton jRadioButton1;
    private javax.swing.JRadioButton jRadioButton2;
    private javax.swing.JRadioButton jRadioButton3;
    private javax.swing.JTextField jTextField1;
    // End of variables declaration//GEN-END:variables

    private String type;

    private boolean ture;

    private int temp;



    
}