Package org.apache.ws.jaxme.sqls

Examples of org.apache.ws.jaxme.sqls.Column

683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
    pMethod.addTry();

    int paramNum = 0;
    for (Iterator iter = pColumnSet.getColumns();  iter.hasNext();  ) {
       Object v = new Object[]{pValues, "[", Integer.toString(paramNum), "]"};
       Column column = (Column) iter.next();
       setPreparedStatementValue(pMethod, column, stmt, Integer.toString(++paramNum), v);
    }
    LocalJavaField rs = pMethod.newJavaField(ResultSet.class, "rs");
    rs.addLine(stmt, ".executeQuery()");
    LocalJavaField isRsClosed = pMethod.newJavaField(boolean.class);
    isRsClosed.addLine("false");
    LocalJavaField result;
    if (pReturnValue) {
      result = pMethod.newJavaField(Object[].class, "result");
      result.addLine("null");
    } else {
      result = null;
    }
    pMethod.addTry();

    pMethod.addWhile(rs, ".next()");
    if (result != null) {
      pMethod.addIf(result, " != null");
      pMethod.addThrowNew(IllegalStateException.class,
                          JavaSource.getQuoted("Expected a single row only."));
      pMethod.addEndIf();
    }

    int resultColumnSize = 0;
    for (Iterator iter = table.getColumns();  iter.hasNext();  iter.next()) {
       ++resultColumnSize;
    }
    LocalJavaField row = pMethod.newJavaField(Object[].class, "row");
    row.addLine("new ", Object.class, "[" + resultColumnSize + "];");

    int resultColumnNum = 0;
    for (Iterator iter = table.getColumns();  iter.hasNext();  ) {
       Column column = (Column) iter.next();
       setResultSetValue(pMethod, column, rs, resultColumnNum++, row);
    }

    pMethod.addLine(((result == null) ? "" : "result = "),
                    getInsertRowMethodName(pTableInfo), "(", pConn, ", ", pMap, ", ",
View Full Code Here
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
                                                     ColumnSet pColumnSet,
                                                     DirectAccessible pValues) {
    Table table = pColumnSet.getTable();
    List params = new ArrayList();
    for (Iterator iter = pColumnSet.getColumns();  iter.hasNext();  ) {
      Column primaryKeyColumn = (Column) iter.next();
      int index = -1;
      int i = 0;
      for (Iterator iter2 = table.getColumns();  iter2.hasNext();  ++i) {
        Column tableColumn = (Column) iter2.next();
        if (tableColumn.equals(primaryKeyColumn)) {
          index = i;
          break;
        }
      }
      if (index == -1) {
View Full Code Here
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
                                   ColumnSet pColumnSet,
                                   DirectAccessible pRow,
                                   DirectAccessible pData) {
    Table table = pTableInfo.getTable();
    for (Iterator iter = pColumnSet.getColumns();  iter.hasNext();  ) {
      Column primaryKeyColumn = (Column) iter.next();
      int index = -1;
      int i = 0;
      for (Iterator iter2 = table.getColumns();  iter2.hasNext();  ++i) {
        Column tableColumn = (Column) iter2.next();
        if (tableColumn.equals(primaryKeyColumn)) {
          index = i;
          break;
        }
      }
      if (index == -1) {
View Full Code Here
919
920
921
922
923
924
925
926
927
928
929
    isStmtClosed.addLine("false");
    jm.addTry();

    int paramNum = 0;
    for (Iterator iter = table.getColumns();  iter.hasNext();  ) {
       Column column = (Column) iter.next();
       Object v = new Object[]{ values, "[", Integer.toString(paramNum), "]" };
       setPreparedStatementValue(jm, column, stmt, Integer.toString(++paramNum), v);
    }

    jm.addLine(stmt, ".executeUpdate();");
View Full Code Here
965
966
967
968
969
970
971
972
973
974
975
976
    jc.addLine("The key values are given by the array <code>pRow</code>:");
    jc.addLine("<ul>");
    int i = 0;
    for (Iterator iter = headTable.getTable().getPrimaryKey().getColumns();
         iter.hasNext();  i++) {
      Column col = (Column) iter.next();
      jc.addLine("  <li><code>pRow[" + i+ "] = " + col.getQName() + "</code></li>");
    }
    jc.addLine("</ul>");
    jc.addLine("The method updates the rows version number and creates a new row");
    jc.addLine("with the updated values.</p>");
    {
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
                          JavaSource.getQuoted("Unknown reference: "), " + ",
                          referencedKey);
      pMethod.addEndIf();
      int valNum = 0;
      for (Iterator iter = referencedTable.getTable().getPrimaryKey().getColumns();  iter.hasNext();  ) {
        Column referencedKeyColumn = (Column) iter.next();
        Column localColumn = null;
        for (Iterator iter2 = foreignKey.getColumnLinks();  iter2.hasNext();  ) {
          ForeignKey.ColumnLink link = (ForeignKey.ColumnLink) iter2.next();
          if (link.getReferencedColumn().equals(referencedKeyColumn)) {
            localColumn = link.getLocalColumn();
            break;
          }
        }
        if (localColumn == null) {
          throw new IllegalStateException("Unable to find the column referencing " + referencedKeyColumn.getQName());
        }

        int colNum = -1, i = 0;
        for (Iterator iter2 = pTableInfo.getTable().getColumns();  iter2.hasNext();  ) {
           Column col = (Column) iter2.next();
           if (col.equals(localColumn)) {
              colNum = i;
              break;
           }
           ++i;
        }
View Full Code Here
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
  private int getPreparedStatementParameters(JavaMethod pMethod, Object pStmt, DirectAccessible pElement,
                                             Iterator pColumns, int pParamNum)
      throws SAXException {
    for (Iterator iter = pColumns;  iter.hasNext();  ) {
      Column col = (Column) iter.next();
      CustomColumnData colData = (CustomColumnData) col.getCustomData();
      Object sg = colData.getSG();
      PropertySG propertySG;
      TypeSG typeSG;
      if (sg instanceof AttributeSG) {
        AttributeSG attrSG = (AttributeSG) sg;
        propertySG = attrSG.getPropertySG();
        typeSG = attrSG.getTypeSG();
      } else if (sg instanceof ParticleSG) {
        ParticleSG particleSG = (ParticleSG) sg;
        propertySG = particleSG.getPropertySG();
        typeSG = particleSG.getObjectSG().getTypeSG();
      } else {
        throw new IllegalStateException("Invalid SG type for column " + col.getName() + ": " + sg);
      }
      Object value = propertySG.getValue(pElement);
      setPreparedStatementValue(pMethod, col, pStmt, new Integer(++pParamNum), value, typeSG);
    }
    return pParamNum;
View Full Code Here
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
  private int getResultSet(JavaMethod pMethod, DirectAccessible pRs, DirectAccessible pElement,
                            Iterator pColumns, int pParamNum)
      throws SAXException {
    for (Iterator iter = pColumns;  iter.hasNext();  ) {
      Column col = (Column) iter.next();
      CustomColumnData colData = (CustomColumnData) col.getCustomData();
      Object sg = colData.getSG();
      PropertySG propertySG;
      TypeSG typeSG;
      if (sg instanceof AttributeSG) {
        AttributeSG attrSG = (AttributeSG) sg;
        propertySG = attrSG.getPropertySG();
        typeSG = attrSG.getTypeSG();
      } else if (sg instanceof ParticleSG) {
        ParticleSG particleSG = (ParticleSG) sg;
        propertySG = particleSG.getPropertySG();
        typeSG = particleSG.getObjectSG().getTypeSG();
      } else {
        throw new IllegalStateException("Invalid SG type for column " + col.getName() + ": " + sg);
      }
      Object value = getResultSetValue(pMethod, col, pRs, new Integer(++pParamNum), typeSG);
      propertySG.setValue(pMethod, pElement, value, null);
    }
    return pParamNum;
View Full Code Here
416
417
418
419
420
421
422
423
424
425
426
427
    stmt.addLine(connection, ".prepareStatement(", query, ")");
    jm.addTry();

    List nonKeyColumns = new ArrayList();
    for (Iterator iter = table.getColumns();  iter.hasNext();  ) {
      Column col = (Column) iter.next();
      if (!col.isPrimaryKeyPart()) {
        nonKeyColumns.add(col);
      }
    }
    int i = 0;
    i = getPreparedStatementParameters(jm, stmt, elem, nonKeyColumns.iterator(), i);
View Full Code Here
477
478
479
480
481
482
483
484
485
486
487
488
489
    Table table = pData.getTable();

    JavaQName qName = pController.getComplexTypeSG().getClassContext().getXMLInterfaceName();
    StringBuffer sb = new StringBuffer();
    for (Iterator iter = table.getColumns();  iter.hasNext();  ) {
      Column col = (Column) iter.next();
      if (sb.length() > 0) sb.append(", ");
      sb.append(col.getName().getName());
    }
    LocalJavaField query = jm.newJavaField(String.class);
    jm.addIf(pParams, " != null  &&  pParams.isDistinct()");
    jm.addLine(query, " = ", JavaSource.getQuoted("SELECT DISTINCT"), ";");
    jm.addElse();
View Full Code Here
TOP

Related Classes of org.apache.ws.jaxme.sqls.Column

  • org.apache.ws.jaxme.js.junit.VersionTest
  • org.apache.ws.jaxme.js.pattern.Ant$AntVersionGenerator
  • org.apache.ws.jaxme.js.pattern.VersionGenerator
  • org.apache.ws.jaxme.js.pattern.VersionGenerator$ForeignKeyUpdater
  • org.apache.ws.jaxme.pm.generator.jdbc.JaxMeJdbcSG
  • org.apache.ws.jaxme.pm.generator.jdbc.JdbcTypeSG
  • org.apache.ws.jaxme.sqls.impl.AbstractColumn
  • org.apache.ws.jaxme.sqls.impl.ColumnImpl
  • org.apache.ws.jaxme.sqls.impl.ColumnReferenceImpl
  • org.apache.ws.jaxme.sqls.impl.CombinedConstraintImpl
    • Copyright © 2018 www.massapicom. 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.