Examples of org.springframework.jdbc.core.JdbcOperations.update()

Class org.springframework.jdbc.core.JdbcOperations

Examples of org.springframework.jdbc.core.JdbcOperations.update()

org.springframework.jdbc.core.JdbcOperations.update()
Issue a single SQL update. @param sql static SQL to execute @return the number of rows affected @throws DataAccessException if there is any problem.

    exchange.setUniqueId(UniqueId.of("DbExg", "101", "0"));
    exchange.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("A", "B"), ExternalId.of("C", "D"), ExternalId.of("E", "F")));
    exchange.setName("TestExchange101");
    exchange.setTimeZone(ZoneId.of("Europe/London"));
    byte[] bytes = fudgeContext.toByteArray(fudgeContext.toFudgeMsg(exchange).getMessage());
    template.update("INSERT INTO exg_exchange VALUES (?,?,?,?,?, ?,?,?,?)",
        101, 101, toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP, toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP,
        "TestExchange101", "Europe/London", new SqlParameterValue(Types.BLOB, new SqlLobValue(bytes, lobHandler)));
    exchange.setUniqueId(UniqueId.of("DbExg", "102", "0"));
    exchange.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("A", "B"), ExternalId.of("C", "D"), ExternalId.of("G", "H")));
    exchange.setName("TestExchange102");

View Full Code Here

    exchange.setUniqueId(UniqueId.of("DbExg", "102", "0"));
    exchange.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("A", "B"), ExternalId.of("C", "D"), ExternalId.of("G", "H")));
    exchange.setName("TestExchange102");
    exchange.setTimeZone(ZoneId.of("Europe/Paris"));
    bytes = fudgeContext.toByteArray(fudgeContext.toFudgeMsg(exchange).getMessage());
    template.update("INSERT INTO exg_exchange VALUES (?,?,?,?,?, ?,?,?,?)",
        102, 102, toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP, toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP,
        "TestExchange102", "Europe/Paris", new SqlParameterValue(Types.BLOB, new SqlLobValue(bytes, lobHandler)));
    exchange.setUniqueId(UniqueId.of("DbExg", "201", "0"));
    exchange.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("C", "D"), ExternalId.of("E", "F")));
    exchange.setName("TestExchange201");

View Full Code Here

    exchange.setUniqueId(UniqueId.of("DbExg", "201", "0"));
    exchange.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("C", "D"), ExternalId.of("E", "F")));
    exchange.setName("TestExchange201");
    exchange.setTimeZone(ZoneId.of("Asia/Tokyo"));
    bytes = fudgeContext.toByteArray(fudgeContext.toFudgeMsg(exchange).getMessage());
    template.update("INSERT INTO exg_exchange VALUES (?,?,?,?,?, ?,?,?,?)",
        201, 201, toSqlTimestamp(_version1Instant), toSqlTimestamp(_version2Instant), toSqlTimestamp(_version1Instant), MAX_SQL_TIMESTAMP,
        "TestExchange201", "Asia/Tokyo", new SqlParameterValue(Types.BLOB, new SqlLobValue(bytes, lobHandler)));
    exchange.setUniqueId(UniqueId.of("DbExg", "201", "1"));
    exchange.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("C", "D"), ExternalId.of("E", "F")));
    exchange.setName("TestExchange202");

View Full Code Here

    exchange.setUniqueId(UniqueId.of("DbExg", "201", "1"));
    exchange.setExternalIdBundle(ExternalIdBundle.of(ExternalId.of("C", "D"), ExternalId.of("E", "F")));
    exchange.setName("TestExchange202");
    exchange.setTimeZone(ZoneId.of("Asia/Tokyo"));
    bytes = fudgeContext.toByteArray(fudgeContext.toFudgeMsg(exchange).getMessage());
    template.update("INSERT INTO exg_exchange VALUES (?,?,?,?,?, ?,?,?,?)",
        202, 201, toSqlTimestamp(_version2Instant), MAX_SQL_TIMESTAMP, toSqlTimestamp(_version2Instant), MAX_SQL_TIMESTAMP,
        "TestExchange202", "Asia/Tokyo", new SqlParameterValue(Types.BLOB, new SqlLobValue(bytes, lobHandler)));
    _totalExchanges = 3;
//  id bigint not null,
//  key_scheme varchar(255) not null,

View Full Code Here

        "TestExchange202", "Asia/Tokyo", new SqlParameterValue(Types.BLOB, new SqlLobValue(bytes, lobHandler)));
    _totalExchanges = 3;
//  id bigint not null,
//  key_scheme varchar(255) not null,
//  key_value varchar(255) not null,
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        1, "A", "B");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        2, "C", "D");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        3, "E", "F");

View Full Code Here

//  id bigint not null,
//  key_scheme varchar(255) not null,
//  key_value varchar(255) not null,
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        1, "A", "B");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        2, "C", "D");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        3, "E", "F");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        4, "G", "H");

View Full Code Here

//  key_value varchar(255) not null,
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        1, "A", "B");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        2, "C", "D");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        3, "E", "F");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        4, "G", "H");
//  exchange_id bigint not null,
//  idkey_id bigint not null,

View Full Code Here

        1, "A", "B");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        2, "C", "D");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        3, "E", "F");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        4, "G", "H");
//  exchange_id bigint not null,
//  idkey_id bigint not null,
    template.update("INSERT INTO exg_exchange2idkey VALUES (?,?)",
        101, 1);

View Full Code Here

        3, "E", "F");
    template.update("INSERT INTO exg_idkey VALUES (?,?,?)",
        4, "G", "H");
//  exchange_id bigint not null,
//  idkey_id bigint not null,
    template.update("INSERT INTO exg_exchange2idkey VALUES (?,?)",
        101, 1);
    template.update("INSERT INTO exg_exchange2idkey VALUES (?,?)",
        101, 2);
    template.update("INSERT INTO exg_exchange2idkey VALUES (?,?)",
        101, 3);

View Full Code Here

        4, "G", "H");
//  exchange_id bigint not null,
//  idkey_id bigint not null,
    template.update("INSERT INTO exg_exchange2idkey VALUES (?,?)",
        101, 1);
    template.update("INSERT INTO exg_exchange2idkey VALUES (?,?)",
        101, 2);
    template.update("INSERT INTO exg_exchange2idkey VALUES (?,?)",
        101, 3);
    template.update("INSERT INTO exg_exchange2idkey VALUES (?,?)",
        102, 1);

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.