본문 바로가기
개발중/JavaServer Pages (JSP)

Login

Binsoo 2020. 8. 14. 16:10
728x90
반응형

login.jsp

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

<html>
<head>
<title>[login.jsp]</title>
	<style type="text/css">
		input, b{font-size: 20pt; font-weight: bold;}
		a{text-decoration: none;font-size: 20pt; font-weight: bold;}
		a:hover {color: red; font-size: 20pt; font-weight: bold;}
		#LOG-IN{
		 font-size:26pt; font-weight: bold; 
		 background:"green"; height:120; 
		}
	</style>
	
	<script type="text/javascript">
	  var xhr; //전역변수 
	  
	  function first( ){
		return new XMLHttpRequest( );
	  }//end
	  
	  function two(){  
		var a=document.getElementById("userid").value; //myform.userid.value;
		var b=document.getElementById("pwd").value; //myform.pwd.value;
		var url="loginSave.jsp?UID="+a+"&UPWD="+b;
		//var url="loginList.jsp?UID="+a+"&UPWD="+b;
		//var url="login.tis?UID="+a+"&UPWD="+b;
		alert("url = "+url);
		xhr=first();
		xhr.onreadystatechange=display;
		xhr.open("GET", url, true);
		xhr.send();
	 }//end
	  
	  function display( ){
		 if(xhr.readyState==4){
			if(xhr.status==200){
			 var message=xhr.responseText;
			 document.getElementById("msg").innerHTML=message;
			}//200 end
		 }//4 end
	  }//end
	</script>
</head>
<body>
	
<div id="msg" align="center">	
	<table width="550" border="1" cellspacing="0">
	  <form name="myform">
		<tr>
			<td width=350> <b>userid: </b></td>
			<td> <input type="text" name="userid" id="userid"  value="sky"></td>
			
			<td rowspan=2 align="center">
			 <input type="button" onclick="two( )" value="LOG-IN" id="LOG-IN" >
			</td>
		</tr>
		
		<tr>
			<td width=350><b>userpw: </b> </td>
			<td>
			  <input type="text"  name="pwd" id="pwd" value="1234">       
			</td>
		</tr>
		</form>
	</table>
</div>

</body>
</html>

loginList.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"   %>
<%@ include file="ssi.jsp" %>
<!DOCTYPE html>
<html> <head>
<title> [loginList.jsp]</title>
   <style type="text/css">
	  *{font-size:14pt; font-weight:bold;  font-family: Comic Sans MS ; margin-left: 10px; }
	  a{font-size:14pt; text-decoration:none; font-weight:bold; color:blue;  font-family: Comic Sans MS ; }
	  a:hover{font-size:16pt; text-decoration:underline; color:green;  font-family: Comic Sans MS ; }
   </style>
</head>
<body>
 <p><br>
 <div align="center">
   <img src="images/a1.png">
 </div>
<%
  //loginList.jsp
   String a = request.getParameter("UID");
   String b = request.getParameter("UPWD");
  try{
   msg="select count(*) as cnt from login where userid =? and pwd =? ";
   PST=CN.prepareStatement(msg);
   		PST.setString(1, a);
   		PST.setString(2, b);
   RS=PST.executeQuery();
  }catch(Exception ex){ System.out.println(ex); }
 if(RS.next()==true){ Gtotal=RS.getInt("cnt"); }
 if( Gtotal>0){	 
	 session.setAttribute("naver", a); //userid값을 가짜변수 naver에 넘김
	 response.sendRedirect("guestList.jsp");
	 
	 //Cookie ck=new Cookie("google", a); //쿠키내장클래스 객체화 
	 //response.addCookie(ck); //쿠키추가등록
	 //response.sendRedirect("main.jsp");
 }else{
%>	 
  <script type="text/javascript">
     alert("로그인문서로 이동합니다\UserID,PWD데이터를 입력하세요");
     location.href="login.jsp";
  </script>	 
<%}%>	
</body>
</html>

loginSave.jsp

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

<html>
<head><title> [loginSave.jsp] </title></head>
<body>		
<%
  
  String usera=request.getParameter("UID");
  String userb=request.getParameter("UPWD");
  msg="select count(*) as cnt from login where userid=? and pwd=? ";
  System.out.println( "loginSave.jsp " + msg);
  PST=CN.prepareStatement(msg);
  	PST.setString(1, usera);
  	PST.setString(2, userb);
  RS=PST.executeQuery(); 
  RS.next(); Gtotal=RS.getInt("cnt");
		  
  if(Gtotal>0){
  %>
   <font size=7 color=blue>
     <b><%= usera %>님 로그인 성공!!!</b> <br>
   </font><p>
	<img src="images/bt_login.gif" width=450 height=70><p>
	<img src="images/bar.gif" width=450 >
 <%  
  }else{
    //response.sendRedirect("login.jsp");
    out.println("<font size=7 color=red><b></b>"+usera+"님 로그인실패</font><p>");
    out.println("<font size=7><a href='login.jsp'>[로그인]</a></font>");
    out.println("<font size=7><a href='index.jsp'>[index]</a></font>");	
  }
%>
	
</body>
</html>

 

ssi.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.CallableStatement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%! 

  Connection CN;
  Statement ST; 
  PreparedStatement PST;
  CallableStatement CST; 
  ResultSet RS; 
  java.util.Date Gwdate;
  
  int Gsabun;
  int Gpay;
  int Ghit;
  int Gtotal;    //조회레코드갯수
  int GGtotal;    //전체레코드갯수
  int GStotal;
  
  String Gname, Gtitle, Gemail, Grownum;
  String msg="쿼리문기술"; String submsg="";
  String Gdata;
  
  //댓글관련 전역변수
  String R_msg;
  String Rdata;
  String Rwriter;
  String Rcontent;
  int Rrn, Rnum, Rsabun;
  int Rcnt;
  
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>[ssi.jsp]</title>
<style type="text/css">
   *{font-size:16pt;}
   a{ font-size: 16pt; color:black; text-decoration:none;}
   a:hover{ font-size: 16pt; color:blue; text-decoration:underline;}
</style>
</head>
<body>

<%
   try{
   Class.forName("oracle.jdbc.driver.OracleDriver"); //드라이브로드
    String url="jdbc:oracle:thin:@127.0.0.1:1521:XE" ;
    CN=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:XE","system","1234");
    Date now = new Date();
   }catch(Exception ex){System.out.println("Error name :" + ex);}
   ST=CN.createStatement();
%>

</body>
</html>
728x90
반응형

'개발중 > JavaServer Pages (JSP)' 카테고리의 다른 글

파일 다운로드/ 선택  (0) 2020.08.14
화폐단위 표현  (0) 2020.08.14
session 사용법  (0) 2020.08.14
Cookies  (0) 2020.08.14
파일 업로드/ 저장  (0) 2020.08.14

'개발중/JavaServer Pages (JSP)' Related Articles

티스토리툴바