前言
所有工程在我另外一篇使用xml开发写过,由于mybatis注解开发并不常用,这里只是简单改动一些使用到注解的地方,其他地方和xml一样即可。
需要修改的工程如何
StuDao.xml和StuCardDao.xml可以直接删除
StuDao接口修改如下
package org.example.dao;
import org.apache.ibatis.annotations.One;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.example.pojo.Stu;
import org.example.pojo.StuCard;
public interface StuDao {
@Select("select s.* ,c.balance from stu s,stu_card c where s.cardid = c.cid and\n" +
" s.sid = #{sid}")
@Results(id = "resultMap" , value = {
@Result(id = true,column = "sid" ,property = "sid"),
@Result(column = "sname" ,property = "sname"),
@Result(column = "age",property = "age"),
@Result(column = "course",property = "course"),
@Result(column = "cardid",property = "sc",one = @One(select = "org.example.pojo.StuCard"))
})
Stu findStudentBySid(Integer sid);
}
StuCardDao无需修改因为只用了查询