로그인 login login_ok logout

login _ login_ok

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

<table height=100><tr><td></td></tr></table>
<table width=1200  border=0 align="center">
	<tr>
		<td align=center style="font-size:40px;">카모</td>
	</tr>
</table>

<script>
function login_ok(){
	if(m_id.value == ""){
		alert("아이디를 입력하새요.");
		m_id.focus();
		return false;
	}
	if(m_pass.value == ""){
		alert("비밀번호를 입력하새요.");
		m_pass.focus();
		return false;
	}
	document.login.submit();
}
</script>


<form name="Login" action="login_ok.jsp" method="post" onsubmit="return login_ok()">
<table width=400 height=300 align="center" style="border:1px solid white;border-radius: 15px 15px 15px 15px;">
	<tr height=100 width=133>
		<td style="text-align:center"><input id="m_id" name="m_id" class="input1" placeholder="아이디를 입력하세요." style="text-align:center" width=133></td>
	</tr>
	<tr height=100 width=133>
		<td style="text-align:center"><input id="m_pass" name="m_pass" class="input1" placeholder="비밀번호를 입력하세요." style="text-align:center" width=133></td>
	</tr>
	<tr height=100 width=133>
		<td style="text-align:center"><button class=button style="font-size:20px;">로그인</button></td>
	</tr>
	
</table>
</form>

<table height=200><tr><td></td></tr></table>

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

<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ include file="/include/dbconnection.jsp" %>


<%
request.setCharacterEncoding("utf-8");  //사용자로부터 받은입력값
String id = request.getParameter("m_id");
String pass = request.getParameter("m_pass");

String sql = "select * from member2 where memberid = '"+id+"' and password = '"+pass+"'";

Connection con = DriverManager.getConnection(url, user, password);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql);

String mem_id = "";
String mem_pass = "";
String mem_name = "";
String mem_level = "";

if(rs.next()){
	mem_id = rs.getString("memberid");
	mem_pass = rs.getString("password");
	mem_level = rs.getString("level");
	mem_name = rs.getString("name");	
}

if(id.equals(mem_id) && pass.equals(mem_pass)){
	session.setAttribute("id", id);
	session.setAttribute("level", mem_level);
	session.setAttribute("name", mem_name);
}else{
	
}

%>

<script>
	location.href="/";
</script>

logout

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

    <%
    session.invalidate(); //모든 세션값을 삭제    
    %>
    <script>
    	location.href="/";
    </script>

   위에서 setattribute(String key,Object Value)로 value를 key에 매핑해서  데이터를 저장했으니

 

 

header.jsp에서  

계속 끌어다 쓸 수 있도록 getAttribute(String key)를 이용해 데이터 읽어온후 전역변수에 대입(처리)해서 편하게 쓰게함. 

• 페이지에 데이터를 저장하는 메서드 : setAttribute()
• DB에서 데이터를 가져오는 메서드 : getAttribute(

<% 
String session_id = (String)session.getAttribute("id");
String session_level = (String)session.getAttribute("level");
String session_name = (String)session.getAttribute("name");

%>