t_dp_transumm_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_TranSumm_Dao
	extends BaseDao
{
	public T_Dp_TranSumm_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_TranSumm_BD transummBd = new T_Dp_TranSumm_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_TranSumm_BD.TABLE_NAME);
		sqlBuffer.append("( ");
		sqlBuffer.append(T_Dp_TranSumm_BD.COMPANYNUM);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.MANNUM);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.PRICE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.REMARK);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.REQUMAN);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.REQUMANADD);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.REQUMANEMAIL);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.REQUMANFAX);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.REQUMANMOBI);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.REQUMANPOSTCODE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_TranSumm_BD.REQUMANTELE);
		sqlBuffer.append(") VALUES (");
		sqlBuffer.append(transummBd.getCompanynum());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getMannum());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getPrice());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getRemark());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getRequman());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getRequmanadd());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getRequmanemail());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getRequmanfax());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getRequmanmobi());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getRequmanpostcode());
		sqlBuffer.append(",");
		sqlBuffer.append(transummBd.getRequmantele());
		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.");
	}

}