busiuseradddao.java

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

package com.liyu.dao;




import java.util.Date;

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

public class BusiUserAddDao extends JdbcDaoSupport{
	private static final String IST_PERSONBASEINFO_SQL = 
		"INSERT INTO PERSON_BASE_INFO VALUES (?,?,?,?)";
	private static final String IST_PERSONRESOURCEINFO_SQL = 
		"INSERT INTO PERSON_RESOURCE_INFO VALUES (?,?,?)";
	private static final String IST_CONTRACTINFO_SQL = 
		"INSERT INTO CONTRACT_INFO VALUES (?,?,?)";
	
	public int istPersonBaseInfo(String PERSON_NAME,String PERSON_SAX,Date PERSON_BRITH,Date PERSON_ENTRY_DATE ){
		return this.getJdbcTemplate().update(IST_PERSONBASEINFO_SQL,new Object[]{PERSON_NAME,PERSON_SAX,PERSON_BRITH,PERSON_ENTRY_DATE});
	}
	public int istPersonResourceInfo(String PERSON_NAME,String PERSON_DEPART,String PERSON_JOBS){
		return this.getJdbcTemplate().update(IST_PERSONRESOURCEINFO_SQL,new Object[]{PERSON_NAME,PERSON_DEPART,PERSON_JOBS});
	}
	public int istContractInfo(String CONTRACT_CHARG,String CONTRACT_TITLE,String CONTRACT_CONTENT){
		return this.getJdbcTemplate().update(IST_CONTRACTINFO_SQL,new Object[]{CONTRACT_CHARG,CONTRACT_TITLE,CONTRACT_CONTENT});
	}
}