servlet数据库插入数据报错！就一个地方一直找不到问题

Question

String condition="INSERT INTO"+tableName+"VALUES"+"("+""+nu+","+na+","+mT+","+p+")";

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1111.0)' at line 1
无论怎么改 在p这里一直有错~

Answer 1

你的引号好像有点问题 试试这样子

 '"INSERT INTO'+tableName+'VALUES("'+nu+'","'+na+'","'+mT+'","'+p+'")'