import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("create table phones ("
    + "id int primary key, "
    + "contactId int, "
    + "foreign key (contactId) references contacts(id) on delete cascade, "
    + "type varchar(20), "
    + "phone varchar(20))")
void createPhoneTable();
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@GetGeneratedKeys
@SqlUpdate("insert into players(first_name, last_name, birth_date, weight, height)"
        + " values (:first_name, :last_name, :birth_date, :weight, :height)")
Long createPlayer(@Bind("first_name") String firstName,
                  @Bind("last_name") String lastName,
                  @Bind("birth_date") Date birthDate,
                  @Bind("height") int height, @Bind("weight") int weight);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("create table accounts (id int primary key, name varchar(100), balance decimal)")
void createTable();
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("update accounts set name = :name, balance = :balance where id = :id")
void update(@BindBean Account accounts);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("create table contacts (id int primary key, name varchar(100))")
void createContactTable();
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("INSERT INTO posts(content, user_id) VALUES (:p.content, :p.userId)")
@Counter(table = "users", column = "posts_count", binding = "p.userId")
void insert(@BindBean("p") Post post);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("DELETE FROM posts WHERE id = :p.id")
@Counter(table = "users", column = "posts_count", binding = "p.userId", decrementing = true)
void delete(@BindBean("p") Post post);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@GetGeneratedKeys
@SqlUpdate("INSERT INTO people(id, firstName, lastName, email, created, modified) VALUES (:p.id, :p.firstName, :p.lastName, :p.email, :now, :now)")
@Timestamped
int insert(@BindBean("p") @Valid Person person);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("UPDATE people SET firstName = :p.firstName, lastName = :p.lastName, email = :p.email, modified= :now WHERE id = :p.id")
@Timestamped
int updatePerson(@BindBean("p") Person person);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("UPDATE people SET email=:p.email WHERE id=:p.id")
void updateEmail(@BindBean("p") @Valid(groups = Person.EmailUpdate.class) Person person);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@GetGeneratedKeys
@SqlUpdate("insert into players(first_name, last_name, birth_date, weight, height) values" +
        "(:first_name, :last_name, :birth_date, :weight, :height)")
Long createPlayer(@Bind("first_name") String firstName, @Bind("last_name") String lastName,
                  @Bind("birth_date") Date birthDate, @Bind("height") int height,
                  @Bind("weight") int weight);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("insert into teams(name, division) values (:name, :division)")
@GetGeneratedKeys
long createTeam(@Bind("name") String name, @Bind("division") Division division);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("insert into roster(team_id, player_id) values (:team_id, :player_id)")
void addPlayerToTeam(@Bind("team_id") long teamId, @Bind("player_id") long playerId);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("insert into cities(country_code, region_code, name, location) " +
        "values (:country_code, :region_code, :name, :location)")
@GetGeneratedKeys
long addCity(@Bind("country_code") String countryCode, @Bind("region_code") String regionCode,
             @Bind("name") String name, @Bind("location") double[] location);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
/**
 * Insert a pet and returns the generated PK.
 *
 * @param pet Pet to insert.
 * @return Primary key.
 */
@SqlUpdate("insert into pets(name) values(:name)")
@GetGeneratedKeys
long insert(@BindBean Pet pet);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
/**
 * Update a pet and returns true if the pets was updated.
 *
 * @param pet Pet to update.
 * @return True if the pet was updated.
 */
@SqlUpdate("update pets set name=:name where id=:id")
boolean update(@BindBean Pet pet);
 

import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
/**
 * Delete a pet by ID.
 *
 * @param id Pet ID.
 * @return True if the pet was deleted.
 */
@SqlUpdate("delete pets where id=:id")
boolean delete(long id);