loginDAO and Loginservlet

how to make loginDAO and loginServlet?

View Answers

May 22, 2013 at 9:22 AM

userDAO
===================
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.tcs.ignite.app.dao;

import com.tcs.ignite.app.beans.User;
import com.tcs.ignite.app.utils.ConnectionManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 *
 * @author 495944
 */
public class UserDAO {

    public void logUserIn(User user) {
        try {
            Connection con = new ConnectionManager().createConnection();
            String queryString = "select Username,password from register where Email='" + user.getEmail() + "'";
            PreparedStatement ps = con.prepareStatement(queryString);
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                user.setRegistered(true);
                String password = rs.getString("password");
                if (password.equals(user.getPassword())) {
                    user.setName(rs.getString("Username"));
                }
            } else {
                user.setRegistered(false);
            }
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

         public boolean forgetpassword(User user){

        try {
            Connection con = new ConnectionManager().createConnection();

            String queryString ="update test.register set password=("+"'"+user.getNewpassword()+"'"+") where Email=("+"'"+user.getEmail()+"'"+")";
            System.out.println(queryString);
            PreparedStatement ps = con.prepareStatement(queryString);
            int rs = ps.executeUpdate();
            if(rs==1){
                return true;
            }else{
                return false;
            } 
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
            return false;
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }
    }  
}

May 22, 2013 at 9:23 AM

Login servlet
=======================
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.tcs.ignite.app.servlets;

import com.tcs.ignite.app.beans.User;
import com.tcs.ignite.app.dao.UserDAO;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author 495944
 */
@WebServlet(name = "Login1", urlPatterns = {"/Login1"})
public class Login1 extends HttpServlet {

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            /*
             * TODO output your page here. You may use following sample code.
             */
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet Login</title>");            
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet Login at " + request.getContextPath() + "</h1>");
            out.println("</body>");
            out.println("</html>");
        } finally {            
            out.close();
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP
     * <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        request.getSession().invalidate();
       response.sendRedirect("home.jsp");
    }

    /**
     * Handles the HTTP
     * <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        User user = new User();
      user.setEmail(request.getParameter("inputEmail").trim());
        user.setPassword(request.getParameter("inputPassword1").trim());
        new UserDAO().logUserIn(user);
        if(user.isRegistered()){
            if(user.getName()!=null){
                request.getSession().setAttribute("user", user);
                request.getRequestDispatcher("home.jsp").forward(request, response);
                }
            else{
                request.setAttribute("msg", "Wrong Password");
                request.getRequestDispatcher("home.jsp").forward(request, response);
//                response.sendRedirect("index.jsp");
            }
        }else{
            request.setAttribute("msg", "User does not exist.");
            request.getRequestDispatcher("home.jsp").forward(request, response);
//            response.sendRedirect("index.jsp");
        }

    }
    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

}