mysql :Data too long for column

[RedYanStar]

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'truename' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3374)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:998)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at dao.RegeditDao.add_member_info(RegeditDao.java:100)
at dao.RegeditDao.reg(RegeditDao.java:169)
at com.jzgc.struts.action.RegeditAction.add(RegeditAction.java:45)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
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:228)
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:216)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
at java.lang.Thread.run(Unknown Source)

[RedYanStar]

//数据库操作类
public static boolean add_member_info(RegeditForm f){
String year = f.getByear();
int userid = getUserid();
if(f.getByear().equals("19")){
year = "1900";
}
String date = year+"-"+f.getBmonth()+"-"+f.getBday();
System.out.println("要添加的此行数据的userid为："+userid);
boolean fg = false;
try{
conn = ds.getConnection();
PreparedStatement ps = conn.prepareStatement(
"insert into phpcms_member_info value(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
ps.setInt(1, userid);
ps.setString(2, f.getUserface());
ps.setString(3, f.getFacewidth());
ps.setString(4, f.getFaceheight());
ps.setString(5, f.getSign());
ps.setString(6, f.getTruename());
ps.setInt(7, f.getGender());
ps.setString(8, date);
ps.setString(9, f.getIdtype());
ps.setString(10, f.getIdcard());
ps.setString(11, f.getProvince());
ps.setString(12, f.getCity());
ps.setString(13, f.getArea());
ps.setString(14, f.getIndustry());
ps.setString(15, f.getEdulevel());
ps.setString(16, f.getOccupation());
ps.setString(17, f.getIncome());
ps.setString(18, f.getTelephone());
ps.setString(19, f.getMobile());
ps.setString(20, f.getAddress());
ps.setString(21, f.getPostid());
ps.setString(22, f.getHomepage());
ps.setString(23, f.getQq());
ps.setString(24, f.getMsn());
ps.setString(25, f.getIcq());
ps.setString(26, f.getSkype());
ps.setString(27, f.getAlipay());
ps.setString(28, f.getPaypal());
ps.setString(29, "");
ps.setString(30, "");
ps.setString(31, "");
ps.setInt(32, 0);
ps.setString(33, "");
ps.setString(34, "");
System.out.println("出生日期:"+date);

if(ps.execute()){
fg = true;
System.out.println("添加会员详细信息"+f.getUsername()+"成功！");
}
}catch(Exception ex){
ex.printStackTrace();
System.out.println("add_member_info()出现异常："+ex.getMessage());
}
return fg;
}

[helloDongXiu]

可能是你的mysql安装时的字符编码没设置好
找到安装的根目录打开my.ini文件
将编码为lain的改为gbk就行......

[RedYanStar]

我解决了，呵呵，谢谢你们了，
是因为，输入的中文进入到action就成了乱码，
由于编码错误，才提示那样的错误

我加了一个过滤器，

不过现在我又出现一个问题，就是数据添加到mysql，在mysql显示的是乱码，，不知怎么回事 ？？

[lihan6415151528]

Data too long for column 'truename' at row 1

看这个英文也知道什么意思啊

[zhj92lxs]

truename 什么类型

[RedYanStar]

数据库中 truename 字段是：varchar(20)
我添加的时候只输入了一个“小”字，就出现了这个异常！ 怎么办？？帮忙解决一下吧！！

拜托了

[RedYanStar]

我知道啊 ，但是一个“小”字，不可能 varchar(20) 不够用吧？

[zhj92lxs]

是不是你的参数顺序错了

[RedYanStar]

没有
错啊 ，我检查过了

[zhj92lxs]

把你的代码贴出来看看

[耶律火柴]

关闭前端工具及数据库本身，然后重新启动，再试试

[dongqdonglin]

是你的mysql设置的问题 我以前遇到过赫赫