26_jsp만_로그인처리_세션응용_jsp
2022. 2. 2. 11:55ㆍksmart_jsp/05_jsp_mysql
728x90
<%@ page language="java" contentType="text/html; charset=EUC-KR"
pageEncoding="EUC-KR"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.SQLException"%>
<%
request.setCharacterEncoding("euc-kr");
String uid = request.getParameter("uid");
String upw = request.getParameter("upw");
String dbid = null;
String dbpw = null;
String dblevel = null;
String dbname = null;
String dbemail = null;
String alert = null;
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
Class.forName("com.mysql.jdbc.Driver");
String jdbcDriver = "jdbc:mysql://localhost:3306/dev42db?" + "useUnicode=true&characterEncoding=euckr";
String dbUser = "dev42id";
String dbPass = "dev42pw";
conn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);
pstmt = conn.prepareStatement("SELECT * FROM tb_member WHERE m_id=?");
pstmt.setString(1, uid);
rs = pstmt.executeQuery();
if (rs.next()) {
System.out.println("1-1 아이디 일치");
dbid = rs.getString("m_id");
dbpw = rs.getString("m_pw");
dblevel = rs.getString("m_level");
dbname = rs.getString("m_name");
dbemail = rs.getString("m_email");
System.out.println(dbid + "<-dbid login_action.jsp");
System.out.println(dbpw + "<-dbpw login_action.jsp");
System.out.println(dblevel + "<-dblevel login_action.jsp");
System.out.println(dbname + "<-dbname login_action.jsp");
System.out.println(dbemail + "<-dbemail login_action.jsp");
if (upw.equals(dbpw)) {
System.out.println("2-1 로그인 성공");
session.setAttribute("S_ID", dbid);
session.setAttribute("S_NAME", dbname);
session.setAttribute("S_LEVEL", dblevel);
alert="로그인성공";
} else {
System.out.println("2-2 비밀번호 불일치");
alert="비밀번호불일치";
}
} else {
System.out.println("1-2 아이디 불일치");
alert="아이디불일치";
}
%>
<script type="text/javascript">
alert('<%=alert%>');
location.href='<%= request.getContextPath()%>/index.jsp';
</script>728x90
'ksmart_jsp > 05_jsp_mysql' 카테고리의 다른 글
| jsp만_상품관리_jsp (0) | 2022.02.02 |
|---|---|
| 25_jsp만_layout포함(로그인처리전)_jsp (0) | 2022.02.02 |
| 24_include_redirect_리스트화면연결_jsp (0) | 2022.02.02 |
| 23_jsp만_search처리_jsp (0) | 2022.02.02 |
| 22_jsp만_delete처리_jsp (0) | 2022.02.02 |