Untitled

<%@ page contentType="text/html; charset=utf-8" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<h2>Login Confirm</h2>
<%
	try{
		Class.forName("com.mysql.jdbc.Driver");
		String url = "jdbc:mysql://localhost:3306/test";
		Connection con = DriverManager.getConnection(url, "root", "1111");

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

		if(con != null){
			String query = "SELECT * FROM tblMember WHERE id ='" + id + "' and pass='" + pass + "'";
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			System.out.println(query);
			if(rs.next()){
				out.println("Login Success");
			}
			else{
				out.println("Login Fail");
			}
		}
		else{
			out.println("Fail");
		}
	}
	catch(Exception err){
		out.println("Fail : " + err);
	}
	*/

	String id = request.getParameter("id");
%>
id : <%=id%>
<script>
	//location.href=url
</script>
</body>
</html>