<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.intellif.mozping.dao.MemberMapper"><insertid="addMember"parameterType="com.intellif.mozping.entity.Member">
insert into tb_member(id,name,skills)values(#{id},#{name},#{skills})
</insert><selectid="findMemberById"resultType="com.intellif.mozping.entity.Member"parameterType="java.lang.Integer">
SELECT * FROM tb_member where id = #{id};
</select></mapper>
4.5 测试
publicvoidadd(){
SqlSession sqlSession = SqlSessionFactoryUtil.getSqlSessionFactoryInstaceByConfig(CONFIG_FILE_PATH).openSession();
ArrayList<String> arr =newArrayList<>();
arr.add("computer");
arr.add("Java");
arr.add("Python");
Member member =newMember();
member.setId(1);
member.setName("No 1");
member.setSkills(arr);
MemberMapper mapper = sqlSession.getMapper(MemberMapper.class);int rowAffected = mapper.addMember(member);
System.out.println("The rows be affected :"+ rowAffected);//显示提交事务
sqlSession.commit();
sqlSession.close();}@Testpublicvoidquery(){
SqlSession sqlSession = SqlSessionFactoryUtil.getSqlSessionFactoryInstaceByConfig(CONFIG_FILE_PATH).openSession();
MemberMapper mapper = sqlSession.getMapper(MemberMapper.class);
List<Member> members = mapper.findMemberById(1);for(Member m : members){
System.out.println(m);}}
打印:我们看到可以按照我们的需要将字符串转换为List
新增:
:22:12.801[main] DEBUG c.i.m.dao.MemberMapper.addMember -==> Preparing: insert into tb_member(id,name,skills)values(?,?,?)
setNonNullParameter#setNonNullParameter execute...null
16:22:12.827[main] DEBUG c.i.m.dao.MemberMapper.addMember -==> Parameters:1(Integer), No 1(String), computer;Java;Python;(String)16:22:12.830[main] DEBUG c.i.m.dao.MemberMapper.addMember -<== Updates:1
The rows be affected :1
查询:
16:22:35.344[main] DEBUG c.i.m.d.MemberMapper.findMemberById -==> Preparing: SELECT * FROM tb_member where id =?;16:22:35.373[main] DEBUG c.i.m.d.MemberMapper.findMemberById -==> Parameters:1(Integer)16:22:35.388[main] DEBUG c.i.m.d.MemberMapper.findMemberById -<== Total:1Member(id=1, name=No 1, skills=[computer, Java, Python])
<!-- 比如如下配置:--><mappers><!--直接映射到相应的mapper文件 --><!--<mapper resource="mybatis/mapper/MemberMapper.xml"/>--></mappers>
//执行代码就会报错:
MemberMapper mapper = sqlSession.getMapper(MemberMapper.class);
org.apache.ibatis.binding.BindingException: Type interface com.intellif.mozping.dao.MemberMapper is not known to the MapperRegistry.