본문 바로가기
IT&코딩/자바 프로젝트

자바 프로젝트 5일차 - JSP 복습 3 (jspMember)

솔론 2023. 1. 24. 19:32
728x90
반응형

■ jspMember

 

□ member package

 

* MemberDTO.java

 

package member;

public class MemberDTO {
	
	private int no;
	private String name;
	private String id;
	private String passwd;
	private String ssn1;
	private String ssn2;
	private String email;
	private String hp1;
	private String hp2;
	private String hp3;
	private String joindate;
	
	public int getNo() {
		return no;
	}
	public void setNo(int no) {
		this.no = no;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getPasswd() {
		return passwd;
	}
	public void setPasswd(String passwd) {
		this.passwd = passwd;
	}
	public String getSsn1() {
		return ssn1;
	}
	public void setSsn1(String ssn1) {
		this.ssn1 = ssn1;
	}
	public String getSsn2() {
		return ssn2;
	}
	public void setSsn2(String ssn2) {
		this.ssn2 = ssn2;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getHp1() {
		return hp1;
	}
	public void setHp1(String hp1) {
		this.hp1 = hp1;
	}
	public String getHp2() {
		return hp2;
	}
	public void setHp2(String hp2) {
		this.hp2 = hp2;
	}
	public String getHp3() {
		return hp3;
	}
	public void setHp3(String hp3) {
		this.hp3 = hp3;
	}
	
	public String getAllHp() {
		if(hp1 == null) return "전화없음";
		return hp1+"-"+hp2+"-"+hp3;
	}
	
	public String getJoindate() {
		return joindate;
	}
	public void setJoindate(String joindate) {
		this.joindate = joindate;
	}
	
	
}

 

* MemberDAO.java

 

package member;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import board.BoardDTO;

public class MemberDAO {
	Connection con;
	PreparedStatement ps;
	ResultSet rs;
	
	String url, user, pass;
	
	private String search, searchString;
	
	public void setSearch(String search) {
		this.search = search;
	}

	public void setSearchString(String searchString) {
		this.searchString = searchString;
	}

	public MemberDAO() {
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		}catch(ClassNotFoundException e) {
			e.printStackTrace();
		}
		url = "jdbc:oracle:thin:@localhost:1521:xe";
		user = "web01";
		pass = "web01";
	}
	
	public boolean checkMember(String name, String ssn1, String ssn2) throws SQLException{
		try {
			con = DriverManager.getConnection(url, user, pass);
			String sql = "select * from member where ssn1=? and ssn2=?";
			ps = con.prepareStatement(sql);
			
			ps.setString(1, ssn1);
			ps.setString(2, ssn2);
			rs = ps.executeQuery();
			
			if(rs.next()) {
				return true;
			}
			return false;
			
		}finally {
			if (rs != null) rs.close();
			if (ps != null) ps.close();
			if (con != null) con.close();
		}
	}
	
	public int insertMember(MemberDTO dto) throws SQLException{
		try {
			con = DriverManager.getConnection(url, user, pass);
			String sql = "insert into member values(member_seq.nextval,?,?,?,?,?,?,?,?,?,sysdate)";
			ps = con.prepareStatement(sql);
			ps.setString(1, dto.getName());
			ps.setString(2, dto.getId());
			ps.setString(3, dto.getPasswd());
			ps.setString(4, dto.getSsn1());
			ps.setString(5, dto.getSsn2());
			ps.setString(6, dto.getEmail());
			ps.setString(7, dto.getHp1());
			ps.setString(8, dto.getHp2());
			ps.setString(9, dto.getHp3());
			int res = ps.executeUpdate();
			return res;
		} finally {
			if (ps != null) ps.close();
			if (con != null) con.close();
		}
	}
	
	public List<MemberDTO> makeList(ResultSet rs) throws SQLException{
		List<MemberDTO> list = new ArrayList<>();
		
		while(rs.next()) {
			MemberDTO dto = new MemberDTO();
			dto.setNo(rs.getInt(1));
			dto.setName(rs.getString(2));
			dto.setId(rs.getString(3));
			dto.setPasswd(rs.getString(4));
			dto.setSsn1(rs.getString(5));
			dto.setSsn2(rs.getString(6));
			dto.setEmail(rs.getString(7));
			dto.setHp1(rs.getString(8));
			dto.setHp2(rs.getString(9));
			dto.setHp3(rs.getString(10));
			dto.setJoindate(rs.getString(11));
			list.add(dto);
			
		}
		return list;
	}
	
	public List<MemberDTO> listMember() throws SQLException{
		try {
			con = DriverManager.getConnection(url, user, pass);
			String sql = "select * from member";
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			List<MemberDTO> list = makeList(rs);
			return list;
			
		} finally {
			if (rs != null) rs.close();
			if (ps != null) ps.close();
			if (con != null) con.close();
		}
	}
	
	public int deleteMember(int no) throws SQLException{
		try {
			con = DriverManager.getConnection(url, user, pass);
			String sql = "delete from member where no = ?";
			ps = con.prepareStatement(sql);
			ps.setInt(1, no);
			int res = ps.executeUpdate();
			return res;
		} finally {
			if (ps != null) ps.close();
			if (con != null) con.close();
		}
	}
	
	public MemberDTO getMember(int no) throws SQLException{
		try {
			
			con = DriverManager.getConnection(url, user, pass);
			String sql = "select * from member where no = ?";
			ps = con.prepareStatement(sql);
			ps.setInt(1, no);
			rs = ps.executeQuery();
			List<MemberDTO> list = makeList(rs);
			return list.get(0);
			
		}finally {
			if (rs != null) rs.close();
			if (ps != null) ps.close();
			if (con != null) con.close();
		}
	}
	
	public int updateMember(MemberDTO dto) throws SQLException{
		
		try {
			con = DriverManager.getConnection(url, user, pass);
			String sql = "update member set passwd = ?, email = ?, hp1 = ?, hp2 = ?, hp3 = ? where no = ?";
			ps = con.prepareStatement(sql);
			
			ps.setString(1, dto.getPasswd());
			ps.setString(2, dto.getEmail());
			ps.setString(3, dto.getHp1());
			ps.setString(4, dto.getHp2());
			ps.setString(5, dto.getHp3());
			ps.setInt(6, dto.getNo());
			
			int res = ps.executeUpdate();
			return res;
		} finally {
			if (ps != null) ps.close();
			if (con != null) con.close();
		}
	}
	
	public List<MemberDTO> findMember() throws SQLException{
		try {
			con = DriverManager.getConnection(url, user, pass);
			String sql = "select * from member where "+search+" = ?";
			ps = con.prepareStatement(sql);
			ps.setString(1, searchString);
			rs = ps.executeQuery();
			
			List<MemberDTO> list = makeList(rs);
			return list;
			
		} finally {
			if (rs != null) rs.close();
			if (ps != null) ps.close();
			if (con != null) con.close();
		}
	}
	
	public MemberDTO getMember(String id) throws SQLException {
		try {
			con = DriverManager.getConnection(url, user, pass);
			String sql = "select * from member where id = ?";
			ps = con.prepareStatement(sql);
			ps.setString(1, id);
			rs = ps.executeQuery();
			List<MemberDTO> list = makeList(rs);
			return list.get(0);
		}finally {
			if (rs != null) rs.close();
			if (ps != null) ps.close();
			if (con != null) con.close();
		}
	}
}

 

□ login package

 

* LoginCheck.java

 

package login;

import java.sql.*;

public class LoginCheck {
	public static final int OK = 0;
	public static final int NOT_ID = 1;
	public static final int NOT_PWD = 2;
	public static final int ERROR = -1;
	
