Java SqlUpdate類代碼示例

本文整理匯總了Java中org.skife.jdbi.v2.sqlobject.SqlUpdate類的典型用法代碼示例。如果您正苦於以下問題：Java SqlUpdate類的具體用法？Java SqlUpdate怎麽用？Java SqlUpdate使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。

SqlUpdate類屬於org.skife.jdbi.v2.sqlobject包，在下文中一共展示了SqlUpdate類的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: moves

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate("INSERT INTO moves (gameId, pigsLeft, birdsLeft, birdsType, fromState, x, y, targetObjectType, aboveCount, leftCount, rightCount, belowCount, distanceToPig, trajectoryType, toState, reward, randomAction) VALUES (:gameId, :pigsLeft, :birdsLeft, :birdsType, :fromState, :x, :y, :targetObjectType, :aboveCount, :leftCount, :rightCount, :belowCount, :distanceToPig, :trajectoryType, :toState, :reward, :randAction);")
void save(
        @Bind("gameId") int gameId,
        @Bind("pigsLeft") int pigsLeft,
        @Bind("birdsLeft") int birdsLeft,
        @Bind("birdsType") String birdsType,
        @Bind("fromState") int fromState,
        @Bind("x") int x,
        @Bind("y") int y,
        @Bind("targetObjectType") String targetObjectType,
        @Bind("aboveCount") int aboveCount,
        @Bind("leftCount") int leftCount,
        @Bind("rightCount") int rightCount,
        @Bind("belowCount") int belowCount,
        @Bind("distanceToPig") double distanceToPig,
        @Bind("trajectoryType") String trajectoryType,
        @Bind("toState") int toState,
        @Bind("reward") double reward,
        @Bind("randAction") boolean randomAction
);

開發者ID:jgonsior，項目名稱:AngryProgrammers，代碼行數:21，代碼來源:MovesDAO.java

示例2: updateQValue

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate("UPDATE q_values SET q_value=:q_value " +
        "WHERE stateId=:stateId AND x=:x AND y=:y AND targetObjectType=:targetObjectType AND aboveCount=:aboveCount " +
        "AND leftCount=:leftCount AND rightCount=:rightCount AND belowCount=:belowCount AND distanceToPig=:distanceToPig AND trajectorytype=:trajectoryType AND pigsLeft=:pigsLeft;")
void updateQValue(
        @Bind("q_value") double qValue,
        @Bind("stateId") int stateId,
        @Bind("x") int x,
        @Bind("y") int y,
        @Bind("targetObjectType") String targetObjectType,
        @Bind("aboveCount") int aboveCount,
        @Bind("leftCount") int leftCount,
        @Bind("rightCount") int rightCount,
        @Bind("belowCount") int belowCount,
        @Bind("distanceToPig") double distanceToPig,
        @Bind("trajectoryType") String trajectoryType,
        @Bind("pigsLeft") int pigsLeft
);

開發者ID:jgonsior，項目名稱:AngryProgrammers，代碼行數:18，代碼來源:QValuesDAO.java

示例3: q_values

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate("INSERT INTO q_values(" +
        "q_value, stateId, x, y, targetObjectType, aboveCount, leftCount, rightCount, belowCount, distanceToPig, trajectoryType, targetObject, pigsLeft" +
        ") VALUES (" +
        ":q_value, :stateId, :x, :y, :targetObjectType, :aboveCount, :leftCount, :rightCount, :belowCount, :distanceToPig, :trajectoryType, :targetObject, :pigsLeft" +
        ")")
void insertNewAction(
        @Bind("q_value") double qValue,
        @Bind("stateId") int stateId,
        @Bind("x") int x,
        @Bind("y") int y,
        @Bind("targetObjectType") String targetObjectType,
        @Bind("aboveCount") int aboveCount,
        @Bind("leftCount") int leftCount,
        @Bind("rightCount") int rightCount,
        @Bind("belowCount") int belowCount,
        @Bind("distanceToPig") double distanceToPig,
        @Bind("trajectoryType") String trajectoryType,
        @Bind("targetObject") String targetObject,
        @Bind("pigsLeft") int pigsLeft
);

開發者ID:jgonsior，項目名稱:AngryProgrammers，代碼行數:21，代碼來源:QValuesDAO.java

示例4: resuming_tasks

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate("insert into resuming_tasks (attempt_id, source_task_id, full_name, updated_at, local_config, export_config, subtask_config, export_params, store_params, report, error, reset_store_params)" +
        " values (:attemptId, :sourceTaskId, :fullName, :updatedAt, :localConfig, :exportConfig, :subtaskConfig, :exportParams, :storeParams, :report, :error, :reset_store_params)")
@GetGeneratedKeys
long insertResumingTask(
        @Bind("attemptId") long attemptId,
        @Bind("sourceTaskId") long sourceTaskId,
        @Bind("fullName") String fullName,
        @Bind("updatedAt") java.sql.Timestamp updatedAt,
        @Bind("localConfig") Config localConfig,
        @Bind("exportConfig") Config exportConfig,
        @Bind("subtaskConfig") Config subtaskConfig,
        @Bind("exportParams") Config exportParams,
        @Bind("reset_store_params") String resetStoreParams,
        @Bind("storeParams") Config storeParams,
        @Bind("report") Config report,
        @Bind("error") Config error);

