Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The problem (and its solution) is as follows:</p> <p>You create a request scope bean <code>user</code> but once the page is loaded the request is finished and gone - no wonder it is <code>null</code> in the next request which is completely unrelated to this one. What you probably wanted to do is the following:</p> <p>1) Remove the <code>&lt;jsp:useBean ...&gt;</code> from your jsp page completely so it will look as follows:</p> <pre><code>&lt;%@ page contentType="text/html;charset=UTF-8" language="java" %&gt; &lt;%@page import="com.hermes.data.RateCode_" %&gt; &lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"&gt; &lt;html&gt; &lt;head&gt;&lt;title&gt;Rate Code&lt;/title&gt;&lt;/head&gt; &lt;body&gt; &lt;form id="f_rateCode" action="/forwarder.jsp" method="post"&gt; &lt;table align="center" border="1" cellspacing="0"&gt; &lt;tr&gt; &lt;td colspan="2" align="center" class="header"&gt;Rate Code Administrations&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="right" style="border-style: solid;"&gt;Rate Code:&lt;/td&gt; &lt;td align="left" style="border-style: solid;"&gt;&lt;input type="text" id="code" name="code" value="" size="10" maxlength="32" style="width: 100px"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="right" style="border-style: solid;"&gt;Rate Description:&lt;/td&gt; &lt;td align="left" style="border-style: solid;"&gt;&lt;input type="text" id="description" name="description" value="" maxlength="128" size="40"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;input type="submit" value="ok"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/form&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>2) Your form now redirects to another jsp, the forwarder. It looks like follows:</p> <pre><code>&lt;%@ page contentType="text/html;charset=UTF-8" language="java" %&gt; &lt;jsp:useBean id="user" class="com.hermes.data.RateCode_" scope="request"/&gt; &lt;jsp:setProperty name="user" property="*" /&gt; &lt;jsp:forward page="/ratePromoCodes" /&gt; </code></pre> <p>What this does: it creates the bean in request scope - <em>the request which submitted the form</em>. Then it populates the bean properties with the data from the form and finally it forwards (<em>IN SAME REQUEST, HERE IS THE POINT</em>) to the servlet which does some job.</p> <p>3) Finally do something in your servlet, I did this for testing purposes:</p> <pre><code>public class TestServlet extends javax.servlet.http.HttpServlet { protected void doPost(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws javax.servlet.ServletException, IOException { RateCode_ code = (RateCode_) request.getAttribute("user"); System.out.println(code); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POjsp useBean is NULL by getAttribute by servlet
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJan Zyka
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthanx budy it works but why it don't work with servlet. GOT null. is there any other way to do this but only in JSP. without framework.
      singulars
      1. PO
      1. USRavi Parekh
    2. COscope="session" would also give NULL while it is in SESSION.
      singulars
      1. PO
      1. USRavi Parekh
    3. COThe point is that if you want the bean to have properties set according to the form-entered values you must call <jsp:useBean> AFTER the form was submitted. It will work with session scope if you go directly to the Servlet BUT 1) You must use request.getSession().getAttribute("user") 2) Note that if you put the <jsp:useBean> in your form page the bean will try to get populated on page load when the form is empty. So as result the bean will not be null in the servlet but the properties will not get set.
      singulars
      1. PO
      1. USJan Zyka
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload