<select name="userId" lay-filter="aihao" lay-search="" clear>
<option value="-1">全部</option>
<c:forEach items="${users}" var="item">
<option value="${item.id}" ${ item.id == obj.userId ? "selected" : ""}>${item.username}</option>
</c:forEach>
</select>
```java
String sql2 = "SELECT * FROM user WHERE 1=1 and is_delete = 0 ";
List<User> users = userService.listBySqlReturnEntity(sql2);
model.addAttribute("users",users);
String sql = "SELECT * FROM daily_inspection WHERE 1=1 ";
if(!isEmpty(dailyInspection.getUserId()) && dailyInspection.getUserId() != -1){//这一行非常不理解!!!!
sql += " and user_id = "+dailyInspection.getUserId();
}
请问是如何进行搜索的,jsp和java,调用的layui框架
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
3条回答 默认 最新
- 秃头批风侠 2022-04-26 14:45关注
sql 语句拼接,如果当前 dailyInspection.getUserId() 不是空值并且不为-1,那么执行
SELECT * FROM daily_inspection WHERE 1=1 and user_id = ‘ 你当前的dailyInspection.getUserId() ’ 也就是根据用户id查询daily_inspection否则执行语句
SELECT * FROM daily_inspection WHERE 1=1
查询全部的daily_inspection本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
悬赏问题
- ¥15 想问一下树莓派接上显示屏后出现如图所示画面,是什么问题导致的
- ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
- ¥15 cmd cl 0x000007b
- ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
- ¥500 火焰左右视图、视差(基于双目相机)
- ¥100 set_link_state
- ¥15 虚幻5 UE美术毛发渲染
- ¥15 CVRP 图论 物流运输优化
- ¥15 Tableau online 嵌入ppt失败
- ¥100 支付宝网页转账系统不识别账号