mybatis自增主键的获取
2024-10-22 04:24:53
实体类
package org.example.entity; public class User {
private Integer id;
private String name;
private int age;
private String gender;
private String email; public User(Integer id, String name, int age, String gender, String email) {
this.id = id;
this.name = name;
this.age = age;
this.gender = gender;
this.email = email;
} public Integer getId() {
return id;
} public void setId(Integer id) {
this.id = id;
} public String getName() {
return name;
} public void setName(String name) {
this.name = name;
} public int getAge() {
return age;
} public void setAge(int age) {
this.age = age;
} public String getGender() {
return gender;
} public void setGender(String gender) {
this.gender = gender;
} public String getEmail() {
return email;
} public void setEmail(String email) {
this.email = email;
} @Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", age=" + age +
", gender='" + gender + '\'' +
", email='" + email + '\'' +
'}';
}
}
mapper接口
public void addUser(User user);
mapper.xml
<!--
useGeneratedKeys:表示当前添加功能使用自增的主键
keyProperty:将添加的数据的自增主键为实体类类型的参数的属性赋值
-->
<insert id="addUser" useGeneratedKeys="true" keyProperty="id">
insert into t_user values (null,#{name},#{age},#{gender},#{email});
</insert>
测试代码
@Test
public void addUser(){
SqlSession sqlSession = SqlSessionUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = new User(null,"xiaoming",35,"男","5555@qq.com");
mapper.addUser(user);
System.out.println(user);
sqlSession.close();
}
最新文章
- 配置mac百度云同步盘
- html5 自定义标签取值
- 基础知识《五》---Java多线程的常见陷阱
- V-rep学习笔记:机器人逆运动学数值解法(Damped Least Squares / Levenberg-Marquardt Method)
- Delphi ORD
- jquery对象和javascript对象相互转换
- BZOJ3016: [Usaco2012 Nov]Clumsy Cows
- 64位系统未注册";MSDAORA.1";提供程序
- hibernate--联合主键--annotation
- 跟着刚哥梳理java知识点——变量之间的类型转换(四)
- About the diffrence of wait timed_wait and block in java
- 利用jmeter进行数据库测试
- 【转载】c++类的实例化与拷贝
- VS2015创建类库项目后添加不了WPF资源字典,窗口,用户控件处理办法
- GNU Wget 1.19.1 static built on mingw32
- LeetCode #001# Two Sum(js描述)
- grep 正则问题 this version of PCRE is compiled without UTF support
- hdu--6178(多校
- MyBatis中log4j 和 参数 和 分页和别名 功能
- Oracle AP更新供应商