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

com.centraview.common.CVDal.executeQuery()
Executes a Query (Select), and returns the data as a Collection of HashMaps HashMap contains field names as key and field data as value delegates to PreparedStatement's executeQuery

      cvdal.setSqlQuery("SELECT * from garbagelist");
      list = cvdal.executeQueryList(1);
      cvdal.setSqlQueryToNull();


      cvdal.setSqlQuery("SELECT count(*) AS NoOfRecords FROM garbagelist");
      Collection colList = cvdal.executeQuery();
      cvdal.clearParameters();
      cvdal.setSqlQueryToNull();


    if (colList != null)
    {

View Full Code Here

    try
    {
      String query = "SELECT f.name, f.fieldName FROM mailimportfields f LEFT JOIN mailimporttypes t ON (f.typeID=t.typeID) WHERE t.name=?";
      cvdal.setSqlQuery(query);
      cvdal.setString(1, importType);
      Collection results = cvdal.executeQuery();
      if (results != null && results.size() > 0)
      {
        Iterator iter = results.iterator();
        while (iter.hasNext())
        {

View Full Code Here

    ArrayList folderList = new ArrayList();
    try {
      String selectQuery = "SELECT FolderID FROM emailfolder WHERE AccountID=? ORDER BY Parent, Name, FolderID";
      cvdal.setSqlQuery(selectQuery);
      cvdal.setInt(1, accountID);
      Collection results = cvdal.executeQuery();
      
      
      if (results != null) {
        Iterator resultsIterator = results.iterator();
        while (resultsIterator.hasNext()) {

View Full Code Here

      String sqlQuery = "Select SearchFieldID from searchfield where SearchtableID = ? and FieldName = ?";
      cvdal.setSqlQuery(sqlQuery);
      cvdal.setInt(1,tableID);
      cvdal.setString(2,GlobalReplaceConstantKeys.SEARCH_MARKETING_FIELD_NAME);


      Collection resultsCollection = cvdal.executeQuery();
      if (resultsCollection != null)
      {
      Iterator resultsIterator = resultsCollection.iterator();
      while (resultsIterator.hasNext())
      {

View Full Code Here

    {
      //We will get the list of table id, for which we can preform the Global Replace
    String sqlQuery = "SELECT SearchTableID,DisplayName,TableName " +
      " FROM searchtable WHERE IsOnGlobalReplaceTable = 'Y' ";
    cvdal.setSqlQuery(sqlQuery);
    Collection resultsCollection = cvdal.executeQuery();
    if (resultsCollection != null)
    {
      Iterator resultsIterator = resultsCollection.iterator();
      while (resultsIterator.hasNext())
      {

View Full Code Here

    //We will get the list of fields which are associate to the table which is selected.
    String sqlQuery = "SELECT RelateTableID,IsRelateTable " +
      " FROM globalreplacerelate WHERE SearchTableID = ? ";
    cvdal.setSqlQuery(sqlQuery);
    cvdal.setInt(1,replaceTableID);
    Collection resultsCollection = cvdal.executeQuery();
    if (resultsCollection != null)
    {
      Iterator resultsIterator = resultsCollection.iterator();
      while (resultsIterator.hasNext())
      {

View Full Code Here

    cvdal.setSqlQueryToNull();
    cvdal.clearParameters();
    sqlQuery = "SELECT SearchTableID,SearchFieldID,DisplayName,FieldType " +
      " FROM searchfield WHERE SearchTableID in ("+tableIDs.toString()+")  and IsGlobalReplaceField ='Y'";
    cvdal.setSqlQuery(sqlQuery);
    Collection fieldCollections = cvdal.executeQuery();
    if (fieldCollections != null)
    {
      Iterator fieldsIterator = fieldCollections.iterator();
      while (fieldsIterator.hasNext())
      {

View Full Code Here


      sqlQuery = "SELECT CustomFieldID , Name, FieldType FROM" +
             " customfield where RecordType = ?;";
      cvdal.setSqlQuery(sqlQuery);
      cvdal.setInt(1,replaceTableID);
      fieldCollections = cvdal.executeQuery();
      if (fieldCollections != null)
      {
        Iterator fieldsIterator = fieldCollections.iterator();
        while (fieldsIterator.hasNext())
        {

View Full Code Here

      String sqlQuery = "SELECT ValueID , Value " +
        " FROM customfieldvalue WHERE CustomFieldID = ? ";
      cvdal.setSqlQuery(sqlQuery);
      cvdal.setInt(1,fieldID);


      Collection resultsCollection = cvdal.executeQuery();
      if (resultsCollection != null)
      {
        Iterator resultsIterator = resultsCollection.iterator();
        while (resultsIterator.hasNext())
        {

View Full Code Here

      cvdal.setSqlQuery(sqlQuery);
      cvdal.setInt(1,tableID);
      cvdal.setInt(2,fieldID);
      String fieldName = null;
      String tableName = null;
      Collection resultsCollection = cvdal.executeQuery();
      if (resultsCollection != null)
      {
        Iterator resultsIterator = resultsCollection.iterator();
        while (resultsIterator.hasNext())
        {

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.