Struts2中mysql数据库中错误解决方案

java.sql.SQLException: Incorrect integer value: 'b' for column 'id' at row 1
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
 at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125)
 at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
 at com.bjxst.bbs2009.Service.CategoryService.update(CategoryService.java:85)
 at com.bjxst.bbs2009.Action.CategoryAction.update(CategoryAction.java:29)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440)
 at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279)
 at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)

 

红色部分中 一定要看清楚自己的代码 我的代码中出现这个问题 看代码

String sql="update  _category set id=?,description=? where id=?";

其实把id 改成 name就可以了