	private String id;
	private String passwd;
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getPasswd() {
		return passwd;
	}
	public void setPasswd(String passwd) {
		this.passwd = passwd;
	}
	
	public int checkLogin() {
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con = DriverManager.getConnection
					("jdbc:oracle:thin:@localhost:1521:xe", "web01", "web01");
			String sql = "select passwd from member where id = ?";
			ps = con.prepareStatement(sql);
			ps.setString(1, id);
			rs = ps.executeQuery();
			if (rs.next()) {
				String dbPass = rs.getString(1);
				if (dbPass.equals(passwd)) {
					return OK;
				}else {
					return NOT_PWD;
				}
			}else {
				return NOT_ID;
			}
		}catch(Exception e) {
			e.printStackTrace();
			return ERROR;
		}finally {
			try {
				if (rs != null) rs.close();
				if (ps != null) ps.close();
				if (con != null) con.close();
			}catch(SQLException e) {}
		}
	}
	
	
}

 

 

□ jsp 페이지

 

* style.css

 

/*style.css
/*표준 글꼴 서식 스타일*/
h1,h2,h3,h4,h5,h6{
	font-family:verdana;
	color:navy;
}
body, td, input, select, textarea, p, th{
	font-size:13px;
	font-family:verdana;
	color:navy;
	padding:4px;
}

