select * from assets where assets.purchasedate between ${start} and ${end}这么写mysql执行出错,该怎么写 其中start和end是从jsp页面传来的值

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/03 05:10:17
select * from assets where assets.purchasedate between ${start} and ${end}这么写mysql执行出错,该怎么写 其中start和end是从jsp页面传来的值

select * from assets where assets.purchasedate between ${start} and ${end}这么写mysql执行出错,该怎么写 其中start和end是从jsp页面传来的值
select * from assets where assets.purchasedate between ${start} and ${end}
这么写mysql执行出错,该怎么写 其中start和end是从jsp页面传来的值

select * from assets where assets.purchasedate between ${start} and ${end}这么写mysql执行出错,该怎么写 其中start和end是从jsp页面传来的值
这样试试:
①去花括号
select * from assets where assets.purchasedate between $start and $end
②去花括号并且加引号
select * from assets where assets.purchasedate between '$start' and '$end'