MyBatis 多对多 XML文件

user.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="com.ifeng.cmpp.mapper.UserMapper">
 <select id="get" parameterType="user" resultType="user" >
  select id,username,password,email,dept,telphone from cmpp_user
  <where>
   <if test="id != null">id = #{id}</if>
  </where>
  order by id desc
 </select>
 
 <delete id="delete" parameterType="user">
  delete from cmpp_user
  where id=#{id}
 </delete>
 
 <insert id="insert" parameterType="user" useGeneratedKeys="true" keyProperty="id">
  insert into cmpp_user
  (username,password,email,dept,telphone)values(#{username},#{password},#{email},#{dept},#{telphone})
 </insert>
 
 <select id="getLastId" resultType="int">
  SELECT LAST_INSERT_ID()
 </select>
 
 <!--为多对多配置-->
    <select id="getByGroupId" parameterType="int" resultType="user">
        select id,username,password,email,dept,telphone from cmpp_user where id in
        (select userId from cmpp_user_group where groupId=#{groupId})
    </select>
 
 <select id="getUserByPage" parameterType="int"  resultType="user">
        select id,username,password,email,dept,telphone from cmpp_user limit #{from},10
    </select>
 
</mapper>

 

mybatisConfig.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">

<configuration>
 <settings>
  <setting name="cacheEnabled" value="true"/>
 </settings>
 
 <typeAliases>

  <typeAlias alias="user" type="com.model.User"/>
  <typeAlias alias="group" type="com.model.Group"/>
  <typeAlias alias="userGroup" type="com.UserGroup"/>

 </typeAliases>
 
 <mappers>
  <mapper resource="mybatis_config/user.xml"/>
  <mapper resource="mybatis_config/group.xml"/>
  <mapper resource="mybatis_config/userGroup.xml"/>
 </mappers>
  
</configuration>