Mybatis关联查询(嵌套功能查询).docx

Mybatis关联查询（嵌套查询）表的存储sql文件：?xml version=1.0 encoding=UTF-8 ?!DOCTYPE configuration PUBLIC -////DTD Config 3.0//EN/dtd/mybatis-3-config.dtdconfiguration!--mybatis别名定义 -- typeAliases typeAlias alias=User type=com.mybatis.test.User/ typeAlias alias=Article type=com.mybatis.test.Article/ typeAlias alias=Blog type=com.mybatis.test.Blog/ /typeAliases environments default=development environment id=development transactionManager type=JDBC/ dataSource type=POOLED property name=driver value=com.mysql.jdbc.Driver/ property name=url value=jdbc:mysql://:3306/mybatis / property name=username value=root/ property name=password value=admin/ /dataSource /environment /environments!--mybatis的mapper文件，每个xml配置文件对应一个接口 -- mappers mapper resource=com/mybatis/test/User.xml/ mapper resource=com/mybatis/test/Article.xml/ mapper resource=com/mybatis/test/Blog.xml/ /mappers/configuration表的存储sql文件：?xml version=1.0 encoding=UTF-8 ?!DOCTYPE mapper PUBLIC -////DTD Mapper 3.0//EN /dtd/mybatis-3-mapper.dtdmapper namespace=com.mybatis.test.IArticleOperation resultMap type=User id=userResultMap!--属性名和数据库列名映射 -- id property=id column=user_id / result property=userName column=user_userName / result property=userAge column=user_userAge / result property=userAddress column=user_userAddress / /resultMap!-- User join Article进行联合查询 (一对一)-- resultMap id=articleResultMap type=Article id property=id column=article_id / result property=title column=article_title / result property=content column=article_content /!--将article的user属性映射到userResultMap -- association property=user javaType=User resultMap=userResultMap/ /resultMap!--使用别名来映射匹配 -- select id=getUserArticles parameterType=int resultMap=articleResultMapselect user.id user_id,user.userNameuser_userName,user.userAddressuser_userAd