2019.07.24
// CRUD
대부분의 컴퓨터 소프트웨어가 가지는 기본적인 데이터 처리기능인
Create(생성), Read(읽기), Update(갱신), Delete(삭제) 를 묶어서 일컫는 말
단어 수정(Update)
|
1
2
3
4
5
6
7
8
9
|
// DicDTO.java
package service;
public class DicDTO {
public int idx;
public String eng;
public String kor;
}
|
|
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
|
// DicDAO.java
package service;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public class DicDAO {
Connection conn = null;
PreparedStatement pstmt = null;
ArrayList<DicDTO> ald = null;
ResultSet rs = null;
// dic 단어 수정 메서드
public void update(DicDTO dicDTO) throws ClassNotFoundException, SQLException {
DriverDB db = new DriverDB();
conn = db.driverDbcon(); // 드라이버 로딩 및 DB 연결
pstmt = conn.prepareStatement("UPDATE dic SET eng=?, kor=? WHERE idx = ?");
pstmt.setString(1, dicDTO.eng);
pstmt.setString(2, dicDTO.kor);
// System.out.println(pstmt + " <-- pstmt update DicDAO.java");
int result = pstmt.executeUpdate();
}
}
|
|
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
|
<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="EUC-KR">
<title>Insert title here</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<!-- jQuery library -->
<!-- Popper JS -->
<!-- Latest compiled JavaScript -->
</head>
<body>
<%
DicDAO dicDAO = new DicDAO();
String getIdx = request.getParameter("idx");
int idx = Integer.parseInt(getIdx);
// System.out.println(idx + " <-- idx dicUpdateForm.jsp");
dicDAO.selectOne(idx);
%>
<div class = "container">
<hr>
<h3> Dictionary </h3>
<div class = "text-right">
홈으로
</button>
<hr>
</div>
<form action = "<%= request.getContextPath() %>
<table class = "table table-striped">
<tr>
<th> eng </th>
<th> kor </th>
</tr>
<tr>
<td><input type = "text" name = "eng" class="form-control"
value = "<%= dicDAO.selectOne(idx).eng %>"></td>
<td><input type = "text" name = "kor" class="form-control"
value = "<%= dicDAO.selectOne(idx).kor %>"></td>
</tr>
</table>
<div class = "text-right">
<button class = "btn btn-outline-secondary" type = "submit"> 확인 </button>
</div>
</form>
</div>
</body>
</html>
|
|
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
|
<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="EUC-KR">
<title>Insert title here</title>
</head>
<body>
<%
request.setCharacterEncoding("euc-kr");
String getIdx = request.getParameter("idx");
int idx = Integer.parseInt(getIdx);
String eng = request.getParameter("eng");
String kor = request.getParameter("kor");
// System.out.println(eng + " <-- eng dicUpdateAction.jsp");
// System.out.println(kor + " <-- kor dicUpdateAction.jsp");
DicDTO dicDTO = new DicDTO();
dicDTO.eng = eng;
dicDTO.kor = kor;
dicDTO.idx = idx;
DicDAO dicDAO = new DicDAO();
response.sendRedirect(request.getContextPath() + "/dicList.jsp");
%>
</body>
</html>
|
'교육 > Java' 카테고리의 다른 글
| #56 Java 다형성과 캐스팅 (0) | 2019.08.05 |
|---|---|
| #51 Java CRUD기능의 간단한 사전 만들기 Delete (0) | 2019.08.01 |
| #49 Java CRUD기능의 간단한 사전 만들기 Create (0) | 2019.08.01 |
| #48 Java CRUD기능의 간단한 사전 만들기 Read (0) | 2019.08.01 |
| #47 Java Servlet 기본 개념 (0) | 2019.08.01 |