1.同一张表的一对多,如何写
public class TownVillageName {
private String townshipName;
private List<String> villageCommitteeNames;
}
<resultMap id="TownVillageNamesResult"
type="com.lingjiu.leping.pojo.bo.farmland.TownVillageName">
<result column="township_name" property="townshipName"
jdbcType="VARCHAR" />
<collection property="villageCommitteeNames">
</collection>
</resultMap>
mybatis框架的关联配置:
为了不让大家迷糊,我还是写全吧,从最基本的实体类开始:
public class Move {
}
[java]
public class MoveType {
}
public interface IMoveDao {
}
public interface IMoveTypeDao {
}
<?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">
(2)映射Move实体类的字段属性
<!-- 映射Move实体类的字段属性 -->
<!-- 关联MoveType实体类, -->
</resultMap>
(3)映射实体类MoveType
<!-- 映射实体类MoveType -->
(4)对应的moveType的映射
[java]
<!-- selectMoveType与上面MoveType实体类的select相对应 -->
(5)下面就是咱们在Dao层里面方法的sql实现了
<!-- 添加电影 -->
<insert id="saveMove" parameterType="move">
</insert>
<!-- 动态查询电影 -->
<select id="queryMoveByTerm"
parameterType="hashmap"
resultMap="moveMapper">
</select>
最后记得用<mapper></mapper>把上面的配置包起来。
到此,我们的MoveDaoMapper.xml的配置就结束了,下面我们来配置一下MoveTypeDaoMapper.xml,请看代码:
<?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="moveTypeDao">
</mapper>
public class MoveTerm {
}
省略getter和setter方法!!