Subversion Repositories SmartDukaan

Rev

Rev 4627 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<?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="in.shop2020.warehouse.persistence.ItemNumberMapper">
  <select id="getItemIds" resultType="java.lang.Long" parameterType="java.lang.String">
    SELECT itemId
    FROM itemnumbermapping
    WHERE itemNumber = #{itemNumber}
  </select>
  
  <select id="getItemNumbers" resultType="java.lang.String" parameterType="java.lang.Long">
    SELECT itemNumber
    FROM itemnumbermapping
    WHERE itemId = #{itemId}
  </select>
  
  <insert id="insertItemNumberMapping" parameterType="map">
    INSERT INTO itemnumbermapping
    VALUES (#{itemNumber}, #{itemId})
  </insert>
  
  <!-- Test Commit Ignore -->
  
</mapper>