<![CDATA[
<p> </p><div class="table-wrap"><table data-ke-type="table" data-ke-align="alignLeft" style="width: 100%;" border="1"><tbody><tr><td><b><span data-ke-size="size20">1. websiteVO</span></b></td></tr></tbody></table></div><p><span style="color: #a71d5d;">package</span> com.spring.springTest.vo;</p><p><span style="color: #a71d5d;">import</span> lombok.Getter;</p><p><span style="color: #a71d5d;">import</span> lombok.Setter;</p><p><span style="color: #a71d5d;">import</span> lombok.ToString;</p><p>@Getter</p><p>@Setter</p><p>@ToString</p><p><span style="color: #a71d5d;">public</span> <span style="color: #a71d5d;">class</span> WebsiteVO {</p><p><span style="color: #a71d5d;">public</span> <span style="color: #066de2;">String</span> driver;</p><p><span style="color: #a71d5d;">private</span> <span style="color: #066de2;">String</span> url;</p><p><span style="color: #a71d5d;">private</span> <span style="color: #066de2;">String</span> user;</p><p><span style="color: #a71d5d;">private</span> <span style="color: #066de2;">String</span> password;</p><p>}</p><p> </p><p><span data-ke-size="size23"> <b><span data-ke-size="size20">2. studyController.java</span></b> </span></p><p>@RequestMapping(value <span style="color: #a71d5d;">=</span> <span style="color: #63a35c;">"/website"</span>, method <span style="color: #a71d5d;">=</span> RequestMethod.GET)</p><p>  <span style="color: #a71d5d;">public</span> <span style="color: #066de2;">String</span> homeworkGet(Model model) {</p><p>      AbstractApplicationContext ctx <span style="color: #a71d5d;">=</span> <span style="color: #a71d5d;">new</span> GenericXmlApplicationContext(<span style="color: #63a35c;">"xml/website.xml"</span>);</p><p>      </p><p>      List<span style="color: #a71d5d;"><</span>WebsiteVO<span style="color: #a71d5d;">></span> vos <span style="color: #a71d5d;">=</span> <span style="color: #a71d5d;">new</span> ArrayList<span style="color: #a71d5d;"><</span>WebsiteVO<span style="color: #a71d5d;">></span>();</p><p>      <span style="color: #a71d5d;">for</span>(<span style="color: #066de2;">int</span> i<span style="color: #a71d5d;">=</span><span style="color: #0099cc;">1</span>; i<span style="color: #a71d5d;"><</span><span style="color: #a71d5d;">=</span><span style="color: #0099cc;">4</span>; i<span style="color: #a71d5d;">+</span><span style="color: #a71d5d;">+</span>) {</p><p>          vos.<span style="color: #066de2;">add</span>(ctx.getBean(<span style="color: #63a35c;">"vo"</span> <span style="color: #a71d5d;">+</span> i, WebsiteVO.<span style="color: #a71d5d;">class</span>));</p><p>      }</p><p>      </p><p>      ctx.close();</p><p>      model.addAttribute(<span style="color: #63a35c;">"vos"</span>, vos);</p><p>      </p><p>      <span style="color: #a71d5d;">return</span> <span style="color: #63a35c;">"study/xml/website"</span>;</p><p>  }</p><p><b><span data-ke-size="size20">3. website.xml</span></b></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">?xml</span> <span style="color: #0a9989;">version</span>=<span style="color: #df5000;">"1.0"</span> <span style="color: #0a9989;">encoding</span>=<span style="color: #df5000;">"UTF-8"</span><span style="color: #0a9989;">?</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">beans</span> <span style="color: #0a9989;">xmlns</span>=<span style="color: #df5000;">"<a href="http://www.springframework.org/schema/beans" target="_top" class="ke-link">http://www.springframework.org/schema/beans</a>"</span></p><p>    <span style="color: #0a9989;">xmlns:xsi</span>=<span style="color: #df5000;">"<a href="http://www.w3.org/2001/XMLSchema-instance" target="_top" class="ke-link">http://www.w3.org/2001/XMLSchema-instance</a>"</span></p><p>    <span style="color: #0a9989;">xsi:schemaLocation</span>=<span style="color: #df5000;">"<a href="http://www.springframework.org/schema/beans" target="_top" class="ke-link">http://www.springframework.org/schema/beans</a> <a href="http://www.springframework.org/schema/beans/spring-beans.xsd" target="_top" class="ke-link">http://www.springframework.org/schema/beans/spring-beans.xsd</a>"</span><span style="color: #010101;">></span></p><p>    </p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">bean</span> <span style="color: #0a9989;">id</span>=<span style="color: #df5000;">"vo1"</span> <span style="color: #0a9989;">class</span>=<span style="color: #df5000;">"com.spring.springTest.vo.WebsiteVO"</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"driver"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"com.mysql.cj.jdbc.Driver"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"url"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"jdbc:mysql://localhost:3306/db명"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"user"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"root"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"password"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"1234"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>    <span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">bean</span><span style="color: #010101;">></span></p><p>    <span style="color: #010101;"><</span><span style="color: #066de2;">bean</span> <span style="color: #0a9989;">id</span>=<span style="color: #df5000;">"vo2"</span> <span style="color: #0a9989;">class</span>=<span style="color: #df5000;">"com.spring.springTest.vo.WebsiteVO"</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"driver"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"oracle.jdbc.driver.OracleDriver"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"url"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"jdbc:oracle:thin:@localhost:1521:xe"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"user"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"scott"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"password"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"tiger"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>    <span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">bean</span><span style="color: #010101;">></span></p><p>    <span style="color: #010101;"><</span><span style="color: #066de2;">bean</span> <span style="color: #0a9989;">id</span>=<span style="color: #df5000;">"vo3"</span> <span style="color: #0a9989;">class</span>=<span style="color: #df5000;">"com.spring.springTest.vo.WebsiteVO"</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"driver"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"org.mariadb.jdbc.Driver"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"url"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"jdbc:mariadb://localhost:3306/db명"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"user"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"root"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"password"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"1234"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>    <span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">bean</span><span style="color: #010101;">></span></p><p>    <span style="color: #010101;"><</span><span style="color: #066de2;">bean</span> <span style="color: #0a9989;">id</span>=<span style="color: #df5000;">"vo4"</span> <span style="color: #0a9989;">class</span>=<span style="color: #df5000;">"com.spring.springTest.vo.WebsiteVO"</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"driver"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"org.postgresql.Driver"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"url"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"jdbc:postgresql://localhost:5432/db명"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"user"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"postgres"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>        <span style="color: #010101;"><</span><span style="color: #066de2;">property</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"password"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"1234"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p>    <span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">bean</span><span style="color: #010101;">></span></p><p>    </p><p><span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">beans</span><span style="color: #010101;">></span></p><p> </p><p><b><span data-ke-size="size20">4. website.jsp</span></b></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">%@</span> <span style="color: #0a9989;">page</span> <span style="color: #0a9989;">language</span>=<span style="color: #df5000;">"java"</span> <span style="color: #0a9989;">contentType</span>=<span style="color: #df5000;">"text/html; charset=UTF-8"</span> <span style="color: #0a9989;">pageEncoding</span>=<span style="color: #df5000;">"UTF-8"</span><span style="color: #0a9989;">%</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">%@</span> <span style="color: #0a9989;">taglib</span> <span style="color: #0a9989;">uri</span>=<span style="color: #df5000;">"<a href="http://java.sun.com/jsp/jstl/core" target="_top" class="ke-link">http://java.sun.com/jsp/jstl/core</a>"</span> <span style="color: #0a9989;">prefix</span>=<span style="color: #df5000;">"c"</span> <span style="color: #0a9989;">%</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">c:set</span> <span style="color: #0a9989;">var</span>=<span style="color: #df5000;">"ctp"</span> <span style="color: #0a9989;">value</span>=<span style="color: #df5000;">"${pageContext.request.contextPath}"</span><span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">!DOCTYPE</span> <span style="color: #0a9989;">html</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">html</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">head</span><span style="color: #010101;">></span></p><p>  <span style="color: #010101;"><</span><span style="color: #066de2;">meta</span> <span style="color: #0a9989;">charset</span>=<span style="color: #df5000;">"UTF-8"</span><span style="color: #010101;">></span></p><p>  <span style="color: #010101;"><</span><span style="color: #066de2;">meta</span> <span style="color: #0a9989;">name</span>=<span style="color: #df5000;">"viewport"</span> <span style="color: #0a9989;">content</span>=<span style="color: #df5000;">"width=device-width, initial-scale=1"</span><span style="color: #010101;">></span></p><p>  <span style="color: #010101;"><</span><span style="color: #066de2;">title</span><span style="color: #010101;">></span>website.jsp<span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">title</span><span style="color: #010101;">></span></p><p>  <span style="color: #010101;"><</span><span style="color: #066de2;">jsp:include</span> <span style="color: #0a9989;">page</span>=<span style="color: #df5000;">"/WEB-INF/views/include/bs5.jsp"</span> <span style="color: #0a9989;">/</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">head</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">body</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">p</span><span style="color: #010101;">></span><span style="color: #010101;"><</span><span style="color: #066de2;">br/</span><span style="color: #010101;">></span><span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">p</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">div</span> <span style="color: #0a9989;">class</span>=<span style="color: #df5000;">"container"</span><span style="color: #010101;">></span></p><p>  <span style="color: #010101;"><</span><span style="color: #066de2;">h2</span><span style="color: #010101;">></span>WebSite JDBC 정보 보기(vo명: WebSiteVO)<span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">h2</span><span style="color: #010101;">></span></p><p>  <span style="color: #010101;"><</span><span style="color: #066de2;">c:forEach</span> <span style="color: #0a9989;">var</span>=<span style="color: #df5000;">"vo"</span> <span style="color: #0a9989;">items</span>=<span style="color: #df5000;">"${vos}"</span> <span style="color: #0a9989;">varStatus</span>=<span style="color: #df5000;">"st"</span><span style="color: #010101;">></span></p><p>      <span style="color: #010101;"><</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span>번호 : ${st.count}<span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span></p><p>      <span style="color: #010101;"><</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span>드라이버 : ${vo.driver}<span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span></p><p>      <span style="color: #010101;"><</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span>URL : ${vo.url}<span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span></p><p>      <span style="color: #010101;"><</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span>User : ${vo.user}<span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span></p><p>      <span style="color: #010101;"><</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span>Password : ${vo.password}<span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span></p><p>      <span style="color: #010101;"><</span><span style="color: #066de2;">hr/</span><span style="color: #010101;">></span></p><p>    <span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">c:forEach</span><span style="color: #010101;">></span></p><p>  <span style="color: #010101;"><</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span><span style="color: #010101;"><</span><span style="color: #066de2;">a</span> <span style="color: #0a9989;">href</span>=<span style="color: #df5000;">"${ctp}/"</span> <span style="color: #0a9989;">class</span>=<span style="color: #df5000;">"btn btn-success"</span><span style="color: #010101;">></span>돌아가기<span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">a</span><span style="color: #010101;">></span><span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">div</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #066de2;">p</span><span style="color: #010101;">></span><span style="color: #010101;"><</span><span style="color: #066de2;">br/</span><span style="color: #010101;">></span><span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">p</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">body</span><span style="color: #010101;">></span></p><p><span style="color: #010101;"><</span><span style="color: #010101;">/</span><span style="color: #066de2;">html</span><span style="color: #010101;">></span></p><p> </p>
<!-- -->
]]>
카페 게시글
조경민
2026.03.19 website JDBC 과제
조경민
추천 0
조회 12
26.03.19 18:09
댓글 1
다음검색
첫댓글 JDBC정보는 1회만 처리해도 좋습니다... 수고하셨어요