在下拉框中选择所有分类时,应该传递什么参数?在线等
sql="SELECT * FROM estate "+"WHERE streetname=? AND buildingname=? AND orientation=? AND " +"decorated=? AND bedroom=? AND dimension=?";
prestat=con.prepareStatement(sql);
prestat.setString(1, streetname);
prestat.setString(2, buildingname);
prestat.setString(3, orientation);
prestat.setString(4, decorated);
prestat.setInt(5, bedroom);
prestat.setInt(6, dimension);
比如在SQL中streetname可以传IS NOT NULL可以查询所有分类,但是在JAVA中传IS NOT NULL报错
通过下拉框选择所有分类实现查询应该怎么传递参数或者有什么更好的实现方法?大家帮帮忙偶也是初学