Hi,

Here is my jsp page where i trying to display the data from table. Here form1 is the name of drop down list in my searchuser.jsp page. The content in the drop down list is a name of one column of the database. I am able to connect firstjsp page showing item available in drop down menu.But when I am running this page I am failing to connect it to database.
Whether My marked query is right or wrong?

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page language ="java" %>
<%@ page import="java.sql.*, javax.sql.*, javax.naming.*,java.io.*,java.util.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>      
              
          <% 
          
          String form=request.getParameter("[B]form1[/B]"); 
          try {
          
          Connection connection = null;
          Statement st = null;
          ResultSet rs = null;
          Class.forName("com.mysql.jdbc.Driver");
          Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mynewdatabase","root", "root123");
           st=con.createStatement();
          
               rs = st.executeQuery("select emailid ,password  from user where emailid='"+form+"'");
                     rs.next();
                     String EMAIL = rs.getString("emailid");
                     String PASSWORD = rs.getString("password");
                     rs.close();
                     %>
                          
                   <table border="1">
                        <%
                      while (rs.next()) {
                           %>

                 <tbody>
                  <tr><thead>
                  <tr>
                   <th><b>MODIFY USER</b></th>
                 </tr>
                   </thead>
                       <td>E-MAIL</td>
                     <td><input type="text" name="email" value=="<%=EMAIL%>" size="30" /> </td>
                    </tr>
                    <tr>
                       <td>PASSWORD</td>
                       <td><input type="text" name="password" value=="<%=PASSWORD%>" size="10" /></td>
                           </tr>
                         <tr>
                        <td><input type="submit" value="SUBMIT" name="submit" /></td>
                      <td><input type="reset" value="RESET" name="res" /></td>
                        </tr>
                        </tbody>
                        
               <%   }    %>
            <%
             
                    rs.close();
                   st.close();
                    connection.close();
            } catch (Exception ex) {
               %>
               <%
                out.println("Unable to connect to database.");
            }
        %>

</table>       
    </body>
</html>

Any Suggestion is highly appreciated.
thanks and Regards
haresh

As Peter_budo had put it in one of his earlier posts, "Its hard to read errors from a crystal ball".

But it seems like you have no intention of learning anything from here, you just come here for quick fixes to your problems. Practically every one has already told you not to do database connectivity inside a JSP, but you refuse to budge and continue to persist in your naive ways.

Really very difficult to find error from such a big JSP programming code. I will advise you to contact any Java or JSP programmer. Hope you will find the error.

<URL SNIPPED>

Do not use scriptlets in your jsp (NEVER EVER) use expression Language and JSTL instead. JSP are not ment for logic they are only meant for displaying static HTML; If you want to do any processing then use a Servlet.

Strip out all your JDBC connection code and put it inside a Servlet and override the init method from HttpServlet. Put all your connection parameters in a init-param tag in your Deployment Descriptor (web.xml).


Please don't ever write code like this again

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.