voicequeryvalue.java

采用JAVA开发

package com.gctech.sms.voice.dao;


  /* author:[e-mail] */
  public class VoiceQueryValue extends  VoiceValueObject {
      //-----Codes below generated by dao

    public   VoiceQueryValue()  {
      super();
     }

    public String   toSql()  {
      StringBuffer sql = new StringBuffer() ;

      if(this.getId()!=null){
      sql.append(" and A.ID=").append(this.getId());
      }

      if(this.getCatalogId()!=null){
      sql.append(" and A.CATALOG_ID=").append(this.getCatalogId());
      }

      if(this.getDescription()!=null&&!this.getDescription().equals("")){
      sql.append(" and A.DESCRIPTION='"+this.getDescription()).append("'");
      }

      if(this.getCount()!=null){
      sql.append(" and A.COUNT=").append(this.getCount());
      }

      if(this.getCreateDate()!=null){
      sql.append(" and A.CREATE_DATE=to_date('"+(this.getCreateDate().getYear()+1900)+"/"+(this.getCreateDate().getMonth()+1)+"/"+this.getCreateDate().getDate()+"','YYYY/MM/DD')");
      }

      if(this.getPrice()!=null){
      sql.append(" and A.PRICE=").append(this.getPrice());
      }

      if(this.getType()!=null){
      sql.append(" and A.TYPE=").append(this.getType());
      }

      if(this.getName()!=null&&!this.getName().equals("")){
      sql.append(" and A.NAME='"+this.getName()).append("'");
      }

      if(this.getUserId()!=null){
      sql.append(" and A.USER_ID=").append(this.getUserId());
      }

      if(this.getUserName()!=null&&!this.getUserName().equals("")){
      sql.append(" and A.USER_NAME='"+this.getUserName()).append("'");
      }

      sql.append("order by count desc");

      return sql.toString();
     }

      //-----Codes above generated by dao
 }