本文整理汇总了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
);
示例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
);
示例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
);
示例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);
示例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
);
示例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
);
示例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
);
示例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
);
示例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
);
示例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
);
示例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
);
示例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
);
示例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
);
示例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
);
示例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();