spring framework에서 xml파싱 내용 db 저장

Question

String ti &#61; (String) xpath.evaluate(&#34;//title[&#64;type&#61;'item']&#34;, document, XPathConstants.STRING); String jl &#61; (String) xpath.evaluate(&#34;//title[&#64;type&#61;'source']&#34;, document, XPathConstants.STRING); String ja &#61; (String) xpath.evaluate(&#34;//title[&#64;type&#61;'source_abbrev']&#34;, document, XPathConstants.STRING); String au1 &#61; (String) xpath.evaluate(&#34;//name[&#64;seq_no &#61; '1']/display_name&#34;, document, XPathConstants.STRING); String au2 &#61; (String) xpath.evaluate(&#34;//name[&#64;seq_no &#61; '2']/display_name&#34;, document, XPathConstants.STRING); String au3 &#61; (String) xpath.evaluate(&#34;//name[&#64;seq_no &#61; '3']/display_name&#34;, document, XPathConstants.STRING); String au4 &#61; (String) xpath.evaluate(&#34;//name[&#64;seq_no &#61; '4']/display_name&#34;, document, XPathConstants.STRING); String py &#61; (String) xpath.evaluate(&#34;//pub_info/&#64;pubyear&#34;, document, XPathConstants.STRING); String vl &#61; (String) xpath.evaluate(&#34;//pub_info/&#64;vol&#34;, document, XPathConstants.STRING); String pt &#61; (String) xpath.evaluate(&#34;//pub_info/&#64;pubtype&#34;, document, XPathConstants.STRING); String pg &#61; (String) xpath.evaluate(&#34;//page/&#64;page_count&#34;, document, XPathConstants.STRING); String di &#61; (String) xpath.evaluate(&#34;//identifier[&#64;type&#61;'doi']/&#64;value&#34;, document, XPathConstants.STRING); String pu &#61; (String) xpath.evaluate(&#34;//name[&#64;role&#61;'publisher']/display_name&#34;, document, XPathConstants.STRING); String sc &#61; (String) xpath.evaluate(&#34;//heading/text()&#34;, document, XPathConstants.STRING); String sc1 &#61; (String) xpath.evaluate(&#34;//subheading/text()&#34;, document, XPathConstants.STRING); String ab &#61; (String) xpath.evaluate(&#34;//p/text()&#34;,document, XPathConstants.STRING); String de &#61; (String) xpath.evaluate(&#34;//keyword | //keyword&#34;, document, XPathConstants.STRING);*/ String nr &#61; (String) xpath.evaluate(&#34;//refs/&#64;count&#34;, document, XPathConstants.STRING); /*쿼리수행_sampel1.xml 파싱한 데이터 db insert */ st.executeUpdate(&#34;INSERT INTO ARTICLE(TI, JI, J9, PD, DI, PU, SC, AB, CR) VALUES('&#34;&#43;ti&#43;&#34;','&#34;&#43;jl&#43;&#34;','&#34;&#43;ja&#43;&#34;','&#34;&#43;py&#43; &#34;,&#34; &#43;vl&#43; &#34;,&#34; &#43;pt&#43; &#34;,&#34; &#43;pg&#43;&#34;',&#34; &#43; &#34;'&#34;&#43;di&#43;&#34;','&#34;&#43;pu&#43;&#34;','&#34;&#43;sc&#43; &#34;>&#34; &#43;sc1&#43;&#34;','&#34;&#43;ab&#43;&#34;','&#34;&#43;nr&#43;&#34;')&#34;); 위와 같이 preparestatement를 사용하여 단순하게 쿼리를 수행하여 db에 저장하는 것을 시도하였는데spring 구조로 코드를 짤수도 있을까요? controller, mapper, do, service등을 거쳐서 db에 저장하는 방법도 있을까요?

spring framework에서 xml파싱 내용 db 저장

0개의 답변

Q&A 목록