あいまい検索の方法を調べていたのですが、ページ上で複数の情報が入ったとき両方のあいまい検索結果を返したい場合どうすればいいでしょうか?
if文で強引に強引に検索をできるようにしたのですが、ほかにやり方があれば知りたいです。
Entity
1package com.example.demo; 2 3import java.util.Date; 4 5import javax.persistence.Column; 6import javax.persistence.Entity; 7import javax.persistence.GeneratedValue; 8import javax.persistence.GenerationType; 9import javax.persistence.Id; 10import javax.persistence.Table; 11 12@Entity 13@Table(name="mydata") 14public class MyData { 15 16 @Id 17 @GeneratedValue 18 @Column 19private Long id; 20 21 @Column 22private String name; 23 24 @Column 25private String memo; 26 27 28 29public MyData(String name,String memo) { 30 super(); 31 this.name = name; 32 this.memo = memo; 33 34} 35public MyData() { 36 37} 38 39public Long getId() { 40 return id; 41} 42 43public String getName() { 44 return name; 45} 46 47public String getMemo() { 48 return memo; 49} 50} 51
Repository
1package com.example.demo.repositories; 2 3import java.util.List; 4 5import org.springframework.data.jpa.repository.JpaRepository; 6 7import com.example.demo.MyData; 8 9public interface MyDataRepository extends JpaRepository<MyData, Long> { 10 public List<MyData> findByNameLike(String name); 11 public List<MyData> findByMemoLike(String memo); 12 13} 14
Controller
1package com.example.demo; 2 3 4 5import java.util.List; 6 7import org.springframework.beans.factory.annotation.Autowired; 8import org.springframework.stereotype.Controller; 9import org.springframework.transaction.annotation.Transactional; 10import org.springframework.web.bind.annotation.RequestMapping; 11import org.springframework.web.bind.annotation.RequestMethod; 12import org.springframework.web.bind.annotation.RequestParam; 13import org.springframework.web.servlet.ModelAndView; 14 15import com.example.demo.repositories.MyDataRepository; 16 17 18@Controller 19public class HeloController { 20 21 @Autowired 22 MyDataRepository repository; 23 24 25 26 27 28 @RequestMapping(value = "/find", method = RequestMethod.GET) 29 public ModelAndView index(ModelAndView mav) { 30 mav.addObject("value", ""); 31 List<MyData>list = repository.findAll(); 32 mav.addObject("datalist",list); 33 return mav; 34 } 35 36 @RequestMapping(value = "/find", method = RequestMethod.POST) 37 @Transactional(readOnly=false) 38 39 public ModelAndView search(@RequestParam("name") String name,String memo,ModelAndView mav) { 40 mav.setViewName("find"); 41 42 if(name == "" && memo == "") { 43 mav = new ModelAndView("redirect:find"); 44 45 }else if(name !="" && memo ==""){ 46 List<MyData> listname = repository.findByNameLike("%"+name+"%"); 47 mav.addObject("datalist",listname); 48 49 }else if(name =="" && memo !=""){ 50 List<MyData> listmemo = repository.findByMemoLike("%"+memo+"%"); 51 mav.addObject("datalist",listmemo); 52 } 53 else if(name !="" && memo !=""){ 54 55 List<MyData> listmemo = repository.findByMemoLike("%"+memo+"%"); 56 List<MyData> listname = repository.findByNameLike("%"+name+"%"); 57 mav.addObject("datalist",listname); 58 mav.addObject("datalist",listmemo); 59 } 60 return mav; 61 } 62}
html
1 <form action="/find" method="post"> 2 <tr> 3 <td> 4 名前検索 5 </td> 6 7 <td> 8 <input type="text" name="name" th:value="${value}"/> 9 </td> 10 11 <td> 12 メモ検索 13 </td> 14 <td> 15 <input type="text" name="memo" th:value="${value}"/> 16 </td> 17 </tr> 18 <tr> 19 <td> 20 </td> 21 <td> 22 <input type="submit" /> 23 </td> 24 </tr> 25 </form> 26 </table> 27<hr/> 28 <table> 29 <tr> 30 <th>名前</th> 31 <th>メモ</th> 32 </tr> 33 <tr th:each="obj : ${datalist}"> 34 <td th:text="${obj.name}"></td> 35 <td th:text="${obj.memo}"></td> 36 </tr> 37 </table> 38</body> 39</html>
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。