Value in the else condition is getting printed as the page loads, how else statement?

Discussion in 'JSP' started by sanidhya09, Sep 19, 2012.

  1. sanidhya09

    sanidhya09 New Member

    Joined:
    Sep 19, 2012
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Code:
    <%-- 
        Document   : login
        Created on : 12 Sep, 2012, 4:30:37 PM
        Author     : sanidhya09
    --%>
    
    <%@page contentType="text/html" pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html>
        <head>
            <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
            <title>Login Page</title>
            <link rel="stylesheet" href="css/margin.css" type="text/css" />
     
        </head>
           
        <body background="images/medicallogo.png">
          
          <form name="form" method="post" action="login.jsp" >
    
            <table background="images/bg1.gif" id="table" width="1000" height="500" border="0" cellpadding="0" cellspacing="0" align="center">
                <tr>
                   <td>
                       
                    <div id="Header">                  
                         <%@ include file="Header2.jsp" %>
                    </div>
                              
                    
                                <div id="body">
                                    <table  id="body1" width="750" height="500" border="0" cellpadding="0" cellspacing="0" align="center">
                                         <tr>
                                             <td>
                                                 
                                                 <%--Database Connectivity --%>
    <%@page import="java.sql.*"%>
    <%@page import="Hospital.Database_Connectivity;"%> 
    
    <%
     try{
     Connection con;
     Statement smt;
     ResultSet rs;
    String user=request.getParameter("user_id");
    String pass=request.getParameter("password");
    //Class.forName("com.mysql.jdbc.Driver").newInstance();
    //connection =DriverManager.getConnection("jdbc:mysql://localhost:3306/hospital", "root", "");
               
                    con=Database_Connectivity.dbcon();
                    smt=con.createStatement();
                    rs=smt.executeQuery("select * from login where user_id='"+user+"' and password='"+pass+"'");
                    if(rs.next())
                                           {
                    while(rs.next())
                    {
                        String str=rs.getString("type");
                        if(str.equals("employee"))
                        {
                         response.sendRedirect("index.jsp"); 
                        }
                              
                   }
                                   }
                    else
                                                               {
                              out.println("Not valid Credentials");
                              // response.sendRedirect("login.jsp"); 
                                                         }
                   }
                catch(Exception ex)
                    {
                    System.out.println("Error="+ex);
                }
    %>
    
                                                                               
                <p align="center"><font face="Arial Black" color="#800000"><b>PLEASE LOGIN HERE</b></font></p>                           
                    <table cellpadding="0" cellspacing="0" width="300" height="250" BORDER="0" align="center">
                         <tr>
                            <td>
                                <font color="#000080" face="arial"/>USERNAME :
                            </td>
                           <td>
                               <input type="text" name="user_id" size="20" id="user_id" />    
                           </td>
                        </tr>
                      <tr>
                          <td>
                            <font face="arial" color="#000080" />PASSWORD :
                             </td>
                           <td>
                               <input type="password" name="password" size="20" id="password" />
                           </td>
                     </tr>
                     <tr>
                         <td>
                            <font face="arial" color="#000080" />COUNTER :  </td>
                           <td>
                               <select size="1" name="Counter">
                            <option>Counter 1</option>
                            <option>Counter 2</option>
                            <option>Counter 3</option>
                            <option>Counter 4</option>
                            <option>Counter 5</option>
                            </select>
    
                           </td>
            </tr>
            <tr>
                             <td>
                            <font face="arial" color="#000080" />Remember Me :
                             </td>
                           <td>
                               <input type="CHECKBOX" name="checkbox" />
                           </td>
                     </tr>
            <tr align="right">
                <td>    
                               <button name="reset" type="reset"  style="background-color:lightseagreen">RESET</button>
                </td>
                <td>
                                <button name="login" style="background-color:lightseagreen">LOGIN</button>
                                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
                                 
                </td>
            </tr>
            
            </table>
                                            </td>
                                         </tr>
                                    </table>
                                </div>                           
                   <div id="footer"><br />
                        <%@ include file="footer2.jsp" %>
                   </div> 
                   
                   </td> 
                </tr>          
            </table>
          </form>
        </body>
    </html>
    
    
    
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice