Code:
<%--
Document : login
Created on : 12 Sep, 2012, 4:30:37 PM
Author : sanidhya09
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Login Page</title>
<link rel="stylesheet" href="css/margin.css" type="text/css" />
</head>
<body background="images/medicallogo.png">
<form name="form" method="post" action="login.jsp" >
<table background="images/bg1.gif" id="table" width="1000" height="500" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td>
<div id="Header">
<%@ include file="Header2.jsp" %>
</div>
<div id="body">
<table id="body1" width="750" height="500" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td>
<%--Database Connectivity --%>
<%@page import="java.sql.*"%>
<%@page import="Hospital.Database_Connectivity;"%>
<%
try{
Connection con;
Statement smt;
ResultSet rs=null;
String user=request.getParameter("user_id");
String pass=request.getParameter("password");
//Class.forName("com.mysql.jdbc.Driver").newInstance();
//connection =DriverManager.getConnection("jdbc:mysql://localhost:3306/hospital", "root", "");
con=Database_Connectivity.dbcon();
smt=con.createStatement();
rs=smt.executeQuery("select * from login where user_id='"+user+"' and password='"+pass+"'");
if(rs.next())
{
while(rs.next())
{
String str=rs.getString("type");
if(str.equals("employee"))
{
response.sendRedirect("index.jsp");
}
}
}
else
{
out.print("Not valid Credentials");
// response.sendRedirect("login.jsp");
}
}
catch(Exception ex)
{
System.out.println("Error="+ex);
}
%>
<p align="center"><font face="Arial Black" color="#800000"><b>PLEASE LOGIN HERE</b></font></p>
<table cellpadding="0" cellspacing="0" width="300" height="250" BORDER="0" align="center">
<tr>
<td>
<font color="#000080" face="arial"/>USERNAME :
</td>
<td>
<input type="text" name="user_id" size="20" id="user_id" />
</td>
</tr>
<tr>
<td>
<font face="arial" color="#000080" />PASSWORD :
</td>
<td>
<input type="password" name="password" size="20" id="password" />
</td>
</tr>
<tr>
<td>
<font face="arial" color="#000080" />COUNTER : </td>
<td>
<select size="1" name="Counter">
<option>Counter 1</option>
<option>Counter 2</option>
<option>Counter 3</option>
<option>Counter 4</option>
<option>Counter 5</option>
</select>
</td>
</tr>
<tr>
<td>
<font face="arial" color="#000080" />Remember Me :
</td>
<td>
<input type="CHECKBOX" name="checkbox" />
</td>
</tr>
<tr align="right">
<td>
<button name="reset" type="reset" style="background-color:lightseagreen">RESET</button>
</td>
<td>
<button name="login" style="background-color:lightseagreen">LOGIN</button>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<div id="footer"><br />
<%@ include file="footer2.jsp" %>
</div>
</td>
</tr>
</table>
</form>
</body>
</html>