member/modify.jsp > JSP2

• 목록

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<%@ include file="/include/header.jsp" %>

<%

String sql=" select * from member where m_id = '"+session_id+"' ";

Connection conn=DriverManager.getConnection(url, user, password);

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sql);

//전역 변수

String member_id="";

String member_name="";

String member_email="";

if(rs.next()){

member_id = rs.getString("m_id");

member_name = rs.getString("m_name");

member_email = rs.getString("m_email");

}

rs.close();

stmt.close();

conn.close();

%>

<table width=100% height=50 border=0>

<tr>

<td align=center style="color:#777;font-size:14px;font-weight:bold;">[회원수정]</td>

</tr>

</table>

<center>

<form action="update.jsp" method="post">

<table width="500" border="0" cellpadding="0" cellspacing="0">

<tr>

<td colspan=2 height=30 style="color:#4b8b99;font-size:13px;font-weight:bold;">사이트 이용정보 입력</td>

</tr>

<tr><td colspan=2 height=1 bgcolor=e9e9e9></td></tr>

<tr>

<td width=100 height=26><b>아이디</b></td>

<td>

<input type="text" name="mb_id" value="<%=member_id %>" readonly style="height:18px;width:50%;border:1px solid #e9e9e9;background:#f7f7f7;">

</td>

</tr>

<tr><td colspan=2 height=1 bgcolor=e9e9e9></td></tr>

<tr>

<td height=26><b>비밀번호</b></td>

<td><input type="password" name="mb_password" style="height:18px;width:50%;border:1px solid #e9e9e9;background:#f7f7f7;"></td>

</tr>

<tr><td colspan=2 height=1 bgcolor=e9e9e9></td></tr>

<tr><td colspan=2 height=15></td></tr>

<tr>

<td colspan=2 height=30 style="color:#4b8b99;font-size:13px;font-weight:bold;">개인정보 입력</td>

</tr>

<tr><td colspan=2 height=1 bgcolor=e9e9e9></td></tr>

<tr>

<td height=26><b>이름</b></td>

<td><input name="mb_name" value="<%=member_name %>" style="height:18px;width:50%;border:1px solid #e9e9e9;background:#f7f7f7;"></td>

</tr>

<tr><td colspan=2 height=1 bgcolor=e9e9e9></td></tr>         

<tr>

<td height=26><b>E-mail</b></td>

<td><input type="email" name="mb_email" value="<%=member_email %>" style="height:18px;width:96%;border:1px solid #e9e9e9;background:#f7f7f7;"></td>

</tr>

<tr><td colspan=2 height=1 bgcolor=e9e9e9></td></tr>

</table>

<br>

<table widtd="96%" border="0" cellpadding="0" cellspacing="0" align=center>

<tr>

<td><button>회원수정</button></td>

</tr>

</table>

<br>

</form>

</center>

<%@ include file="/include/footer.jsp" %>