【无标题】idea中的条件查询

最新推荐文章于 2024-04-16 03:05:14 发布

我的职业我定义

最新推荐文章于 2024-04-16 03:05:14 发布

阅读量813

点赞数

文章标签：数据库 sql database idea

本文链接：https://blog.csdn.net/weixin_57924621/article/details/121470185

版权

public void find(HttpServletRequest request, HttpServletResponse response){
        String name = request.getParameter("name");
        String tel = request.getParameter("tel");
        List<Map> list = null;
        StringBuffer sql = new StringBuffer();
        sql.append("select * from user ");
        list = userService.find(sql.toString(),name,tel);
        if(StrUtil.isNotEmpty(name)&&StrUtil.isEmpty(tel)){//只查名称
            sql.append("where userName like ? ");
            name="%"+name+"%";
            list = userService.find(sql.toString(),name);
        }else if(StrUtil.isEmpty(name)&&StrUtil.isNotEmpty(tel)){//只查tel
            sql.append("where userTel = ? ");
            list = userService.find(sql.toString(),tel);
        }else if(StrUtil.isNotEmpty(name)&&StrUtil.isNotEmpty(tel)){//都查
            sql.append("where userName like ? and userTel = ? ");
            name="%"+name+"%";
            list = userService.find(sql.toString(),name,tel);
        }else{
            list = userService.find(sql.toString());
        }
        JsonFromat jsonFromat = JsonFromat.success(list);
        OutPutJson.OutPutWriter(jsonFromat, response);

import com.alibaba.fastjson.JSON;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;

/**
 * 将数据以json格式返回到前端
 */
public class OutPutJson {
    public static void OutPutWriter(Object data, HttpServletResponse resp){
        String json = JSON.toJSONString(data);
        PrintWriter pw = null;
        try {
             pw =  resp.getWriter();
             pw.write(json);
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            if(pw!=null){
                pw.close();
            }
        }
    }
}