Question

请求支援：java 连接数据库如何实现多条件并列查询？

条件可以有很多，也可以只有一条，但是sql语句都可以执行

Answer 1

String sql = "select carId,type_id,carNo, engineNo,buyInsureTime,auditTime,buyDate,status,file_id,carDesc from car where type_id = " + type_id;
String temp = "";
if (!StringUtils.isEmpty(carNo)) {
temp += " and carNo like '%" + carNo + "%' ";
}
if(!StringUtils.isEmpty(engineNo))
{
temp += " and engineNo like '%"+engineNo + "%' ";
}
if(!StringUtils.isEmpty(buyDate))
{
temp += " and buyDate = date('"+buyDate + "') ";
}
if(!StringUtils.isEmpty(status))
{
temp += " and status=" + status+ " ";
}

sql = sql + temp + " order by carId desc ";
这是多条件的例子，可以参考一下