t_dp_regicomp_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_RegiComp_Dao
	extends BaseDao
{
	public T_Dp_RegiComp_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_RegiComp_BD regicompBd = new T_Dp_RegiComp_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_RegiComp_BD.TABLE_NAME);
		sqlBuffer.append("( ");
		sqlBuffer.append(T_Dp_RegiComp_BD.COMPANYADD);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.COMPANYINTRO);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.COMPANYNAME);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.COMPANYSHORT);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.LINKMAN);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.LINKMANADD);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.LINKMANMOBILE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.LINKMANPOSTCODE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.LINKMANTELE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.PRINMAN);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.PRINMANADD);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.PRINMANMOBILE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.PRINMANPOSTCODE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.PRINMANTELE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.REGISTERDATE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiComp_BD.UPDATEDATE);
		sqlBuffer.append(") VALUES (");
		sqlBuffer.append(regicompBd.getCompanyadd());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getCompanyintro());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getCompanyname());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getCompanyshort());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getLinkman());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getLinkmanadd());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getLinkmanmobile());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getLinkmanpostcode());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getLinkmantele());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getPrinman());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getPrinmanadd());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getPrinmanmobile());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getPrinmanpostcode());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getPrinmantele());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getRegisterdate());
		sqlBuffer.append(",");
		sqlBuffer.append(regicompBd.getUpdatedate());

		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.");
	}

}