实体类

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();
}

最新文章

  1. 配置mac百度云同步盘
  2. html5 自定义标签取值
  3. 基础知识《五》---Java多线程的常见陷阱
  4. V-rep学习笔记:机器人逆运动学数值解法(Damped Least Squares / Levenberg-Marquardt Method)
  5. Delphi ORD
  6. jquery对象和javascript对象相互转换
  7. BZOJ3016: [Usaco2012 Nov]Clumsy Cows
  8. 64位系统未注册&quot;MSDAORA.1&quot;提供程序
  9. hibernate--联合主键--annotation
  10. 跟着刚哥梳理java知识点——变量之间的类型转换(四)
  11. About the diffrence of wait timed_wait and block in java
  12. 利用jmeter进行数据库测试
  13. 【转载】c++类的实例化与拷贝
  14. VS2015创建类库项目后添加不了WPF资源字典,窗口,用户控件处理办法
  15. GNU Wget 1.19.1 static built on mingw32
  16. LeetCode #001# Two Sum(js描述)
  17. grep 正则问题 this version of PCRE is compiled without UTF support
  18. hdu--6178(多校
  19. MyBatis中log4j 和 参数 和 分页和别名 功能
  20. Oracle AP更新供应商

热门文章

  1. Django中遇到的问题
  2. vue页面添加锚点后 点击不改变URL
  3. VUE学习-过滤器
  4. day01-java流程
  5. Oracle RAC单节点启停
  6. 狂神--Docker
  7. vue项目去掉网页滚动条
  8. JavaSE——String
  9. (app笔记)Appium如何开启、配置、启用
  10. [洛谷/题目] P1562 还是N皇后