}
public void setCreateBy(String createBy) {
this.createBy = createBy;
}
public String getCreateTime() {
return createTime;
}
public void setCreateTime(String createTime) {
this.createTime = createTime;
}
}
创建操作sysRole的映射器接口RoleMapper,并在其中定义SysRole selectById(Long id)方法。
package mapper;
import entity.SysRole;
public interface RoleMapper {
SysRole selectById(long id);
}
定义RoleMapper.xml,在其中定义标签,注意返回结果的resultMap映射说明。
<?xml version="1.0" encoding="UTF-8"?>select * from sys_role where id=#{id}
编写测试类测试方法调用。
package test;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
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 org.junit.BeforeClass;
import org.junit.Test;
import mapper.RoleMapper;
public class RoleMapperTest {
private static SqlSessionFactory sqlSessionFactory;
/* 完成mybatis配置的加载,创建得到SqlSessionFactory */
@BeforeClass
public static void init() {
try {
Reader reader = Resources.getResourceAsReader(“mybatis-config.xml”);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
reader.close();
} catch (IOException e) {
e.printStackTrace();
}
}
/* 获取SqlSession对象,用于调用方法得到数据 */
@Test
public void testSelectAll() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
RoleMapper roleMapper = sqlSession.getMapper(RoleMapper.class);
最后
由于篇幅原因,就不多做展示了
[外链图片转存中…(img-EeG74mln-1714304420726)]
[外链图片转存中…(img-i81DVCK7-1714304420726)]
[外链图片转存中…(img-6GQ5AnpF-1714304420726)]
[外链图片转存中…(img-qZbXBtOs-1714304420726)]
由于篇幅原因,就不多做展示了