这个问题应该不是数据库的问题,应该是C语言语法问题。楼主可以试着将单引号加转义符,即在每个单引号前加\ sql="select applyriqi,audit from w_applyd where bmbh=\'"+bmbh+"\'and applyriqi like\'"+applymonth+"%\'"; 楼主debug时跟踪sql这个字符串了吗?
用的是jbx+oracle,debug的结果: select applyriqi,audit from w_applyd where bmbh='002'and applyriqi like'2004-10%'
错误是缺少表达式:java.sql.SQLException: ORA-00936: 缺少表达式
select applyriqi,audit from w_applyd where bmbh='bmbh'and applyriqi like'%applymonth%';
sql="select applyriqi,audit from w_applyd where bmbh=\'"+bmbh+"\'and applyriqi like\'"+applymonth+"%\'";
楼主debug时跟踪sql这个字符串了吗?
select applyriqi,audit from w_applyd where bmbh='002'and applyriqi like'2004-10%'