本帖最后由 就玩一小会 于 2014-11-7 15:36 编辑 控件textarea里如何回车转换成',' SELECT * from bin_unit_data WHERE update_time>to_date('${sd}','yyyy-mm-dd hh:mi:ss')-3 AND update_time<to_date('${sd}','yyyy-mm-dd hh:mi:ss') ${if(len(bu)==0,""," and bin_unit_id in ('"+bu+"')")} ${if(len(ip)==0,""," and is_print ='"+ip+"'")} ${if(len(bn)==0,""," and barcode_no ='"+bn+"'")} |