userhistoryqueryvalue.java

采用JAVA开发

package com.gctech.sms.voice.dao;


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

    public   UserHistoryQueryValue()  { 
      super();
     } 

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

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

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

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

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

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

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

      return sql.toString();
     } 

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