Sqlite参数查询
今天想将SQlite中的查询语句改为带参数的查询语句,修改后没有报错,但是查询结果却没有显示任何信息,事例如下:
无参数查询:
sql = " select * "
" from Student "
" where Sage = 19 ;";
查询结果是:
Sno: Sname: Ssex: Sage: Sdept:
200215122: LiuChen: female: 19: CS:
200215125: ZHangLi: male: 19: IS:
//**************************************************************************//
有参数查询是:
int var = 19;
sql = " select * "
" from Student "
" where Sage = $var ;";
查询无任何结果。
不知道这个是什么情况???
求大侠帮忙