predialtaskdao.java

采用JAVA开发

package com.gctech.sms.voice.dao;

import java.sql.* ;
import java.util.ArrayList;

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

    public int insert(Connection aConnection,PredialtaskValueObject aPredialtaskValueObject) throws SQLException  { 
      String sql = " INSERT INTO PREDIALTASK A ( A.SERIALNUM, A.CALLORDER, A.SERVICEBEGINTIME, A.SERVICESTOPTIME, A.DIALBEGINTIME, A.DIALENDTIME, A.TIMEINTERVAL, A.INTERVALTYPE, A.CALLER, A.ORIGCALLER, A.CALLED, A.ORIGCALLED, A.PRIVATEDATA, A.REDIALINTERVAL, A.REDIALCOUNT, A.TYPE, A.SERVICEID, A.ANSWERTYPE, A.PRIORITY, A.STATUS, A.DEFAULTINTERVAL, A.USERDATA ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )  " ;
      int result = 0;
      PreparedStatement prepStmt = aConnection.prepareStatement( sql.toString() );
      if (aPredialtaskValueObject.getSerialnum()  == null){ 
       prepStmt.setNull(1, Types.VARCHAR);
      }else{ 
       prepStmt.setString(1, aPredialtaskValueObject.getSerialnum() ); 
      }
      if (aPredialtaskValueObject.getCallorder()  == null){ 
       prepStmt.setNull(2, Types.INTEGER);
      }else{ 
       prepStmt.setInt(2, aPredialtaskValueObject.getCallorder().intValue() ); 
      }      
      if (aPredialtaskValueObject.getServicebegintime()  == null){ 
       prepStmt.setNull(3, Types.VARCHAR);
      }else{ 
       prepStmt.setString(3, aPredialtaskValueObject.getServicebegintime() ); 
      }
      if (aPredialtaskValueObject.getServicestoptime()  == null){ 
       prepStmt.setNull(4, Types.VARCHAR);
      }else{ 
       prepStmt.setString(4, aPredialtaskValueObject.getServicestoptime() ); 
      }
      if (aPredialtaskValueObject.getDialbegintime()  == null){ 
       prepStmt.setNull(5, Types.VARCHAR);
      }else{ 
       prepStmt.setString(5, aPredialtaskValueObject.getDialbegintime() ); 
      }
      if (aPredialtaskValueObject.getDialendtime()  == null){ 
       prepStmt.setNull(6, Types.VARCHAR);
      }else{ 
       prepStmt.setString(6, aPredialtaskValueObject.getDialendtime() ); 
      }
      if (aPredialtaskValueObject.getTimeinterval()  == null){ 
       prepStmt.setNull(7, Types.INTEGER);
      }else{ 
       prepStmt.setInt(7, aPredialtaskValueObject.getTimeinterval().intValue() ); 
      }      
      if (aPredialtaskValueObject.getIntervaltype()  == null){ 
       prepStmt.setNull(8, Types.INTEGER);
      }else{ 
       prepStmt.setInt(8, aPredialtaskValueObject.getIntervaltype().intValue() ); 
      }      
      if (aPredialtaskValueObject.getCaller()  == null){ 
       prepStmt.setNull(9, Types.VARCHAR);
      }else{ 
       prepStmt.setString(9, aPredialtaskValueObject.getCaller() ); 
      }
      if (aPredialtaskValueObject.getOrigcaller()  == null){ 
       prepStmt.setNull(10, Types.VARCHAR);
      }else{ 
       prepStmt.setString(10, aPredialtaskValueObject.getOrigcaller() ); 
      }
      if (aPredialtaskValueObject.getCalled()  == null){ 
       prepStmt.setNull(11, Types.VARCHAR);
      }else{ 
       prepStmt.setString(11, aPredialtaskValueObject.getCalled() ); 
      }
      if (aPredialtaskValueObject.getOrigcalled()  == null){ 
       prepStmt.setNull(12, Types.VARCHAR);
      }else{ 
       prepStmt.setString(12, aPredialtaskValueObject.getOrigcalled() ); 
      }
      if (aPredialtaskValueObject.getPrivatedata()  == null){ 
       prepStmt.setNull(13, Types.VARCHAR);
      }else{ 
       prepStmt.setString(13, aPredialtaskValueObject.getPrivatedata() ); 
      }
      if (aPredialtaskValueObject.getRedialinterval()  == null){ 
       prepStmt.setNull(14, Types.VARCHAR);
      }else{ 
       prepStmt.setString(14, aPredialtaskValueObject.getRedialinterval() ); 
      }
      if (aPredialtaskValueObject.getRedialcount()  == null){ 
       prepStmt.setNull(15, Types.INTEGER);
      }else{ 
       prepStmt.setInt(15, aPredialtaskValueObject.getRedialcount().intValue() ); 
      }      
      if (aPredialtaskValueObject.getType()  == null){ 
       prepStmt.setNull(16, Types.INTEGER);
      }else{ 
       prepStmt.setInt(16, aPredialtaskValueObject.getType().intValue() ); 
      }      
      if (aPredialtaskValueObject.getServiceid()  == null){ 
       prepStmt.setNull(17, Types.INTEGER);
      }else{ 
       prepStmt.setInt(17, aPredialtaskValueObject.getServiceid().intValue() ); 
      }      
      if (aPredialtaskValueObject.getAnswertype()  == null){ 
       prepStmt.setNull(18, Types.INTEGER);
      }else{ 
       prepStmt.setInt(18, aPredialtaskValueObject.getAnswertype().intValue() ); 
      }      
      if (aPredialtaskValueObject.getPriority()  == null){ 
       prepStmt.setNull(19, Types.INTEGER);
      }else{ 
       prepStmt.setInt(19, aPredialtaskValueObject.getPriority().intValue() ); 
      }      
      if (aPredialtaskValueObject.getStatus()  == null){ 
       prepStmt.setNull(20, Types.INTEGER);
      }else{ 
       prepStmt.setInt(20, aPredialtaskValueObject.getStatus().intValue() ); 
      }      
      if (aPredialtaskValueObject.getDefaultinterval()  == null){ 
       prepStmt.setNull(21, Types.INTEGER);
      }else{ 
       prepStmt.setInt(21, aPredialtaskValueObject.getDefaultinterval().intValue() ); 
      }      
      if (aPredialtaskValueObject.getUserdata()  == null){ 
       prepStmt.setNull(22, Types.VARCHAR);
      }else{ 
       prepStmt.setString(22, aPredialtaskValueObject.getUserdata() ); 
      }
      result = prepStmt.executeUpdate();
      prepStmt.close();
      return result ;
     } 

    public int update(Connection aConnection,PredialtaskValueObject aPredialtaskValueObject) throws SQLException  { 
      StringBuffer sql = new StringBuffer(" update PREDIALTASK A  set " );
            if(aPredialtaskValueObject.getServicebegintime()!=null&&!aPredialtaskValueObject.getServicebegintime().equals("")){
            if(aPredialtaskValueObject.getServicebegintime().equals("@_@"))sql.append( " A.SERVICEBEGINTIME= null,");
            else sql.append(" A.SERVICEBEGINTIME='"+aPredialtaskValueObject.getServicebegintime()+"',");
      }
      if(aPredialtaskValueObject.getServicestoptime()!=null&&!aPredialtaskValueObject.getServicestoptime().equals("")){
            if(aPredialtaskValueObject.getServicestoptime().equals("@_@"))sql.append( " A.SERVICESTOPTIME= null,");
            else sql.append(" A.SERVICESTOPTIME='"+aPredialtaskValueObject.getServicestoptime()+"',");
      }
      if(aPredialtaskValueObject.getDialbegintime()!=null&&!aPredialtaskValueObject.getDialbegintime().equals("")){
            if(aPredialtaskValueObject.getDialbegintime().equals("@_@"))sql.append( " A.DIALBEGINTIME= null,");
            else sql.append(" A.DIALBEGINTIME='"+aPredialtaskValueObject.getDialbegintime()+"',");
      }
      if(aPredialtaskValueObject.getDialendtime()!=null&&!aPredialtaskValueObject.getDialendtime().equals("")){
            if(aPredialtaskValueObject.getDialendtime().equals("@_@"))sql.append( " A.DIALENDTIME= null,");
            else sql.append(" A.DIALENDTIME='"+aPredialtaskValueObject.getDialendtime()+"',");
      }
      if(aPredialtaskValueObject.getTimeinterval()!=null){
            if(aPredialtaskValueObject.getTimeinterval().doubleValue() == -1.0)sql.append(" A.TIMEINTERVAL= null,");
            else sql.append("  A.TIMEINTERVAL=").append(aPredialtaskValueObject.getTimeinterval()).append(",");
      }
      if(aPredialtaskValueObject.getIntervaltype()!=null){
            if(aPredialtaskValueObject.getIntervaltype().doubleValue() == -1.0)sql.append(" A.INTERVALTYPE= null,");
            else sql.append("  A.INTERVALTYPE=").append(aPredialtaskValueObject.getIntervaltype()).append(",");
      }
      if(aPredialtaskValueObject.getCaller()!=null&&!aPredialtaskValueObject.getCaller().equals("")){
            if(aPredialtaskValueObject.getCaller().equals("@_@"))sql.append( " A.CALLER= null,");
            else sql.append(" A.CALLER='"+aPredialtaskValueObject.getCaller()+"',");
      }
      if(aPredialtaskValueObject.getOrigcaller()!=null&&!aPredialtaskValueObject.getOrigcaller().equals("")){
            if(aPredialtaskValueObject.getOrigcaller().equals("@_@"))sql.append( " A.ORIGCALLER= null,");
            else sql.append(" A.ORIGCALLER='"+aPredialtaskValueObject.getOrigcaller()+"',");
      }
      if(aPredialtaskValueObject.getCalled()!=null&&!aPredialtaskValueObject.getCalled().equals("")){
            if(aPredialtaskValueObject.getCalled().equals("@_@"))sql.append( " A.CALLED= null,");
            else sql.append(" A.CALLED='"+aPredialtaskValueObject.getCalled()+"',");
      }
      if(aPredialtaskValueObject.getOrigcalled()!=null&&!aPredialtaskValueObject.getOrigcalled().equals("")){
            if(aPredialtaskValueObject.getOrigcalled().equals("@_@"))sql.append( " A.ORIGCALLED= null,");
            else sql.append(" A.ORIGCALLED='"+aPredialtaskValueObject.getOrigcalled()+"',");
      }
      if(aPredialtaskValueObject.getPrivatedata()!=null&&!aPredialtaskValueObject.getPrivatedata().equals("")){
            if(aPredialtaskValueObject.getPrivatedata().equals("@_@"))sql.append( " A.PRIVATEDATA= null,");
            else sql.append(" A.PRIVATEDATA='"+aPredialtaskValueObject.getPrivatedata()+"',");
      }
      if(aPredialtaskValueObject.getRedialinterval()!=null&&!aPredialtaskValueObject.getRedialinterval().equals("")){
            if(aPredialtaskValueObject.getRedialinterval().equals("@_@"))sql.append( " A.REDIALINTERVAL= null,");
            else sql.append(" A.REDIALINTERVAL='"+aPredialtaskValueObject.getRedialinterval()+"',");
      }
      if(aPredialtaskValueObject.getRedialcount()!=null){
            if(aPredialtaskValueObject.getRedialcount().doubleValue() == -1.0)sql.append(" A.REDIALCOUNT= null,");
            else sql.append("  A.REDIALCOUNT=").append(aPredialtaskValueObject.getRedialcount()).append(",");
      }
      if(aPredialtaskValueObject.getType()!=null){
            if(aPredialtaskValueObject.getType().doubleValue() == -1.0)sql.append(" A.TYPE= null,");
            else sql.append("  A.TYPE=").append(aPredialtaskValueObject.getType()).append(",");
      }
      if(aPredialtaskValueObject.getServiceid()!=null){
            if(aPredialtaskValueObject.getServiceid().doubleValue() == -1.0)sql.append(" A.SERVICEID= null,");
            else sql.append("  A.SERVICEID=").append(aPredialtaskValueObject.getServiceid()).append(",");
      }
      if(aPredialtaskValueObject.getAnswertype()!=null){
            if(aPredialtaskValueObject.getAnswertype().doubleValue() == -1.0)sql.append(" A.ANSWERTYPE= null,");
            else sql.append("  A.ANSWERTYPE=").append(aPredialtaskValueObject.getAnswertype()).append(",");
      }
      if(aPredialtaskValueObject.getPriority()!=null){
            if(aPredialtaskValueObject.getPriority().doubleValue() == -1.0)sql.append(" A.PRIORITY= null,");
            else sql.append("  A.PRIORITY=").append(aPredialtaskValueObject.getPriority()).append(",");
      }
      if(aPredialtaskValueObject.getStatus()!=null){
            if(aPredialtaskValueObject.getStatus().doubleValue() == -1.0)sql.append(" A.STATUS= null,");
            else sql.append("  A.STATUS=").append(aPredialtaskValueObject.getStatus()).append(",");
      }
      if(aPredialtaskValueObject.getDefaultinterval()!=null){
            if(aPredialtaskValueObject.getDefaultinterval().doubleValue() == -1.0)sql.append(" A.DEFAULTINTERVAL= null,");
            else sql.append("  A.DEFAULTINTERVAL=").append(aPredialtaskValueObject.getDefaultinterval()).append(",");
      }
      if(aPredialtaskValueObject.getUserdata()!=null&&!aPredialtaskValueObject.getUserdata().equals("")){
            if(aPredialtaskValueObject.getUserdata().equals("@_@"))sql.append( " A.USERDATA= null,");
            else sql.append(" A.USERDATA='"+aPredialtaskValueObject.getUserdata()+"',");
      }

      //remove the last comma
      sql.setLength(sql.length()-1);
      sql .append( " where 1=1");
      if(aPredialtaskValueObject.getSerialnum()!=null&&!aPredialtaskValueObject.getSerialnum().equals("")){
      sql.append(" and A.SERIALNUM='"+aPredialtaskValueObject.getSerialnum()).append("'");
      }

      if(aPredialtaskValueObject.getCallorder()!=null){
      sql.append(" and A.CALLORDER=").append(aPredialtaskValueObject.getCallorder());
      }

      int result = 0;
      PreparedStatement prepStmt = aConnection.prepareStatement( sql.toString() );
      result = prepStmt.executeUpdate();
      prepStmt.close();
      return result ;
     } 

    public int updateByQueryValue(Connection aConnection,PredialtaskValueObject aPredialtaskValueObject,PredialtaskQueryValue aPredialtaskQueryValue) throws SQLException  { 
      StringBuffer sql = new StringBuffer(" update PREDIALTASK A  set " );
            if(aPredialtaskValueObject.getServicebegintime()!=null&&!aPredialtaskValueObject.getServicebegintime().equals("")){
            if(aPredialtaskValueObject.getServicebegintime().equals("@_@"))sql.append( " A.SERVICEBEGINTIME= null,");
            else sql.append(" A.SERVICEBEGINTIME='"+aPredialtaskValueObject.getServicebegintime()+"',");
      }
      if(aPredialtaskValueObject.getServicestoptime()!=null&&!aPredialtaskValueObject.getServicestoptime().equals("")){
            if(aPredialtaskValueObject.getServicestoptime().equals("@_@"))sql.append( " A.SERVICESTOPTIME= null,");
            else sql.append(" A.SERVICESTOPTIME='"+aPredialtaskValueObject.getServicestoptime()+"',");
      }
      if(aPredialtaskValueObject.getDialbegintime()!=null&&!aPredialtaskValueObject.getDialbegintime().equals("")){
            if(aPredialtaskValueObject.getDialbegintime().equals("@_@"))sql.append( " A.DIALBEGINTIME= null,");