index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<script src="https://code.jquery.com/jquery-3.5.0.js"></script>
</head>
<body>
<div class="wrapper">
<form action=LoginCheckController method="post">
<table align=center border="1px" style="text-align: center">
<tr>
<td><b>Login</b></td>
</tr>
<tr>
<td><input type="text" name="id" placeholder="Input your ID"></td>
</tr>
<tr>
<td><input type="password" name="pw"
placeholder="Input your PW"></td>
</tr>
<tr>
<td><input type="submit" id="login" value="Login"> <input
type="button" id="signup" value="Sign up"><br> <input
type="checkbox">Remember my ID</td>
</tr>
</table>
</form>
</div>
<script>
$("#signup").on("click",function(){
location.href="signup.jsp"
})
$("#login").on("click",function(){
location.href="LoginCheckController"
})
</script>
</body>
</html>
LoginCheckController
package kh.backend.controller;
import java.io.IOException;
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 kh.backend.dao.memberDAO;
@WebServlet("/LoginCheckController")
public class LoginCheckController extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
memberDAO dao = new memberDAO();
String id = request.getParameter("id");
String pw = dao.getSHA512(request.getParameter("pw"));
try {
boolean result = dao.loginCheck(id, pw);
request.setAttribute("result",result);
request.getRequestDispatcher("loginView.jsp").forward(request, response);
}catch(Exception e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
DAO
- loginCheck
public boolean loginCheck(String id,String pw) throws Exception{
String sql = "select * from member where id=? and pw=?";
try(Connection con = this.getConnection();
PreparedStatement pstat = con.prepareStatement(sql)){
pstat.setString(1, id);
pstat.setString(2, pw);
try( ResultSet rs = pstat.executeQuery();){
return rs.next();
}
}
}
loginView.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="https://code.jquery.com/jquery-3.5.0.js"></script>
</head>
<body>
<%
boolean result = (boolean)request.getAttribute("result");
if (result) {
%>
로그인 가능합니다.
<%
} else {
%>
로그인 할수 없습니다.
<%
}
%>
<button id="back">돌아가기</button>
<script>
$("#back").on("click", function() {
location.href="index.jsp";
})
</script>
</body>
</html>
'디지털 컨버전스 > Project' 카테고리의 다른 글
| [BoardProject] 로그인 (0) | 2020.04.29 |
|---|---|
| [BoardProject] 로그인 인증 저장 (0) | 2020.04.29 |
| [BoardProject] 중복확인 (0) | 2020.04.29 |
| [BoardProject] - 회원가입 (0) | 2020.04.28 |
| [UML]유스케이스 다이어그램 ( Usecase Diagram ) (0) | 2020.04.01 |