TestForm
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
TestForm
·Î±×ÀÎ
TestPro
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import = "java.sql.*" %>
<%@ page import = "java.sql.Connection" %>
<%@ page import = "java.sql.DriverManager" %>
<%@ page import = "java.sql.PreparedStatement" %>
<%@ page import = "java.sql.ResultSet" %>
<%request.setCharacterEncoding("utf-8"); %>
<%
String id = request.getParameter("id");
String password = request.getParameter("pwd");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@168.126.146.45:1521:orcl", "20172262", "980930");
String sql = "select * from HACK";
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
String userid="";
String pwd="";
while(rs.next()){
userid = rs.getString("id");
pwd = rs.getString("password");
if(id.equals(userid) && pwd.equals(pwd)) {
break;
}
}
if(id.equals(userid)&&password.equals(pwd)){
response.sendRedirect("TestMain.jsp");
}else{
%>
<%
}
%>
Insert title here
TestMain
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
String id="";
String passwd="";
try{
id = (String)session.getAttribute("id");
passwd = (String)session.getAttribute("password");
session.setAttribute("id", id);
session.setAttribute("password", passwd);
if(id==null||id.equals(""))
response.sendRedirect("TestForm.jsp");
else{
%>
main
<%=(String)session.getAttribute("id") %> ´Ô ȯ¿µÇÕ´Ï´Ù.
°¨»çÇÕ´Ï´Ù!
<%
}
}catch(Exception e){
e.printStackTrace();
}
%>