login.jsp

<%--
    Document   : login.jsp
    Created on : Jul 31, 2017, 12:09:32 PM
    Author     : Shahadat-Hossain
--%>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>loginjsp</title>
</head>
<body>
	<%@ page import="java.sql.*"%>
	<%@ page import="javax.sql.*"%>
	<%
String username=request.getParameter("usr");
String pass=request.getParameter("pwd");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/tourguide","root","");
Statement st= con.createStatement();
ResultSet rs=st.executeQuery("select * from login where userid='"+username+"' and password='"+pass+"'");
if(rs.next())
{
session.setAttribute("sessionid",username);
out.println("welcome "+username);
}
else if(request.getParameter("usr").equals("")||request.getParameter("pwd").equals("")){
    out.println("you are not logged in <a href='index.html'>try again</a>");
}
else {
        out.println("Invalid password <a href='index.html'>try again</a>");
    }
%>

</body>
</html>