/*표준 링크 스타일*/
a:link{
	color:#000000; text-decoration:none;
	font-size:13px; font-family:verdana;
}
a:visited{
	color:red; text-decoration:none;
	font-size:13px; font-family:verdana;
}
a:hover{
	color:orange; text-decoration:underline;
	font-size:13px; font-family:verdana;
}

/*입력 양식 스타일 .은 class로 #은 id로*/
.box{
	border:1px solid navy;
	padding-left:8px;
}
.outline{
	border-top:4px double navy;
	border-bottom:4px double navy;
}
.m1{
background-color:#EAF0E8;
border-bottom:1px dotted #9933CC;
}
.m2{
background-color:#FFCC00;
border-bottom:1px dotted #9933CC;
}
.m3{
border-bottom:1px dotted navy;
}

 

* top.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="member.*"%>
<!-- top.jsp -->
<html>
<head>
<title>회원관리</title>
<script type="text/javascript">
	function checkMember(){
		window.open("<%=request.getContextPath()%>/member/memberSsn.jsp", "", "width=640, height=400")
	}
</script>
</head>

<%
	MemberDTO mdto = (MemberDTO)session.getAttribute("member");
	boolean isLogin = false;
	if(mdto != null){
		isLogin = true;
	}
%>

<body>
	<div align="center">
		<h2>회 원 관 리 프 로 그 램</h2>
		<table border="1" width="800" height="600">
			<tr height="50">
				<th>
				<%if(isLogin){ %>
					<a href="<%=request.getContextPath()%>/login/logout.jsp">로그아웃</a>
				<%}else { %>
					<a href="<%=request.getContextPath()%>/login/login.jsp">로그인</a>
				<%} %>
				</th>
				<th><a href="javascript:checkMember()">회원가입</a></th>
				<th><a href="<%=request.getContextPath() %>/member/memberAll.jsp">회원보기</a></th>
				<th><a href="<%=request.getContextPath()%>/member/memberAll.jsp?mode=find">회원찾기</a></th>
			</tr>
			<tr height="80%">
				<td colspan="4">

 

* bottom.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!-- bottom.jsp -->
</td>
			</tr>
			<tr height="50">
				<td align="center" colspan="4">아이티뱅크 1월 웹프로젝트 주말반</td>
			</tr>
		</table>
	</div>
</body>
</html>

 

* index.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!-- index.jsp -->
<%@ include file="top.jsp" %>
	<img src="image01.jpg" width="100%" height="500">
<%@ include file="bottom.jsp" %>

 

* image01.jpg - 자기가 메인에 뜨기를 원하는 이미지 파일 아무거나

 

 

□ login 폴더

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ include file="../top.jsp" %>   
<!-- login.jsp-->

<script type="text/javascript">
	function loginCheck(){
		if(f.id.value == ""){
			alert('아이디를 입력해주세요')
			f.id.focus()
			return;
		} 
		
		if(f.passwd.value == ""){
			alert('비밀번호를 입력해주세요')
			f.passwd.focus()
			return;
		}
		
		document.f.submit()
	}
</script>
<%
	// 클라이언트의 정보는 request에 담겨져있다.
	
	Cookie[] cks = request.getCookies();
	String value = null;
	if(cks != null || cks.length != 0){
		for(int i=0; i<cks.length; ++i){
			String name = cks[i].getName();
			if(name.equals("saveId")){
				value = cks[i].getValue();
				break;
			}
		}
	}
	
	
%>

