sql语句错误帮忙解决

Question

tdDBBean.tdsetQuery("SELECT majorName,majorTypeDM,majorExplain,useTag FROM dicMajor WHERE schoolID="&ischoolID&"",true);
String[][] dicMajor=tdDBBean.tdgetQueryStrings2();这是错误提示
Translator.CompilationFailedExceptionCompiler errors:
Found 1 semantic error compiling "D:/wzcode/eduState/default-ear/default-war/WEB-INF/jsp/jrun__gbSYS__schoolDetail2ejsp17.java":199. tdDBBean.tdsetQuery("SELECT majorName,majorTypeDM,majorExplain,useTag FROM dicMajor WHERE schoolID="&ischoolID&"",true);
<------------------------------------------------------------------------------>
*** Error: The type of this expression, "String", is not numeric.
我已经转换类型了
int ischoolID=Integer.parseInt(schoolID);
可是还有这样的错误

Answer 1

刚从vb换来的？用&连接字符串？

Answer 2

如果楼主的表dicMajor中字段schoolID是数值型,换成:tdDBBean.tdsetQuery("SELECT majorName,majorTypeDM,majorExplain,useTag FROM dicMajor WHERE schoolID=" + ischoolID,true);试试看!另外楼主在SQL语句中ischoolID后加 &"" 是什么意思,不懂?

Answer 3

tdDBBean.tdsetQuery("SELECT majorName,majorTypeDM,majorExplain,useTag FROM dicMajor WHERE schoolID="+ischoolID,true);
如果是JAVA的话应该这样写