我把MSSQL中的文件转换到MYSQL中

Question

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 '8 ID,GoodsStyle,GoodsName,StartOmit,StartCity,EndOmit,EndCity,Style,UserName fro' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422)
at wuliu.conndata.executeQuery(conndata.java:22)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:203)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Query Exception这个是什么问题MySQLMS SQL

Answer 1

检查一下MYSQL中的字符集设置。MYSQL中的字符集设置有多处，需要仔细检查。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 2

已经提示，语法错误，不能直接使用，修改SQL语句再执行

Answer 3

select top 8 ID,GoodsStyle,GoodsName,StartOmit,StartCity,EndOmit,EndCity,Style,UserName from db_GoodsMeg order by IssueDate desc这句话改成MYSQL是怎样的

Answer 4

select ID,GoodsStyle,GoodsName,StartOmit,StartCity,EndOmit,EndCity,Style,UserName from db_GoodsMeg order by IssueDate desc limit 8

Answer 5

MYSQL 中使用 limit N,Mselect ID,GoodsStyle,GoodsName,StartOmit,StartCity,EndOmit,EndCity,Style,UserName from db_GoodsMeg order by IssueDate desc limit 8

Answer 6

确实是语句问题 String sql="delete tb_Enterprise where ID="+request.getParameter("id");
boolean dele=condata.executeDelete(sql);这样SQL 语句换成MYSQL 是怎样的

Answer 7

谢谢各位 现在有新问题
信息: Server startup in 919 ms
java.sql.SQLException: Column count doesn't match value count at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524)
at wuliu.conndata.executeInsert(conndata.java:52)
at org.apache.jsp.Goods.Good_005fconfig_jsp._jspService(Good_005fconfig_jsp.java:102)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Insert Exception
以下是代码
request.setCharacterEncoding("utf-8");
String gname=request.getParameter("gname");
String gclass=request.getParameter("gclass");
String gcount=request.getParameter("gcount");
String gunit=request.getParameter("gunit");
String gstartfirm=request.getParameter("gstartfirm");
String gstartcity=request.getParameter("gstartcity");
String gendfirm=request.getParameter("gendfirm");
String gendcity=request.getParameter("gendcity");
String gtransstyle=request.getParameter("gtransstyle");
String gtime=request.getParameter("gtime");
String glink=request.getParameter("glink");
String gphone=request.getParameter("gphone");
String gre=request.getParameter("gre");
String grequest=request.getParameter("grequest");
String username=(String)session.getAttribute("name");
java.sql.Date gshowdate=new java.sql.Date(date.getYear(),date.getMonth(),date.getDate());
sql="insert into db_GoodsMeg values('"+gclass+"','"+
    gname+"','"+gcount+"','"+gunit+"','"+gstartfirm+"','"+
    gstartcity+"','"+gendfirm+"','"+gendcity+"','"+
    gtransstyle+"','"+gtime+"','"+gphone+"','"+
    glink+"','"+gshowdate+"','"+gre+"','"+grequest+"','"+username+"')";
boolean sert=condata.executeInsert(sql);
if(sert)
{%>
<script language="javascript">
alert("您输入的货物信息已经成功完成！！！");

Answer 8

sql="insert into db_GoodsMeg values('"+gclass+"','"+
    gname+"','"+gcount+"','"+gunit+"','"+gstartfirm+"','"+
    gstartcity+"','"+gendfirm+"','"+gendcity+"','"+
    gtransstyle+"','"+gtime+"','"+gphone+"','"+
    glink+"','"+gshowdate+"','"+gre+"','"+grequest+"','"+username+"')";
boolean sert=condata.executeInsert(sql);
if(sert)
打断点看，SQL的实际内容是什么。 你的表中的字段数与输入的值数量不匹配。

Answer 9

我没有把SQL 转成MYSQL以前  是正常添加的

Answer 10

问题已经解决  我确实不知道怎么DEBUG 但是这个问题确实是数据库语言的错误导致的  我2次发你留言 我态度一直很好，我哪里说错了？  现在确实是数据库问题  你不负责的把帖子转到J2SE？

Answer 11

sql="insert into db_CarMessage(TradeMark,Brand,Style,CarLoad,UsedTime,DriverName,DriverTime,LicenceNumber,LicenceStyle,TranspotStyle,LinkMan,LinkPhone,Re,IssueDate,UserName) values('"+numbers+"','"+carname+"','"+types+"','"+loads+"','"+usetime+"','"+drivername+"','"+drivertime+"','"+number+"','"+styles+"','"+transtyle+"','"+linkman+"','"+
phone+"','"+meg+"','"+showdate+"','"+username+"')";
问题我已经解决  确实少了值  版主态度傲慢   让人无法理解   好了结账