Ravi R. Oza

DynamicLogin.html

<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Static Login</title>
<!--  www.raviroza.com -->
</head>
<body>
	<h1>Static Login Information</h1>

	<hr>
	<form action="dlogin" method="post">
		<p>
			Username <input type="text" name="txtuser">
		</p>
		<p>
			Password <input type="password" name="txtpass">
		</p>
		<p>
			<input type="submit" value="Login" />
		</p>
	</form>
</body>
</html>

DynamicLoginServlet.java

package RROExamples;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/dlogin")
public class DynamicLoginServlet extends HttpServlet {
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		//create table tbluser (username varchar2(30), password varchar2(30));
		//response.getWriter().append("Served at: ").append(request.getContextPath());
		response.setContentType("text/html");
		PrintWriter pw = response.getWriter();
		
		String user = request.getParameter("txtuser");
		String pass = request.getParameter("txtpass");
		
		String QRY = "select * from tbluser where ";
		QRY += " username = '"+ user +"' and ";
		QRY += " password = '"+ pass +"' ";
				
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","hjd");
			
			if(conn.createStatement().executeQuery(QRY).next())
			{
				pw.print("Welcome, Master : "+user);
				response.sendRedirect("home.html");
			}
			else
			{
				pw.print("Sorry, My Lord ");
				pw.println("<br><a href='signup.html'> Sign Up Here </a> ");
				
			}
		}
		catch(Exception e)
		{
			pw.print("Error : "+e.toString());
		}

		
	}

}