I have written a servlet program for login page ..am using tomcat server...after i run on the server am getting the above mentioned error... Below is my servlet code.
package demo;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class LoginServlet
*/
public class LoginServlet extends HttpServlet {
static private String dbUrl="jdbc:mysql://localhost:3306/employee";
static private String dbUn="root";
static private String dbPwd="root";
static private Connection ConObj;
static private Statement StmtObj;
static private ResultSet RsObj;
public void service(HttpServletRequest request,HttpServletResponse response)throws IOException
{
try {
Class.forName("com.mysql.jdbc.driver");
ConObj=DriverManager.getConnection(dbUrl, dbUn, dbPwd);
StmtObj=ConObj.createStatement();
response.setContentType("text/html");
PrintWriter out=response.getWriter();
out.write("<html><body>");
out.write("<h2>");
String ActLogName=request.getParameter("Logname");
String ActPwd=request.getParameter("Pwd");
String SqlQuery="select * from users where username='"+ActLogName+"' and password='"+ActPwd+"'";
RsObj=StmtObj.executeQuery(SqlQuery);
if(RsObj.next()==true)
{
String ExpLogName=RsObj.getString("username");
String ExpPwd=RsObj.getString("password");
if(ActLogName.equals(ExpLogName)&& ActPwd.equals(ExpPwd))
{
out.write("Login Success");
}
}
else
{
out.write("Login Failed");
}
out.write("</h2>");
out.write("</body></html>");
}
catch (ClassNotFoundException|SQLException exp) {
exp.printStackTrace();
}
finally{
try {
RsObj.close();
StmtObj.close();
ConObj.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
Below is my html code
<!DOCTYPE html>
<html>
<head>
<title>login page</title>
</head>
<body>
<form action="http://localhost:8080/FlipKart/loginpage">
LoginName :<input type="text" name="Logname"><br>
Password :<input type="password" name="Pwd"><br>
<input type="submit" value="Login">
<input type="button" value="cancel">
</form>
</body>
</html>
Below is my web.xml code
<web-app>
<servlet>
<servlet-name>loginserv</servlet-name>
<servlet-class>LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>loginserv</servlet-name>
<url-pattern>/loginpage</url-pattern>]
</servlet-mapping>
</web-app>
Can somebody help me to the resolve this issue.. Thanks in advance..:)