member/login_ok.jsp > JSP2

• 목록

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

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

<%

String id = request.getParameter("mb_id");

String passwd = request.getParameter("mb_password");

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

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

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sql);

//전역 변수

String member_id="";

String member_pass="";

String member_name="";

String member_level="";

if(rs.next()){

member_id = rs.getString("m_id");

member_pass = rs.getString("m_pass");

member_name = rs.getString("m_name");

member_level = rs.getString("m_level");

}

rs.close();

stmt.close();

conn.close();

//아이디, 비밀번호 매칭 : 세션 생성

if(id.equals(member_id) && passwd.equals(member_pass)){

session.setAttribute("id", member_id);

session.setAttribute("name", member_name);

session.setAttribute("level", member_level);

}

response.sendRedirect("/"); //첫 페이지 이동

%>