busiusermoddao.java

来自「用JAVA环境开发的人力资源管理系统」· Java 代码 · 共 47 行

package com.liyu.dao;


import java.text.SimpleDateFormat;
import java.util.Date;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

public class BusiUserModDao extends JdbcDaoSupport{
	public static final String MOD_PERSONBASEINFO_SQL ="UPDATE PERSON_BASE_INFO SET PERSON_NAME =?,PERSON_SAX=?,PERSON_BRITH=? ,PERSON_ENTRY_DATE=? WHERE PERSON_NAME =? AND PERSON_SAX=? AND PERSON_BRITH=? AND PERSON_ENTRY_DATE =?";
	public static final String MOD_PERSONRESOURCEINFO_SQL ="UPDATE PERSON_RESOURCE_INFO SET PERSON_NAME =?,PERSON_DEPART=?,PERSON_JOBS=? WHERE PERSON_NAME =? AND PERSON_DEPART=? AND PERSON_JOBS=?";
	public static final String MOD_CONTRACTINFO_SQL ="UPDATE CONTRACT_INFO SET CONTRACT_CHARGE =?,CONTRACT_TITLE=?,CONTRACT_CONTENT=? WHERE CONTRACT_CHARGE =? AND CONTRACT_TITLE=? AND CONTRACT_CONTENT=?";
	
	public int updPersonBaseInfo(String PERSON_NAME,String PERSON_SAX,Date PERSON_BRITH, Date PERSON_ENTRY_DATE,String[] personBaseInfoModBef){
		String personBrithBef = personBaseInfoModBef[2];
		String personEntryDateBef = personBaseInfoModBef[3];
		Date dtPersonBrithBef = new Date();
		Date dtPersonEntryDateBef = new Date();
		try{
	    	SimpleDateFormat s = new SimpleDateFormat ("yyyy-MM-dd");
	    	dtPersonBrithBef = s.parse(personBrithBef);
	    	dtPersonEntryDateBef = s.parse(personEntryDateBef);
	        Long lon = new Long(556145322);
	        //String str = lon.toBinaryString();
	        
	    }catch(Exception e){
	    	e.printStackTrace();
	    	//errors.add("pubdate",new ActionMessage("errors.invaliddateformat"));
	    	//this.saveErrors(request,errors);
	    	//return false;
	    }
		return this.getJdbcTemplate().update
		(MOD_PERSONBASEINFO_SQL,new Object[]{PERSON_NAME,PERSON_SAX,PERSON_BRITH,PERSON_ENTRY_DATE,personBaseInfoModBef[0],personBaseInfoModBef[1],
				dtPersonBrithBef,dtPersonEntryDateBef});
	}
	public int updPersonResourceInfo(String PERSON_NAME,String PERSON_DEPART,String PERSON_JOBS,String[] personResourceInfoModBef){
		return this.getJdbcTemplate().update
		(MOD_PERSONRESOURCEINFO_SQL,new Object[]{PERSON_NAME,PERSON_DEPART,PERSON_JOBS,personResourceInfoModBef[0],personResourceInfoModBef[1],
				personResourceInfoModBef[2]});
	}
	public int updContractInfo(String CONTRACT_CHARGE,String CONTRACT_TITLE,String CONTRACT_CONTENT,String[] contractInfoModBef){
		return this.getJdbcTemplate().update
		(MOD_CONTRACTINFO_SQL,new Object[]{CONTRACT_CHARGE,CONTRACT_TITLE,CONTRACT_CONTENT,contractInfoModBef[0],contractInfoModBef[1],
				contractInfoModBef[2]});
	}
}