Examples of edu.uga.galileo.voci.db.QueryParser.addPreparedStmtElementDefinition()

Class edu.uga.galileo.voci.db.QueryParser

Examples of edu.uga.galileo.voci.db.QueryParser.addPreparedStmtElementDefinition()

edu.uga.galileo.voci.db.QueryParser.addPreparedStmtElementDefinition()
Define the value of that column to be inserted into '?' parts of a PreparedStatement. The order in which the '?' elements are populated is the order in which they're added using this method. @param value The value to insert into the PreparedStatement. The should be String for strings, Integer for ints, and Date for dates.

    sql.append("status, created, expires) values ");
    sql.append("(?, ?, ?, ?, now(), ?) ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());
    qp.addPreparedStmtElementDefinition(bundle.getProjectId());
    qp.addPreparedStmtElementDefinition(bundle.isActive());
    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, bundle
        .getStatus() <= 0 ? null : bundle.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP,
        bundle.getExpires());

View Full Code Here

    sql.append("(?, ?, ?, ?, now(), ?) ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());
    qp.addPreparedStmtElementDefinition(bundle.getProjectId());
    qp.addPreparedStmtElementDefinition(bundle.isActive());
    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, bundle
        .getStatus() <= 0 ? null : bundle.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP,
        bundle.getExpires());

View Full Code Here


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());
    qp.addPreparedStmtElementDefinition(bundle.getProjectId());
    qp.addPreparedStmtElementDefinition(bundle.isActive());
    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, bundle
        .getStatus() <= 0 ? null : bundle.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP,
        bundle.getExpires());


    if (connection != null) {

View Full Code Here

    qp.addPreparedStmtElementDefinition(bundle.getBundleId());
    qp.addPreparedStmtElementDefinition(bundle.getProjectId());
    qp.addPreparedStmtElementDefinition(bundle.isActive());
    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, bundle
        .getStatus() <= 0 ? null : bundle.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP,
        bundle.getExpires());


    if (connection != null) {
      qp.setConnection(connection);
    }

View Full Code Here

    sql.append("set active=?, status=?, expires=? ");
    sql.append("where bundle_id=? ");
    sql.append("and project_id=? ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(bundle.isActive());
    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, bundle
        .getStatus() <= 0 ? null : bundle.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP,
        bundle.getExpires());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());

View Full Code Here

    sql.append("where bundle_id=? ");
    sql.append("and project_id=? ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(bundle.isActive());
    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, bundle
        .getStatus() <= 0 ? null : bundle.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP,
        bundle.getExpires());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());
    qp.addPreparedStmtElementDefinition(bundle.getProjectId());

View Full Code Here


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(bundle.isActive());
    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, bundle
        .getStatus() <= 0 ? null : bundle.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP,
        bundle.getExpires());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());
    qp.addPreparedStmtElementDefinition(bundle.getProjectId());


    try {

View Full Code Here

    qp.addPreparedStmtElementDefinition(bundle.isActive());
    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, bundle
        .getStatus() <= 0 ? null : bundle.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP,
        bundle.getExpires());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());
    qp.addPreparedStmtElementDefinition(bundle.getProjectId());


    try {
      if (!Configuration.getConnectionPool().executeInsertOrUpdate(qp)) {
        throw new NoSuchBundleException("Bundle "

View Full Code Here

    qp.addPreparedStmtElementDefinition(QueryParserElement.INT, bundle
        .getStatus() <= 0 ? null : bundle.getStatus());
    qp.addPreparedStmtElementDefinition(QueryParserElement.TIMESTAMP,
        bundle.getExpires());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());
    qp.addPreparedStmtElementDefinition(bundle.getProjectId());


    try {
      if (!Configuration.getConnectionPool().executeInsertOrUpdate(qp)) {
        throw new NoSuchBundleException("Bundle "
            + bundle.getId() + " in project "

View Full Code Here

    sql.append(" (select bundle_id ");
    sql.append("  from item2bundle ");
    sql.append("  where bundle_id=?) ");


    QueryParser qp = new QueryParser(sql.toString());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());
    qp.addPreparedStmtElementDefinition(bundle.getProjectId());
    qp.addPreparedStmtElementDefinition(bundle.getBundleId());


    try {
      if (!Configuration.getConnectionPool().executeInsertOrUpdate(qp)) {

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.