modifyactionservice.java

一个管理系统 用java作的

package net.shanxiu.HR.service;

import net.shanxiu.HR.dao.UpdateDao;
import net.shanxiu.HR.entity.CommonMethod;
import net.shanxiu.HR.actionform.ModifyActionForm;

/**
 * ModifyActionService
 */

/*******************************************************************************
 * 僋儔僗偺奣梫:private a  middle layer that connect modify action to DAO
 * 
 * @author  挘楉
 * @version 1.0
*******************************************************************************
 */
public class ModifyActionService {
    
    /*******************************************************************************
     * 張棟撪梕偺奣梫:update employer 
     * 
     * @param   堷悢:String SQL  
     * @return  栠傝抣:void
     * @exception  ?忢丗Exception
     *******************************************************************************
     */
    public void update(String strSql) throws Exception{
        
        UpdateDao updateDao = new UpdateDao();
        updateDao.update(strSql);
        
    }
    
    /*******************************************************************************
     * 張棟撪梕偺奣梫:create a sql language that update to emp table
     * 
     * @param   堷悢:modifyActionForm 
     * @return  栠傝抣:String 
     * @exception  ?忢丗null
     *******************************************************************************
     */
    public String logic(ModifyActionForm modifyActionForm) {
        
        String strSql = new String("update emp set ");
        
        String Name =modifyActionForm.getName();
        if (Name!=null&&!Name.equals("")){
            
            Name = CommonMethod.ChangeChar(Name);
            strSql += "Name =" + "'"+Name +"'"+ "," ;
        }
        String Birth_year=modifyActionForm.getBirth_year();
        String Birth_month=modifyActionForm.getBirth_month();
        String Birth_day=modifyActionForm.getBirth_day();
        if (Birth_year!=null&&!Birth_year.equals("")){
            strSql +=  "Birthday =" 
                   +"'"+ Birth_year
                   +'-'
                   + Birth_month
                   +'-'
                   + Birth_day +"'"+ "," ;
        }          
        else strSql += "Birthday = null,";
        
        String Sex=modifyActionForm.getSex(); 
        if (Sex!=null&&!Sex.equals("")){
            strSql +=  "Sex =" +"'"+ Sex +"'"+ "," ;
        }
        
        String Grade=modifyActionForm.getGrade();
        if (Grade!=null&&!Grade.equals("")){
            strSql +=  "Grade =" +"'"+ Grade +"'"+ "," ;
        }
        else strSql += "Grade = null,"; 
        
        String Born_in=modifyActionForm.getBorn_in();
        if (Born_in!=null&&!Born_in.equals("")){
            
            Born_in = CommonMethod.ChangeChar(Born_in);
            strSql +=  "Born_in =" +"'"+ Born_in +"'"+ "," ;
        }
        else strSql += "Born_in = null,";
        
        String Polity=modifyActionForm.getPolity();
        if (Polity!=null&&!Polity.equals("")){
            strSql +=  "Polity =" + "'"+Polity +"'"+ "," ;
        }
        else strSql += "Polity = null,";
        
        String Telephone=modifyActionForm.getTelephone();
        if (Telephone!=null&&!Telephone.equals("")){
            
            Telephone = CommonMethod.ChangeChar(Telephone);
            strSql +=  "Telephone =" +"'"+ Telephone +"'"+ "," ;
        }
        else strSql += "Telephone = null,";
        
        String Address=modifyActionForm.getAddress();
        if (Address!=null&&!Address.equals("")){
            
            Address = CommonMethod.ChangeChar(Address);
            strSql +=  "Address =" +"'"+ Address +"'"+ "," ;
        }
        else strSql += "Address = null,";
        
        String Number=modifyActionForm.getNumber();
        if (Number!=null&&!Number.equals("")){
            
            Number = CommonMethod.ChangeChar(Number);
            strSql +=  "Number= " + "'"+Number +"'"+ "," ;
        }
        else strSql += "Number = null,";
        
        String Get_marry=modifyActionForm.getGet_marry();
        if (Get_marry!=null&&!Get_marry.equals("")){
            strSql +=  "Get_marry= " + "'"+Get_marry +"'"+ "," ;
        }
        else strSql += "Get_marry = null,";
        
        String In_year=modifyActionForm.getIn_year();
        String In_month=modifyActionForm.getIn_month();
        String In_day=modifyActionForm.getIn_day();
        if (In_year!=null&&!In_year.equals("")){
            strSql +=  "In_time =" 
                   + "'"+
                   In_year
                   +'-'
                   + In_month
                   +'-'	
                   + In_day 
                   +"'"+ "," ;
        }
        
        String Out_year=modifyActionForm.getOut_year();
        String Out_month=modifyActionForm.getOut_month();
        String Out_day=modifyActionForm.getOut_day();
        if (Out_year!=null&&!Out_year.equals("")){
            strSql +=  "Out_time =" 
                   +"'"+
                   Out_year
                   +'-'
                   + Out_month
                   +'-'
                   + Out_day 
                   +"'"+ "," ;
        }
        else strSql += "Out_time = null,";
        
        String Salary=modifyActionForm.getSalary();
        if (Salary!=null&&!Salary.equals("")){
            
            Salary = CommonMethod.ChangeChar(Salary);
            strSql +=  "Salary =" +"'"+ Salary + "'"+"," ;
        }
        else strSql += "Salary = null,";
        
        String Password=modifyActionForm.getPassword();
        if (Password!=null&&!Password.equals("")){
            
            Password = CommonMethod.ChangeChar(Password);
            strSql +=  "Password =" +"'"+ Password + "'"+"," ;
        }
        
        String Guard=modifyActionForm.getGuard();
        if (Guard!=null&&!Guard.equals("")){
            strSql +=  "Guard =" +"'"+ Guard +"'"+ "," ;
        }
        
        String Dep_name=modifyActionForm.getDep_name();
        if (Dep_name!=null&&!Dep_name.equals("")){
            strSql +=  "Dep_id =" +"'"+ Dep_name +"'";
        }
        else
            strSql = strSql.substring(0,strSql.length()-1);
        
        strSql = strSql + "where id = " + "'"+ modifyActionForm.getId() +"'";
        
    	return strSql;
    }
  /*  public static void main(String[] args) {
        
        ModifyActionForm addActionForm = new ModifyActionForm();
        addActionForm.setID("112");
        addActionForm.setName("zhangli");
        addActionForm.setAddress("jiangsuwuxi");
        addActionForm.setBorn_in("jilin");
        addActionForm.setBirth_year("1982");
        addActionForm.setBirth_month("10");
        addActionForm.setBirth_day("10");
        addActionForm.setSex("0");
        addActionForm.setPassword("821010");
        addActionForm.setTelephone("01010101");
        addActionForm.setGuard("1");
        addActionForm.setGrade("F");
        addActionForm.setPolity("dangyuan");
        addActionForm.setNumber("00000000");
        addActionForm.setGet_marry("0");
        addActionForm.setIn_year("2006");
        addActionForm.setIn_month("07");
        addActionForm.setIn_day("09");
        addActionForm.setSalary("2000");
        addActionForm.setDep_name("base");
        
        addActionForm.setManager("zhangbing");
        ModifyActionService service = new ModifyActionService();
        
        String sql = service.logic_emp(addActionForm);
        
        System.out.println(sql);
        
    }
    */ 
}