t_dp_regimanbaseinfo_dao.java

一个javaweb开的小例子

package cn.com.pkusoft.entity.dao;

import java.util.List;
//import cn.com.pkusoft.entity.*;
import cn.com.pkusoft.entity.BaseEntityData;
import cn.com.pkusoft.entity.T_Dp_RegiManBaseInfo_BD;


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

  public T_Dp_RegiManBaseInfo_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_RegiManBaseInfo_BD RegiManBd = (T_Dp_RegiManBaseInfo_BD) bd;

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

		StringBuffer sqlBuffer = new StringBuffer("");
		sqlBuffer.append("INSERT INTO ");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.TABLE_NAME);
		sqlBuffer.append("( ");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.NAME);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.BIRTHDAY);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.SEX);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.GRADSCHOOL);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.PROFESSION);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.GRADDATE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.TECHTITLE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.LASTDEGREE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.CODINGAGE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.SEAGE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.LEADERAGE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.PMAGE);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.JAPALEVEL);
		sqlBuffer.append(",");
		sqlBuffer.append(T_Dp_RegiManBaseInfo_BD.ENGLLEVEL);

		sqlBuffer.append(") VALUES (");
		sqlBuffer.append(RegiManBd.getName());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getBirthday());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getSex());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getGradschool());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getProfession());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getGraddate());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getTechtitle());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getLastdegree());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getCodingage());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getSeage());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getLeaderage());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getPmage());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getJapalevel());
		sqlBuffer.append(",");
		sqlBuffer.append(RegiManBd.getEngllevel());
		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.");
  }

}