我想加入一段日期变量进入数据库
代码如下：
java.sql.Date publisheddate=new java.sql.Date(year,month,day);
String query = "INSERT INTO Books (Title,Author,ISBN,PublishedDate,Publisher) VALUES ('" + title + "','" + author + " ','" + i*****n + "','" + publisheddate + "','" + publisher + "')";
错误如下：
javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the following unknown field name: 'PublishedDate'. Make sure you have typed the name correctly, and try the operation again.
网上实在找不到解决办法了，请各位高人帮忙看看。
谢谢。