t_dp_workhist_dao.java

一个javaweb开的小例子

package cn.com.pkusoft.entity.dao;

import java.util.List;
import cn.com.pkusoft.entity.*;

public class T_Dp_WorkHist_Dao
	extends BaseDao
{
	public T_Dp_WorkHist_Dao()
	{
	}

	public List select(String strFilter) throws java.sql.SQLException
	{
		/**@todo Implement this cn.com.pkusoft.entity.dao.BaseDao abstract method*/
		throw new java.lang.UnsupportedOperationException("Method select() not yet implemented.");
	}

	public int update(BaseEntityData bd) throws java.sql.SQLException
	{
		/**@todo Implement this cn.com.pkusoft.entity.dao.BaseDao abstract method*/
		throw new java.lang.UnsupportedOperationException("Method update() not yet implemented.");
	}

	public int insert(BaseEntityData bd) throws java.sql.SQLException
	{
		T_Dp_WorkHist_BD  workhistBd  = new T_Dp_WorkHist_BD();
		StringBuffer sqlBuffer = new StringBuffer("");
		sqlBuffer.append("INSERT INTO ");
		sqlBuffer.append(T_Dp_WorkHist_BD.TABLE_NAME);
		sqlBuffer.append("( ");
		sqlBuffer.append(T_Dp_WorkHist_BD.COMPANYNAME);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_WorkHist_BD.DEPARTNAME);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_WorkHist_BD.ENDDATE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_WorkHist_BD.HEADSHIP);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_WorkHist_BD.JOBDES);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_WorkHist_BD.REGIMANNUM);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_WorkHist_BD.REMARK);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_WorkHist_BD.STARTDATE);
		sqlBuffer.append(") VALUES (");
		sqlBuffer.append(workhistBd.getCompanyname());
		sqlBuffer.append(",");
		sqlBuffer.append(workhistBd.getDepartname());
		sqlBuffer.append(",");
		sqlBuffer.append(workhistBd.getEnddate());
		sqlBuffer.append(",");
		sqlBuffer.append(workhistBd.getHeadship());
		sqlBuffer.append(",");
		sqlBuffer.append(workhistBd.getJobdes());
		sqlBuffer.append(",");
		sqlBuffer.append(workhistBd.getRegimannum());
		sqlBuffer.append(",");
		sqlBuffer.append(workhistBd.getRemark());
		sqlBuffer.append(",");
		sqlBuffer.append(workhistBd.getStartdate());
		sqlBuffer.append(")");

		String strSql = sqlBuffer.toString();
		//delete sqlBuffer;
		int nReturn = this.execute(strSql);

		return nReturn;

	}

	protected String getSequenceName() throws java.sql.SQLException
	{
		/**@todo Implement this cn.com.pkusoft.entity.dao.BaseDao abstract method*/
		throw new java.lang.UnsupportedOperationException("Method getSequenceName() not yet implemented.");
	}

	public int delete(BaseEntityData bd) throws java.sql.SQLException
	{
		/**@todo Implement this cn.com.pkusoft.entity.dao.BaseDao abstract method*/
		throw new java.lang.UnsupportedOperationException("Method delete() not yet implemented.");
	}

}