{"id":2365,"date":"2021-07-23T16:29:52","date_gmt":"2021-07-23T07:29:52","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=2365"},"modified":"2021-11-23T17:52:02","modified_gmt":"2021-11-23T08:52:02","slug":"%ea%b0%9c%ec%b2%b4-%ed%95%9c%ec%a0%95%ec%9e%90%ec%9d%98-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%9d%b4%eb%a6%84-%ea%b5%ac%ec%84%b1-%ec%9a%94%ec%86%8c%eb%8a%94-%ed%98%84%ec%9e%ac","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=2365","title":{"rendered":"\uac1c\uccb4 \ud55c\uc815\uc790\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984 \uad6c\uc131 \uc694\uc18c\ub294 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc774\ub984\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4"},"content":{"rendered":"

\uac1c\uccb4 \ud55c\uc815\uc790\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984 \uad6c\uc131 \uc694\uc18c\ub294 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc774\ub984\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4<\/h1>\n

\uc6d0\uc778<\/h2>\n

MS-SQL \uc758 \uc81c\ud55c\uc870\uce58\ub85c \ub514\ube44 \ucee4\ub125\uc158\uc744 \ud55c \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub9cc \uc811\uc18d\uac00\ub2a5\ud558\uac8c \uc81c\ud55c\uc870\uce58\uac00 \uac78\ub824\uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ud574\uacb0\ucc45<\/h2>\n
url: jdbc:sqlserver:\/\/XXX.XXX.XXX.XXX;databaseName=\ub514\ube44\uba85<\/code><\/pre>\n
\uc811\uadfc\ud558\ub824\ub294 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \uba85\uc744 \ub3d9\uc77c\ud558\uac8c \ub9de\ucdb0\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\uc5ec\ub7ec\uac1c\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud558\ub824\uba74,
\n\ubb3c\ub9ac\uc801\uc73c\ub85c\ub294 \ud558\ub098\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc774\ub354\ub77c\ub3c4,
\n\uc5ec\ub7ec\uac1c\uc758 \ub370\uc774\ud0c0\uc18c\uc2a4\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
\ud574\uacb0\ucc45 02<\/h2>\n
JDBC URL \uc0c1\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c master \ub85c \uc124\uc815\ud55c\ub2e4.<\/p>\n
\uc5d4\ud130\ud2f0\uc5d0 catalog \ub97c \uc9c0\uc815\ud574 \uc900\ub2e4.<\/p>\n
@Getter\n@Setter\n@AllArgsConstructor\n@NoArgsConstructor\n@Entity\n@Table(name = "tbl_orderMaster", catalog = "database_order.dbo")\npublic class OrderMaster implements Persistable<Integer> {\n\n    @Id\n    @GeneratedValue(strategy = GenerationType.AUTO)\n    @Column(name = "idx")\n    private int idx;\n    \/\/ ......\n}<\/code><\/pre>\n
nativeQuery \ub97c \uc774\uc6a9\ud574 \ud504\ub85c\uc2dc\uc800\ub3c4 \ud638\ucd9c\ud560 \uc218 \uc788\ub2e4.<\/p>\n
@Repository\npublic interface OrderMasterRepository extends JpaRepository<OrderMaster, Integer> {\n\n    Optional<OrderMaster> findByOrderserial(String orderserial);\n\n    \/\/ \ub300\uad04\ud638 \uc55e\ub4a4\uc5d0 \uacf5\ubc31\ubb38\uc790\uac00 \uc788\uc5b4\uc57c \ud55c\ub2e4.\n    @Query(value = "{ CALL database_order.dbo.usp_Ten_Order_GetOrderMasterListJpa(:pageNo, :pageSize, :userid, :orderserial) }", nativeQuery = true)\n    List<OrderMaster> GetOrderMasterList(\n            @Param("pageNo") Integer pageNo,\n            @Param("pageSize") Integer pageSize,\n            @Param("userid") String userid,\n            @Param("orderserial") String orderserial);\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\uac1c\uccb4 \ud55c\uc815\uc790\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984 \uad6c\uc131 \uc694\uc18c\ub294 \ud604\uc7ac \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc774\ub984\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4 \uc6d0\uc778 MS-SQL \uc758 \uc81c\ud55c\uc870\uce58\ub85c \ub514\ube44 \ucee4\ub125\uc158\uc744 \ud55c \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub9cc \uc811\uc18d\uac00\ub2a5\ud558\uac8c \uc81c\ud55c\uc870\uce58\uac00 \uac78\ub824\uc788\uc2b5\ub2c8\ub2e4. \ud574\uacb0\ucc45 url: jdbc:sqlserver:\/\/XXX.XXX.XXX.XXX;databaseName=\ub514\ube44\uba85 \uc811\uadfc\ud558\ub824\ub294 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc758 \uba85\uc744 \ub3d9\uc77c\ud558\uac8c \ub9de\ucdb0\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc5ec\ub7ec\uac1c\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud558\ub824\uba74, \ubb3c\ub9ac\uc801\uc73c\ub85c\ub294 \ud558\ub098\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc774\ub354\ub77c\ub3c4, \uc5ec\ub7ec\uac1c\uc758 \ub370\uc774\ud0c0\uc18c\uc2a4\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ud574\uacb0\ucc45 02 JDBC URL \uc0c1\uc758 \ub370\uc774\ud0c0\ubca0\uc774\uc2a4\ub97c master \ub85c \uc124\uc815\ud55c\ub2e4. \uc5d4\ud130\ud2f0\uc5d0 catalog \ub97c \uc9c0\uc815\ud574 \uc900\ub2e4.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-2365","post","type-post","status-publish","format-standard","hentry","category-devops"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2365"}],"version-history":[{"count":2,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2365\/revisions"}],"predecessor-version":[{"id":3932,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2365\/revisions\/3932"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}