21_01_jsp만_ update화면_jsp

2022. 2. 2. 11:54ㆍksmart_jsp/05_jsp_mysql

728x90

 

폴더명 mupdate
수정화면 m_update_form.jsp
수정처리 m_update_action.jsp 
//m_update_form.jsp
<%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%>
<!DOCTYPE html>
<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"></td>
<tr>
<tr>
    <td>암호</td>
    <td><input type="text" name="m_pw2" size="20"></td>
<tr>
<tr>
	<td>권한</td>
	<td><input type="text" name="m_level2" size="20"></td>
<tr>
<tr>
	<td>이름</td>
	<td><input type="text" name="m_name2" size="20"></td>
<tr>
<tr>
	<td>이메일</td>
	<td><input type="text" name="m_email2" size="20""></td>
<tr>
<tr>
	<td colspan="4"><input type="submit" value="회원수정버튼"></td>
</tr>
</table>
</form>

 1. 수정버튼 클릭 시 get 방식으로 아이디 값을 넘긴다. 

//m_list.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"%>

회원 리스트
<br>
<table width="100%" border="1">
  <tr>
    <td>아이디</td>
    <td>비번</td>
    <td>권한</td>
    <td>이름</td>
    <td>이메일</td>
//1. 수정버튼 클릭 시 get 방식으로 아이디 값을 넘긴다.
    <td>수정</td>
////
  </tr>
<% 
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rs = 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");

  rs = pstmt.executeQuery();

  while (rs.next()) {
%>
  <tr>
    <td><%=rs.getString("m_id")%></td>
    <td><%=rs.getString("m_pw")%></td>
    <td><%=rs.getString("m_level")%></td>
    <td><%=rs.getString("m_name")%></td>
    <td><%=rs.getString("m_email")%></td>
//1. 수정버튼 클릭 시 get 방식으로 아이디 값을 넘긴다.
    <td><a href="<%=request.getContextPath()%>/mupdate/m_update_form.jsp?send_id=<%=rs.getString("m_id")%>">수정버튼</a></td>
////
  </tr>
<%
  }
  rs.close();
  pstmt.close();
  conn.close();
%>
</table>

 2. 아이디 값을 받아서 콘솔창에 확인한다. 

//m_update_form.jsp
<%
   String send_id = request.getParameter("send_id");
   System.out.println(send_id+"<-send_id m_update_form.jsp");
%>

 3. 드라이버 로딩, DB 연결 

<%@ 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");
//03 드라이버 로딩, DB 연결
  Connection conn = 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);
////
%>
<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"></td>
<tr>
<tr>
  <td>암호</td>
  <td><input type="text" name="m_pw2" size="20"></td>
<tr>
<tr>
  <td>권한</td>
  <td><input type="text" name="m_level2" size="20"></td>
<tr>
<tr>
  <td>이름</td>
  <td><input type="text" name="m_name2" size="20"></td>
<tr>
<tr>
  <td>이메일</td>
  <td><input type="text" name="m_email2" size="20"></td>
<tr>
<tr>
  <td colspan="4"><input type="submit" value="회원수정버튼"></td>
</tr>
</table>
</form>

 4. 쿼리 실행  

한명의 회원을 조회하는 select 쿼리

SELECT * FROM tb_member WHERE m_id='id001';

<%@ 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;
//04 쿼리 실행
  ResultSet rs = 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);
//04 쿼리 실행
  pstmt = conn.prepareStatement("SELECT *FROM tb_member WHERE m_id=?");
  pstmt.setString(1, send_id);
  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");
  } 
////
%>
<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"></td>
<tr>
<tr>
  <td>암호</td>
  <td><input type="text" name="m_pw2" size="20"></td>
<tr>
<tr>
  <td>권한</td>
  <td><input type="text" name="m_level2" size="20"></td>
<tr>
<tr>
  <td>이름</td>
  <td><input type="text" name="m_name2" size="20"></td>
<tr>
<tr>
  <td>이메일</td>
  <td><input type="text" name="m_email2" size="20"></td>
<tr>
<tr>
  <td colspan="4"><input type="submit" value="회원수정버튼"></td>
</tr>
</table>
</form>

 5. 쿼리 실행 결과  

 6. 객체 종료 

<%@ 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;
  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);
  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");
  }
//6 객체 종료
  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>

 

728x90

'ksmart_jsp > 05_jsp_mysql' 카테고리의 다른 글

22_jsp만_delete처리_jsp  (0) 2022.02.02
21_02_jsp만_ update처리_jsp  (0) 2022.02.02
20_jsp만_list처리_jsp  (0) 2022.02.02
19_jsp만_insert처리_jsp  (0) 2022.02.02
JDBC 프로그램 순서  (0) 2022.02.02

관련글

댓글 0

티스토리툴바