MYSQL版本:5.0
JDBC版本:mysql-connector-java-5.0.8-bin.jar
服务:jakarta-tomcat-5.0.24
代码如下:
uploadImg.jsp:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/webshop?user=root&password=root&useUnicode=true&characterEncoding=GBK";
Connection conn=DriverManager.getConnection(Util.dburl,Util.dbuser,Util.dbpwd);
FileInputStream str=new FileInputStream(img);
String sql= "insert into img(index,imgName) values(1,?)";
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1,"aa");
pstmt.execute();出现如下异常:
javax.servlet.ServletException: 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 'index,imgName) values(1,'aa')' at line 1
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.manage.uploadImg_jsp._jspService(uploadImg_jsp.java:158)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)请问这是怎么回事?非常急,感谢各位高手相助!
JDBC版本:mysql-connector-java-5.0.8-bin.jar
服务:jakarta-tomcat-5.0.24
代码如下:
uploadImg.jsp:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/webshop?user=root&password=root&useUnicode=true&characterEncoding=GBK";
Connection conn=DriverManager.getConnection(Util.dburl,Util.dbuser,Util.dbpwd);
FileInputStream str=new FileInputStream(img);
String sql= "insert into img(index,imgName) values(1,?)";
PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1,"aa");
pstmt.execute();出现如下异常:
javax.servlet.ServletException: 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 'index,imgName) values(1,'aa')' at line 1
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.manage.uploadImg_jsp._jspService(uploadImg_jsp.java:158)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)请问这是怎么回事?非常急,感谢各位高手相助!
疑似列名、类型的问题
index int(11)
imgName varchar(50)
img blob
吃饭去了, 要是没解决回来再看看
javax.servlet.ServletException: 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 'index,imgName) values(1,'aa')' at line 1
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.manage.uploadImg_jsp._jspService(uploadImg_jsp.java:158)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
改成 pstmt.executeUpdate();
另外问一下,execute()和executeUpdate()有什么区别?
我觉得可能是格式不匹配,看用单引号行不?
org.gjt.mm.mysql.Driver
是不是驱动的问题
mysql-connector-java-5.0.8-bin.jar
我一般都是用
Class.forName("com.mysql.jdbc.Driver").newInstance();
MYSQL版本:5.0
JDBC版本:mysql-connector-java-5.0.8-bin.jar
服务:jakarta-tomcat-5.0.24