How to get and use the parameter from URL?

[Jozo Stan]

Hello everybody!


I have a table with sport events. Table is populated from database.



Uploaded with ImageShack.us



When I click on detalji (details) it should open a new page with details about the match. Result prediction, users comments and so on.

I send the ID of the match through GET method

http://localhost:8909/SportInfo/dohUtakmica.html?id=1

.

The problem is that I receive all matches from database on the new page, but I only want the match that has the ID I sent through GET method.

I hope You understand what I want.

With the next code I receive empty table.

Here is my code:

Controller DohUtakmica.java

@Controller

public class DohUtakmica {
	
	@Autowired
	public SportService sportService;
	

	@RequestMapping(value = "/dohUtakmica.html", method = RequestMethod.GET)
	public String redirect(Model model){	

		model.addAttribute("utakmica", new Utakmica());		
		return "dohUtakmica";
	}
	
	@RequestMapping(value="/dohUtakmica.html", method=RequestMethod.POST)
	public String redi(@ModelAttribute() Utakmica utakmica, BindingResult results, Model model){
			
		
		
		if (results.hasErrors()) {
			return "index";
		}
		
		sportService.dohvatiUtakmicuPremaID("utakmica_id");
		model.addAttribute("utakmica", utakmica);
		
		
		return "dohUtakmica";

	}

Method for fetching ID from DAOimpl

@Override
	public Utakmica dohvatiUtakmicuPremaID(String utakmica_id) {
		Utakmica odabrana = (Utakmica) getHibernateTemplate().findByNamedParam(
						"from Utakmica where utakmica_id = :trazenId", "trazenId", Integer.parseInt(utakmica_id)).get(0);
		return odabrana;


	}

dohUtakmica.jsp

<table cellpadding="5" cellspacing="0" border="3" class="display" id="coolTablica" width="100%" style="border-color: blue;">
<thead>
<tr>


<th> <fmt:message key="odabirSport.domacin"/> </th>
<th> <fmt:message key="odabirSport.gost"/> </th>
<th> <fmt:message key="odabirSport.rez"/> </th>
</tr>

</thead>

<tbody>

<%
String utakmica_id = request.getParameter("id");
%>
<c:if test = "${param.name != null}">

<c:if test="${listaUtakmica.contains(utakmica.utakmica_id) == true}">

<tr>
<td><c:out value="${utakmica.domacin.nazivTeama}"/></td>
<td><c:out value="${utakmica.gost.nazivTeama}"/></td>
<td><c:out value="${utakmica.rezultat}"/></td>
</tr>


</tbody>

</table>


I hope that someone could give me an advice.

Thanks in advance!

[jatan bhavsar]

Hi Jojo,

I receive all matches from database on the new page

Have you try to fetch the data which matches with the id only? You are passing the id in the method so you can retrieve records based on that id and then display on the page.

Regards
Jatan

[Jozo Stan]

jatan bhavsar wrote:Hi Jojo,

I receive all matches from database on the new page

Have you try to fetch the data which matches with the id only? You are passing the id in the method so you can retrieve records based on that id and then display on the page.

Regards
Jatan

Exactly that is what I want to achieve. I want to fetch only the match whose ID I have in the url.

[Bear Bibeault]

Then that's what your code should do. What is it doing now? We have no way of knowing.

[jatan bhavsar]

Hi Jojo,

you need to write code for that . You need to fetch the data from the database based on the parameters from the URL. that was the meaning of my post. You already mentioned in your post that you are getting all the data so you need to retrieve the data which you need(which you are passing in the url)


Regards
Jatan

[Jozo Stan]

This is a part of my dohUtakmica.jsp

<table cellpadding="5" cellspacing="0" border="3" class="display" id="coolTablica" width="100%" style="border-color: blue;">
       <thead>
       		<tr>
       		

			<th> <fmt:message key="odabirSport.domacin"/> </th>
			<th> <fmt:message key="odabirSport.gost"/> </th>
			<th> <fmt:message key="odabirSport.rez"/> </th>
			</tr>
			
	    </thead>
      
      <tbody>		
        <c:forEach var="utakmica" items="${listaUtakmica}"> 

  	<tr>    
                     <td><c:out  value="${utakmica.domacin.nazivTeama}"/></td>
                      <td><c:out  value="${utakmica.gost.nazivTeama}"/></td>
                        <td><c:out  value="${utakmica.rezultat}"/></td>
              	 </tr> 
             </c:forEach> 
            </tbody>
            
