Examples of com.centraview.common.CVDal.executeUpdate()

com.centraview.common.CVDal.executeUpdate()
Executes the SQL statement in this PreparedStatement object, which must be an SQL INSERT, UPDATE or DELETE statement; or an SQL statement that returns nothing, such as a DDL statement. @return int: Either (a) the row count for INSERT, UPDATE, orDELETE statements or (b) 0 for SQL statements that return nothing

       cvdl.executeUpdate();
       cvdl.clearParameters();


        cvdl.setSql("email.deleteemailrecipient");
       cvdl.setInt( 1, mailId);
       cvdl.executeUpdate();
       cvdl.clearParameters();


        cvdl.setSql("email.deleteemailmessage");
       cvdl.setInt( 1, mailId);
       cvdl.executeUpdate();

View Full Code Here

       cvdl.executeUpdate();
       cvdl.clearParameters();


        cvdl.setSql("email.deleteemailmessage");
       cvdl.setInt( 1, mailId);
       cvdl.executeUpdate();
       cvdl.clearParameters();
      }
       }
     }
       catch(Exception e)

View Full Code Here


       //System.out.println ("*** This is Final String for Mark as Read Method ***");
        //System.out.println (str);
       cvdl.setSqlQueryToNull();
       cvdl.setSqlQuery(str);
        cvdl.executeUpdate();
       cvdl.clearParameters();
        cvdl.destroy();
      }
      catch(Exception e)
      {

View Full Code Here

    CVDal cvdl = new CVDal(this.dataSource);
    if (filter != null && filter.length() > 0)
    {
      String str = "CREATE TABLE historylistfilter " + filter;
      cvdl.setSqlQuery(str);
      cvdl.executeUpdate();
      cvdl.setSqlQueryToNull();
    }
    int numberOfRecords = 0;
    numberOfRecords = EJBUtil.buildListFilterTable(cvdl, "historylistfilter", individualId, 0, "history", "historyId", "owner", null, false);
    parameters.setTotalRecords(numberOfRecords);

View Full Code Here

      dl.setFloat(7,tsvo.getBreakTime());
      dl.setFloat(8,userId);
      dl.setFloat(9,tsvo.getHours());
      dl.setInt(10, tsvo.getTicketID());
      dl.setInt(11, tsvo.getTimesheetID());
      dl.executeUpdate();


      timeSlipId = dl.getAutoGeneratedKey();


            InitialContext ic = CVUtility.getInitialContext();
            AuthorizationLocalHome authorizationHome = (AuthorizationLocalHome)ic.lookup("local/Authorization");

View Full Code Here

    String query = this.buildReportListQuery(parameters);
    cvdl.setSqlQuery(query);
    list = cvdl.executeQueryList(1);
    cvdl.setSqlQueryToNull();
    cvdl.setSqlQuery("DROP TABLE historylistfilter");
    cvdl.executeUpdate();
    cvdl.setSqlQueryToNull();
    cvdl.setSqlQuery("DROP TABLE listfilter");
    cvdl.executeUpdate();
    cvdl.destroy();
    cvdl = null;

View Full Code Here

    cvdl.setSqlQueryToNull();
    cvdl.setSqlQuery("DROP TABLE historylistfilter");
    cvdl.executeUpdate();
    cvdl.setSqlQueryToNull();
    cvdl.setSqlQuery("DROP TABLE listfilter");
    cvdl.executeUpdate();
    cvdl.destroy();
    cvdl = null;
    return new ValueListVO(list, parameters);
  }

View Full Code Here

      dl.setFloat(8,tsvo.getBreakTime());
      dl.setFloat(9,tsvo.getHours());
      dl.setInt(10,tsvo.getTimeSlipID());




      dl.executeUpdate();


        dl.clearParameters();


      dl.destroy();
    }

View Full Code Here

        cvdl.setTime(5,(java.sql.Time)hm.get("Start"));
        cvdl.setTime(6,(java.sql.Time)hm.get("End"));
        cvdl.setFloat(7,((Float)hm.get("BreakTime")).floatValue());
        //cvdl.setFloat(8,userId);
        cvdl.setFloat(9,((Float)hm.get("hours")).floatValue());
        cvdl.executeUpdate();


      }
       cvdl.clearParameters();
      cvdl.destroy();

View Full Code Here

    try
    {
      CVDal cvdl = new CVDal(dataSource);
      cvdl.setSql( "projecttimeslip.deletetimeSlip" );
      cvdl.setInt( 1 , timeSlipId );
       cvdl.executeUpdate();
       cvdl.clearParameters();
      cvdl.destroy();


    }catch( Exception e )
    {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.