predialtaskdao.java

采用JAVA开发

      if(aPredialtaskValueObject.getOrigcalled()!=null&&!aPredialtaskValueObject.getOrigcalled().equals("")){
      sql.append(" and A.ORIGCALLED='"+aPredialtaskValueObject.getOrigcalled()).append("'");
      }

      if(aPredialtaskValueObject.getPrivatedata()!=null&&!aPredialtaskValueObject.getPrivatedata().equals("")){
      sql.append(" and A.PRIVATEDATA='"+aPredialtaskValueObject.getPrivatedata()).append("'");
      }

      if(aPredialtaskValueObject.getRedialinterval()!=null&&!aPredialtaskValueObject.getRedialinterval().equals("")){
      sql.append(" and A.REDIALINTERVAL='"+aPredialtaskValueObject.getRedialinterval()).append("'");
      }

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

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

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

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

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

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

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

      if(aPredialtaskValueObject.getUserdata()!=null&&!aPredialtaskValueObject.getUserdata().equals("")){
      sql.append(" and A.USERDATA='"+aPredialtaskValueObject.getUserdata()).append("'");
      }

      //-----Result between variable start and variable end
      if (start != -1 && end != -1){
      String mainSql = sql.toString();
      sql = new StringBuffer("select * from ( select a.*,rownum as tmprow from (").append(mainSql).append(") a where rownum <=").append(end).append(") where tmprow>= ").append(start);
      }

      ResultSet rs = null;
      ArrayList list = new ArrayList();
      PreparedStatement prepStmt = aConnection.prepareStatement( sql.toString() );
      rs = prepStmt.executeQuery();
      while( rs.next() ) { 
        PredialtaskValueObject model = new PredialtaskValueObject();
        String strSERIALNUM =rs.getString("SERIALNUM");
       if(!rs.wasNull()) model.setSerialnum(strSERIALNUM.trim());
        int intCALLORDER = rs.getInt("CALLORDER");
       if(!rs.wasNull()) model.setCallorder(new Integer(intCALLORDER));
        String strSERVICEBEGINTIME =rs.getString("SERVICEBEGINTIME");
       if(!rs.wasNull()) model.setServicebegintime(strSERVICEBEGINTIME.trim());
        String strSERVICESTOPTIME =rs.getString("SERVICESTOPTIME");
       if(!rs.wasNull()) model.setServicestoptime(strSERVICESTOPTIME.trim());
        String strDIALBEGINTIME =rs.getString("DIALBEGINTIME");
       if(!rs.wasNull()) model.setDialbegintime(strDIALBEGINTIME.trim());
        String strDIALENDTIME =rs.getString("DIALENDTIME");
       if(!rs.wasNull()) model.setDialendtime(strDIALENDTIME.trim());
        int intTIMEINTERVAL = rs.getInt("TIMEINTERVAL");
       if(!rs.wasNull()) model.setTimeinterval(new Integer(intTIMEINTERVAL));
        int intINTERVALTYPE = rs.getInt("INTERVALTYPE");
       if(!rs.wasNull()) model.setIntervaltype(new Integer(intINTERVALTYPE));
        String strCALLER =rs.getString("CALLER");
       if(!rs.wasNull()) model.setCaller(strCALLER.trim());
        String strORIGCALLER =rs.getString("ORIGCALLER");
       if(!rs.wasNull()) model.setOrigcaller(strORIGCALLER.trim());
        String strCALLED =rs.getString("CALLED");
       if(!rs.wasNull()) model.setCalled(strCALLED.trim());
        String strORIGCALLED =rs.getString("ORIGCALLED");
       if(!rs.wasNull()) model.setOrigcalled(strORIGCALLED.trim());
        String strPRIVATEDATA =rs.getString("PRIVATEDATA");
       if(!rs.wasNull()) model.setPrivatedata(strPRIVATEDATA.trim());
        String strREDIALINTERVAL =rs.getString("REDIALINTERVAL");
       if(!rs.wasNull()) model.setRedialinterval(strREDIALINTERVAL.trim());
        int intREDIALCOUNT = rs.getInt("REDIALCOUNT");
       if(!rs.wasNull()) model.setRedialcount(new Integer(intREDIALCOUNT));
        int intTYPE = rs.getInt("TYPE");
       if(!rs.wasNull()) model.setType(new Integer(intTYPE));
        int intSERVICEID = rs.getInt("SERVICEID");
       if(!rs.wasNull()) model.setServiceid(new Integer(intSERVICEID));
        int intANSWERTYPE = rs.getInt("ANSWERTYPE");
       if(!rs.wasNull()) model.setAnswertype(new Integer(intANSWERTYPE));
        int intPRIORITY = rs.getInt("PRIORITY");
       if(!rs.wasNull()) model.setPriority(new Integer(intPRIORITY));
        int intSTATUS = rs.getInt("STATUS");
       if(!rs.wasNull()) model.setStatus(new Integer(intSTATUS));
        int intDEFAULTINTERVAL = rs.getInt("DEFAULTINTERVAL");
       if(!rs.wasNull()) model.setDefaultinterval(new Integer(intDEFAULTINTERVAL));
        String strUSERDATA =rs.getString("USERDATA");
       if(!rs.wasNull()) model.setUserdata(strUSERDATA.trim());
        list.add(model);
      }
      rs.close(); 
      prepStmt.close();
      return list ;
     } 

    public ArrayList supplements(Connection aConnection,PredialtaskValueObject[] manyPredialtaskValueObject,int start,int end) throws SQLException  { 
      //---- variable sql be provided througth analyze the ValueObject  
      StringBuffer sql = new StringBuffer("SELECT 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 FROM PREDIALTASK A WHERE 1 = 0 " );

      for(int i=0;i<manyPredialtaskValueObject.length;i++){
      sql.append( " or ( 1=1 ");
      if(manyPredialtaskValueObject[i].getSerialnum()!=null&&!manyPredialtaskValueObject[i].getSerialnum().equals("")){
      sql.append(" and A.SERIALNUM='"+manyPredialtaskValueObject[i].getSerialnum()).append("'");
      }

      if(manyPredialtaskValueObject[i].getCallorder()!=null){
      sql.append(" and A.CALLORDER=").append(manyPredialtaskValueObject[i].getCallorder());
      }

      if(manyPredialtaskValueObject[i].getServicebegintime()!=null&&!manyPredialtaskValueObject[i].getServicebegintime().equals("")){
      sql.append(" and A.SERVICEBEGINTIME='"+manyPredialtaskValueObject[i].getServicebegintime()).append("'");
      }

      if(manyPredialtaskValueObject[i].getServicestoptime()!=null&&!manyPredialtaskValueObject[i].getServicestoptime().equals("")){
      sql.append(" and A.SERVICESTOPTIME='"+manyPredialtaskValueObject[i].getServicestoptime()).append("'");
      }

      if(manyPredialtaskValueObject[i].getDialbegintime()!=null&&!manyPredialtaskValueObject[i].getDialbegintime().equals("")){
      sql.append(" and A.DIALBEGINTIME='"+manyPredialtaskValueObject[i].getDialbegintime()).append("'");
      }

      if(manyPredialtaskValueObject[i].getDialendtime()!=null&&!manyPredialtaskValueObject[i].getDialendtime().equals("")){
      sql.append(" and A.DIALENDTIME='"+manyPredialtaskValueObject[i].getDialendtime()).append("'");
      }

      if(manyPredialtaskValueObject[i].getTimeinterval()!=null){
      sql.append(" and A.TIMEINTERVAL=").append(manyPredialtaskValueObject[i].getTimeinterval());
      }

      if(manyPredialtaskValueObject[i].getIntervaltype()!=null){
      sql.append(" and A.INTERVALTYPE=").append(manyPredialtaskValueObject[i].getIntervaltype());
      }

      if(manyPredialtaskValueObject[i].getCaller()!=null&&!manyPredialtaskValueObject[i].getCaller().equals("")){
      sql.append(" and A.CALLER='"+manyPredialtaskValueObject[i].getCaller()).append("'");
      }

      if(manyPredialtaskValueObject[i].getOrigcaller()!=null&&!manyPredialtaskValueObject[i].getOrigcaller().equals("")){
      sql.append(" and A.ORIGCALLER='"+manyPredialtaskValueObject[i].getOrigcaller()).append("'");
      }

      if(manyPredialtaskValueObject[i].getCalled()!=null&&!manyPredialtaskValueObject[i].getCalled().equals("")){
      sql.append(" and A.CALLED='"+manyPredialtaskValueObject[i].getCalled()).append("'");
      }

      if(manyPredialtaskValueObject[i].getOrigcalled()!=null&&!manyPredialtaskValueObject[i].getOrigcalled().equals("")){
      sql.append(" and A.ORIGCALLED='"+manyPredialtaskValueObject[i].getOrigcalled()).append("'");
      }

      if(manyPredialtaskValueObject[i].getPrivatedata()!=null&&!manyPredialtaskValueObject[i].getPrivatedata().equals("")){
      sql.append(" and A.PRIVATEDATA='"+manyPredialtaskValueObject[i].getPrivatedata()).append("'");
      }

      if(manyPredialtaskValueObject[i].getRedialinterval()!=null&&!manyPredialtaskValueObject[i].getRedialinterval().equals("")){
      sql.append(" and A.REDIALINTERVAL='"+manyPredialtaskValueObject[i].getRedialinterval()).append("'");
      }

      if(manyPredialtaskValueObject[i].getRedialcount()!=null){
      sql.append(" and A.REDIALCOUNT=").append(manyPredialtaskValueObject[i].getRedialcount());
      }

      if(manyPredialtaskValueObject[i].getType()!=null){
      sql.append(" and A.TYPE=").append(manyPredialtaskValueObject[i].getType());
      }

      if(manyPredialtaskValueObject[i].getServiceid()!=null){
      sql.append(" and A.SERVICEID=").append(manyPredialtaskValueObject[i].getServiceid());
      }

      if(manyPredialtaskValueObject[i].getAnswertype()!=null){
      sql.append(" and A.ANSWERTYPE=").append(manyPredialtaskValueObject[i].getAnswertype());
      }

      if(manyPredialtaskValueObject[i].getPriority()!=null){
      sql.append(" and A.PRIORITY=").append(manyPredialtaskValueObject[i].getPriority());
      }

      if(manyPredialtaskValueObject[i].getStatus()!=null){
      sql.append(" and A.STATUS=").append(manyPredialtaskValueObject[i].getStatus());
      }

      if(manyPredialtaskValueObject[i].getDefaultinterval()!=null){
      sql.append(" and A.DEFAULTINTERVAL=").append(manyPredialtaskValueObject[i].getDefaultinterval());
      }

      if(manyPredialtaskValueObject[i].getUserdata()!=null&&!manyPredialtaskValueObject[i].getUserdata().equals("")){
      sql.append(" and A.USERDATA='"+manyPredialtaskValueObject[i].getUserdata()).append("'");
      }

      sql.append(")");
      }
      //-----Result between variable start and variable end
      if (start != -1 && end != -1){
      String mainSql = sql.toString();
      sql = new StringBuffer("select * from ( select a.*,rownum as tmprow from (").append(mainSql).append(") a where rownum <=").append(end).append(") where tmprow>= ").append(start);
      }

      ResultSet rs = null;
      ArrayList list = new ArrayList();
      PreparedStatement prepStmt = aConnection.prepareStatement( sql.toString() );
      rs = prepStmt.executeQuery();
      while( rs.next() ) { 
        PredialtaskValueObject model = new PredialtaskValueObject();
        String strSERIALNUM =rs.getString("SERIALNUM");
       if(!rs.wasNull()) model.setSerialnum(strSERIALNUM.trim());
        int intCALLORDER = rs.getInt("CALLORDER");
       if(!rs.wasNull()) model.setCallorder(new Integer(intCALLORDER));
        String strSERVICEBEGINTIME =rs.getString("SERVICEBEGINTIME");
       if(!rs.wasNull()) model.setServicebegintime(strSERVICEBEGINTIME.trim());
        String strSERVICESTOPTIME =rs.getString("SERVICESTOPTIME");
       if(!rs.wasNull()) model.setServicestoptime(strSERVICESTOPTIME.trim());
        String strDIALBEGINTIME =rs.getString("DIALBEGINTIME");
       if(!rs.wasNull()) model.setDialbegintime(strDIALBEGINTIME.trim());
        String strDIALENDTIME =rs.getString("DIALENDTIME");
       if(!rs.wasNull()) model.setDialendtime(strDIALENDTIME.trim());
        int intTIMEINTERVAL = rs.getInt("TIMEINTERVAL");
       if(!rs.wasNull()) model.setTimeinterval(new Integer(intTIMEINTERVAL));
        int intINTERVALTYPE = rs.getInt("INTERVALTYPE");
       if(!rs.wasNull()) model.setIntervaltype(new Integer(intINTERVALTYPE));
        String strCALLER =rs.getString("CALLER");
       if(!rs.wasNull()) model.setCaller(strCALLER.trim());
        String strORIGCALLER =rs.getString("ORIGCALLER");
       if(!rs.wasNull()) model.setOrigcaller(strORIGCALLER.trim());
        String strCALLED =rs.getString("CALLED");
       if(!rs.wasNull()) model.setCalled(strCALLED.trim());
        String strORIGCALLED =rs.getString("ORIGCALLED");
       if(!rs.wasNull()) model.setOrigcalled(strORIGCALLED.trim());
        String strPRIVATEDATA =rs.getString("PRIVATEDATA");
       if(!rs.wasNull()) model.setPrivatedata(strPRIVATEDATA.trim());