searchdao.java

一个管理系统 用java作的

            int i = 0;
            while(rs.next() && i < Constants.PAGENUM){
                
                 partVo = new PartVo();
                 partVo.setName(rs.getString("name"));
                 partVo.setId(rs.getString("ID"));
                 partVo.setSex(rs.getString("sex"));
                 partVo.setDep_name(rs.getString("dep_name"));
                 partVos.add(partVo);
                 i++;
          	     }
            
            //set resultVo 
            resultVo.setRecords(count);
            resultVo.setPartVos(partVos);
            
            
            int rest = count % Constants.PAGENUM;
            int page = count /Constants.PAGENUM;
           
            int pages = (0 == rest) ? page : page + 1;
            resultVo.setPages(pagenumber);
            //set page list
            for(int j = 1;j <= pages;j++) {
                if (pagenumber == j){
                    integer = new Integer(-1);
                    list.add(integer);
                }
                else{ 
                    integer = new Integer(j);
                	list.add(integer);
                }
            }
            resultVo.setList(list);
            
            
           

      	    }finally{
              
      	        try{
                  
      	            silentClose(rs);
          	    
      	            silentClose(stm);
          	    
      	            silentClose(con);
                
                }catch(Exception e){
                    e.printStackTrace();
                  	}
            }
      	
            return resultVo;
          
    }
    
    /*******************************************************************************
     * 張棟撪梕偺奣梫:晛捠?岺崻悩?岺ID??晞崌梫媮揑?岺??怣懅
     * 
     * @param   堷悢:?岺ID
     * @return  栠傝抣:detailVo,懚??岺??怣懅 
     * @exception  ?忢丗Exception
     *******************************************************************************
     */
    public DetailVo detail_search(String id)throws Exception {
        
        Connection con    = connectToDb();
        String sql        = Constants.SQL_EMP + "'" + id + "'";
        DetailVo detailVo = new DetailVo();
        
        try{
            
          stm=con.createStatement();
          rs=stm.executeQuery(sql);
          rs.next();
         
          detailVo.setName(rs.getString("name"));
          detailVo.setId(rs.getString("ID"));
          
          String str = rs.getString("birthday");
          if(str != null){
          detailVo.setBirth_year(str.substring(0,4));
          detailVo.setBirth_month(str.substring(5,7));
          detailVo.setBirth_day(str.substring(8,10));
          }
          else{ 
              detailVo.setBirth_year(null);
              detailVo.setBirth_month(null);
              detailVo.setBirth_day(null);
          }
          detailVo.setSex(rs.getString("sex"));
          detailVo.setGrade(rs.getString("grade"));
          detailVo.setBorn_in(rs.getString("born_in"));
          detailVo.setPolity(rs.getString("polity"));
          detailVo.setTelephone(rs.getString("telephone"));
          detailVo.setDep_name(rs.getString("dep_name"));

    	  }finally {
    	    
    	    try{
    	    
    	        silentClose(rs);
    	    
    	        silentClose(stm);
    	    
    	        silentClose(con);
    	    
	    	}catch(Exception e){
    	        e.printStackTrace();
    	        }
    	  }
    	
        return detailVo;
    }
    
    /*******************************************************************************
     * 張棟撪梕偺奣梫:??悢悩????摼晹?柤
     * 
     * @param   堷悢:null
     * @return  栠傝抣:resultDepVo,懚?晹?柤 
     * @exception  ?忢丗Exception
     *******************************************************************************
     */
    public ResultDepVo dep_search()throws Exception {
        
        Connection con          = connectToDb();
        String sql              = Constants.SQL_DEP;
        DepVo depVo;            
        ArrayList list          = new ArrayList();
        ResultDepVo resultDepVo = new ResultDepVo();
        try{
            
          stm=con.createStatement();
          rs=stm.executeQuery(sql);
            
          while(rs.next()){
              
             depVo = new DepVo();
             depVo.setDep_name(rs.getString("dep_name"));
             depVo.setDep_id(rs.getString("dep_id"));
             list.add(depVo);
             }
          resultDepVo.setDepVos(list);
        }finally{
                
      	   try{
                  
      	       silentClose(rs);
          	    
  	           silentClose(stm);
          	    
  	           silentClose(con);
                
            }catch(Exception e){
                e.printStackTrace();
                }
         }
        
        return resultDepVo;
    }
    
    /*******************************************************************************
     * 張棟撪梕偺奣梫:娗棟?崻悩?岺ID??晞崌梫媮揑?岺??怣懅
     * 
     * @param   堷悢:?岺ID崋
     * @return  栠傝抣:m_DetailVo,懚??岺??怣懅 
     * @exception  ?忢丗Exception
     *******************************************************************************
     */
    public M_DetailVo m_detail_search(String id,String dep_id)throws Exception {
        
        Connection con        = connectToDb();
        String sql        	  = Constants.SQL_ADMIN + "'" + id + "'";
        M_DetailVo m_detailVo = new M_DetailVo();
        
        try{
          stm=con.createStatement();
          rs=stm.executeQuery(sql);
          rs.next();
          
          m_detailVo.setName(rs.getString("name"));
          m_detailVo.setId(rs.getString("ID"));
          
          String str = rs.getString("birthday");
          if(str != null){
          m_detailVo.setBirth_year(str.substring(0,4));
          m_detailVo.setBirth_month(str.substring(5,7));
          m_detailVo.setBirth_day(str.substring(8,10));
          }
          else{ 
              m_detailVo.setBirth_year(null);
              m_detailVo.setBirth_month(null);
              m_detailVo.setBirth_day(null);
          }
          m_detailVo.setSex(rs.getString("sex"));
          m_detailVo.setGrade(rs.getString("grade"));
          m_detailVo.setBorn_in(rs.getString("born_in"));
          m_detailVo.setPolity(rs.getString("polity"));
          m_detailVo.setTelephone(rs.getString("telephone"));
          m_detailVo.setAddress(rs.getString("address"));
          m_detailVo.setNumber(rs.getString("number"));
          m_detailVo.setGet_marry(rs.getString("get_marry"));

          String str1 = rs.getString("in_time");
          if(str1 != null){
          m_detailVo.setIn_year(str1.substring(0,4));
          m_detailVo.setIn_month(str1.substring(5,7));
          m_detailVo.setIn_day(str1.substring(8,10));
          }
          else{
              m_detailVo.setIn_year(null);
              m_detailVo.setIn_month(null);
              m_detailVo.setIn_day(null);
          }
          String str2 = rs.getString("out_time");
          if(str2 != null){
          m_detailVo.setOut_year(str2.substring(0,4));
          m_detailVo.setOut_month(str2.substring(5,7));
          m_detailVo.setOut_day(str2.substring(8,10));
          }
          else{
              m_detailVo.setOut_year(null);
              m_detailVo.setOut_month(null);
              m_detailVo.setOut_day(null);
          }
          m_detailVo.setSalary(rs.getString("salary"));
          m_detailVo.setGuard(rs.getString("guard"));
          m_detailVo.setDep_name(rs.getString("dep_name"));
          m_detailVo.setManager(rs.getString("manager"));
          m_detailVo.setPassword(rs.getString("password"));
    	}finally {
    	    
    	    try{
    	    
    	        silentClose(rs);
    	    
    	        silentClose(stm);
    	    
    	        silentClose(con);
    	    
	    	}catch(Exception e){
    	        e.printStackTrace();
    	        }
    	  }
    	
        return m_detailVo;
    }

}