当数据库字段名与实体类属性不一致时需要使用resultMap来绑定数据库字段名和实体类中对应的属性名
项目分布
1.创建Student实体类
package com.it.domain;
public class Student {
private int sss ;
private String sName;
private String sSex;
private int sAge;
private String sDept;
public Student() {
}
public Student(int sNo, String sName, String sSex, int sAge, String sDept) {
this.sss = sNo;
this.sName = sName;
this.sSex = sSex;
this.sAge = sAge;
this.sDept = sDept;
}
public int getSss() {
return sss;
}
public void setSss(int sss) {
this.sss = sss;
}
public String getsName() {
return sName;
}
public void setsName(String sName) {
this.sName = sName;
}
public String getsSex() {
return sSex;
}
public void setsSex(String sSex) {
this.sSex = sSex;
}
public int getsAge() {
return sAge;
}
public void setsAge(int sAge) {
this.sAge = sAge;
}
public String getsDept() {
return sDept;
}
public void setsDept(String sDept) {
this.sDept = sDept;
}
@Override
public String toString() {
return "Student{" +
"sNo=" + sss +
", sName='" + sName + ''' +
", sSex='" + sSex + ''' +
", sAge=" + sAge +
", sDept='" + sDept + ''' +
'}';
}
}
2.创建StudentDao接口类
package com.it.dao;
import com.it.domain.Student;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface StudentDao {
//使用 resultMap定义映射关系
List selectStudents(Integer sage);
}
3.创建StudentDao接口类的映射文件StudentDao.xml
在这里使用resultMap标签来绑定数据库中的字段名和实体中的属性
4.创建MyBatis.xml文件
5.创建MyBatisUntils工具类
package com.it.untils;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
public class MyBatisUntils {
private static SqlSessionFactory factory = null;
static {
String config="mybatis.xml";
InputStream resourceAsStream=null;
try {
resourceAsStream = Resources.getResourceAsStream(config);
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
factory = builder.build(resourceAsStream);
} catch (IOException e) {
e.printStackTrace();
}
}
//获取SqlSession的方法
public static SqlSession getSqlSession(){
SqlSession sqlSession=null;
if (factory!=null){
sqlSession = factory.openSession(true);
}
return sqlSession;
}
}
6.创建测试类
package com.it;
import com.it.dao.StudentDao;
import com.it.domain.Student;
import com.it.untils.MyBatisUntils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.List;
public class AppTest
{
@Test
public void selectStudents(){
SqlSession sqlSession = MyBatisUntils.getSqlSession();
//getMapper能获取dao接口的实现类
StudentDao mapper = sqlSession.getMapper(StudentDao.class);
//调用mapper,执行数据库操作。
List studentList = mapper.selectStudents("信电",20);
for (Student stu:studentList){
System.out.println(stu);
}
}
}
执行结果,如果数据库字段名和实体类中的属性名不一样,可以通过resultMap文件的绑定可以实现正常的查询