<div align="center">
<br>
<img src="../img/bottom.gif" width=570 height="40" border="0" alt="">
<br>
<p>
<img src="../img/tm_login.gif" width=100 height="13" border="0" 
	align="center" ALT="회원 로그인">
<form name="f" action="login_ok.jsp" method="post">
	<table width="60%" align="center" height="120">
		<tr>
			<td align="right" width="30%">
				<img src="../img/id01.gif" 
				width="28" height="11" border="0" alt="아이디">&nbsp;&nbsp;
			</td>
			<td width="40%">
			<% if(value == null){ %>
				<input type="text" name="id" tabindex="1">
			<% } else{ %>
				<input type="text" name="id" tabindex="1" value="<%=value %>">
			<% } %>
			</td>
			<td rowspan="2" width="30%" valign="middle">
				<a href="javascript:loginCheck()">
					<img src="../img/bt_login.gif" border="0" alt="로그인"  tabindex="3">&nbsp;&nbsp;<br>
				</a>
				<nobr>
			<% if(value == null){ %>
					<input type="checkbox" name="saveId">
			<% } else{ %>
					<input type="checkbox" name="saveId" checked>
			<% } %>
					<font face="굴림" size="2">아이디 기억하기</font>
				</nobr>
			</td>
		</tr>
		<tr>
			<td align="right">
				<img src="../img/pwd.gif" 
							width="37" height="11" alt="비밀번호">
			</td>
			<td>
				<input type="password" name="passwd"  tabindex="2">
			</td>
		</tr>
		<tr>
			<td colspan="3" align="center">
				<a href="javascript:checkMember()">
					<img src="../img/bt_join.gif" width="60" height="22" alt="회원가입">
				</a>
 				<img src="../img/bt_search_id.gif" border="0" width="60" height="22" alt="아이디 찾기">
				<img src="../img/bt_search_pw.gif" border="0" width="60" height="22" alt="비밀번호 찾기">
	
			</td>
		</tr>
	</table>
</form> 
</div>
<%@ include file="../bottom.jsp" %>

 

* login_ok.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="login.*, member.*"%>

<!-- login_ok.jsp -->
<jsp:useBean id="loginCheck" class="login.LoginCheck"/>
<jsp:setProperty property="*" name="loginCheck"/>
<jsp:useBean id="mbdao" class="member.MemberDAO" />

<%
		String saveId = request.getParameter("saveId");

		int res = loginCheck.checkLogin();
		String msg = null, url = null;
		switch(res){
		case LoginCheck.OK :
			Cookie ck = new Cookie("saveId", loginCheck.getId());
			if(saveId != null){
				ck.setMaxAge(24 * 60 * 60);
			} else{
				ck.setMaxAge(0);
			}
			response.addCookie(ck);
			
			MemberDTO dto = mbdao.getMember(loginCheck.getId());
			session.setAttribute("member", dto);
			msg = dto.getName()+"님, 반갑습니다.";
			url = request.getContextPath()+"/index.jsp";
			break;
		case LoginCheck.NOT_ID :
			msg = "해당하는 아이디가 없습니다. 다시 확인 후 로그인을 해 주세요";
			url = "login.jsp";
			break;
		case LoginCheck.NOT_PWD :
			msg = "비밀번호가 틀렸습니다. 다시 확인 후 로그인을 해 주세요";
			url = "login.jsp";
			break;
		case LoginCheck.ERROR :
			msg = "DB 오류 발생!! 관리자에게 문의해 주세요";
			url = request.getContextPath()+"/index.jsp";
		}
			
%>
<script type="text/javascript">
	alert("<%=msg%>")
	location.href="<%=url%>"
</script>

 

* logout.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!-- logout.jsp -->
<%
	session.invalidate();
%>

<script type="text/javascript">
	alert('로그아웃 되었습니다.')
	location.href="<%=request.getContextPath()%>/index.jsp"
</script>

 

 

□ member 폴더

 

