| 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">
|
|
|
6 |
<select id="getItemId" resultType="java.lang.Long" parameterType="java.lang.String">
|
|
|
7 |
SELECT itemId
|
|
|
8 |
FROM itemnumbermapping
|
|
|
9 |
WHERE itemNumber = #{itemNumber}
|
|
|
10 |
</select>
|
|
|
11 |
|
|
|
12 |
<insert id="insertItemNumberMapping" parameterType="map">
|
|
|
13 |
INSERT INTO itemnumbermapping
|
|
|
14 |
VALUES (#{itemNumber}, #{itemId})
|
|
|
15 |
</insert>
|
|
|
16 |
</mapper>
|