本文整理汇总了Java中org.jdbi.v3.sqlobject.statement.SqlUpdate类的典型用法代码示例。如果您正苦于以下问题:Java SqlUpdate类的具体用法?Java SqlUpdate怎么用?Java SqlUpdate使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SqlUpdate类属于org.jdbi.v3.sqlobject.statement包,在下文中一共展示了SqlUpdate类的17个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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();
开发者ID:qualidafial,项目名称:jdbi-examples,代码行数:8,代码来源:Example06Joins.java
示例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);
开发者ID:arteam,项目名称:jdit-examples,代码行数:8,代码来源:PlayerDao.java
示例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();
开发者ID:qualidafial,项目名称:jdbi-examples,代码行数:3,代码来源:Example05SqlObjectApi.java
示例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);
开发者ID:qualidafial,项目名称:jdbi-examples,代码行数:3,代码来源:Example05SqlObjectApi.java
示例5: contacts
import org.jdbi.v3.sqlobject.statement.SqlUpdate; //导入依赖的package包/类
@SqlUpdate("create table contacts (id int primary key, name varchar(100))")
void createContactTable();
开发者ID:qualidafial,项目名称:jdbi-examples,代码行数:3,代码来源:Example06Joins.java
示例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);
开发者ID:zikani03,项目名称:jdbi-utils,代码行数:4,代码来源:TestCounter.java
示例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);
开发者ID:zikani03,项目名称:jdbi-utils,代码行数:4,代码来源:TestCounter.java
示例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);
开发者ID:zikani03,项目名称:jdbi-utils,代码行数:5,代码来源:PersonDAO.java
示例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);
开发者ID:zikani03,项目名称:jdbi-utils,代码行数:4,代码来源:PersonDAO.java
示例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);
开发者ID:zikani03,项目名称:jdbi-utils,代码行数:3,代码来源:PersonDAO.java
示例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);
开发者ID:arteam,项目名称:jdit,代码行数:7,代码来源:PlayerSqlObject.java
示例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);
开发者ID:arteam,项目名称:jdit,代码行数:4,代码来源:TeamSqlObject.java
示例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);
开发者ID:arteam,项目名称:jdit,代码行数:3,代码来源:TeamSqlObject.java
示例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);
开发者ID:arteam,项目名称:jdit-examples,代码行数:6,代码来源:CityDao.java
示例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);
开发者ID:jooby-project,项目名称:jdbi-starter,代码行数:10,代码来源:PetRepository.java
示例16: update
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);
开发者ID:jooby-project,项目名称:jdbi-starter,代码行数:9,代码来源:PetRepository.java
示例17: delete
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);
开发者ID:jooby-project,项目名称:jdbi-starter,代码行数:9,代码来源:PetRepository.java
注:本文中的org.jdbi.v3.sqlobject.statement.SqlUpdate类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论