t_dp_edcahist_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_EdcaHist_Dao extends BaseDao
{
	/**
    * sequence name
    */
    public static final String T_SEQUENCE_NAME = "SEQ_DP_EDCAHIST";

    public T_Dp_EdcaHist_Dao()
    {
    }

	/**
    * 根据查询条件，检索出结果，然后返回一个BD 的列表。
    * @param strFilter String 查询条件
    * @throws SQLException
    * @return List
    */
    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.");
    }

	/**
    * 更新一条数据
    * @param bd BaseEntityData  要进行更新的记录数据
    * @throws SQLException
    * @return int
    */
    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.");
    }

	/**
    * 插入一条数据
    * @param bd BaseEntityData 要进行插入的记录数据
    * @throws SQLException
    * @return int
    */
    public int insert(BaseEntityData bd) throws java.sql.SQLException
    {
		T_Dp_EdcaHist_BD edcahistBd = (T_Dp_EdcaHist_BD) 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_EdcaHist_BD.TABLE_NAME);
	   sqlBuffer.append("( ");
	   sqlBuffer.append(T_Dp_EdcaHist_BD.REGIMANNUM);
	   sqlBuffer.append(",");
	   sqlBuffer.append(T_Dp_EdcaHist_BD.STARTDATE);
	   sqlBuffer.append(",");
	   sqlBuffer.append(T_Dp_EdcaHist_BD.ENDDATE);
	   sqlBuffer.append(",");
	   sqlBuffer.append(T_Dp_EdcaHist_BD.SCHOOLNAME);
	   sqlBuffer.append(",");
	   sqlBuffer.append(T_Dp_EdcaHist_BD.PROFESSION);
	   sqlBuffer.append(",");
	   sqlBuffer.append(T_Dp_EdcaHist_BD.REMARK);
	   sqlBuffer.append(") VALUES (");
	   sqlBuffer.append(edcahistBd.getRegimannum());
	   sqlBuffer.append(",");
	   sqlBuffer.append(edcahistBd.getStartdate());
	   sqlBuffer.append(",");
	   sqlBuffer.append(edcahistBd.getEnddate());
	   sqlBuffer.append(",");
	   sqlBuffer.append(edcahistBd.getSchoolname());
	   sqlBuffer.append(",");
	   sqlBuffer.append(edcahistBd.getProfession());
	   sqlBuffer.append(",");
	   sqlBuffer.append(edcahistBd.getRemark());
	   sqlBuffer.append(")");

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

	   return nReturn;


    }

	/**
    * 取得SEQUENCE的名字。
    * @throws SQLException
    * @return String
    */
    protected String getSequenceName() throws java.sql.SQLException
    {
		// 返回SEQUENCE的名字。
        return T_SEQUENCE_NAME;
    }

	/**
    * 删除一条记录
    * @param bd BaseEntityData 要进行删除的数据
    * @throws SQLException
    * @return int
    */
    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.");
    }

}