Example #1
0
 /**
  * Creates a select distinct prepared statement
  *
  * @param dp The DataPack object which contains the data to render as an sql string
  * @return The sql prepared statement we are parsing
  */
 public String selectDistinct(DataPack dp) {
   synchronized (syncSelectDistinct) {
     String sql = "SELECT DISTINCT " + dp.getSetClause() + " FROM " + dp.getTableName();
     sql = getWhereString(dp, sql);
     return sql + ";";
   }
 }
Example #2
0
 /**
  * Gets the where statement and conditions
  *
  * @param dataPack The DataPack object which contains the data to render as an sql string
  * @param sql The sql string we are parsing
  * @return The sql string concatenated with the where statement
  */
 protected String getWhereString(DataPack dataPack, String sql) {
   synchronized (synchWhereString) {
     if (dataPack.getWhereClause() != null) {
       sql += " WHERE " + dataPack.getWhereClause();
     }
     return sql;
   }
 }
Example #3
0
  /**
   * Creates a delete prepared statement
   *
   * @param dp The DataPack object which contains the data to render as an sql string
   * @return The sql string we are parsing
   */
  public String delete(DataPack dp) {
    synchronized (syncDelete) {
      String s = "DELETE ";
      if (dp.getSetClause() != null) {
        s += dp.getSetClause();
      }
      s += " FROM " + dp.getTableName();
      s = getWhereString(dp, s);

      return s;
    }
  }
Example #4
0
 /**
  * Creates an insert prepared statement
  *
  * @param dp The DataPack object which contains the data to render as an sql string
  * @return The sql prepared statement we are parsing
  */
 public synchronized String insert(DataPack dp) {
   synchronized (syncInsert) {
     String sql =
         "INSERT INTO "
             + dp.getTableName()
             + "("
             + dp.getSetClause()
             + ")"
             + " VALUES("
             + getQuestionMarks(dp.getDataCount())
             + ")";
     return getWhereString(dp, sql);
   }
 }
Example #5
0
 /**
  * Creates an update prepared statement
  *
  * @param dp The DataPack object which contains the data to render as an sql string
  * @return The sql prepared statement we are parsing
  */
 public String update(DataPack dp) {
   synchronized (syncUpdate) {
     String statement = "UPDATE " + dp.getTableName() + " SET " + dp.getSetClause();
     return getWhereString(dp, statement);
   }
 }