Examples of PreparedStatementSetter

com.volantis.mcs.accessors.jdbc.PreparedStatementSetter
Callback interface used by the JdbcTemplate class.
This interface sets values on a PreparedStatement provided by the JdbcTemplate class. Implementations are responsible for setting any necessary parameters. SQL with placeholders will already have been supplied.
It's easier to use this interface than PreparedStatementCreator, as the JdbcTemplate will create the prepared statement.
Implementations do not need to concern themselves with SQLExceptions that may be thrown from operations they attempt. The JdbcTemplate class will catch and handle SQLExceptions appropriately.
org.springframework.jdbc.core.PreparedStatementSetter
General callback interface used by the {@link JdbcTemplate} class.
This interface sets values on a {@link java.sql.PreparedStatement} providedby the JdbcTemplate class, for each of a number of updates in a batch using the same SQL. Implementations are responsible for setting any necessary parameters. SQL with placeholders will already have been supplied.
It's easier to use this interface than {@link PreparedStatementCreator}: The JdbcTemplate will create the PreparedStatement, with the callback only being responsible for setting parameter values.
Implementations do not need to concern themselves with SQLExceptions that may be thrown from operations they attempt. The JdbcTemplate class will catch and handle SQLExceptions appropriately. @author Rod Johnson @since March 2, 2003 @see JdbcTemplate#update(String,PreparedStatementSetter) @see JdbcTemplate#query(String,PreparedStatementSetter,ResultSetExtractor)

Examples of org.springframework.jdbc.core.PreparedStatementSetter

        // Make the "acls" map contain all requested objectIdentities
        // (including markers to each parent in the hierarchy)
        String sql = computeRepeatingSql(lookupObjectIdentitiesWhereClause, objectIdentities.size());


        Set<Long> parentsToLookup = jdbcTemplate.query(sql,
            new PreparedStatementSetter() {
                public void setValues(PreparedStatement ps) throws SQLException {
                    int i = 0;
                    for (ObjectIdentity oid : objectIdentities) {
                        // Determine prepared statement values for this iteration
                        String type = oid.getType();

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

                            
                            //No row exists for the counter, insert it
                            if (!selected) {
                                value.initialize(initialValue);
                                
                                jdbcOperations.update(INSERT_QUERY, new PreparedStatementSetter() {
                                    @Override
                                    public void setValues(PreparedStatement ps) throws SQLException {
                                        ps.setString(1, counterName);
                                        value.bind(ps, 2);
                                    }
                                });
                            }
                            
                            //Increment the counter row value
                            final IntegralDataTypeHolder updateValue = value.copy();
                            if (optimizer.applyIncrementSizeToSourceValues()) {
                                updateValue.add(incrementSize);
                            }
                            else {
                                updateValue.increment();
                            }
                            
                            //Update the counter row, if rows returns 0 the update failed due to a race condition, it will be retried
                            rows = jdbcOperations.update(UPDATE_QUERY, new PreparedStatementSetter() {
                                @Override
                                public void setValues(PreparedStatement ps) throws SQLException {
                                    updateValue.bind(ps, 1);
                                    ps.setString(2, counterName);
                                    value.bind(ps, 3);

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

        new SqlParameter[] {
          new SqlParameter("from_id", Types.NUMERIC),
          new SqlParameter("to_id", Types.NUMERIC)  
        });
    reader.setPreparedStatementSetter(
        new PreparedStatementSetter() {
                    @Override
          public void setValues(PreparedStatement ps)
              throws SQLException {
            ps.setInt(1, 1000);
            ps.setInt(2, 1001);

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

    else {
      shortContext = serializedContext;
      longContext = null;
    }


    getJdbcTemplate().update(getQuery(sql), new PreparedStatementSetter() {
      @Override
      public void setValues(PreparedStatement ps) throws SQLException {
        ps.setString(1, shortContext);
        if (longContext != null) {
          lobHandler.getLobCreator().setClobAsString(ps, 2, longContext);

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

    reader.setProcedureName("foo_bar");
    reader.setParameters(new SqlParameter[] {
        new SqlParameter("foo", Types.VARCHAR),
        new SqlParameter("bar", Types.OTHER)});
    reader.setPreparedStatementSetter(
        new PreparedStatementSetter() {
                    @Override
          public void setValues(PreparedStatement ps)
              throws SQLException {
          }
        });

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

                                    try {
                                        failedDatas.clear(); // 先清理
                                        processedDatas.clear();
                                        interceptor.transactionBegin(context, Arrays.asList(data), dbDialect);
                                        JdbcTemplate template = dbDialect.getJdbcTemplate();
                                        int affect = template.update(data.getSql(), new PreparedStatementSetter() {


                                            public void setValues(PreparedStatement ps) throws SQLException {
                                                doPreparedStatement(ps, dbDialect, lobCreator, data);
                                            }
                                        });

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

                                    try {
                                        failedDatas.clear(); // 先清理
                                        processedDatas.clear();
                                        interceptor.transactionBegin(context, Arrays.asList(data), dbDialect);
                                        JdbcTemplate template = dbDialect.getJdbcTemplate();
                                        int affect = template.update(data.getSql(), new PreparedStatementSetter() {


                                            public void setValues(PreparedStatement ps) throws SQLException {
                                                doPreparedStatement(ps, dbDialect, lobCreator, data);
                                            }
                                        });

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

                                    try {
                                        failedDatas.clear(); // 先清理
                                        processedDatas.clear();
                                        interceptor.transactionBegin(context, Arrays.asList(data), dbDialect);
                                        JdbcTemplate template = dbDialect.getJdbcTemplate();
                                        int affect = template.update(data.getSql(), new PreparedStatementSetter() {


                                            public void setValues(PreparedStatement ps) throws SQLException {
                                                doPreparedStatement(ps, dbDialect, lobCreator, data);
                                            }
                                        });

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

      log.debug("sql = [" + sqlInfo.sql + "], args = " + Arrays.asList(sqlInfo.args));
    }
    long beforeUpdateSlaveDBTime = System.currentTimeMillis();


    if(DBType.ORACLE.equals(slave.getDbType())){ //TODO �����и��ٶ������ⶼ��Oracle
    PreparedStatementSetter pss = getPss(context.getMasterLogicTableName(), sqlInfo.args, sqlInfo.argNames);
    if (slave.getJdbcTemplate().update(sqlInfo.sql, pss) != 0) {
      Monitor.add(Monitor.KEY1, Monitor.KEY2_SYNC, Monitor.KEY3_UpdateSlaveRow_dup_all, 0, 1); //�ظ�ͬ������
      return System.currentTimeMillis() - beforeUpdateSlaveDBTime;
    }
    }else{//MYSQL���������ݿ⡣��������Oracle�ֿ���Mysqlʱ����Oracle��meta���÷ֿ��setObject3��������

View Full Code Here

Examples of org.springframework.jdbc.core.PreparedStatementSetter

                return new Movie(resultSet.getInt(1), resultSet.getString(2), resultSet.getString(3));
            }
        });


        for (final Movie movie : movieList) {
            List<Actor> actorList = jdbcTemplate.query(moviesSql, new PreparedStatementSetter() {
                        @Override
                        public void setValues(PreparedStatement preparedStatement) throws SQLException {
                            preparedStatement.setString(1, String.valueOf(movie.getId()));
                        }
                    }, new RowMapper<Actor>() {

View Full Code Here

0 1 2 3 4

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.