eclipse这句警告什么意思该怎么改啊

更新时间2020-12-23 11:36:20

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] + "')");