可是他又报错: You have an error in your SQL syntax near 'join' SELECT * FROM ClassLabel WHERE LENGTH(LabelID)=8 AND LabelID like '0001%'' at line 1是这样吗? stmt.execute(strsql1+" join "+strsql2);
strsql1="select * from ClassLabel WHERE LabelID like '"+sub+"%' and LabelID <='"+LabelID+"' order by LabelID asc";strsql2="SELECT * FROM ClassLabel WHERE LENGTH(LabelID)="+len+" AND LabelID like '"+LabelID+"%'";
You have an error in your SQL syntax near 'join' SELECT * FROM ClassLabel WHERE LENGTH(LabelID)=8 AND LabelID like '0001%'' at line 1是这样吗?
stmt.execute(strsql1+" join "+strsql2);