proceesql.java

来自「学生学籍管理系统」· Java 代码 · 共 1,459 行 · 第 1/4 页

JAVA
1,459 行
字号
1234
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
	
	//按课院系查找课程信息
	int SearchCourseByCollege(Vector vc,String college){
    	int i=0;
		try{
	
	   sql = "SELECT * FROM FORCOURSE WHERE sno IN (SELECT id FROM STUINFOR WHERE college = '"+college+"');";         	 	
       ResultSet rs = stmt.executeQuery(sql);     

        	
            while(rs.next()){
                  Vector temp_v= new Vector(9);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  temp_v.add(7,rs.getObject(7));
                  temp_v.add(8,rs.getObject(8));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
	
	//按课姓名查找课程信息
  	int SearchCourseBySname(Vector vc,String sname){
    	int i=0;
		try{
	
	   sql = "SELECT * FROM FORCOURSE WHERE sname = '"+sname+"';";         	 	
       ResultSet rs = stmt.executeQuery(sql);     

        	
            while(rs.next()){
                  Vector temp_v= new Vector(9);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  temp_v.add(7,rs.getObject(7));
                  temp_v.add(8,rs.getObject(8));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
	
	//按课学号查找课程信息
	int SearchCourseBySno(Vector vc,String sno){
    	int i=0;
		try{
	
	   sql = "SELECT * FROM FORCOURSE WHERE sno = '"+sno+"';";         	 	
       ResultSet rs = stmt.executeQuery(sql);     

        	
            while(rs.next()){
                  Vector temp_v= new Vector(9);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  temp_v.add(7,rs.getObject(7));
                  temp_v.add(8,rs.getObject(8));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
	
    //按课程号查找成绩信息
    int SearchSCByCno(Vector vc,String cno){
    	int i=0;
		try{
	
	   sql = "SELECT * FROM SC WHERE cno = '"+cno+"';";         	 	
       ResultSet rs = stmt.executeQuery(sql);     

        	
            while(rs.next()){
                  Vector temp_v= new Vector(9);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
    
	//按课程名查找成绩信息
    int SearchSCByCname(Vector vc,String cname){
    	int i=0;
		try{
	
	   sql = "SELECT * FROM SC WHERE cname = '"+cname+"';";         	 	
       ResultSet rs = stmt.executeQuery(sql);     

        	
            while(rs.next()){
                  Vector temp_v= new Vector(7);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
	
	//按课班级查找成绩信息
	int SearchSCByClasses(Vector vc,String classes){
    	int i=0;
		try{
	
	   sql = "SELECT * FROM SC WHERE sno = (SELECT id FROM STUINFOR WHERE clsses = '"+classes+"');";        	 	
       ResultSet rs = stmt.executeQuery(sql);     

        	
            while(rs.next()){
                  Vector temp_v= new Vector(7);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
	
	//按课院系查找成绩信息
	int SearchSCByCollege(Vector vc,String college){
    	int i=0;
		try{
	
	   sql = "SELECT * FROM SC WHERE  sno = (SELECT id FROM STUINFOR WHERE college = '"+college+"');";          	 	
       ResultSet rs = stmt.executeQuery(sql);     

        	
            while(rs.next()){
                  Vector temp_v= new Vector(7);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
	
	//按课姓名查找成绩信息
	int SearchSCBySname(Vector vc,String sname){
    	int i=0;
		try{
	
	   sql = "SELECT * FROM SC WHERE sname = '"+sname+"';";         	 	
       ResultSet rs = stmt.executeQuery(sql);     

        	
            while(rs.next()){
                  Vector temp_v= new Vector(7);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
	
	
  //按课学号查找成绩信息
	int SearchSCBySno(Vector vc,String sno){
    	int i=0;
		try{
	
	   sql = "SELECT * FROM SC WHERE sno = '"+sno+"';";         	 	
       ResultSet rs = stmt.executeQuery(sql);     

        	
            while(rs.next()){
                  Vector temp_v= new Vector(7);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;  
	}
	
	//按课帐号查找学生基本信息
	int SearchStudentDetailById(Vector vc,String id){
		int i=0;
		try{
		
		sql = " SELECT * FROM DETAIL WHERE id = '"+id+"';";         
        	ResultSet rs = stmt.executeQuery(sql);
        	       
         while(rs.next()){
                  Vector temp_v= new Vector(12);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  temp_v.add(7,rs.getObject(7));
                  temp_v.add(8,rs.getObject(8));
                  temp_v.add(9,rs.getObject(9));
                  temp_v.add(10,rs.getObject(10));
                  vc.addElement(temp_v);
                  i++;
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;   	
	}
	
		//按课姓名查找学生基本信息
	int SearchStudentDetailByName(Vector vc,String name){
		int i=0;
		try{
		
		sql = " SELECT * FROM DETAIL WHERE name = '"+name+"';";         
        	ResultSet rs = stmt.executeQuery(sql);
        	       
         while(rs.next()){
                  Vector temp_v= new Vector(12);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  temp_v.add(7,rs.getObject(7));
                  temp_v.add(8,rs.getObject(8));
                  temp_v.add(9,rs.getObject(9));
                  temp_v.add(10,rs.getObject(10));
                  vc.addElement(temp_v);
                  i++;
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;   	
	}
	
	//按课姓别查找学生基本信息
	int SearchStudentDetailBySex(Vector vc,String sex){
		int i=0;
		try{
		
		sql = " SELECT * FROM DETAIL WHERE sex = '"+sex+"';";         
        	ResultSet rs = stmt.executeQuery(sql);
        	       
         while(rs.next()){
                  Vector temp_v= new Vector(12);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
                  temp_v.add(7,rs.getObject(7));
                  temp_v.add(8,rs.getObject(8));
                  temp_v.add(9,rs.getObject(9));
                  temp_v.add(10,rs.getObject(10));
                  vc.addElement(temp_v);
                  i++;
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;   	
	}
	
	
	//按课年龄查找学生基本信息
	  int SearchStudentDetailByAge(Vector vc,int age){
		int i=0;
		try{
		
		sql = " SELECT * FROM DETAIL WHERE age =" + age + ";";         
        	ResultSet rs = stmt.executeQuery(sql);
        	       
         while(rs.next()){
                  Vector temp_v= new Vector(12);
            	  temp_v.add(0,(i+1));
                  temp_v.add(1,rs.getObject(1));
                  temp_v.add(2,rs.getObject(2));
                  temp_v.add(3,rs.getObject(3));
                  temp_v.add(4,rs.getObject(4));
                  temp_v.add(5,rs.getObject(5));
                  temp_v.add(6,rs.getObject(6));
1234

proceesql.java - 源码说明

本页面展示了「学生学籍管理系统」中的 proceesql.java 源码文件，采用 Java 编程语言编写，共 1,459 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与管理系统相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?