20260601 과제

[조경민]

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89

package com.spring.demo2.controller;   import java.util.List;   import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam;   import com.spring.demo2.service.UserService; import com.spring.demo2.vo.UserVO;   @Controller @RequestMapping("/user") public class UserController {     @Autowired   UserService userService;      @GetMapping("/userList")   public String userListGet(Model model) {     List<UserVO> vos = userService.getUserList();     //System.out.println("vos :" + vos);     for(UserVO vo : vos) {       System.out.println("vo : " + vo);     }          model.addAttribute("vos", vos);          return "user/userList";   }      @GetMapping("/userInput")   public String userInputGet() {     return "user/userInput";   }      @PostMapping("/userInput")   public String userInputPost(UserVO vo) {     userService.setUserInput(vo);     return "redirect:/user/userList";   }      @GetMapping("/userSearch")   public String userSearchGet(@RequestParam(name = "mid", required = false) String mid, Model model) {     if (mid != null && !mid.isBlank()) {       UserVO vo = userService.getUserSearch(mid);       model.addAttribute("vo", vo);       model.addAttribute("mid", mid);     }     return "user/userSearch";   }      @GetMapping("/userUpdate")   public String userUpdateGet(@RequestParam(name = "mid", required = false) String mid, Model model) {     if (mid != null && !mid.isBlank()) {       UserVO vo = userService.getUserSearch(mid);       model.addAttribute("vo", vo);       model.addAttribute("mid", mid);     }     return "user/userUpdate";   }      @PostMapping("/userUpdate")   public String userUpdatePost(UserVO vo) {     userService.setUserUpdate(vo);     return "redirect:/user/userList";   }      @GetMapping("/userDelete")   public String userDeleteGet(@RequestParam(name = "mid", required = false) String mid, Model model) {     if (mid != null && !mid.isBlank()) {       UserVO vo = userService.getUserSearch(mid);       model.addAttribute("vo", vo);       model.addAttribute("mid", mid);     }     return "user/userDelete";   }      @PostMapping("/userDelete")   public String userDeletePost(@RequestParam("mid") String mid) {     userService.setUserDelete(mid);     return "redirect:/user/userList";   }    } Colored by Color Scripter

cs

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53

package com.spring.demo2.controller;   import java.util.List;   import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.DeleteMapping; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.PutMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController;   import com.spring.demo2.service.UserService; import com.spring.demo2.vo.UserVO;   @RestController @RequestMapping("/api/user") public class UserRestController {     @Autowired   UserService userService;     @GetMapping("/list")   public List<UserVO> userListGet() {     return userService.getUserList();   }     @PostMapping("/input")   public String userInputPost(@RequestBody UserVO vo) {     userService.setUserInput(vo);     return "success";   }     @GetMapping("/search")   public UserVO userSearchGet(@RequestParam("mid") String mid) {     return userService.getUserSearch(mid);   }     @PutMapping("/update")   public String userUpdatePost(@RequestBody UserVO vo) {     userService.setUserUpdate(vo);     return "success";   }     @DeleteMapping("/delete")   public String userDeletePost(@RequestParam("mid") String mid) {     userService.setUserDelete(mid);     return "success";   }    } Colored by Color Scripter

cs

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.spring.demo2.dao.UserDao">     <select id="getUserList" resultType="com.spring.demo2.vo.UserVO">     select * from user order by idx desc;   </select>     <insert id="setUserInput" parameterType="com.spring.demo2.vo.UserVO">     insert into user (mid, pwd, name, age, gender, address)     values (#{mid}, #{pwd}, #{name}, #{age}, #{gender}, #{address});   </insert>     <select id="getUserSearch" resultType="com.spring.demo2.vo.UserVO">     select * from user where mid = #{mid};   </select>     <update id="setUserUpdate" parameterType="com.spring.demo2.vo.UserVO">     update user      set pwd = #{pwd}, name = #{name}, age = #{age}, gender = #{gender}, address = #{address}     where mid = #{mid};   </update>     <delete id="setUserDelete">     delete from user where mid = #{mid};   </delete>   </mapper> Colored by Color Scripter

cs

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!DOCTYPE html> <html> <head>   <meta charset="UTF-8">   <title>userList.jsp</title> </head> <body> <p><br/></p>   <hr/>   <h2>이곳은 전체리스트 입니다.</h2>   <hr/>      <table border="1">     <thead>       <tr>         <th>번호</th>         <th>아이디</th>         <th>이름</th>         <th>나이</th>         <th>성별</th>         <th>주소</th>       </tr>     </thead>     <tbody>       <c:forEach var="vo" items="${vos}">         <tr>           <td>${vo.idx}</td>           <td>${vo.mid}</td>           <td>${vo.name}</td>           <td>${vo.age}</td>           <td>${vo.gender}</td>           <td>${vo.address}</td>         </tr>       </c:forEach>       <c:if test="${empty vos}">         <tr>           <td colspan="6">등록된 회원이 없습니다.</td>         </tr>       </c:if>     </tbody>   </table>     <br/>   <a href="/main/main">홈으로 가기</a>   </body> </html> Colored by Color Scripter

cs

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head>   <meta charset="UTF-8">   <title>userInput.jsp</title> </head> <body> <p><br/></p>   <hr/>   <h2>회원 가입 양식</h2>   <hr/>     <form action="/user/userInput" method="post">     <table border="1">       <tr>         <th>아이디</th>         <td><input type="text" name="mid" required /></td>       </tr>       <tr>         <th>비밀번호</th>         <td><input type="password" name="pwd" required /></td>       </tr>       <tr>         <th>성명</th>         <td><input type="text" name="name" required /></td>       </tr>       <tr>         <th>나이</th>         <td><input type="number" name="age" /></td>       </tr>       <tr>         <th>성별</th>         <td>           <input type="radio" name="gender" value="남자" checked />남자           <input type="radio" name="gender" value="여자" />여자         </td>       </tr>       <tr>         <th>주소</th>         <td><input type="text" name="address" /></td>       </tr>       <tr>         <td colspan="2" align="center">           <input type="submit" value="가입하기" />           <input type="reset" value="다시입력" />         </td>       </tr>     </table>   </form>     <br/>   <a href="/user/userList">전체리스트로 가기</a>   </body> </html> Colored by Color Scripter

cs

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!DOCTYPE html> <html> <head>   <meta charset="UTF-8">   <title>userSearch.jsp</title> </head> <body> <p><br/></p>   <hr/>   <h2>회원 개별 조회</h2>   <hr/>     <form action="/user/userSearch" method="get">     아이디 검색 :      <input type="text" name="mid" value="${mid}" required />     <input type="submit" value="검색" />   </form>   <br/>     <c:if test="${not empty vo}">     <table border="1">       <tr>         <th>번호</th>         <td>${vo.idx}</td>       </tr>       <tr>         <th>아이디</th>         <td>${vo.mid}</td>       </tr>       <tr>         <th>성명</th>         <td>${vo.name}</td>       </tr>       <tr>         <th>나이</th>         <td>${vo.age}</td>       </tr>       <tr>         <th>성별</th>         <td>${vo.gender}</td>       </tr>       <tr>         <th>주소</th>         <td>${vo.address}</td>       </tr>     </table>   </c:if>     <c:if test="${empty vo && not empty mid}">     <p>검색하신 회원 정보가 없습니다.</p>   </c:if>     <br/>   <a href="/user/userList">전체리스트로 가기</a>   </body> </html> Colored by Color Scripter

cs

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!DOCTYPE html> <html> <head>   <meta charset="UTF-8">   <title>userUpdate.jsp</title> </head> <body> <p><br/></p>   <hr/>   <h2>회원 정보 수정</h2>   <hr/>     <form action="/user/userUpdate" method="get">     수정할 아이디 입력 :      <input type="text" name="mid" value="${mid}" required />     <input type="submit" value="조회" />   </form>   <br/>     <c:if test="${not empty vo}">     <form action="/user/userUpdate" method="post">       <input type="hidden" name="idx" value="${vo.idx}" />       <input type="hidden" name="mid" value="${vo.mid}" />              <table border="1">         <tr>           <th>아이디</th>           <td>${vo.mid} (변경불가)</td>         </tr>         <tr>           <th>비밀번호</th>           <td><input type="password" name="pwd" value="${vo.pwd}" required /></td>         </tr>         <tr>           <th>성명</th>           <td><input type="text" name="name" value="${vo.name}" required /></td>         </tr>         <tr>           <th>나이</th>           <td><input type="number" name="age" value="${vo.age}" /></td>         </tr>         <tr>           <th>성별</th>           <td>             <input type="radio" name="gender" value="남자" <c:if test="${vo.gender eq '남자'}">checked</c:if> />남자             <input type="radio" name="gender" value="여자" <c:if test="${vo.gender eq '여자'}">checked</c:if> />여자           </td>         </tr>         <tr>           <th>주소</th>           <td><input type="text" name="address" value="${vo.address}" /></td>         </tr>         <tr>           <td colspan="2" align="center">             <input type="submit" value="수정하기" />           </td>         </tr>       </table>     </form>   </c:if>     <br/>   <a href="/user/userList">전체리스트로 가기</a>   </body> </html> Colored by Color Scripter

cs

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <!DOCTYPE html> <html> <head>   <meta charset="UTF-8">   <title>userDelete.jsp</title> </head> <body>     <h2>회원삭제</h2>   <hr/>     <form action="/user/userDelete" method="get">     삭제할 아이디 :      <input type="text" name="mid" value="${mid}" required />     <input type="submit" value="검색" />     <button type="button" xxxxonclick="location.href='/user/userList'">돌아가기</button>   </form>   <hr/>     <c:if test="${not empty vo}">     <table border="1">       <tr>         <th>아이디</th>         <td>${vo.mid}</td>       </tr>       <tr>         <th>성명</th>         <td>${vo.name}</td>       </tr>       <tr>         <th>나이</th>         <td>${vo.age}</td>       </tr>       <tr>         <th>성별</th>         <td>${vo.gender}</td>       </tr>       <tr>         <th>주소</th>         <td>${vo.address}</td>       </tr>     </table>     <br/>          <form action="/user/userDelete" method="post" style="display:inline;">       <input type="hidden" name="mid" value="${vo.mid}" />       <input type="submit" value="회원삭제" />     </form>     <button type="button" xxxxonclick="location.href='/user/userList'">전체리스트</button>   </c:if>     <c:if test="${empty vo && not empty mid}">     <p>존재하지 않는 회원 아이디입니다.</p>   </c:if>   </body> </html> Colored by Color Scripter

cs