1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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