p_highsearch1.sql

来自「本文论述了一个前台笔记本销售系统的开发过程」· SQL 代码 · 共 9 行

select *
from bussiness.product p
where  p.price >=? and  p.price<? 
and ( p.model like ? or '' like ?) 
and ( p.brand like ?  or '' like ?) 
 and ( p.cpu like ? or '' like ?)
 and  (p.emsmemory like ? or '' like ?)
and ( p.display like ? or '' like ?)
 and ( p.hd like ? or '' like ?)