我刚才是这样的:
String sqlstring="select gooddate,managername,goodslevel,id,goodsnumber,goodsmoney,materialnumber,buyman,vehicleid from goodsjoin where goodslevel='"+goodslevel1+"' and managername='"+managername+"' and " +"to_char(gooddate,'yyyy')"+"="+year+" and "+"to_char(gooddate,'mm')"+"="+month+"";rs_sq=stmt_sq.executeQuery(sqlstring);
错在哪儿了?
String sqlstring="select gooddate,managername,goodslevel,id,goodsnumber,goodsmoney,materialnumber,buyman,vehicleid from goodsjoin where goodslevel='"+goodslevel1+"' and managername='"+managername+"' and " +"to_char(gooddate,'yyyy')"+"="+year+" and "+"to_char(gooddate,'mm')"+"="+month+"";rs_sq=stmt_sq.executeQuery(sqlstring);
错在哪儿了?
from table1
where to_char(gooddate,"yyyy")=year--这个语句没有错!String sqlstring="select gooddate,managername,goodslevel,id,goodsnumber,goodsmoney,materialnumber,buyman,vehicleid from goodsjoin where goodslevel='"+goodslevel1+"' and managername='"+managername+"' and to_char(gooddate,'yyyy')="+year+" and to_char(gooddate,'mm')="+month+"";rs_sq=stmt_sq.executeQuery(sqlstring);--你试试这样改
from table1
where to_char(gooddate,"yyyy")=year
在sql*plus中执行出什么错误?
String sqlstring="select gooddate,managername,goodslevel,id,goodsnumber,goodsmoney,materialnumber,buyman,vehicleid from goodsjoin where goodslevel='"+goodslevel1+"' and managername='"+managername+"' and " +"to_char(gooddate,'yyyy')"+"='"+year+"' and "+"to_char(gooddate,'mm')"+"='"+month+"'";