将列表插入单独的表MYBATIS

Question

我需要帮助插入以下数据到数据库我有两个表employee和employee_skills(1个employee可以有很多技能）

mapper.xml

<insert id='addEmp1' parameterType='Employee'
    useGeneratedKeys='true '>
    INSERT INTO "PUBLIC"."EMPLOYEE"("ADDRESS", "AGE", "CITY", "DEPT",
    "FNAME","LNAME", "SALARY", "STATE")
    values(#{address},#{age},#{city},#{dept},#{fname},#{lname},#{salary},#{state});

</insert>

<insert id='addskills' parameterType='Employee'
    useGeneratedKeys='true '>
    INSERT INTO "PUBLIC"."EMPLOYEE_SKILLS"
    ( "EMPLOYEE_E_ID", "SKILLS" )
    VALUES (
    <foreach collection="skills" item="skill" separator=",">
        #{id},#{employee.skills}</foreach>)
     </insert>

    SqlSession sqlSession = MyBatisUtil.getSqlSessionFactory().openSession();
      try{
      EmployeeDAO userMapper = sqlSession.getMapper(EmployeeDAO.class);                                        //sqlSession.getMapper(UserMapper.class);
      // userMapper.addEmp(employee);                                                                       //userMapper.insertUser(employee);
    sqlSession.insert("addEmp1",employee);
    sqlSession.insert("addskill",employee);

      sqlSession.commit();
      }finally{
       sqlSession.close();
      }

Answer 1

如果使用sqlsession，则必须结合XML中指定的命名空间和查询id。见正式文件。