Databases
StackOverflow2013
Postsdbo
POUpdating database record after displaying to user
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUpdating database record after displaying to user
    primarykey
    data
    text
    <p>I have a question on how to update a particular record in a database using JSTL and java servlets. </p> <p>Ok to call one record, I use a servlet to run a query to populate a jsp page using this type of format. </p> <pre><code> ResultSet results = getRecords.executeQuery(); //run database query Result result = ResultSupport.toResult(results); request.setAttribute("result", result); RequestDispatcher rd = request.getRequestDispatcher("/showReport.jsp"); //redirect to this page with query info rd.forward(request, response); </code></pre> <p>In the jsp page, I use this format to populate the page.<br> the row number is the corresponding to the index of the value on how the query is run.</p> <pre><code> &lt;c:forEach var="row" items="${result.rowsByIndex}"&gt; &lt;form action = "/runthis/servlet?id=${row[0]}" method = "get" &gt; Employee Name&lt;input type="text" value="&lt;c:out value="${row[2]}"/&gt;" /&gt; Department&lt;select&gt; &lt;option value="&lt;c:out value="${row[4]}"/&gt;"&gt;&lt;c:out value="${row[4]}"/&gt;&lt;/option&gt;&lt;/select&gt; &lt;input type="submit" value="Save"&gt; &lt;/form&gt; &lt;/c:forEach&gt; </code></pre> <p>So for instance, if someone changes the Employee Name, but leaves the Department field alone, or vice versa, how would I go about this? </p> <p>I think I should be able to kick this form action to a "update servlet", but I would rather not "update" every element in the record if I do not need to.</p> <p>Also I'm still learning web dev, so if you can think of a better way to prepopulate stuff, via javascript or whatever, I'm willing to try that as well, if it's a possible solution. </p> <p>Thanks for any help!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDrake0727
    1. USDrake0727
    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. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CO5 things: 1) well done! separation between database logics and front end jsp :) 2) lonely</strong>-tag? 3) input-tag doesn't close itself. 4) how would one of these forms you will generate be submitted? by pressing <enter> while standing in the text field? cause, you know, there's no submit button ;) 5) why is there no method-attribute on your form-tag?
      singulars
      1. POUpdating database record after displaying to user
      1. USdavogotland
    2. CO1) Thanks, I originally started learning this doing scriptlets, and learned it was the outdated, wrong way :D 2) fixed, thanks, was doing a quick copy paste, and I did not delete enough 3) fixed 4) added submit button, nice observation :) 5) added method get (not sure if it should be get or post)
      singulars
      1. POUpdating database record after displaying to user
      1. USDrake0727
    3. COoutdated or not, there is separation. i believe in separation! and i would use post in this case, since you're going to write data, not read it :) new question! when the servlet (/runthis/servlet) gets the form data, how will the servlet know what line in the database to update?
      singulars
      1. POUpdating database record after displaying to user
      1. USdavogotland
 

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