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

来源:学生作业帮助网 编辑:六六作业网 时间:2024/05/29 06:16:51
select*fromassetswhereassets.purchasedatebetween${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'