t_dp_dispwast_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_DispWast_Dao
	extends BaseDao
{
	public static final String T_SEQUENCE_NAME = "SEQ_DP_DISPWAST";

	public T_Dp_DispWast_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_DispWast_BD dispwastBd = new T_Dp_DispWast_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_DispWast_BD.TABLE_NAME);
		sqlBuffer.append("( ");
		sqlBuffer.append(T_Dp_DispWast_BD.CONTRATNUM);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_DispWast_BD.ENDTIME);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_DispWast_BD.INSIDEVALUE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_DispWast_BD.OUTVALUE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_DispWast_BD.REGIMANNUM);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_DispWast_BD.REMARK);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_DispWast_BD.STARTTIME);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_DispWast_BD.WORKCONTENT);
		sqlBuffer.append(") VALUES (");
		sqlBuffer.append(dispwastBd.getContratnum());
		sqlBuffer.append(",");
		sqlBuffer.append(dispwastBd.getEndtime());
		sqlBuffer.append(",");
		sqlBuffer.append(dispwastBd.getInsidevalue());
		sqlBuffer.append(",");
		sqlBuffer.append(dispwastBd.getOutvalue());
		sqlBuffer.append(",");
		sqlBuffer.append(dispwastBd.getRegimannum());
		sqlBuffer.append(",");
		sqlBuffer.append(dispwastBd.getRemark());
		sqlBuffer.append(",");
		sqlBuffer.append(dispwastBd.getStarttime());
		sqlBuffer.append(",");
		sqlBuffer.append(dispwastBd.getWorkcontent());
		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.");
	}

}