카테고리 없음

21111~211112_mybatis_3

요옫 2021. 11. 12. 14:10

1. carsql에 메서드 추가

 

2. updateformservlet 생성

 

3. updateform

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<link href="https://fonts.googleapis.com/css2?family=Do+Hyeon&display=swap" rel="stylesheet">

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">

<script src="https://code.jquery.com/jquery-3.5.0.js"></script>

<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>

<title>Insert title here</title>

</head>

<body>

<form action="update" method="post">

 

<!-- hidden -->

<input type="hidden" name="num" value="${dto.num }">

 

  <table class="table table-bordered" style="width: 350px; margin-left: 50px;">

    <caption><b>정보수정</b></caption>

      <tr>

        <th bgcolor="#e6e6fa" width="100">차종</th>

        <td>

<!-- name은 dto랑 일치해야 함 -->

          <input type="text" name="carname" size="10" required="required" value="${dto.carname }">

        </td>

      </tr>

      

      <tr>

        <th bgcolor="#e6e6fa" width="100">가격</th>

        <td>

          <input type="text" name="carprice" size="10" required="required" value="${dto.carprice }">

        </td>

      </tr>

      

      <tr>

        <th bgcolor="#e6e6fa" width="100">색상</th>

        <td>

          <input type="color" name="carcolor" required="required" value="${dto.carcolor }">

        </td>

      </tr>

      

      <tr>

        <th bgcolor="#e6e6fa" width="100">구입일</th>

        <td>

          <input type="date" name="carguip" size="10" required="required"  value="${dto.carguip }">

        </td>

      </tr>

      

      <tr>

        <td colspan="2" align="center">

          <button type="submit" class="btn btn-default btn-sm">DB수정</button>

          <button type="button" class="btn btn-default btn-sm" onclick="location.href='list'">목록</button>

        </td>

      </tr>

  </table>

</form>

</body>

</html>

4. carsql에 수정메서드 추가

 

5. updatecarservlet 생성

 

6. carsql에 삭제메서드 추가

 

7. cardao에 삭제 메서드 추가

 

8. deletecarservlet 생성후 메서드

 

9. carstart 수정

 

10. 퀀텀db에 carmember 테이블 추가