i made a simple login and rgistration form using servlet and authentication through mysql and whenevr i run it on tomcat a blank page is displayed plz help here is my code...plz chk the web.xml file also
index.jsp(login form)
<%@page contentType="text/html" pageEncoding="UTF-8"%>
login.java (servlet)
package login;
import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement;
import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;
public class login extends HttpServlet {
private static final long serialVersionUID = 1L; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("test"); String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost/login"; response.setContentType("text/html"); String msg = " "; String username = request.getParameter("username"); String password = request.getParameter("password"); try { Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/login","root",""); String strQuery = "select * from validate WHERE username='" + username + "' and password='" + password + "'"; Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(strQuery); if (rs.next()) { msg = "HELLO" + username + "! Your login is SUCESSFULL"; } else { msg = "HELLO" + username + "!Your login is UNSUCESSFULL"; } rs.close(); st.close(); System.out.println("test :" + msg); PrintWriter out = response.getWriter(); } catch (Exception e) { e.printStackTrace(); } }
}
sign.jsp (signup form)
<%@page contentType="text/html" pageEncoding="UTF-8"%>
signup.java(servlet)
import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement;
import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;
public class signup extends HttpServlet {
private static final long serialVersionUID = 1L; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("test");
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String n=request.getParameter("name");
String c=request.getParameter("city");
String co=request.getParameter("country");
String u=request.getParameter("username");
String p=request.getParameter("password");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/login","root","");
PreparedStatement ps=con.prepareStatement("insert into registeruser values(?,?,?,?,?)");
ps.setString(1,n);
ps.setString(2,c);
ps.setString(3,co);
ps.setString(4,u);
ps.setString(5,p);
int i=ps.executeUpdate();
if(i>0)
out.print("You are successfully registered...");
System.out.println("test");
}catch (Exception e2) {System.out.println(e2);}
out.close();
}
}
web.xml
Ads