231027 Update 0613_SPLR.md

code-sum · code-sum · commit e891a14e8592 · 2023-10-27T23:25:26.000+09:00
diff --git a/notes/0613_SPLR.md b/notes/0613_SPLR.md
@@ -14,7 +14,7 @@
     ```xml
     <select id="splrlist" resultType="kr.happyjob.study.busSpm.model.SplrModel">
         SELECT
-                sp.splr_no
+                  sp.splr_no
                 , sp.splr_name
                 , sp.splr_tel
                 , sp.splr_mng
@@ -76,4 +76,31 @@
     </select>
     ```
   
+  
+  - 데이터 1건 조회
+  
+    ```xml
+    <select id="splrselectone" resultType="kr.happyjob.study.busSpm.model.SplrModel">
+        SELECT
+                  sp.splr_no
+                , sp.splr_name
+                , sp.splr_tel
+                , sp.splr_mng
+                , sp.splr_hp
+                , sp.splr_zip
+                , sp.bk_cd
+                , dc.detail_name AS bk_name
+                , sp.splr_acc
+                , sp.splr_add
+                , sp.splr_add_dt
+                , sp.splr_indst
+                , sp.splr_indst_no
+                , sp.splr_memo
+                , sp.splr_email
+        FROM tb_splr sp
+        INNER JOIN tb_detail_code dc ON dc.group_code = 'bk_cd' AND dc.detail_code = sp.bk_cd
+        WHERE sp.splr_no = #{splr_no}              
+    </select>
+    ```
+  
     
