Examples of JDBCCMPFieldBridge2

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
      // 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)
      {
View Full Code Here

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

505
506
507
508
509
510
511
512
513
514
515
516
517
         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

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

649
650
651
652
653
654
655
656
657
658
659
660
661
            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

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
            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

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

783
784
785
786
787
788
789
790
791
792
793
794
795
            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

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

1712
1713
1714
1715
1716
1717
1718
1719
1720
1721
1722
1723
1724
            paramInd = 1;
            JDBCCMPFieldBridge2[] tableFields = (JDBCCMPFieldBridge2[]) entity.getTableFields();
            for(int fInd = 0; fInd < tableFields.length; ++fInd)
            {
               JDBCCMPFieldBridge2 field = tableFields[fInd];
               Object fieldValue = fields[field.getRowIndex()];
               paramInd = field.setArgumentParameters(insertPs, paramInd, fieldValue);
            }

            insertPs.executeUpdate();

            flushStatus();
View Full Code Here

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

1737
1738
1739
1740
1741
1742
1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
         }
      }

      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

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
            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

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
            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

Examples of org.jboss.ejb.plugins.cmp.jdbc2.bridge.JDBCCMPFieldBridge2

285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
      // 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)
      {
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.