predialtaskdao.java

采用JAVA开发

        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 int size(Connection aConnection,PredialtaskQueryValue aPredialtaskQueryValue) throws SQLException  { 
      StringBuffer sql = new StringBuffer("select  count(*) tsize from PREDIALTASK A where 1=1 " );

      String condition = aPredialtaskQueryValue.toSql();
      sql.append(condition);
      ResultSet rs = null;
      int  size = 0;
      PreparedStatement prepStmt = aConnection.prepareStatement( sql.toString() );
      rs = prepStmt.executeQuery();
      if(rs.next())  size = rs.getInt(1);
      rs.close(); 
      prepStmt.close();
      return size ;
     } 

    public ArrayList all(Connection aConnection) throws SQLException  { 
      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 = 1 " );

      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 selectByQueryValue(Connection aConnection,PredialtaskQueryValue aPredialtaskQueryValue,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 = 1 " );

      String condition = aPredialtaskQueryValue.toSql();
      sql.append(condition);
      //-----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 PredialtaskValueObject getByPrimaryKey(Connection aConnection,Integer callorder,String serialnum) throws SQLException  { 
      String sql = "select * from PREDIALTASK A where 1=1  and A.CALLORDER=? and A.SERIALNUM=?";
      ResultSet rs = null;
      ArrayList list = new ArrayList();
      PreparedStatement prepStmt = aConnection.prepareStatement( sql.toString() );
      prepStmt.setInt(1,callorder.intValue());
      prepStmt.setString(2,serialnum);
      rs = prepStmt.executeQuery();
      while( rs.next() ) { 
        PredialtaskValueObject model = new PredialtaskValueObject();
      model.setSerialnum(serialnum);
      model.setCallorder(callorder);
        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.size()==0?null:(PredialtaskValueObject)list.get(0) ;
     } 

    public void  deleteByPrimaryKey(Connection aConnection,Integer callorder,String serialnum) throws SQLException  { 
      String sql = "delete  from PREDIALTASK where 1=1   and CALLORDER=? and SERIALNUM=?";
      PreparedStatement prepStmt = aConnection.prepareStatement( sql.toString() );
      prepStmt.setInt(1,callorder.intValue());
      prepStmt.setString(2,serialnum);
       prepStmt.executeUpdate();
     } 

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