Package org.jboss.as.cmp.jdbc2.schema

Examples of org.jboss.as.cmp.jdbc2.schema.Table$View

1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
                JDBCUtil.safeClose(con);
            }
        }

        private Object loadField(int i) {
            JDBCCMPFieldBridge2 field = (JDBCCMPFieldBridge2) entity.getFields().get(i);

            StringBuffer query = new StringBuffer();
            query.append("select ")
                    .append(field.getColumnName())
                    .append(" from ")
                    .append(tableName)
                    .append(" where ");

            JDBCCMPFieldBridge2[] pkFields = (JDBCCMPFieldBridge2[]) entity.getPrimaryKeyFields();
            for (int pkI = 0; pkI < pkFields.length; ++pkI) {
                if (pkI > 0) {
                    query.append(" and ");
                }
                query.append(pkFields[pkI].getColumnName()).append("=?");
            }

            if (log.isDebugEnabled()) {
                log.debug("executing: " + query.toString());
            }

            Object value = null;
            Connection con = null;
            PreparedStatement ps = null;
            ResultSet rs = null;

            try {
                con = dataSource.getConnection();
                ps = con.prepareStatement(query.toString());

                for (int pkI = 0; pkI < pkFields.length; ++pkI) {
                    JDBCCMPFieldBridge2 pkField = pkFields[pkI];
                    Object fieldValue = fields[pkField.getRowIndex()];
                    pkField.setArgumentParameters(ps, pkI + 1, fieldValue);
                }

                rs = ps.executeQuery();

                if (!rs.next()) {
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
                RelationKeys keys = view.deleted;

                int paramInd = 1;
                JDBCCMPFieldBridge2[] keyFields = (JDBCCMPFieldBridge2[]) leftField.getTableKeyFields();
                for (int pkInd = 0; pkInd < keyFields.length; ++pkInd) {
                    JDBCCMPFieldBridge2 pkField = keyFields[pkInd];
                    Object fieldValue = pkField.getPrimaryKeyValue(keys.leftKey);
                    paramInd = pkField.setArgumentParameters(ps, paramInd, fieldValue);
                }

                keyFields = (JDBCCMPFieldBridge2[]) rightField.getTableKeyFields();
                for (int pkInd = 0; pkInd < keyFields.length; ++pkInd) {
                    JDBCCMPFieldBridge2 pkField = keyFields[pkInd];
                    Object fieldValue = pkField.getPrimaryKeyValue(keys.rightKey);
                    paramInd = pkField.setArgumentParameters(ps, paramInd, fieldValue);
                }

                ps.addBatch();
                ++batchCount;
View Full Code Here
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
                RelationKeys keys = view.created;

                JDBCCMPFieldBridge2[] keyFields = (JDBCCMPFieldBridge2[]) leftField.getTableKeyFields();
                int paramInd = 1;
                for (int fInd = 0; fInd < keyFields.length; ++fInd) {
                    JDBCCMPFieldBridge2 field = keyFields[fInd];
                    Object fieldValue = field.getPrimaryKeyValue(keys.leftKey);
                    paramInd = field.setArgumentParameters(ps, paramInd, fieldValue);
                }

                keyFields = (JDBCCMPFieldBridge2[]) rightField.getTableKeyFields();
                for (int fInd = 0; fInd < keyFields.length; ++fInd) {
                    JDBCCMPFieldBridge2 field = keyFields[fInd];
                    Object fieldValue = field.getPrimaryKeyValue(keys.rightKey);
                    paramInd = field.setArgumentParameters(ps, paramInd, fieldValue);
                }

                ps.addBatch();
                ++batchCount;
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
        // UPDATE SQL
        updateSql = "update " + tableName + " set ";
        int setFields = 0;
        for (int i = 0; i < tableFields.length; ++i) {
            JDBCCMPFieldBridge2 field = tableFields[i];
            if (!field.isPrimaryKeyMember()) {
                if (setFields++ > 0) {
                    updateSql += ", ";
                }
                updateSql += field.getColumnName() + "=?";
            }
        }
        updateSql += " where ";
        updateSql += pkFields[0].getColumnName() + "=?";
        for (int i = 1; i < pkFields.length; ++i) {
            updateSql += " and " + pkFields[i].getColumnName() + "=?";
        }

        if (entity.getVersionField() != null) {
            updateSql += " and " + entity.getVersionField().getColumnName() + "=?";
        }
        log.debug("update sql: " + updateSql);

        // SELECT SQL
        String selectColumns = tableFields[0].getColumnName();
        for (int i = 1; i < tableFields.length; ++i) {
            JDBCCMPFieldBridge2 field = tableFields[i];
            selectColumns += ", " + field.getColumnName();
        }

        String whereColumns = pkFields[0].getColumnName() + "=?";
        for (int i = 1; i < pkFields.length; ++i) {
            whereColumns += " and " + pkFields[i].getColumnName() + "=?";
View Full Code Here
333
334
335
336
337
338
339
340
341
342
343
344
345
            con = dataSource.getConnection();
            ps = con.prepareStatement(selectSql);

            int paramInd = 1;
            for (int i = 0; i < pkFields.length; ++i) {
                JDBCCMPFieldBridge2 pkField = pkFields[i];
                Object pkValue = pkField.getPrimaryKeyValue(id);
                paramInd = pkField.setArgumentParameters(ps, paramInd, pkValue);
            }

            rs = ps.executeQuery();

            if (!rs.next()) {
View Full Code Here
446
447
448
449
450
451
452
453
454
455
456
457
458
            while (view.deleted != null) {
                Row row = view.deleted;

                int paramInd = 1;
                for (int pkInd = 0; pkInd < pkFields.length; ++pkInd) {
                    JDBCCMPFieldBridge2 pkField = pkFields[pkInd];
                    Object fieldValue = row.fields[pkField.getRowIndex()];
                    paramInd = pkField.setArgumentParameters(ps, paramInd, fieldValue);
                }

                deleteStrategy.executeUpdate(ps);

                ++batchCount;
View Full Code Here
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
            while (view.dirty != null) {
                Row row = view.dirty;

                int paramInd = 1;
                for (int fInd = 0; fInd < tableFields.length; ++fInd) {
                    JDBCCMPFieldBridge2 field = tableFields[fInd];
                    if (!field.isPrimaryKeyMember()) {
                        Object fieldValue = row.fields[field.getRowIndex()];
                        paramInd = field.setArgumentParameters(ps, paramInd, fieldValue);
                    }
                }

                for (int fInd = 0; fInd < pkFields.length; ++fInd) {
                    JDBCCMPFieldBridge2 pkField = pkFields[fInd];
                    Object fieldValue = row.fields[pkField.getRowIndex()];
                    paramInd = pkField.setArgumentParameters(ps, paramInd, fieldValue);
                }

                JDBCCMPFieldBridge2 versionField = entity.getVersionField();
                if (versionField != null) {
                    int versionIndex = versionField.getVersionIndex();
                    Object curVersion = row.fields[versionIndex];
                    paramInd = versionField.setArgumentParameters(ps, paramInd, curVersion);

                    Object newVersion = row.fields[versionField.getRowIndex()];
                    row.fields[versionIndex] = newVersion;
                }

                updateStrategy.executeUpdate(ps);
View Full Code Here
556
557
558
559
560
561
562
563
564
565
566
567
568
            while (view.created != null) {
                Row row = view.created;

                int paramInd = 1;
                for (int fInd = 0; fInd < tableFields.length; ++fInd) {
                    JDBCCMPFieldBridge2 field = tableFields[fInd];
                    Object fieldValue = row.fields[field.getRowIndex()];
                    paramInd = field.setArgumentParameters(ps, paramInd, fieldValue);
                }

                insertStrategy.executeUpdate(ps);

                ++batchCount;
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
                RelationKeys keys = view.deleted;

                int paramInd = 1;
                JDBCCMPFieldBridge2[] keyFields = (JDBCCMPFieldBridge2[]) leftField.getTableKeyFields();
                for (int pkInd = 0; pkInd < keyFields.length; ++pkInd) {
                    JDBCCMPFieldBridge2 pkField = keyFields[pkInd];
                    Object fieldValue = pkField.getPrimaryKeyValue(keys.leftKey);
                    paramInd = pkField.setArgumentParameters(ps, paramInd, fieldValue);
                }

                keyFields = (JDBCCMPFieldBridge2[]) rightField.getTableKeyFields();
                for (int pkInd = 0; pkInd < keyFields.length; ++pkInd) {
                    JDBCCMPFieldBridge2 pkField = keyFields[pkInd];
                    Object fieldValue = pkField.getPrimaryKeyValue(keys.rightKey);
                    paramInd = pkField.setArgumentParameters(ps, paramInd, fieldValue);
                }

                ps.addBatch();
                ++batchCount;
View Full Code Here
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
                RelationKeys keys = view.created;

                JDBCCMPFieldBridge2[] keyFields = (JDBCCMPFieldBridge2[]) leftField.getTableKeyFields();
                int paramInd = 1;
                for (int fInd = 0; fInd < keyFields.length; ++fInd) {
                    JDBCCMPFieldBridge2 field = keyFields[fInd];
                    Object fieldValue = field.getPrimaryKeyValue(keys.leftKey);
                    paramInd = field.setArgumentParameters(ps, paramInd, fieldValue);
                }

                keyFields = (JDBCCMPFieldBridge2[]) rightField.getTableKeyFields();
                for (int fInd = 0; fInd < keyFields.length; ++fInd) {
                    JDBCCMPFieldBridge2 field = keyFields[fInd];
                    Object fieldValue = field.getPrimaryKeyValue(keys.rightKey);
                    paramInd = field.setArgumentParameters(ps, paramInd, fieldValue);
                }

                ps.addBatch();
                ++batchCount;
View Full Code Here
TOP

Related Classes of org.jboss.as.cmp.jdbc2.schema.Table$View

  • com.google.collide.client.code.debugging.DebuggerApiTypes.StackTraceItem
  • com.google.collide.client.testing.DebugAttributeSetter
  • com.google.gwt.cell.client.Cell.Context
  • com.google.gwt.dom.client.Element
  • com.google.gwt.dom.client.Node
  • com.google.gwt.safecss.shared.SafeStyles
  • com.google.gwt.safehtml.shared.SafeHtml
  • com.google.gwt.safehtml.shared.SafeHtmlBuilder
  • com.google.gwt.view.client.TreeViewModel
  • elemental.css.CSSStyleDeclaration
    • 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.