* memberSsn.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!-- memberSsn.jsp -->
<html>
<head>
	<title>회원가입 유무</title>
	<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
	<div align="center">
		<hr color="green" width="300">
		<h2>회 원 가 입 유 무</h2>
		<hr color="green" width="300">
		<form name="f" action="checkMember.jsp" method="post">
			<table border="0" width="500" class="outline">
				<tr>
					<th width="20%">이름</th>
					<td><input type="text" name="name" class="box"></td>
				</tr>
				<tr>
					<th width="20%">주민번호</th>
					<td><input type="text" name="ssn1" class="box" maxlength="6">
					<input type="password" name="ssn2" class="box" maxlength="7"></td>
				</tr>
				<tr>
					<td colspan="2" align="center">
						<input type="submit" value="조회">
						<input type="reset" value="다시입력">
					</td>
				</tr>
			</table>
		</form>
	</div>
</body>
</html>

 

* checkMember.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="member.*"%>
<!-- checkMember.jsp -->   
<%
	request.setCharacterEncoding("UTF-8");
	
	String name = request.getParameter("name");
	String ssn1 = request.getParameter("ssn1");
	String ssn2 = request.getParameter("ssn2");
	if(name == null || ssn1 == null || ssn2 == null 
			|| name.trim().equals("") || ssn1.trim().equals("") || ssn2.trim().equals("")){
		response.sendRedirect("memberSsn.jsp");
		return;
	}
%>

<jsp:useBean id="mbdao" class="member.MemberDAO"/>

<%
	boolean isMember = mbdao.checkMember(name, ssn1, ssn1);
	if(isMember){
%>
	<script type="text/javascript">
		alert('현재 회원이십니다. 로그인을 해주세요!')
		self.close()
	</script>
<%
	} else{
%>
	<form name="f" action="member_input.jsp" method="post">
		<input type="hidden" name="name" value="<%=name %>">
		<input type="hidden" name="ssn1" value="<%=ssn1 %>">
		<input type="hidden" name="ssn2" value="<%=ssn2 %>">
	</form>
	<script type="text/javascript">
		alert('회원이 아닙니다. 회원가입 페이지로 이동합니다.')
		document.f.submit()
	</script>
<%		
	}
%>

 

* member_input.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!-- member_input_ok.jsp -->
<html>
<head>
	<link rel="stylesheet" type="text/css" href="../style.css">
	<script type="text/javascript">
	function check(){
		if(f.id.value==""){
			alert('아이디를 입력해 주세요!')
			f.id.focus()
			return false
		}
		
		if(f.passwd.value==""){
			alert('비밀번호 입력해 주세요!')
			f.passwd.focus()
			return false
		}

		return true
	}
	</script>
</head>
<%
	request.setCharacterEncoding("UTF-8");
	
	String name = request.getParameter("name");
	String ssn1 = request.getParameter("ssn1");
	String ssn2 = request.getParameter("ssn2");
	if(name == null || ssn1 == null || ssn2 == null 
			|| name.trim().equals("") || ssn1.trim().equals("") || ssn2.trim().equals("")){
		response.sendRedirect("memberSsn.jsp");
		return;
	}
%>

<body>
<div align="center">
	<form name="f" action="member_input_ok.jsp" 
								method="post" onsubmit="return check()">
		<table width="80%" class="outline">
			<tr>
				<td colspan="2" align=center class="m2">회원가입</td>
			</tr>
			<tr>
				<th width="20%" class="m3">이름</th>
				<td><input type="text" class="box" name="name" value="<%= name%>" readOnly></td>
			</tr>
			<tr>
				<th class="m3">아이디</th>
				<td><input type="text" class="box" name="id"></td>
			</tr>
			<tr>
				<th class="m3">비밀번호</th>
				<td><input type="password" class="box" name="passwd"></td>
			</tr>
			<tr>
				<th class="m3">주민번호</th>
				<td><input type="text" class="box" name="ssn1" value="<%=ssn1 %>" readOnly>
					- <input type="password" class="box" name="ssn2" value="<%=ssn2 %>" readOnly></td>
			</tr>
			<tr>
				<th class="m3">이메일</th>
				<td><input type="text" class="box" name="email"></td>
			</tr>
			<tr>
				<th class="m3">전화번호</th>
				<td><input type="text" name="hp1" class="box" size="3" maxlength="3">
					-<input type="text" name="hp2" class="box" size="4" maxlength="4">
					-<input type="text" name="hp3" class="box" size="4" maxlength="4"></td>
			</tr>
			<tr>
				<td align="center" colspan="2" class="m2">
					<input type="submit" value="회원가입">
					<input type="reset" value="다시입력">
				</td>
			</tr>
		</table>
	</form>
