package com.itheima.one_to_one;
import com.itheima.bean.Card;
import com.itheima.bean.Person;
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 java.util.List;
public interface CardMapper {
//查询全部
// @Select("SELECT * FROM card")
// @Results({
// @Result(column = "id",property = "id"),
// @Result(column = "number",property = "number"),
// @Result(
// property = "p", // 被包含对象的变量名
// javaType = Person.class, // 被包含对象的实际数据类型
// column = "pid", // 根据查询出的card表中的pid字段来查询person表
// /*
// one、@One 一对一固定写法
// select属性：指定调用哪个接口中的哪个方法
// */
// one = @One(select = "com.itheima.one_to_one.PersonMapper.selectById")
// )
// })
@Select("select * from card")
@Results(
{
@Result(column = "id", property = "id"),
@Result(column = "number", property = "number"),
@Result(
property = "p",
javaType = Person.class,
column = "pid",
one = @One(select = "com.itheima.one_to_one.PersonMapper.selectById")
)
}
)
public abstract List<Card> selectAll();
}
mybatis05.zip （47个子文件） 
mybatis05 target production mybatis05 META-INF 
mybatis05.kotlin_module 16B MyBatisConfig.xml 2KB jdbc.properties 95B log4j.properties 289B com itheima one_to_many Test01.class 3KB ClassesMapper.class 696B StudentMapper.class 419B one_to_one CardMapper.class 688B PersonMapper.class 333B Test01.class 2KB bean Classes.class 2KB Card.class 2KB Person.class 1KB Student.class 2KB Course.class 1KB many_to_many Test01.class 3KB StudentMapper.class 772B CourseMapper.class 456B mybatis05.iml 883B src MyBatisConfig.xml 2KB jdbc.properties 95B log4j.properties 289B com itheima one_to_many Test01.java 1KB StudentMapper.java 330B ClassesMapper.java 1KB one_to_one PersonMapper.java 278B Test01.java 1KB CardMapper.java 2KB bean Classes.java 1KB Course.java 722B Person.java 972B Student.java 1KB Card.java 969B many_to_many Test01.java 1KB StudentMapper.java 1KB CourseMapper.java 469B .idea codeStyles codeStyleConfig.xml 153B misc.xml 388B mybatis05.iml 509B modules.xml 277B workspace.xml 8KB libraries hamcrest_core_1_3.xml 515B libs 
junit-4.12.jar 308KB mybatis-3.5.3.jar 1.62MB hamcrest-core-1.3.jar 44KB mysql-connector-java-5.1.37-bin.jar 963KB log4j-1.2.17.jar 478KB
评论0