21_02_jsp만_ update처리_jsp
2022. 2. 2. 11:54ㆍksmart_jsp/05_jsp_mysql
728x90
1. 수정화면에서 수정 처리 버튼 클릭 시 post 방식으로 전송한다.
2. 5개의 입력자료를 받아서 콘솔창에 확인한다.
3. 드라이버 로딩
4. DB 연결
5. UPDATE 쿼리 실행 준비
6. UPDATE 쿼리 실행
7. 객체 종료
//m_update_form.jsp
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.SQLException"%>
회원수정화면
<%
String send_id = request.getParameter("send_id");
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String dbid = null;
String dbpw = null;
String dblevel = null;
String dbname = null;
String dbemail = null;
Class.forName("com.mysql.jdbc.Driver");
String jdbcDriver = "jdbc:mysql://localhost:3306/dev42db?" + "useUnicode=true&characterEncoding=euckr";
String dbUser = "dev42id";
String dbPass = "dev42pw";
conn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);
pstmt = conn.prepareStatement("SELECT *FROM tb_member WHERE m_id=?");
pstmt.setString(1, send_id);
System.out.println(pstmt);
rs = pstmt.executeQuery();
if (rs.next()) {
dbid = rs.getString("m_id");
dbpw = rs.getString("m_pw");
dblevel = rs.getString("m_level");
dbname = rs.getString("m_name");
dbemail = rs.getString("m_email");
}
rs.close();
pstmt.close();
conn.close();
%>
<form action="<%=request.getContextPath()%>/mupdate/m_update_action.jsp" method="post">
<table border="1">
<tr>
<td>아이디</td>
<td><input type="text" name="m_id2" size="20" value="<%=dbid%>" readonly></td>
<tr>
<tr>
<td>암호</td>
<td><input type="text" name="m_pw2" size="20" value="<%=dbpw%>"></td>
<tr>
<tr>
<td>권한</td>
<td><input type="text" name="m_level2" size="20" value="<%=dblevel%>"></td>
<tr>
<tr>
<td>이름</td>
<td><input type="text" name="m_name2" size="20" value="<%=dbname%>"></td>
<tr>
<tr>
<td>이메일</td>
<td><input type="text" name="m_email2" size="20" value="<%=dbemail%>"></td>
<tr>
<tr>
<td colspan="4"><input type="submit" value="회원수정버튼"></td>
</tr>
</table>
</form>//m_update_action.jsp
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%
request.setCharacterEncoding("euc-kr");
String m_id = request.getParameter("m_id");
String m_pw = request.getParameter("m_pw");
String m_level = request.getParameter("m_level");
String m_name = request.getParameter("m_name");
String m_email = request.getParameter("m_email");
Connection conn = null;
PreparedStatement pstmt = null;
Class.forName("com.mysql.jdbc.Driver");
String jdbcDriver = "jdbc:mysql://localhost:3306/dev42db?" + "useUnicode=true&characterEncoding=euckr";
String dbUser = "dev42id";
String dbPass = "dev42pw";
conn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);
pstmt = conn.prepareStatement("UPDATE tb_member SET m_pw=?,m_level=?,m_name=?,m_email=? WHERE m_id=?");
pstmt.setString(1, m_pw);
pstmt.setString(2, m_level);
pstmt.setString(3, m_name);
pstmt.setString(4, m_email);
pstmt.setString(5, m_id);
int result = pstmt.executeUpdate();
System.out.println(result);
pstmt.close();
conn.close();
%>728x90
'ksmart_jsp > 05_jsp_mysql' 카테고리의 다른 글
| 23_jsp만_search처리_jsp (0) | 2022.02.02 |
|---|---|
| 22_jsp만_delete처리_jsp (0) | 2022.02.02 |
| 21_01_jsp만_ update화면_jsp (0) | 2022.02.02 |
| 20_jsp만_list처리_jsp (0) | 2022.02.02 |
| 19_jsp만_insert처리_jsp (0) | 2022.02.02 |