JSP
[JSP + MySQL] 200416 dto dao // select 쿼리 분리
N'Che
2020. 4. 16. 12:25
select 쿼리 분리
package kr.or.ksmart.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import kr.or.ksmart.driverdb.DriverDB;
import kr.or.ksmart.dto.Member;
//04_01 수정화면(한명 회원 정보 조회) 메서드 선언
//return data type, 입력개수, 매개변수 data type, 처리과정 ?
public Member mSelectforUpdate (String mid) throws ClassNotFoundException, SQLException {
System.out.println("04 mSelectforUpdate Mdao.java");
System.out.println(mid);
Member m = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
DriverDB db = new DriverDB();
Connection conn = db.driverDbcon();
System.out.println(conn);
pstmt = conn.prepareStatement("select * from tb_member WHERE m_id = ?");
pstmt.setString(1, mid);
System.out.println(pstmt + "<-- pstmt");
rs = pstmt.executeQuery();
System.out.println(rs + "<-- rs");
if(rs.next()){
System.out.println("-------------if 조건문 통과-------------");
m = new Member();
m.setM_id(rs.getString("m_id"));
m.setM_pw(rs.getString("m_pw"));
m.setM_level(rs.getString("m_level"));
m.setM_name(rs.getString("m_name"));
m.setM_email(rs.getString("m_email"));
System.out.println(m.getM_id() + "<- m.setM_id");
System.out.println(m.getM_pw() + "<- getM_pw");
System.out.println(m.getM_level() + "<- getM_level");
System.out.println(m.getM_name() + "<- getM_name");
System.out.println(m.getM_email() + "<- getM_email");
System.out.println("-------------if 조건문 끝-------------");
}
pstmt.close();
conn.close();
return m;
}<%@ 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.SQLException" %>
<%@ page import="kr.or.ksmart.dao.Mdao"%>
<%@ page import="kr.or.ksmart.dto.Member" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>Insert title here</title>
<link rel="stylesheet" type="text/css" href="<%= request.getContextPath() %>/css/main.css" />
</head>
<body>
<%@ include file="/module/top.jsp" %>
<%@ include file="/module/left.jsp" %>
<%
String send_id = request.getParameter("send_id");
System.out.println(send_id);
System.out.println("-------------수정 화면 코드 시작-------------");
Mdao mdao = new Mdao();
Member m = mdao.mSelectforUpdate(send_id);
System.out.println(m + "m");
System.out.println(m.getM_id() + "getM_id" );
System.out.println(m.getM_pw() + "getM_pw");
System.out.println(m.getM_level() + "getM_level");
System.out.println(m.getM_name() + "getM_name");
System.out.println(m.getM_email() + "getM_email");
System.out.println("-------------이후 화면-------------");
%>
<%--
아이디 : <%= m.getM_id()%><br>
패스워드 : <%=m.getM_pw()%><br>
권한 : <%=m.getM_level()%><br>
이름 : <%=m.getM_name()%><br>
이메일 : <%=m.getM_email()%>
--%>
<form action="<%= request.getContextPath() %>/mupdate/m_update_pro.jsp" method="post">
<table border="1">
<tr>
<td>아이디</td>
<td><input type="text" name="m_id" size="20" value="<%= m.getM_id()%>" readonly></td>
<tr>
<tr>
<td>암호</td>
<td><input type="text" name="m_pw" size="20" value="<%= m.getM_pw() %>"></td>
<tr>
<tr>
<td>권한</td>
<td><input type="text" name="m_level" size="20" value="<%= m.getM_level() %>"></td>
<tr>
<tr>
<td>이름</td>
<td><input type="text" name="m_name" size="20" value="<%= m.getM_name() %>"></td>
<tr>
<tr>
<td>이메일</td>
<td><input type="text" name="m_email" size="20" value="<%= m.getM_email() %>"></td>
<tr>
<tr>
<td colspan="4"><input type="submit" value="회원수정버튼"></td>
</tr>
</table>
</form>
<%@ include file="/module/hadan.jsp" %>
</body>
</html>
