急.快进来看看吧
查询价格从minprice 到maxprice 品牌是brand 这打语句怎么在JSP里写?
我写了一条但是错的
String pcondtion=
"price<="+maxprice+"and"+"price>="+minprice;
String bcondtion=
"brand="+brand+"";
String connection="select * from buytable where"+pcondtion+"and"+bcondtion;
他说第一行<有错
还有一条思路就是用' where (price between ... and ...) and ...'
这条应该怎么写String connection="................"