Create a simple Login page using eclipse and mysql

Question

I have created a simple login page in which user will give an username and password  After clicking on submit button it will show welcome user  But it is not giving any result This is my index page      This is my index login page     lt    page language  java  contentType  text html  charset ISO-8859-1  pageEncoding  ISO-8859-1   gt   lt  DOCTYPE html PUBLIC  -  W3C  DTD HTML 4 01 Transitional  EN   http   www w3 org TR html4 loose dtd  gt   lt html gt   lt head gt       lt meta http-equiv  Content-Type  content  text html  charset ISO-8859-1  gt       lt link rel  stylesheet  type  text css  href  style css   gt       lt title gt Login lt  title gt   lt  head gt   lt body gt       lt           String error msg               Object error   request getAttribute  error            if  error    null  error msg   error toString          gt       lt div id  Container  gt           lt div id  Header  gt               lt h1 gt Online File Management System lt  h1 gt           lt  div gt           lt a href     index html  target   self  gt Home lt  a gt           lt div id  Content  gt               lt div id  Login  gt                   lt form action  login  gt                       lt table align    center  bgcolor  66CCFF gt                           lt tr gt  lt td align    left  gt Username     lt  td gt                               lt td rowspan  7  valign  middle  gt                                       lt font color  red  gt   lt    error msg   gt   lt  font gt                                       lt p gt You can also Login using Google lt  p gt                                       lt p class  Google  gt  lt input name  Submit  type  Submit  value  Login with Google Account  gt  lt  p gt                                lt  td gt                           lt  tr gt                           lt tr gt                               lt td gt  lt input name  username  type  text  size  30  gt  lt  td gt                               lt td gt  lt  td gt                           lt  tr gt                           lt tr gt  lt td align    left  gt Password  lt  td gt  lt  tr gt                           lt tr gt  lt td gt  lt input name  password  type  password  size  30  gt  lt  td gt  lt  tr gt                           lt tr gt  lt td align    left  gt Forgot your password  lt  td gt  lt  tr gt                           lt tr gt  lt td align    left  gt Remember me        lt input type  checkbox  name  checkbox  value  checkbox  gt  lt  td gt  lt  tr gt                           lt tr gt  lt td align    left  gt  lt input type  Submit  value  LOGIN  gt  lt  td gt  lt  tr gt                       lt  table gt                   lt  form gt                   lt hr gt               lt  div gt           lt  div gt           lt div id  Footer  gt              Copyright  amp copy  2014 Office of the Vice Chancellor           lt  div gt       lt  div gt     lt  body gt   lt  html gt    This is my Database conectivity page    package org form login   import java sql Connection  import java sql DriverManager  import java sql ResultSet  import java sql SQLException  import java sql Statement   import org apache catalina connector Request   public class database         SuppressWarnings  null       public String validateUserLogin  String username  String password  throws SQLException          Connection connection   null          ResultSet resultset   null          Statement statement   null           String fullname                String DRIVER    com mysql jdbc Driver           String URL    jdbc mysql   localhost 3306 onfms           String USER    root           String PASS               String QUERY    SELECT   FROM tblUser WHERE fldUser Name                   username             AND fldPassword      password               try               Class forName DRIVER               connection   DriverManager getConnection URL USER PASS               resultset   statement executeQuery QUERY               catch  Exception e               e printStackTrace                finally               if  resultset    null                  resultset close                if  statement    null                  statement close                if  connection    null                  connection close                        This is my login servlet page    package org form login   import java io IOException  import java sql SQLException   import javax servlet RequestDispatcher  import javax servlet ServletContext  import javax servlet ServletException  import javax servlet annotation WebServlet  import javax servlet http HttpServlet  import javax servlet http HttpServletRequest  import javax servlet http HttpServletResponse   import org form login database          Servlet implementation class login      WebServlet   login   public class login extends HttpServlet       private static final long serialVersionUID   1L                   see HttpServlet HttpServlet               public login             super               TODO Auto-generated constructor stub                       see HttpServlet doGet HttpServletRequest request  HttpServletResponse response             protected void doGet HttpServletRequest request  HttpServletResponse response  throws ServletException  IOException              TODO Auto-generated method stub         String url     main jsp           String user   request getParameter  username            String pass   request getParameter  password            if  user    null    user length      0   pass    null    pass length      0                url     index jsp               request setAttribute  error    Username  amp  Password must not be empty              else              try                   String fullname   new database   validateUserLogin user  pass                   request setAttribute  fullname   fullname                   if  fullname    null    fullname length      0                       request setAttribute  sucess    Sucessfull Connection                                    catch  SQLException e                    e printStackTrace                                    ServletContext context   getServletContext            RequestDispatcher dispatcher   context getRequestDispatcher url           dispatcher forward request  response                         see HttpServlet doPost HttpServletRequest request  HttpServletResponse response             protected void doPost HttpServletRequest request  HttpServletResponse response  throws ServletException  IOException              TODO Auto-generated method stub           This is my final Page where I display my result    lt    page language  java  contentType  text html  charset ISO-8859-1  pageEncoding  ISO-8859-1   gt   lt  DOCTYPE html PUBLIC  -  W3C  DTD HTML 4 01 Transitional  EN   http   www w3 org     TR html4 loose dtd  gt   lt html gt   lt head gt   lt meta http-equiv  Content-Type  content  text html  charset ISO-8859-1  gt   lt title gt Desk Board lt  title gt   lt  head gt   lt body gt  Hello  lt       String sucess message          Object sucess   request getAttribute  sucess        if  sucess    null   sucess message   sucess toString      gt   lt    sucess message   gt   lt  body gt   lt  html gt