開發者ID:treasure-data，項目名稱:digdag，代碼行數:17，代碼來源:DatabaseSessionStoreManager.java

示例5: updateResponseDeadline

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate(
    "UPDATE claim SET response_deadline = :responseDeadline "
        + "WHERE id = :claimId"
)
void updateResponseDeadline(
    @Bind("claimId") Long claimId,
    @Bind("responseDeadline") LocalDate responseDeadline
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:9，代碼來源:TestingSupportRepository.java

示例6: updateSettlement

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate(
    "UPDATE claim "
        + " SET settlement = :settlement::JSONB "
        + " WHERE id = :claimId"
)
void updateSettlement(
    @Bind("claimId") Long claimId,
    @Bind("settlement") String settlement
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:10，代碼來源:OffersRepository.java

示例7: acceptOffer

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate(
    "UPDATE claim "
        + " SET "
        + " settlement = :settlement::JSONB, settlement_reached_at = :settlementReachedAt "
        + " WHERE id = :claimId"
)
void acceptOffer(
    @Bind("claimId") Long claimId,
    @Bind("settlement") String settlement,
    @Bind("settlementReachedAt") LocalDateTime settlementReachedAt
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:12，代碼來源:OffersRepository.java

示例8: claim

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@GetGeneratedKeys
@SqlUpdate("INSERT INTO claim ( "
    + "submitter_id, "
    + "claim, "
    + "issued_on, "
    + "response_deadline, "
    + "external_id, "
    + "submitter_email, "
    + "reference_number"
    + ") "
    + "VALUES ("
    + ":submitterId, "
    + ":claim::JSONB, "
    + ":issuedOn, "
    + ":responseDeadline, "
    + ":externalId, "
    + ":submitterEmail, "
    + "next_legal_rep_reference_number()"
    + ")")
Long saveRepresented(
    @Bind("claim") String claim,
    @Bind("submitterId") String submitterId,
    @Bind("issuedOn") LocalDate issuedOn,
    @Bind("responseDeadline") LocalDate responseDeadline,
    @Bind("externalId") String externalId,
    @Bind("submitterEmail") String submitterEmail
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:28，代碼來源:ClaimRepository.java

示例9: linkLetterHolder

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate(
    "UPDATE claim SET letter_holder_id = :letterHolderId WHERE id = :claimId"
)
Integer linkLetterHolder(
    @Bind("claimId") Long claimId,
    @Bind("letterHolderId") String letterHolderId
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:8，代碼來源:ClaimRepository.java

示例10: linkSealedClaimDocument

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate(
    "UPDATE claim SET sealed_claim_document_management_self_path = :documentSelfPath"
        + " WHERE id = :claimId"
)
Integer linkSealedClaimDocument(
    @Bind("claimId") Long claimId,
    @Bind("documentSelfPath") String documentSelfPath
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:9，代碼來源:ClaimRepository.java

示例11: linkDefendant

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate(
    "UPDATE claim SET defendant_id = :defendantId WHERE id = :claimId"
)
Integer linkDefendant(
    @Bind("claimId") Long claimId,
    @Bind("defendantId") String defendantId
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:8，代碼來源:ClaimRepository.java

示例12: requestMoreTime

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate(
    "UPDATE claim SET more_time_requested = TRUE, response_deadline = :responseDeadline "
        + "WHERE id = :claimId AND more_time_requested = FALSE"
)
void requestMoreTime(
    @Bind("claimId") Long claimId,
    @Bind("responseDeadline") LocalDate responseDeadline
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:9，代碼來源:ClaimRepository.java

示例13: saveDefendantResponse

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate(
    "UPDATE CLAIM SET "
        + "response = :response::JSONB, "
        + "defendant_id = :defendantId, "
        + "defendant_email = :defendantEmail, "
        + "responded_at = now() AT TIME ZONE 'utc' "
        + "WHERE id = :claimId"
)
void saveDefendantResponse(
    @Bind("claimId") Long claimId,
    @Bind("defendantId") String defendantId,
    @Bind("defendantEmail") String defendantEmail,
    @Bind("response") String response
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:15，代碼來源:ClaimRepository.java

示例14: saveCountyCourtJudgment

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate("UPDATE claim SET "
    + " county_court_judgment = :countyCourtJudgmentData::JSONB,"
    + " county_court_judgment_requested_at = now() at time zone 'utc'"
    + "WHERE"
    + " id = :claimId")
void saveCountyCourtJudgment(
    @Bind("claimId") long claimId,
    @Bind("countyCourtJudgmentData") String countyCourtJudgmentData
);

開發者ID:hmcts，項目名稱:cmc-claim-store，代碼行數:10，代碼來源:ClaimRepository.java

示例15: descriptor

import org.skife.jdbi.v2.sqlobject.SqlUpdate; //導入依賴的package包/類
@SqlUpdate("create table descriptor ("
        + "url varchar(100) unique, "
        + "descriptor clob, "
        + "type varchar(100), "
        + "descriptor_path varchar(100), "
        + "tool_id varchar(100), "
        + "version varchar(100), "
        + "foreign key(tool_id, version) references toolversion(tool_id, version) " + ")")
void createToolDescriptorTable();

開發者ID:dockstore，項目名稱:write_api_service，代碼行數:10，代碼來源:ToolDescriptorDAO.java

注：本文中的org.skife.jdbi.v2.sqlobject.SqlUpdate類示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。