modify.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%!
Connection dbconn;
Statement stmt;
ResultSet rs;
String name,id,pw,hp,hp2,hp3,gender;
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
id = (String)session.getAttribute("id");
String sql="select * from member where id='"+id+"'";
Class.forName("oracle.jdbc.driver.OracleDriver");
dbconn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","1234");
stmt = dbconn.createStatement();
rs = stmt.executeQuery(sql);
//while(rs.next()){
rs.next();
name = rs.getString("name");
pw = rs.getString("pw");
hp = rs.getString("hp");
hp2 = rs.getString("hp2");
hp3 = rs.getString("hp3");
gender = rs.getString("gender");
//}
%>
<%=name%>
<%=pw %>
<%=hp %>
<%=hp2 %>
<%=hp3 %>
<%=gender %>
<center>
<hr width = 500 size=2 color="blue">
<h2>회원 가입</h2>
<hr width = 500 size=2 color="blue">
<form action="ModifyOK" method="post">
이름 : <input type="text" name="name" value="<%=name%>" size="20"><br />
아이디 :<input type="text" name="id" value="<%=id%>" size="20"><br />
비밀번호 :<input type="password" name="pw" size="20"><br/>
전화번호 :<select name = "hp">
<option value="010">010</option>
<option value="016">016</option>
<option value="017">017</option>
<option value="018">018</option>
<option value="019">019</option>
</select>
<input type="text" name="hp2" value="<%=hp2%>" size="4">-<input type="text" name="hp3" value="<%=hp3%>" size=4><br/>
성별 :
<input type="radio" name="gender" value="man" <%if(gender.equals("man")){%>checked="checked"<%}%>>남
<input type="radio" name="gender" value="woman" <%if(gender.equals("woman")){%>checked="checked"<%}%>>여<br/>
<input type="submit" value="수정"> <input type="reset" value="취소">
</form>
</center>
</body>
</html>
---------------------------------------------------------------------------------------
ModifyOK.java
package com.test.ex;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
/**
* Servlet implementation class ModifyOK
*/
@WebServlet("/ModifyOK")
public class ModifyOK extends HttpServlet {
private static final long serialVersionUID = 1L;
private Connection dbconn;
private Statement stmt;
private String name,id,pw,hp,hp2,hp3,gender;
HttpSession httpSession;
/**
* @see HttpServlet#HttpServlet()
*/
public ModifyOK() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
modifyDo(request, response);
}
private void modifyDo(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
request.setCharacterEncoding("UTF-8");
httpSession = request.getSession();
name = request.getParameter("name");
id = request.getParameter("id");
pw = request.getParameter("pw");
hp = request.getParameter("hp");
hp2 = request.getParameter("hp2");
hp3 = request.getParameter("hp3");
gender = request.getParameter("gender");
if(pwCheck()){
System.out.println("Ok");
String sql = "update member set name='"+name+"',hp='"+hp+"',hp2='"+hp2+"',hp3='"+hp3+"',gender='"+gender+"' where id='"+id+"'";
System.out.println(sql);
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
dbconn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "scott","1234");
stmt = dbconn.createStatement();
int n = stmt.executeUpdate(sql);
if(n>0){
System.out.println("정상수정");
httpSession.setAttribute("name",name);
response.sendRedirect("modifyRes.jsp");
}else{
System.out.println("수정오류");
response.sendRedirect("modify.jsp");
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if(stmt!=null) stmt.close();
if(dbconn!=null) dbconn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}else{
System.out.println("패스워드 확인요망");
}
}
private boolean pwCheck(){
boolean bool=false;
String sessionPw = (String)httpSession.getAttribute("pw");
if(sessionPw.equals(pw)){
bool=true;
}else{
bool=false;
}
return bool;
}
}
------------------------------------------------------------------------------------------------------
modifyRes.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%=session.getAttribute("name") %>님 정보수정완료.
<a href="logout.jsp">로그아웃</a>
</body>
</html>
-------------------------------------------------------------------------------------------------------
logout.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
session.invalidate();
response.sendRedirect("login.html");
%>
</body>
</html>
'기존카테고리 > JSP' 카테고리의 다른 글
| 커넥션 풀 설정 방법 (0) | 2017.06.07 |
|---|---|
| 리스트 출력 DTO,DAO,memberView.jsp (0) | 2017.06.07 |
| 로그인 입력, 처리페이지 (0) | 2017.06.07 |
| [회원가입] 회원가입 폼, 입력 (0) | 2017.06.07 |
| [회원가입1]join.html, joinOK.java (0) | 2017.06.06 |