I have this code in my view to display a input box and a submit button. (UPDATED)
<form action="/hms/accommodations" method="GET">
<input type="text" name="searchKeyword"/>
<input type="submit" value="Submit"/>
</form>
As I click the submit button, I need to pass whatever the user's typed into the input box to be passed on to a method in my Controller.
This is the method I have in my Controller. (UPDATED)
@RequestMapping(value = "/hms/accommodations", method = RequestMethod.GET)
public List<Accommodation> listofAccomo(@RequestParam String searchKeyword){
List<Accommodation> searchResult = accommodationService.findAllAccommodationBySearchBox(searchKeyword);
return searchResult;
}
I have this in my AccommodationService class:
public abstract List<Accommodation> findAllAccommodationBySearchBox(String searchKeyword);
And this on another class:
public List<Accommodation> findAllAccommodationBySearchBox(String searchKeyword){
TypedQuery<Accommodation> searchResult = em.createNamedQuery("findAllAccommodationBySearch", Accommodation.class);
searchResult.setParameter("searchKeyword",'%'+searchKeyword+'%');
List<Accommodation> result=searchResult.getResultList();
return result;
}
I have this NamedQuery in my domain.:
@NamedQueries(
{
@NamedQuery(
name = "findAllAccommodationBySearch",
query = "SELECT a FROM Accommodation a WHERE a.person.firstName LIKE :searchKeyword OR a.person.middleName LIKE :searchKeyword OR a.person.lastName LIKE :searchKeyword OR a.room.roomNumber LIKE :searchKeyword OR a.person.pvId LIKE :searchKeyword OR a.startDate LIKE :searchKeyword OR a.endDate LIKE :searchKeyword"
)
})
What happens is that when I click my submit button after typing, it redirects to the same page but with a different URL but it does not seem to access my Controller method because it doesn't return the value it was supposed to return. What am I missing out here? Hope someone can help. Thanks!
EDIT: This is my Controller class code.
import java.io.UnsupportedEncodingException;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.TypedQuery;
import javax.servlet.http.HttpServletRequest;
import javax.validation.Valid;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.util.UriComponentsBuilder;
import org.springframework.web.util.UriUtils;
import org.springframework.web.util.WebUtils;
import ph.com.smesoft.hms.domain.Accommodation;
import ph.com.smesoft.hms.service.AccommodationService;
import ph.com.smesoft.hms.service.PersonService;
import ph.com.smesoft.hms.service.RoomService;
@Controller
@RequestMapping("/accommodations")
public class AccommodationController {
@RequestMapping(value = "/{id}", method = RequestMethod.GET, headers = "Accept=application/json")
@ResponseBody
public ResponseEntity<String> showJson(@PathVariable("id") Long id) {
HttpHeaders headers = new HttpHeaders();
headers.add("Content-Type", "application/json; charset=utf-8");
try {
Accommodation accommodation = accommodationService.findAccommodation(id);
if (accommodation == null) {
return new ResponseEntity<String>(headers, HttpStatus.NOT_FOUND);
}
return new ResponseEntity<String>(accommodation.toJson(), headers, HttpStatus.OK);
} catch (Exception e) {
return new ResponseEntity<String>("{\"ERROR\":"+e.getMessage()+"\"}", headers, HttpStatus.INTERNAL_SERVER_ERROR);
}
}
[1:49:35 AM] Kath Revilla: @RequestMapping(headers = "Accept=application/json")
@ResponseBody
public ResponseEntity<String> listJson() {
HttpHeaders headers = new HttpHeaders();
headers.add("Content-Type", "application/json; charset=utf-8");
try {
List<Accommodation> result = accommodationService.findAllAccommodations();
return new ResponseEntity<String>(Accommodation.toJsonArray(result), headers, HttpStatus.OK);
} catch (Exception e) {
return new ResponseEntity<String>("{\"ERROR\":"+e.getMessage()+"\"}", headers, HttpStatus.INTERNAL_SERVER_ERROR);
}
}
@RequestMapping(method = RequestMethod.POST, headers = "Accept=application/json")
public ResponseEntity<String> createFromJson(@RequestBody String json, UriComponentsBuilder uriBuilder) {
HttpHeaders headers = new HttpHeaders();
headers.add("Content-Type", "application/json");
try {
Accommodation accommodation = Accommodation.fromJsonToAccommodation(json);
accommodationService.saveAccommodation(accommodation);
RequestMapping a = (RequestMapping) getClass().getAnnotation(RequestMapping.class);
headers.add("Location",uriBuilder.path(a.value()[0]+"/"+accommodation.getId().toString()).build().toUriString());
return new ResponseEntity<String>(headers, HttpStatus.CREATED);
} catch (Exception e) {
return new ResponseEntity<String>("{\"ERROR\":"+e.getMessage()+"\"}", headers, HttpStatus.INTERNAL_SERVER_ERROR);
}
}
@RequestMapping(value = "/jsonArray", method = RequestMethod.POST, headers = "Accept=application/json")
public ResponseEntity<String> createFromJsonArray(@RequestBody String json) {
HttpHeaders headers = new HttpHeaders();
headers.add("Content-Type", "application/json");
try {
for (Accommodation accommodation: Accommodation.fromJsonArrayToAccommodations(json)) {
accommodationService.saveAccommodation(accommodation);
}
return new ResponseEntity<String>(headers, HttpStatus.CREATED);
} catch (Exception e) {
return new ResponseEntity<String>("{\"ERROR\":"+e.getMessage()+"\"}", headers, HttpStatus.INTERNAL_SERVER_ERROR);
}
}
@RequestMapping(value = "/{id}", method = RequestMethod.PUT, headers = "Accept=application/json")
public ResponseEntity<String> updateFromJson(@RequestBody String json, @PathVariable("id") Long id) {
HttpHeaders headers = new HttpHeaders();
headers.add("Content-Type", "application/json");
try {
Accommodation accommodation = Accommodation.fromJsonToAccommodation(json);
accommodation.setId(id);
if (accommodationService.updateAccommodation(accommodation) == null) {
return new ResponseEntity<String>(headers, HttpStatus.NOT_FOUND);
}
return new ResponseEntity<String>(headers, HttpStatus.OK);
} catch (Exception e) {
return new ResponseEntity<String>("{\"ERROR\":"+e.getMessage()+"\"}", headers, HttpStatus.INTERNAL_SERVER_ERROR);
}
}
@Autowired
AccommodationService accommodationService;
@Autowired
PersonService personService;
@Autowired
RoomService roomService;
@RequestMapping(produces = "text/html")
public String list(@RequestParam(value = "page", required = false) Integer page, @RequestParam(value = "size", required = false) Integer size, @RequestParam(value = "sortFieldName", required = false) String sortFieldName, @RequestParam(value = "sortOrder", required = false) String sortOrder, Model uiModel) {
if (page != null || size != null) {
int sizeNo = size == null ? 10 : size.intValue();
final int firstResult = page == null ? 0 : (page.intValue() - 1) * sizeNo;
uiModel.addAttribute("accommodations", Accommodation.findAccommodationEntries(firstResult, sizeNo, sortFieldName, sortOrder));
float nrOfPages = (float) accommodationService.countAllAccommodations() / sizeNo;
uiModel.addAttribute("maxPages", (int) ((nrOfPages > (int) nrOfPages || nrOfPages == 0.0) ? nrOfPages + 1 : nrOfPages));
} else {
uiModel.addAttribute("accommodations", Accommodation.findAllAccommodations(sortFieldName, sortOrder));
}
addDateTimeFormatPatterns(uiModel);
return "accommodations/list";
}
@RequestMapping(value = "/hms/accommodations", method = RequestMethod.GET)
public List<Accommodation> listofAccomo(@RequestParam String searchKeyword){
List<Accommodation> searchResult = accommodationService.findAllAccommodationBySearchBox(searchKeyword);
return searchResult;
}
void addDateTimeFormatPatterns(Model uiModel) {
uiModel.addAttribute("accommodation_startdate_date_format","yyyy-MM-dd");
uiModel.addAttribute("accommodation_enddate_date_format","yyyy-MM-dd");
}
void populateEditForm(Model uiModel, Accommodation accommodation) {
uiModel.addAttribute("accommodation", accommodation);
addDateTimeFormatPatterns(uiModel);
uiModel.addAttribute("people", personService.findAllPeople());
uiModel.addAttribute("rooms", roomService.findAllRooms());
}
String encodeUrlPathSegment(String pathSegment, HttpServletRequest httpServletRequest) {
String enc = httpServletRequest.getCharacterEncoding();
if (enc == null) {
enc = WebUtils.DEFAULT_CHARACTER_ENCODING;
}
try {
pathSegment = UriUtils.encodePathSegment(pathSegment, enc);
} catch (UnsupportedEncodingException uee) {}
return pathSegment;
}
}