本文整理汇总了Java中org.jdbi.v3.sqlobject.statement.SqlUpdate类的典型用法代码示例。如果您正苦于以下问题:Java SqlUpdate类的具体用法?Java SqlUpdate怎么用?Java SqlUpdate使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SqlUpdate类属于org.jdbi.v3.sqlobject.statement包,在下文中一共展示了SqlUpdate类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: phones
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();
示例2: players
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);
示例3: accounts
import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("create table accounts (id int primary key, name varchar(100), balance decimal)")
void createTable();
示例4: update
import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("update accounts set name = :name, balance = :balance where id = :id")
void update(@BindBean Account accounts);
示例5: contacts
import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("create table contacts (id int primary key, name varchar(100))")
void createContactTable();
示例6: posts
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);
示例7: delete
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);
示例8: people
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);
示例9: updatePerson
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);
示例10: updateEmail
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);
示例11: players
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);
示例12: teams
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);
示例13: roster
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);
示例14: cities
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);
示例15: pets
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);