本示例的场景:mapper中的resultType是类名,但数据库表的列名和类的属性名不完全匹配。例如,数据库中表的列名是user_name,而java类中属性名称是userName。
数据库user表的结构:
mapper文件:
UserMapper接口:
User类:
package com.thb.model;
public class User {
private int id;
private String userName;
private String homeTown;
public int getId() {
return this.id;
}
public void setId(int id) {
this.id = id;
}
public String getUserName() {
return this.userName;
}
public void setUserName(String name) {
this.userName = name;
}
public String getHomeTown () {
return this.homeTown;
}
public void setHomeTown(String hometown) {
this.homeTown = hometown;
}
}
调用代码片段:
运行输出: