高分请教,这个SQL语句在JDBC中该怎么写呀?
queryStr = "SSELECT a.uniqueno,a.oilwellname,c.basicvalue ";
queryStr = queryStr + " FROM oilwell a,basicprop b,basicparam c ";
queryStr = queryStr + " where a.uniqueno=c.uniqueno and b.basicno=c.basicno ";
queryStr = queryStr + " and b.basicname='油井类型' and a.oilwellname='" + OilWellName + "'";
queryStr = queryStr + " and c.modifydate=(select max(d.modifydate) from basicparam d where d.uniqueno=c.uniqueno and d.basicno=c.basicno)";
在JDBC中似乎不支持上面这种写法,请大家帮我改一下,谢谢!