Question

jsp中sql语句为什么从where或者是从from处换行后不执行，代码如下sql1错误，sql2正确。

sql1="select GCData.deviceId,GCData.time,GCData.latitude,GCData.longitude,bindingTable.trainId,bindingTable.containerId,"+
"bindingTable.containerType,bindingTable.routeType from GCData,bindingTable"+
"where GCData.deviceId=bindingTable.IMEI and GCData.deviceId="+"'"+id[i]+"'"+"and bindingTable.state='Y' and GCData.time>="+"'"+startTime+"'"+"and GCData.time<="+"'"+endTime+"'";

sql2="select GCData.deviceId,GCData.time,GCData.latitude,GCData.longitude,bindingTable.trainId,bindingTable.containerId,"+
"bindingTable.containerType,bindingTable.routeType from GCData,bindingTable where GCData.deviceId=bindingTable.IMEI and GCData.deviceId="+"'"+id[i]+"'"+"and bindingTable.state='Y' and GCData.time>="+"'"+startTime+"'"+"and GCData.time<="+"'"+endTime+"'";
adt.getGCResults(sql,ID,GCTime,alat,alon,trainId,containerId,containerType,routeType);

Answer 1

可能是SQL字符串在拼接的时候,有些关键字拼在一起了.比如
string = 'select';
string += '*' ;
string += 'from' ;
string += 'table' ;

这样出来的SQL字符串是 'select*fromtable' ,全部在一起了.

建议在所有字符串前后分别加入" " 空格符号避免上述情况的发生.