Examples of toPreparedStatement()

Examples of org.conserve.tools.StatementPrototype.toPreparedStatement()

605
606
607
608
609
610
611
612
613
614
615
    statement.append(" FROM ");
    if (id != null)
    {
      sp.addEqualsClause(shortName + "." + Defaults.ID_COL, id);
    }
    PreparedStatement ps = sp.toPreparedStatement(cw, statement.toString());
    ResultSet rs = ps.executeQuery();
    List<HashMap<String, Object>> propertyVector = createPropertyVector(rs);
    ps.close();
    // If a row has a REALCLASS entry, load data for the subclass
    for (HashMap<String, Object> map : propertyVector)
View Full Code Here

Examples of org.conserve.tools.StatementPrototype.toPreparedStatement()

1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
    StatementPrototypeGenerator whereGenerator = new StatementPrototypeGenerator(
        adapter);
    whereGenerator.setClauses(clauses);
    StatementPrototype sp = whereGenerator.generate(clazz, true);
    PreparedStatement ps = sp.toPreparedStatement(cw,
        sp.getSelectStartQuery());
    ResultSet rs = ps.executeQuery();
    List<HashMap<String, Object>> propertyVector = createPropertyVector(rs);
    ps.close();
    for (HashMap<String, Object> map : propertyVector)
View Full Code Here

Examples of org.conserve.tools.StatementPrototype.toPreparedStatement()

1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
    whereGenerator.setClauses(clause);
    StatementPrototype sp = whereGenerator.generate(clazz, true);
    String tableId = sp.getIdStatementGenerator().getJoinTableIds().get(0);
    StringBuilder statement = new StringBuilder("SELECT COUNT(DISTINCT("
        + tableId + "." + Defaults.ID_COL + ")) FROM ");
    PreparedStatement ps = sp.toPreparedStatement(cw, statement.toString());
    ResultSet rs = ps.executeQuery();
    if (rs.next())
    {
      res = rs.getLong(1);
    }
View Full Code Here

Examples of org.conserve.tools.StatementPrototype.toPreparedStatement()

1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
    String shortName = whereGenerator.getTypeStack()
        .getRepresentation(clazz).getAsName();

    sp.addEqualsClause(shortName + "." + Defaults.ID_COL, id);

    PreparedStatement ps = sp.toPreparedStatement(cw,
        sp.getSelectStartQuery());
    ResultSet rs = ps.executeQuery();
    List<HashMap<String, Object>> propertyVector = createPropertyVector(rs);
    ps.close();
    for (HashMap<String, Object> map : propertyVector)
View Full Code Here

Examples of org.conserve.tools.StatementPrototype.toPreparedStatement()

1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
    StringBuilder statement = new StringBuilder("SELECT * FROM ");
    StatementPrototypeGenerator whereGenerator = new StatementPrototypeGenerator(
        adapter);
    StatementPrototype sp = whereGenerator.generate(clazz, false);
    sp.addEqualsClause(Defaults.ID_COL, dbId);
    PreparedStatement ps = sp.toPreparedStatement(cw, statement.toString());
    ResultSet rs = ps.executeQuery();
    List<HashMap<String, Object>> propertyVector = createPropertyVector(rs);
    if (propertyVector.size() != 1)
    {
      throw new SQLException("Wrong number of subclass entities found: "
View Full Code Here

Examples of org.conserve.tools.StatementPrototype.toPreparedStatement()

1610
1611
1612
1613
1614
1615
1616
1617
1618
1619
1620
          .getRepresentation(gen.getTypeStack().getLevel(c))
          .getAsName());
      prepend.append(".");
      prepend.append(Defaults.ID_COL);
      prepend.append(" FROM ");
      PreparedStatement ps = sp.toPreparedStatement(cw,
          prepend.toString());
      try
      {
        Tools.logFine(ps);
        ResultSet rs = ps.executeQuery();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.