eclipse这句警告什么意思该怎么改啊
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 '5000,'红富士')' at line 1
程序没有分行,但从上面看,至少有一个错
preparedStatement = conn.prepareStatement("insert into fruit values(" + value[i][0] + ",'" + value[i][1] + ",'" + value[i][2] + ",'" + value[i][3] + "')");
第一字段没有加''(它是中文,必须加''的),所以要改为
preparedStatement = conn.prepareStatement("insert into fruit values("'" + value[i][0] + "','" + value[i][1] + ",'" + value[i][2] + ",'" + value[i][3] + "')");
上一篇:神字旁加个是读什么?什么意思
热门标签: