該樓層疑似違規已被系統折疊?隱藏此樓查看此樓

現在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;

}