java 模糊查询_到底Java里的模糊查询语句该怎么写

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

现在String sql="select * from car where carName like '%'+?+'%'";可以查询出结果了，但问题又来了，只能查询出一条结果，代码如下

carDao.java页面

public ArrayList queryAppoint(String carname){//通过车辆名模糊查询

ArrayList list=new ArrayList();

try{

mydb.openDB();

String sql="select * from car where carName like '%'+?+'%'";

Object[] params={carname};

ResultSet rs=mydb.executeQuery(sql, params);

if(rs.next()){

CarDto dto=new CarDto();

dto.setUserId(rs.getString("userId"));

dto.setMaintenanceTime(rs.getString("maintenanceTime"));

dto.setAccidentNumber(rs.getString("accidentNumber"));

dto.setBooked(rs.getString("booked"));

dto.setCarBrand(rs.getString("carBrand"));

dto.setCarId(rs.getString("carId"));

dto.setCarName(rs.getString("carName"));

dto.setCarPlace(rs.getString("carPlace"));

dto.setCarPrice(rs.getString("carPrice"));

dto.setDriveKilometre(rs.getString("driveKilometre"));

dto.setDrivingAge(rs.getString("drivingAge"));

dto.setOriginalPrice(rs.getString("originalPrice"));

dto.setImage(rs.getString("image"));

list.add(dto);//把对象添加到数组中

}

}catch (Exception e) {

e.printStackTrace();

}finally{

mydb.close();

}

return list;

}