Examples of java.sql.PreparedStatement.addBatch()

java.sql.PreparedStatement.addBatch()
Add a set of parameters to the PreparedStatement's command batch. @throws SQLException if a database error happens

        PreparedStatement ps = prepareStatement("INSERT INTO T2 VALUES(?,?,?)");
        for (int i=0; i<1000; i++) {
          ps.setInt(1, i%2);
            ps.setString(2, "Tuple " +i);
            ps.setString(3, "any value");
            ps.addBatch();
        }
        ps.executeBatch();


    s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");

View Full Code Here

            prep.close();
            return false;
          }
          i++;
        }
        prep.addBatch();
        conn.setAutoCommit(false);
        prep.executeBatch();
        conn.commit();
        prep.close();
        prep = null;

View Full Code Here

      dataStmt.setInt(1, relLoc.getBlockX());
      dataStmt.setInt(2, relLoc.getBlockY());
      dataStmt.setInt(3, relLoc.getBlockZ());
      dataStmt.setString(4, block.getType().toString());
      dataStmt.setShort(5, block.getData().toItemStack().getDurability());
      dataStmt.addBatch();
      if (++changed % batchSize == 0) {
        dataStmt.executeBatch();
      }
    }
    dataStmt.executeBatch(); // insert remaining records

View Full Code Here

                + "\n" + ((CommandBlock) block.getState()).getCommand());
          } else if (state instanceof CreatureSpawner) {
            dataStmt.setString(6, ((CreatureSpawner) block.getState()).getSpawnedType().toString());
          }
          
          dataStmt.addBatch();
          
          if (++changed % batchSize == 0) {
            dataStmt.executeBatch();
            if ((System.currentTimeMillis() - startTime) >= 5000L) {
              String seconds = new DecimalFormat("#0.00").format((double) (System.currentTimeMillis() - startTime) / 1000.0D);

View Full Code Here

      dataStmt.setInt(1, relLoc.getBlockX());
      dataStmt.setInt(2, relLoc.getBlockY());
      dataStmt.setInt(3, relLoc.getBlockZ());
      dataStmt.setString(4, block.getType().toString());
      dataStmt.setShort(5, block.getData().toItemStack().getDurability());
      dataStmt.addBatch();
      if (++changed % batchSize == 0) {
        dataStmt.executeBatch();
      }
    }
    dataStmt.executeBatch(); // insert remaining records

View Full Code Here

      conn.setAutoCommit(false);
      for (KillsDeathsRecord kdr : records) {
        stmt.setString(1, kdr.getPlayer().getName());
        stmt.setInt(2, kdr.getKills());
        stmt.setInt(3, kdr.getDeaths());
        stmt.addBatch();
      }
      stmt.executeBatch();
      conn.commit();
      stmt.close();
      final String deleteClause =

View Full Code Here

      // test batch inserts
      update = "insert into prepstmt_test values (?,?)";
      prep = getPreparedStatement(update);
      prep.setString(1, "danny");
      prep.setInt(2, 2);
      prep.addBatch();
      prep.setString(1, "denver");
      prep.setInt(2, 3);
      prep.addBatch();
      prep.setString(1, "aspen");
      prep.setInt(2, 4);

View Full Code Here

      prep.setString(1, "danny");
      prep.setInt(2, 2);
      prep.addBatch();
      prep.setString(1, "denver");
      prep.setInt(2, 3);
      prep.addBatch();
      prep.setString(1, "aspen");
      prep.setInt(2, 4);
      prep.addBatch();
      prep.executeBatch();
      assertTrue(super.getLastLogEntry().contains(update));

View Full Code Here

      prep.setString(1, "denver");
      prep.setInt(2, 3);
      prep.addBatch();
      prep.setString(1, "aspen");
      prep.setInt(2, 4);
      prep.addBatch();
      prep.executeBatch();
      assertTrue(super.getLastLogEntry().contains(update));
      assertTrue(super.getLastLogEntry().contains("aspen"));
      assertTrue(super.getLastLogEntry().contains("4"));
      prep.close();

View Full Code Here

                            queryBuilder.getParameterValues(query),
                            query instanceof InsertBatchQuery);
                }


                queryBuilder.bindParameters(statement, query);
                statement.addBatch();
            }


            // execute the whole batch
            int[] results = statement.executeBatch();
            delegate.nextBatchCount(query, results);

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.