java - 插入数据时出现 SQL 异常 : com. microsoft.sqlserver.jdbc.SQLServerException

Question

已关闭。这个问题是 not reproducible or was caused by typos 。目前不接受答案。

---

这个问题是由拼写错误或无法再重现的问题引起的。虽然类似的问题可能是 on-topic在这里，这个问题的解决方式不太可能帮助 future 的读者。

已关闭 8 年前。

Improve this question

SQL Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'st'.

这是我整个程序代码的数据插入部分。我猜异常就在这里

String SQL;
            stmt = con.createStatement();
            SQL = "INSERT INTO formtable (clgname,clgaddres,hmob,hemail,pmonth,pyear,sname,gender,dob,paddr,smob,semail,tenboard,tenyop,tenper,tendiv,twscboard,twscyop,twscper,twscdiv,bscbcaboard,bscbcayop,bscbcaper,bscbcadiv,mscboard,mscyop,mscper,mscdiv,frsem,scsem,thsem,frthsem,hardware,os,languages,dbms,communication,stporganization,stpobjective,stphardware,stpsoftware,stpduration,othertraining) VALUES ('"+combo1+"','"+ta1+"','"+text1+"','"+text2+"','"+combo2+"','"+text3+"','"+text4+"','"+rbdtext+"','"+date+"','"+ta2+"','"+text5+"','"+text6+"','"+tboard+"','"+tyop+"','"+tper+"',"+tdiv+"','"+twboard+"','"+twyop+"','"+twper+"','"+twdiv+"','"+bsbcboard+"','"+bsbcyop+"','"+bsbcper+"','"+bsbcdiv+"','"+mscboard+"','"+mscyop+"','"+mscper+"','"+mscdiv+"','"+fsem+"','"+ssem+"','"+tsem+"','"+fosem+"','"+text7+"','"+text8+"','"+text9+"','"+text10+"','"+text11+"','"+text12+"','"+ta3+"','"+text13+"','"+text14+"','"+text15+"','"+ta4+"')";
            int rowsEffected = stmt.executeUpdate(SQL);

Answer 1

您在查询中错过了单引号 在“+tdiv+”'

应该是

'"+tdiv+"'

使用以下查询

String SQL;
            stmt = con.createStatement();
            SQL = "INSERT INTO formtable (clgname,clgaddres,hmob,hemail,pmonth,pyear,sname,gender,dob,paddr,smob,semail,tenboard,tenyop,tenper,tendiv,twscboard,twscyop,twscper,twscdiv,bscbcaboard,bscbcayop,bscbcaper,bscbcadiv,mscboard,mscyop,mscper,mscdiv,frsem,scsem,thsem,frthsem,hardware,os,languages,dbms,communication,stporganization,stpobjective,stphardware,stpsoftware,stpduration,othertraining) VALUES ('"+combo1+"','"+ta1+"','"+text1+"','"+text2+"','"+combo2+"','"+text3+"','"+text4+"','"+rbdtext+"','"+date+"','"+ta2+"','"+text5+"','"+text6+"','"+tboard+"','"+tyop+"','"+tper+"','"+tdiv+"','"+twboard+"','"+twyop+"','"+twper+"','"+twdiv+"','"+bsbcboard+"','"+bsbcyop+"','"+bsbcper+"','"+bsbcdiv+"','"+mscboard+"','"+mscyop+"','"+mscper+"','"+mscdiv+"','"+fsem+"','"+ssem+"','"+tsem+"','"+fosem+"','"+text7+"','"+text8+"','"+text9+"','"+text10+"','"+text11+"','"+text12+"','"+ta3+"','"+text13+"','"+text14+"','"+text15+"','"+ta4+"')";
            int rowsEffected = stmt.executeUpdate(SQL);