//Mapper 映射配置 信息:
<?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">
<mapper namespace="orderMapper">
<select id="getOrderByOid" resultMap="orderMap">
select* from orders where oid=#{oid}
<!--result代表普通字段的映射，分别指定列与属性的对应
如果字段名和属性名一致，可以省略
属性名叫做payType，字段名pay_type;
-->
<resultMap id="orderMap" type="zhu.Order">
<id property="oid" column="oid">
<result column="price" property="price"/>
<result column="addr" property="addr"/>
<result column="payType" property="payType"/>
<!-- association关联，只要是"对一"的关系都可以使用association，代表关联 property代表Order类中的属性名u
column代表Orders表中的uid字段 select代表要使用该查询完成两表的联合查询得出user对象
-->
<association property="u" column="uid" select="userMapper.getUserByUid">
<collection property="details" column="oid" select="detailMapper.getdetailByOid" ofType="zhu.Detail"/>
//association一对一 查询 collection一对多查询
</mapper>
//驱动加载配置信息资源读取xml配置:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<properties resource="db.properties" /> //读取配置资源,
<!--给当前mybatis项目添加日志功能，该STDOUT_LOGGING值的好处是不用添加第三方jar包就可以有日志的输出-->
<setting name="logImpl" value="STDOUT_LOGGING"/>
-->
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED"> //mybatis自在的连接池
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${userName}"/>
<property name="password" value="${password}"/>
<mapper resource="mapper/orderMapper.xml"/> //映射的xml配置
</configuration>
