向sql语句的动态变量传值

Question

哪位大神知道怎么向这条sql语句的动态变量传值，select 4800 from piccl p where ？ProdID？ in ('62483','62484')
and ？ManageOrgan？ in ('1130000','1150000','1220000','1330000','1370000','1410000','1530000')

Answer 1

若是java语言。用？代替要传值的地方，用preparestatement进行传值就好了。