select name,price,fee.agio,numerics,money,loginTime,farePerID from fee,serviceitem where fee.serviceCode = serviceitem.id and handleid=?;
这个语句是要通过页面输入handleid来查询 这个语句我在底层中用来查询
请问?处写什么?
这个语句是要通过页面输入handleid来查询 这个语句我在底层中用来查询
请问?处写什么?
--这样?
select name,price,fee.agio,numerics,money,loginTime,farePerID from fee,serviceitem where fee.serviceCode = serviceitem.id and handleid=传进来的值;
你指的底层, 是MYSQL后台吗?要是的话.handleid=?; 这里应该写你想查询的值.比如:
select name,price,fee.agio,numerics,money,loginTime,farePerID from fee,serviceitem where fee.serviceCode = serviceitem.id and handleid='0001';
如果你用的是jsp或java的话String handleid=request.getParamater("handleid");select name,price,fee.agio,numerics,money,loginTime,farePerID from fee,serviceitem where fee.serviceCode = serviceitem.id and handleid='"+handleid+"'";