updatedao.java

一个管理系统 用java作的

/*
 *  僔僗僥儉丂丂丗 嶳廏HR僔僗僥儉奐敪
 *  僒僽僔僗僥儉丗 WEB僔僗僥儉
 *
 *   VER    丂曄峏擔     丂晹壽      扴摉幰  丂曄峏撪梕
 *  -----------------------------------------------------------------
 *  V1.00 丂丂2006/09/14 (ShanXiu丂Soft)  Tuwenjie   弶斉
 *
 *       (C) Copyright SHANXIU CORPORATION 2006
 *                     All Rights Reserved.
 *
 */
package net.shanxiu.HR.dao;

import java.sql.Connection;
import net.shanxiu.HR.entity.Constants;

/**
 * UpdateDao
 */

/*******************************************************************************
 * 僋儔僗偺奣梫丗姰惉崯宯?庡梫揑峏怴岟擻丆曪妵捛壛丆廋夵榓?彍
 * 
 * @author  嶌惉幰 tuwenjie
 * @version 1.0
*******************************************************************************
 */
public class UpdateDao extends DbUtil {
    
    public UpdateDao(){
        
    }
    
    /*******************************************************************************
     * 張棟撪梕偺奣梫:崻悩?岺ID??悢悩?丆敾抐崯?岺惀斲懚嵼
     * 
     * @param   堷悢:?岺ID
     * @return  栠傝抣:int,0昞帵懚嵼丆1昞帵晄懚嵼
     * @exception  ?忢丗Exception
     *******************************************************************************
     */
    public int is_present(String id)throws Exception{
        
        Connection con    = connectToDb();
        try{
            
          stm   = con.createStatement();
          rs    = stm.executeQuery(Constants.SQL_ALL_EMP);
          while(rs.next()){
              if(rs.getString("id").equals(id))
                  return 0;
          }
        }finally{
        
           try{
            
               silentClose(rs);
    	    
               silentClose(stm);
    	    
               silentClose(con);
          
           }catch(Exception e){
               e.printStackTrace();
            	}
        }
        return 1;
    }
    
    /*******************************************************************************
     * 張棟撪梕偺奣梫:崻悩SQL?嬪峏怴悢悩?曪妵捛壛丆廋夵榓?彍
     * 
     * @param   堷悢:String SQL?嬪
     * @return  栠傝抣:void 
     * @exception  ?忢丗Exception
     *******************************************************************************
     */
    public void update(String strSql)throws Exception{
        
          Connection con    = connectToDb();
          
          try{
              
            stm     = con.createStatement();
            
            int lab = stm.executeUpdate(strSql);
            
      	  }finally{
              
              try{
                  
                silentClose(rs);
          	    
          	    silentClose(stm);
          	    
      	        silentClose(con);
                
              }catch(Exception e){
                  e.printStackTrace();
                  }
           }
      	
    }
    
}