國外素材網(wǎng)站博客可以做seo嗎
Mybatis如何給字段起別名?
假如有一個學(xué)生表,有一個字段是class,你的實體類變量肯定不能用class,那么如何起別名?
通過以下代碼實現(xiàn)
@Result(column = "class",property = "clas")
mapper代碼
public interface StudentDao {@Insert("insert into student(id,name,sex,clas) values(#{name},#{money})")void save(Student student);@Update("upate student set name=#{name},sex=#{sex} where id=#{id}")void update(Student student);@Delete("delete from student where id=#{id}")void delete(String id);@Select("select * from student where id=#{id}")Student findById(String id);@Select("select * from student")@Result(column = "class",property = "clas")List<Student> findAll();
}
實體類
public class Student {public String getId() {return id;}public void setId(String id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}public String getClas() {return clas;}public void setClas(String clas) {this.clas = clas;}@Overridepublic String toString() {return "Student{" +"id='" + id + '\'' +", name='" + name + '\'' +", sex='" + sex + '\'' +", clas='" + clas + '\'' +'}';}private String id;private String name;private String sex;private String clas;
}