sql中字符串拼接
SELECT * FROM tableName WHERE name LIKE CONCAT(CONCAT('%', #{text}), '%');
举个例子说明一下:
如://模糊搜索花名
IFlowerMapper.java
@Select("select * from flower where name LIKE CONCAT(CONCAT('%', #{name}), '%')")
public List<Flower> getFlowersByName(String name);
public List<Flower> getFlowersByName(String name);
jsp页面:
<form action="/ssm/Flower/findbyname" method="post" >
<input type="text" value="Site Search" name="name" />
<input type="submit" value="submit" />
</form>
controller页面:
@RequestMapping("/findbyname")
public String index132(HttpServletRequest request,Model model){
String name=request.getParameter("name");
List<Flower> user = flowerService.findFlowersByName(name);
model.addAttribute("flower",user);
return "flower/product";
}
public String index132(HttpServletRequest request,Model model){
String name=request.getParameter("name");
List<Flower> user = flowerService.findFlowersByName(name);
model.addAttribute("flower",user);
return "flower/product";
}
service页面:
public List<Flower> findFlowersByName(String username) {
List<Flower> u=iFlowerMapper.getFlowersByName(username);
return u;
}
效果图://通过搜索花 得到所有包含花字的 鲜花信息