30_jsp_java_DTO(bean)_update처리_jsp
2022. 2. 5. 17:27ㆍksmart_jsp/06_jsp_java_mysql_model01
728x90
29단계 참고해서 m_update_action.jsp DTO 한다
2022.02.05 - [jsp/06_jsp_java_mysql_model01] - 29_jsp_java_DTO(bean)_insert처리_jsp
29단계_jsp_java_DTO(bean)_insert처리_jsp
JSP 액션태그와 JavaBean , DTO&DAO 이론 2022.02.05 - [jsp] - JavaBean, DTO& DAO_jsp JavaBean, DTO& DAO_jsp JavaBean DTO 클래스로서 자바빈의 규격서에 따라 작성된 클래스 더보기 DTO는 Data Transfer Obje..
moon09-developer.tistory.com
<%@ 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 = "kr.or.ksmart.driverdb.DriverDB" %>
<jsp:useBean id="m" class="kr.or.ksmart.dto.Member" />
<jsp:setProperty name="m" property="*" />
<%
request.setCharacterEncoding("euc-kr");
Connection conn = null;
PreparedStatement pstmt = null;
DriverDB db=new DriverDB();
conn=db.driverDbcon();
pstmt = conn.prepareStatement("UPDATE tb_member SET m_pw=?,m_level=?,m_name=?,m_email=? WHERE m_id=?");
pstmt.setString(1, m.getM_pw());
pstmt.setString(2, m.getM_level());
pstmt.setString(3, m.getM_name());
pstmt.setString(4, m.getM_email());
pstmt.setString(5, m.getM_id());
int result = pstmt.executeUpdate();
System.out.println(result);
pstmt.close();
conn.close();
response.sendRedirect(request.getContextPath()+"/msearch/m_search_list.jsp");
%>728x90
'ksmart_jsp > 06_jsp_java_mysql_model01' 카테고리의 다른 글
| 32_jsp_java_DTO(bean)_DAO_list처리_jsp (0) | 2022.02.05 |
|---|---|
| 31_jsp_java_DTO(bean)_DAO_insert처리_jsp (0) | 2022.02.05 |
| url 주소 가져오는 함수_jsp (0) | 2022.02.05 |
| 29_jsp_java_DTO(bean)_insert처리_jsp (0) | 2022.02.05 |
| 28참조 (0) | 2022.02.05 |