</div>
</body>
</html>

 

* member_input_ok.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!-- member_input_ok.jsp -->
<%
	request.setCharacterEncoding("UTF-8");
%>

<jsp:useBean id="mbdto" class="member.MemberDTO" />
<jsp:setProperty property="*" name="mbdto"/>
<jsp:useBean id="mbdao" class="member.MemberDAO" />

<%
		if (mbdto.getName() == null || mbdto.getName().trim().equals("")){
			response.sendRedirect("memberSsn.jsp");
			return;
		}
		
		int res = mbdao.insertMember(mbdto);
		if(res > 0){
%>
			<script type="text/javascript">
				alert('회원가입 성공! 로그인을 해주세요')
				self.close()
			</script>
<%
		} else{	
%>
			<script type="text/javascript">
				alert('회원가입 실패! 다시 시도해보세요')
				location.href="memberSsn.jsp"
			</script>
<%
		}
%>

 

* memberAll.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="member.*, java.util.* "%>
<!-- memberAll.jsp -->
<%@ include file="../top.jsp"%>

<%
	request.setCharacterEncoding("UTF-8");
	String mode = request.getParameter("mode");
	if(mode == null){
		mode = "all";
	}
%>
<jsp:useBean id="mbdao" class="member.MemberDAO"/>	
<jsp:setProperty property="*" name="mbdao"/>

<div align="center">
	<hr color="green" width="300">
<% if(mode.equals("all")){ %>
	<h2>회 원 목 록 보 기</h2>
<% } else{ %>
	<h2>회 원 찾 기</h2>
	<form name="f" method="post">
		<select name="search">
			<option value="id">아이디</option>
			<option value="name">이름</option>
		</select>
		<input type="text" name="searchString">
		<input type="submit" value="찾기">
	</form>


<% } %>
	<hr color="green" width="300">
	<table border="1" width="100%">
		<tr>
			<th>번호</th>
			<th>이름</th>
			<th>아이디</th>
			<th>이메일</th>
			<th>전화번호</th>
			<th>가입일</th>
			<th>수정 | 삭제</th>
		</tr>	

<%
	List<MemberDTO> list = null;			
	if (mode.equals("all")){
		list = mbdao.listMember();
	} else{
		list = mbdao.findMember(); 
	}
	
	if (list == null || list.size() == 0){
%>
	<tr>
		<td colspan="7">등록된 회원이 없습니다.</td>
	</tr>
<%		
	} else{
		for(MemberDTO dto : list){
%>
	<tr>
			<td><%=dto.getNo() %></td>
			<td><%=dto.getName() %></td>
			<td><%=dto.getId() %></td>
			<td><%=dto.getEmail() %></td>
			<td><%=dto.getAllHp() %></td>
			<td><%=dto.getJoindate() %></td>
			<td>
			<a href="member_edit.jsp?no=<%=dto.getNo()%>">수정</a> | 
			<a href="member_delete.jsp?no=<%=dto.getNo()%>">삭제</a></td>
	</tr>
<%		
		}
	}
%>
	
	</table>
</div>
<%@ include file="../bottom.jsp"%>

 

* member_edit.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" import="member.*"%>
<!-- member_edit.jsp -->
<%
	
	String no = request.getParameter("no");
	if(no == null || no.trim().equals("")){
		response.sendRedirect("memberAll.jsp");
		return;
	}
	
%>

<jsp:useBean id="mbdao" class="member.MemberDAO" />
<%	
	MemberDTO dto = mbdao.getMember(Integer.parseInt(no));
%>

<html>
<head>
	<link rel="stylesheet" type="text/css" href="../style.css">
	<script type="text/javascript">
	function check(){
	
		if(f.passwd.value==""){
			alert('비밀번호 입력해 주세요!')
			f.passwd.focus()
			return false
		}

		return true
	}
	</script>
</head>

