미안 멍청해서.;;
검색해도 모르겠다
로그인해서 회원정보 수정하는거 만들려고하는데
회원정보 입력한거 어케 가져오냐..
계속 에러나
<%@ page import=\"java.sql.*\" contentType=\"text/html;charset=utf-8\" %>
<%
String sessionid=(String)session.getAttribute(\"sessionid\");
if(sessionid==null) {
%>
< language=>
alert(\"이 페이지를 보실 수 없습니다\");
document.href=\'login.jsp\';
</>
<%
}
%>
<%
try {
Class.forName(\"com.mysql.jdbc.Driver\");
Connection con = DriverManager.getConnection(\"jdbc:mysql://localhost/memberdb\",\"root\",\"\");
String ID=null;
String RRN=null;
String name=null;
String nic=null;
String password=null;
String phone=null;
String email=null;
String address1=null;
String address2=null;
String sql = \"INSERT INTO person (ID, RRN,Name, nic, password,phone,email,address1, address2) values(?,?,?,?,?,?,?,?,?)\"; // sql문 작성(id와 name, pwd값들을 보내기위한 작업)
PreparedStatement pstmt=con.PrepareStatement(sql);
ResultSet rs=pstmt.executeQuery(\"select * from person where id=\'\"+sessionid+\"\'\");
if(rs.next()) {
ID=rs.getString(1);
RRN=rs.getString(2);
name=rs.getString(3);
nic=rs.getString(4);
password=rs.getString(5);
phone=rs.getString(6);
email=rs.getString(7);
address1=rs.getString(8);
address2=rs.getString(9);
%>
<html>
<head>
<title>회원 가입</title>
< language=>
function check() {
if(document.mform.id.value.length==0) {
alert(\"아이디를 입력해주세요\");
mform.id.focus();
return false;
}
if(document.mform.pri_num.value.length==0) {
alert(\"주민번호를 입력해주세요\");
mform.pri_num.focus();
return false;
}
if(document.mform.name.value.length==0) {
alert(\"이름을 입력해주세요\");
mform.name.focus();
return false;
}
if(document.mform.nic.value.length==0) {
alert(\"닉네임을 입력해주세요\");
mform.nic.focus();
return false;
}
if(document.mform.password.value.length==0) {
alert(\"패스워드를 입력해주세요\");
mform.password.focus();
return false;
}
if(document.mform.phone.value.length==0) {
alert(\"휴대폰 번호를 정확히 입력해주세요\");
mform.phone.focus();
return false;
}
if(document.mform.mail.value.length==0) {
alert(\"메일주소를 정확히 입력해주세요\");
mform.mail.focus();
return false;
}
if(document.mform.address1.value.length==0) {
alert(\"주소를 입력해주세요\");
mform.address1.focus();
return false;
}
if(document.mform.address2.value.length==0) {
alert(\"상세주소를 정확히 입력해주세요\");
mform.address2.focus();
return false;
}
document.mform.submit();
}
</>
</head>
<body style=\"font-family:돋움;\" =\":document.mform.mem_id.focus();\">
<center>
<b>회원 가입</b><br>
<form action=\"member_modify_act.jsp\" method=\"post\" name=\"process\">
<table border=\"0\">
<tr>
<td><SPAN style=\"COLOR: #ff0000\"> *</SPAN>아이디</td>
<td><input type=\"text\" name=\"id\" size=\"10\"><br/></td></tr>
<tr>
<td><SPAN style=\"COLOR: #ff0000\"> *</SPAN>주민등록번호</td>
<td><input type=\"text\" name=\"pri_num\" size=\"15\"></td></tr>
<tr>
<td><SPAN style=\"COLOR: #ff0000\"> *</SPAN>이름</td>
<td><input type=\"text\" name=\"name\"size=\"7\"><br/></td></tr>
<tr>
<td><SPAN style=\"COLOR: #ff0000\"> *</SPAN>닉네임</td>
<td><input type=\"text\" name=\"nic\" size=\"10\"><br/></td></tr>
<tr>
<td><SPAN style=\"COLOR: #ff0000\"> *</SPAN>비밀번호</td>
<td><input type=\"password\" name=\"pw\"><br/></td></tr>
<tr>
<td><SPAN style=\"COLOR: #ff0000\"> *</SPAN>휴대폰번호</td>
<td><input type=\"text\" name=\"phone\" SIZE=15 ></td></tr>
<tr>
<td><SPAN style=\"COLOR: #ff0000\"> *</SPAN>E-mail</td>
<td><input type=\"text\" name=\"mail\">
</tr>
<tr>
<td><SPAN style=\"COLOR: #ff0000\"> *</SPAN>주소</td>
<td><input type=\"text\" name=\"address1\" size=\"35\"></td></tr>
<td><SPAN style=\"COLOR: #ff0000\"> *</SPAN>상세주소</td>
<td><input type=\"text\" name=\"address2\"size=\"50\"><br/>▲ 근거리 병원 조회를 위해 입력하시기 바랍니다. </td></tr>
</table>
<input type=\"button\" value =\"수정하기\" =check()>
<input type=\"reset\" value =\"새로 작성\" name=\"resetbtn\">
<br/>
<br/>
</form>
<br>
</center>
</body>
</html>
<%
}
pstmt.close();
rs.close();
} catch (SQLException e) {
out.println(e);
}
%>
댓글 0