在Struts中怎么把中文数据从JSP页面提交到MySql数据库中

suny999 suny999 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
Struts中的Action文件代码:
public class TiJiaoAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException {
ActionForward actionforward = new ActionForward();

UserInfoActionForm userInfoForm = (UserInfoActionForm)form;

request.setCharacterEncoding("gb2312");
String id = userInfoForm.getId();
String name = userInfoForm.getName();

Connection con = null;
Statement sta = null;

try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/china";
String user = "root";
String pwd = "111";

con = DriverManager.getConnection(url,user,pwd);
sta = con.createStatement();

String sql = "insert into user_info values('"+id+"','"+name+"')";
sta.executeUpdate(sql);
actionforward = mapping.findForward("success");

}catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (sta != null) {
try {
sta.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if (con != null) {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return actionforward;
}
}
JSP页面中编码(<%@ page language="java" pageEncoding="gb2312"%>)也是GB2312。
但是在jsp页面提交时显示下面错误信息(在数据库平台可以直接向表中插入中文数据):
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'name' at row 1
跪求天下IT豪杰,代码尽量写的详细点,本人比较笨,思念答案早日到来...
...全文
评论 9
收藏 已收藏
分享
返回顶部
suny999
Web 开发 81,108 成员 341,721 内容