-
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 테이블 추가