proceesql.java

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

JAVA
1,459 行
字号
1234
                  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 SearchStudentDetailByDomNum(Vector vc,int domBuilding){
		int i=0;
		try{
		
		sql = " SELECT * FROM DETAIL WHERE domBuilding = '"+domBuilding+"';";         
        	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;   	
	}
	


	
	//插入学籍信息
	public void insertStuInforDetail(Object StuInfor[]){	
     try {	 
   	 	 //0id,1name,2sex,3birthPlace,4testPlace,5graduateSchool,6totalScore
 //7birthDate,8nation,9eductionalSystem,10languageType,11degree,
 //12entranceDate,13politicsType,14college,15classes
  
  
    sql ="INSERT INTO STUINFOR " +
    "VALUES("+"'"+String.valueOf(StuInfor[0])+"','"+String.valueOf(StuInfor[1])+"','"+String.valueOf(StuInfor[2]) +"','"+
    String.valueOf(StuInfor[3])+"','"+String.valueOf(StuInfor[4]) +"','"+String.valueOf(StuInfor[5])+"',"+String.valueOf(StuInfor[6]) +",'"
    + String.valueOf(StuInfor[7])+"','"+String.valueOf(StuInfor[8]) +"','"+String.valueOf(StuInfor[9])+"','"+String.valueOf(StuInfor[10]) +"','"
    + String.valueOf(StuInfor[11])+"','"+ String.valueOf(StuInfor[12])+"','"+String.valueOf(StuInfor[13])+"','"+String.valueOf(StuInfor[14])+"','"
    +String.valueOf(StuInfor[15])+"');";
     stmt.executeUpdate(sql);            
     con.commit();                           


       	} catch(SQLException ex) {
       		JOptionPane.showMessageDialog(null, "对象已经存在或高考分数错误");
            System.err.println("SQLException: " + ex.getMessage());
            	

        }             		
	}
	
	
	
		//提取学籍
	int getStudentInfor(Vector vc){
    	int i=0;
		try{
	
		sql = " SELECT * FROM STUINFOR";         
        	ResultSet rs = stmt.executeQuery(sql);
        	
            while(rs.next()){
            	Vector temp_v= new Vector(17);
            	  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));
                  temp_v.add(11,rs.getObject(11));
                  temp_v.add(12,rs.getObject(12));
                  temp_v.add(13,rs.getObject(13));
                  temp_v.add(14,rs.getObject(14));
                  temp_v.add(15,rs.getObject(15));
                  temp_v.add(16,rs.getObject(16));
                  vc.addElement(temp_v);
	          i++; 
	           }
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }    
        return i;   	
	}
	
	
	  //按学号查找学籍2
	void SearchStuInforForCustomer(Object studentInfor[],String id){
		try{

		sql = " SELECT * FROM STUINFOR "+" where id=" +"'"+id+"'";                 
        	ResultSet rs = stmt.executeQuery(sql);
        	
            while(rs.next()){
             studentInfor[0]=rs.getObject(1);
             studentInfor[1]=rs.getObject(2);
             studentInfor[2]=rs.getObject(3);
             studentInfor[3]=rs.getObject(4);
             studentInfor[4]=rs.getObject(5);
             studentInfor[5]=rs.getObject(6);
             studentInfor[6]=rs.getObject(7);
             studentInfor[7]=rs.getObject(8);
             studentInfor[8]=rs.getObject(9);
             studentInfor[9]=rs.getObject(10);
             studentInfor[10]=rs.getObject(11);
             studentInfor[11]=rs.getObject(12);
             studentInfor[12]=rs.getObject(13);
             studentInfor[13]=rs.getObject(14);
             studentInfor[14]=rs.getObject(15);
              studentInfor[15]=rs.getObject(16);
	           }
    
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
	}
	
	
	
	   //按学号查找学籍
	int SearchStuInforById(Vector vc,String id){
		int i=0;
		try{

		sql = " SELECT * FROM STUINFOR "+" where id=" +"'"+id+"'";                 
        	ResultSet rs = stmt.executeQuery(sql);
        	
        	
             while(rs.next()){
            	Vector temp_v= new Vector(17);
            	  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));
                  temp_v.add(11,rs.getObject(11));
                  temp_v.add(12,rs.getObject(12));
                  temp_v.add(13,rs.getObject(13));
                  temp_v.add(14,rs.getObject(14));
                  temp_v.add(15,rs.getObject(15));
                  temp_v.add(16,rs.getObject(16));
                  vc.addElement(temp_v);
                  i++;
	           }
    
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
        return i;
	}
	
   //按姓名查找学籍
	int SearchStuInforByName(Vector vc,String Sname){
		int i=0;
		try{

		sql = " SELECT * FROM STUINFOR "+" where name=" +"'"+Sname+"'";                 
        	ResultSet rs = stmt.executeQuery(sql);
        	
        	
             while(rs.next()){
            	Vector temp_v= new Vector(17);
            	  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));
                  temp_v.add(11,rs.getObject(11));
                  temp_v.add(12,rs.getObject(12));
                  temp_v.add(13,rs.getObject(13));
                  temp_v.add(14,rs.getObject(14));
                  temp_v.add(15,rs.getObject(15));
                  temp_v.add(16,rs.getObject(16));
                  vc.addElement(temp_v);
                  i++;
	           }
    
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
        return i;
	}
	
	   //按班级查找学籍
	int SearchStuInforByClasses(Vector vc,String classes){
		int i=0;
		try{

		sql = " SELECT * FROM STUINFOR "+" where classes=" +"'"+classes+"'";                 
        	ResultSet rs = stmt.executeQuery(sql);
        	
        	
             while(rs.next()){
            	Vector temp_v= new Vector(17);
            	  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));
                  temp_v.add(11,rs.getObject(11));
                  temp_v.add(12,rs.getObject(12));
                  temp_v.add(13,rs.getObject(13));
                  temp_v.add(14,rs.getObject(14));
                  temp_v.add(15,rs.getObject(15));
                  temp_v.add(16,rs.getObject(16));
                  vc.addElement(temp_v);
                  i++;
	           }
    
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
        return i;
	}
	
	   //按院系查找学籍
	int SearchStuInforByCollege(Vector vc,String college){
		int i=0;
		try{

		sql = " SELECT * FROM STUINFOR "+" where college=" +"'"+college+"'";                 
        	ResultSet rs = stmt.executeQuery(sql);
        	
        	
             while(rs.next()){
            	Vector temp_v= new Vector(17);
            	  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));
                  temp_v.add(11,rs.getObject(11));
                  temp_v.add(12,rs.getObject(12));
                  temp_v.add(13,rs.getObject(13));
                  temp_v.add(14,rs.getObject(14));
                  temp_v.add(15,rs.getObject(15));
                  temp_v.add(16,rs.getObject(16));
                  vc.addElement(temp_v);
                  i++;
	           }
    
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
        return i;
	}
	
	   //按民族查找学籍
	int SearchStuInforByNation(Vector vc,String nation){
		int i=0;
		try{

		sql = " SELECT * FROM STUINFOR "+" where nation=" +"'"+nation+"'";                 
        	ResultSet rs = stmt.executeQuery(sql);
        	
        	
             while(rs.next()){
            	Vector temp_v= new Vector(17);
            	  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));
                  temp_v.add(11,rs.getObject(11));
                  temp_v.add(12,rs.getObject(12));
                  temp_v.add(13,rs.getObject(13));
                  temp_v.add(14,rs.getObject(14));
                  temp_v.add(15,rs.getObject(15));
                  temp_v.add(16,rs.getObject(16));
                  vc.addElement(temp_v);
                  i++;
	           }
    
	         }catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
        return i;
	}
	
	   //插入SC表,根据学号和选定的课程
	public void insertScDetail(Object course[]){	
          	 try {
          	 
          	 sql = "INSERT INTO StudentCourse " +
              "VALUES("+"'"+String.valueOf(course[0])+"','" + String.valueOf(course[2]) +"',0);";
                stmt.executeUpdate(sql);            
                con.commit();   
	           } catch(SQLException ex) {
	        JOptionPane.showMessageDialog(null,"对象已经存在！");
            System.err.println("SQLException: " + ex.getMessage());          	
        }             		
	}
	
    //提取SC表内容
	int getSC(Vector vc){
    	int i=0;
		try{
	
		sql = " SELECT DISTINCT * FROM SC";         
        	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));
1234

proceesql.java - 源码说明

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

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

⌨️ 快捷键说明

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