login and registration form using servlet and authentication through mysql

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:::

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"%> :::Sign Up:::

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

login index.html index.htm index.jsp default.html default.htm default.jsp login login login.login login /login signup signup signup signup /signup

View Answers

Ads