         </table>

In listaUtakmica I fetch all the matches from database.

With this code i receive:



Uploaded with ImageShack.us

and the url was

http://localhost:8909/SportInfo/dohUtakmica.html?id=9

In database the match between Federer and Nadal has id 9. I know that with this code I won't achieve what I want. The problem is that I don't know how to fetch only this particular match.

I hope that the answer isn't fetching from database directly from jsp file because that is against the MVC rules.

Any help is appreciate.
Thank you.

[Bear Bibeault]

Jozo Stan wrote:I hope that the answer isn't fetching from database directly from jsp file because that is against the MVC rules.

You are correct. That is never the answer! :thumbup:

[Bear Bibeault]

Jozo Stan wrote: The problem is that I don't know how to fetch only this particular match

What is your DB fetch code like? It should be something like "select * from tablename where id=?", and supplying the single id value that you want to fetch.

[Jozo Stan]

This is part of my HibernateDAO

@Override
	public List<Utakmica> dohvatiUniq(String utakmica_id) {
		return getHibernateTemplate().find("from Utakmica WHERE utakmica_id =?", utakmica_id);
	}

Controller DohUtakmica.java

@Controller

public class DohUtakmica {
	
	
	@ModelAttribute("mojaUtList")
	public List<Utakmica> getUtakmicaList() {
		return new ArrayList<Utakmica>();
	}
	
	
	@Autowired
	public SportService sportService;
	
	String utakmica_id;
	

	@RequestMapping(value = "/dohUtakmica.html", method = RequestMethod.GET)
	public String redirect(Model model){	
		
		List<Utakmica> tempLista=new ArrayList<Utakmica>();
		tempLista=sportService.dohvatiUniq(utakmica_id);
		model.addAttribute("mojaUtList", tempLista);

		model.addAttribute("utakmica", new Utakmica());		
		return "dohUtakmica";
	}
	
	
	@RequestMapping(value="/dohUtakmica.html", method=RequestMethod.POST)
	public String redi(@ModelAttribute Utakmica utakmica, @ModelAttribute("mojaUtList") List<Utakmica> tempLista, 
			@RequestParam("id") String idOdabraneUtakmiceString, BindingResult results, Model model){
			
		Integer idOdabraneUtakmice=Integer.parseInt(idOdabraneUtakmiceString);
		
		
		if (results.hasErrors()) {
			return "index";
		}
		
		sportService.dohvatiUtakmicuPremaID("idOdabraneUtakmice");
		model.addAttribute("utakmica", utakmica);
		
		
		return "dohUtakmica";

	}
}

I think that my code in POST method isn't correct...

[jatan bhavsar]

Hi Jojo,

url is : http://localhost:8909/SportInfo/dohUtakmica.html?id=9

You are passing parameter with the name id and in the query to fetch the values you are using

from Utakmica WHERE utakmica_id =?", utakmica_id

Instead of utakmica_id you should fetch the data with the id which will give you the specific data.

Regards
Jatan

[Jozo Stan]

I have finally solved this. Thank you all!

Here is my code:

Method from HibernateDAO

public List<Utakmica> dohvatiUtakmicuPremaID(String utakmica_id) {
		return getHibernateTemplate().findByNamedParam(
				"from Utakmica where utakmica_id = :trazenId", "trazenId", Long.parseLong(utakmica_id));
	}

Controller

@Controller

public class DohUtakmica {
	
	
	@ModelAttribute("mojaUtList")
	public List<Utakmica> getUtakmicaList() {
		return new ArrayList<Utakmica>();
	}
	
	
	@Autowired
	public SportService sportService;
	
	
	@RequestMapping(value = "/dohUtakmica.html", method = RequestMethod.GET)
	public String redirect(@RequestParam("id") String broj, Model model){	
		
		
		
		List<Utakmica> tempLista=new ArrayList<Utakmica>();
		tempLista=sportService.dohvatiUtakmicuPremaID(broj);
		
		model.addAttribute("mojaUtList", tempLista);

		model.addAttribute("utakmica", new Utakmica());		
		return "dohUtakmica";
	}
	
	
	@RequestMapping(value="/dohUtakmica.html", method=RequestMethod.POST)
	public String redi(Model model){
		
		return "dohUtakmica";

	}
}

Part of jsp

<table cellpadding="5" cellspacing="0" border="3" class="display" id="coolTablica" width="100%" style="border-color: blue;">
       <thead>
       		<tr>
       		

			<th> <fmt:message key="odabirSport.domacin"/> </th>
			<th> <fmt:message key="odabirSport.gost"/> </th>
			<th> <fmt:message key="odabirSport.rez"/> </th>
			</tr>
			
	    </thead>
      
      <tbody>		
        <c:forEach var="utakmica" items="${mojaUtList}"> 
					
 					<tr>    
                     <td><c:out  value="${utakmica.domacin.nazivTeama}"/></td>
                      <td><c:out  value="${utakmica.gost.nazivTeama}"/></td>
                        <td><c:out  value="${utakmica.rezultat}"/></td>
              	 </tr> 


                  </c:forEach>  
            </tbody>
            
         </table>