t_dp_requjob_dao.java

一个javaweb开的小例子

package cn.com.pkusoft.entity.dao;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class T_Dp_RequJob_Dao
	extends BaseDao
{
	public T_Dp_RequJob_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_RequJob_BD rightDesBd = new T_Dp_RequJob_BD();

		/*
		   INSERT INTO DP_USER (
		   USERNUM, LOGINNAME, LOGINPASS,
		   LOGINQUES, LOGINANSE, EMAIL,
		   TELE, ADDRESS, USERGRADE,
		   REMARK, FAX)
		   VALUES ( , , ,
			, , ,
			, , ,
			, )
		 */

		StringBuffer sqlBuffer = new StringBuffer("");
		sqlBuffer.append("INSERT INTO ");
		sqlBuffer.append(T_Dp_RequJob_BD.TABLE_NAME);
		sqlBuffer.append("( ");
		sqlBuffer.append(T_Dp_RequJob_BD.ISDISP);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RequJob_BD.JOBADD);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RequJob_BD.JOBDES);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RequJob_BD.JOBNEED);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RequJob_BD.REGICOMPNUM);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RequJob_BD.REMARK);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RequJob_BD.REQUJOB);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RequJob_BD.REQUJOBAMOUNT);
		sqlBuffer.append(") VALUES (");
		sqlBuffer.append(rightDesBd.getIsdisp());
		sqlBuffer.append(",");
		sqlBuffer.append(rightDesBd.getJobadd());
		sqlBuffer.append(",");
		sqlBuffer.append(rightDesBd.getJobdes());
		sqlBuffer.append(",");
		sqlBuffer.append(rightDesBd.getJobneed());
		sqlBuffer.append(",");
		sqlBuffer.append(rightDesBd.getRegicompnum());
		sqlBuffer.append(",");
		sqlBuffer.append(rightDesBd.getRemark());
		sqlBuffer.append(",");
		sqlBuffer.append(rightDesBd.getRequjob());
		sqlBuffer.append(",");
		sqlBuffer.append(rightDesBd.getRequjobamount());
		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.");
	}

}