Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
4500 mandeep.dh 1 
<?xml version="1.0" encoding="UTF-8"?>
2 
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
3 
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
4 
 
5 
<mapper namespace="in.shop2020.warehouse.persistence.ItemNumberMapper">
4846 mandeep.dh 6 
  <select id="getItemIds" resultType="java.lang.Long" parameterType="java.lang.String">
4500 mandeep.dh 7 
    SELECT itemId
8 
    FROM itemnumbermapping
9 
    WHERE itemNumber = #{itemNumber}
10 
  </select>
11 
 
4627 amit.gupta 12 
  <select id="getItemNumbers" resultType="java.lang.String" parameterType="java.lang.Long">
13 
    SELECT itemNumber
14 
    FROM itemnumbermapping
15 
    WHERE itemId = #{itemId}
16 
  </select>
17 
 
4500 mandeep.dh 18 
  <insert id="insertItemNumberMapping" parameterType="map">
19 
    INSERT INTO itemnumbermapping
20 
    VALUES (#{itemNumber}, #{itemId})
21 
  </insert>
4627 amit.gupta 22 
 
23 
  <!-- Test Commit Ignore -->
24 
 
4500 mandeep.dh 25 
</mapper>