<body>
	<div align="center">
	<form name="f" action="member_edit_ok.jsp" 
								method="post" onsubmit="return check()">
		<input type="hidden" name="no" value="<%=dto.getNo() %>">
		<table width="80%" class="outline">
			<tr>
				<td colspan="2" align=center class="m2">회원수정</td>
			</tr>
			<tr>
				<th width="20%" class="m3">이름</th>
				<td><input type="text" class="box" name="name" value="<%= dto.getName()%>" readOnly></td>
			</tr>
			<tr>
				<th class="m3">아이디</th>
				<td><input type="text" class="box" name="id" value="<%=dto.getId() %>" readOnly></td>
			</tr>
			<tr>
				<th class="m3">비밀번호</th>
				<td><input type="password" class="box" name="passwd" value="<%=dto.getPasswd()%>"></td>
			</tr>
			<tr>
				<th class="m3">주민번호</th>
				<td><input type="text" class="box" name="ssn1" value="<%=dto.getSsn1() %>" readOnly>
					- <input type="password" class="box" name="ssn2" value="<%=dto.getSsn2() %>" readOnly></td>
			</tr>
			<tr>
				<th class="m3">이메일</th>
				<td><input type="text" class="box" name="email" value="<%=dto.getEmail() %>"></td>
			</tr>
			<tr>
				<th class="m3">전화번호</th>
				<td><input type="text" name="hp1" class="box" size="3" maxlength="3" value="<%=dto.getHp1() %>">
					-<input type="text" name="hp2" class="box" size="4" maxlength="4" value="<%=dto.getHp2() %>">
					-<input type="text" name="hp3" class="box" size="4" maxlength="4" value="<%=dto.getHp3() %>"></td>
			</tr>
			<tr>
				<td align="center" colspan="2" class="m2">
					<input type="submit" value="회원수정">
					<input type="reset" value="다시입력">
				</td>
			</tr>
		</table>
	</form>
</div>
</body>
</html>

 

* member_edit_ok.jsp

 

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!-- member_edit_ok.jsp -->
<%
	request.setCharacterEncoding("UTF-8");
%>

<jsp:useBean id="mbdto" class="member.MemberDTO" />
<jsp:setProperty property="*" name="bdto"/>
<jsp:useBean id="mbdao" class="member.MemberDAO" />

<%
	if(mbdto.getName() == null || mbdto.getName().trim().equals("")){
		response.sendRedirect("memberAll.jsp");
		return;
	}

	int res = mbdao.updateMember(mbdto);
	
	if(res > 0){
%>
	<script type="text/javascript">
		alert('회원수정 성공 ! 회원목록 페이지로 이동합니다.')
		location.href="memberAll.jsp"
	</script>
<%		
	} else{
%>
	<script type="text/javascript">
		alert('회원수정 실패 ! 회원목록 페이지로 이동합니다.')
		location.href="memberAll.jsp"
	</script>
<%		
	}
%>

 

* delete.jsp

 

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"%>
<!-- member_delete.jsp -->
<%
		String no = request.getParameter("no");
		if (no == null || no.trim().equals("")){
			response.sendRedirect("memberAll.jsp");
			return;
		}
%>
<jsp:useBean id="mbdao" class="member.MemberDAO" />
<%
		int res = mbdao.deleteMember(Integer.parseInt(no));
		if (res>0){%> 
			<script type="text/javascript">
				alert("회원삭제 성공!! 회원목록페이지로 이동합니다")
				location.href="memberAll.jsp"
			</script>
<%	}else { %>	
			<script type="text/javascript">
			alert("회원삭제 실패!! 회원목록페이지로 이동합니다")
			location.href="memberAll.jsp"
			</script>	
<%	}%>
728x90
반응형
저작자표시 변경금지

'IT&코딩 > 자바 프로젝트' 카테고리의 다른 글

자바 프로젝트 7일차 - Servlet 2 (mvcTest)  (0) 2023.02.01
자바 프로젝트 6일차 - Servlet (testServlet)  (0) 2023.01.26
자바 프로젝트 4일차 - JSP 복습 2 (jspBoard)  (2) 2023.01.22
자바 프로젝트 3일차 - JSP 복습 1  (2) 2023.01.21
자바 프로젝트 2일차 - Java 복습2  (0) 2023.01.21

'IT&코딩/자바 프로젝트' Related Articles

티스토리툴바