Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>1) change the input type to button instead of submit and add an onclick event that will call your submitPage function passing in the action to call</p> <pre><code>&lt;input class="button" id="save" type="button" name="user_request" value="Save" onclick="submitPage('citizen_registration.htm');"/&gt; &lt;input class="button" id="update" type="button" name="user_request" value="Update" onclick="submitPage('citizen_registration.htm');"/&gt; &lt;input class="button" id="query" type="button" name="user_request" value="Query" onclick="submitPage('citizen_list.htm');"/&gt; </code></pre> <p>2) change your submitPage function to set the action based on which button was clicked</p> <pre><code>function submitPage(action){ document.getElementById("citizenRegistration").action = action; document.getElementById("citizenRegistration").method = "POST"; document.getElementById("citizenRegistration").submit(); } </code></pre> <p>3) have 2 controller methods, one mapped to save/update, the other mapped to list</p> <pre><code>@RequestMapping(value="citizen_list.htm", method = RequestMethod.POST) public ModelAndView getCitizenList(@Valid @ModelAttribute Citizens citizen, BindingResult result, ModelMap m, Model model, @RequestParam(value="user_request") String user_request) throws Exception { try{ logger.debug("about to preform query"); //citizenManager.getListOfCitizens(citizen); if(citizenManager.getListOfCitizens(citizen).isEmpty()){ model.addAttribute("icon","ui-icon ui-icon-circle-close"); model.addAttribute("results","Notice: Query Caused No Records To Be Retrived!"); }else{ model.addAttribute("citizens",citizenManager.getListOfCitizens(citizen)); return new ModelAndView("citizenList"); } }catch(Exception e){ logger.error("Exception in CitizenRegistrationController - ModelAndView loadPage "+e); //request.setAttribute("error",e.getMessage()); return new ModelAndView("citizen_registration"); } } @RequestMapping(value="citizen_registration.htm", method = RequestMethod.POST) public ModelAndView handleRequest(@Valid @ModelAttribute Citizens citizen, BindingResult result, ModelMap m, Model model, @RequestParam(value="user_request") String user_request) throws Exception { try{ logger.debug("In Http method for CitizenRegistrationController - Punishment Registration"); logger.debug("User Request Is " + user_request); if(result.hasErrors()){ logger.debug("Has Errors"); return new ModelAndView("citizen_registration"); }else{ //check if its a save of an update if(user_request.equals("Save")){ citizenManager.RegisterCitizen(citizen); model.addAttribute("icon","ui-icon ui-icon-circle-check"); model.addAttribute("results","Record Was Saved"); return new ModelAndView("citizen_registration"); } else if (user_request.equals("Update")){ logger.info("About to do update"); citizenManager.UpdateCitizen(citizen); return new ModelAndView("citizen_registration"); } } logger.debug("Has No Errors"); return new ModelAndView("citizen_registration"); }catch(Exception e){ logger.error("Exception in CitizenRegistrationController - ModelAndView loadPage "+e); //request.setAttribute("error",e.getMessage()); return new ModelAndView("citizen_registration"); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POSpring MVC Pages HTTP Status 400 and Incorrect URL's
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USclav
    1. USclav
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSpring MVC Pages HTTP Status 400 and Incorrect URL's
      singulars
      1. PTQuestion
    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. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    1. COi am submitting he page using jscript i dont think there is any need to include the action in the form tag?
      singulars
      1. PO
      1. USdevdar
    2. COthe issue i am having is when i am on the registration form and i click query i am taken to the citizenList.htm and that fine i dont use a redirect to get to this page i do a return new ModelAndView("citizenList"); and the page is returned ok with the results however the url doesn't change it stays as http://localhost:8084/crimeTrack/citizen_registration.htm.
      singulars
      1. PO
      1. USdevdar
    3. COAh, I see, you're returning new ModelAndView("citizenList") and you expect to see the URL change to something like localhost:8084/crimeTrack/citizenList.htm. Is that correct? If that's the case you need a separate controller method to retrieve the citizenList that's mapped to the URL you'd like to see. Right now you have everything in the handleRequest method which is mapped to citizen_registration.htm. You want something like @RequestMapping("/citizenList.htm") public ModelAndView getCitizenList() ...
      singulars
      1. PO
      1. USclav
 

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