User · Answer

You Can simply Use One Jsp Page To accomplish the task.

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE html>
<html>
   <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>JSP Page</title>
</head>
<body>
    <%
        String username=request.getParameter("user_name");
        String password=request.getParameter("password");
        String role=request.getParameter("role");
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/t_fleet","root","root");
            Statement st=con.createStatement();
            String query="select * from tbl_login where user_name='"+username+"' and password='"+password+"' and role='"+role+"'";
            ResultSet rs=st.executeQuery(query);
            while(rs.next())
            {
                session.setAttribute( "user_name",rs.getString(2));
                session.setMaxInactiveInterval(3000);
                response.sendRedirect("homepage.jsp");
            }
            %>



        <%}
        catch(Exception e)
        {
            out.println(e);
        }
    %>

</body>

I have use username, password and role to get into the system. One more thing to implement is you can do page permission checking through jsp and javascript function.

User · Answer

use this code it is working     index jsp or login jsp   lt    page language  java  contentType  text html  charset ISO-8859-1      pageEncoding  ISO-8859-1   gt   lt  DOCTYPE html PUBLIC  -  W3C  DTD HTML 4 01 Transitional  EN   http   www w3 org TR html4 loose dtd  gt   lt html gt   lt head gt   lt meta http-equiv  Content-Type  content  text html  charset ISO-8859-1  gt   lt title gt Insert title here lt  title gt   lt  head gt   lt body gt    lt form action  login  method  post  gt  Username    lt input type  text  name  username  gt  lt br gt  Password    lt input type  password  name  pass  gt  lt br gt   lt input type  submit  gt  lt br gt   lt  form gt    lt  body gt   lt  html gt       authentication servlet class      import java io IOException      import java io PrintWriter      import java sql Connection      import java sql DriverManager      import java sql SQLException      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 auth extends HttpServlet           private static final long serialVersionUID   1L           public auth                 super                      protected void doGet HttpServletRequest request                  HttpServletResponse response  throws ServletException  IOException                       protected void doPost HttpServletRequest request                  HttpServletResponse response  throws ServletException  IOException                try                   Class forName  com mysql jdbc Driver                  catch  ClassNotFoundException e                    e printStackTrace                               String username   request getParameter  username                String pass   request getParameter  pass                 String sql    select   from reg where username      username                    Connection conn   null               try                   conn   DriverManager getConnection  jdbc mysql   localhost Exam                            root                        Statement s   conn createStatement                     java sql ResultSet rs   s executeQuery sql                   String un   null                  String pw   null                  String name   null                  Need to put some condition in case the above query does not return any row  else code will throw Null Pointer exception                    PrintWriter prwr1   response getWriter                               if  rs isBeforeFirst                     prwr1 write   lt h1 gt  No Such User in Database lt h1 gt                   else       Conditions to be executed after at least one row is returned by query execution                     while  rs next                          un   rs getString  username                        pw   rs getString  password                        name   rs getString  name                                       PrintWriter pww   response getWriter                     if  un equalsIgnoreCase username   amp  amp  pw equals pass                                        use this or create request dispatcher                      response setContentType  text html                        pww write   lt h1 gt Welcome      name     lt  h1 gt                       else                       pww write  wrong username or password n                                                     catch  SQLException e                    e printStackTrace

[mysql] Create a simple Login page using eclipse and mysql

Examples related to mysql

Examples related to eclipse

Examples related to jsp

Examples related to servlets