用jsp往数据库里插入内容,汉字怎么插不进去呀。
来源:百度知道 编辑:UC知道 时间:2024/07/05 08:15:08
各位大侠,我在用jsp做东西的时候,一只解决不了一个问题,就是不能正确的把汉字添加到数据库中去,怎么办啊。
代码是:
String id=request.getParameter("id");
String name=request.getParameter("name");
String tel=request.getParameter("tel");
String relation=request.getParameter("relation");
String Other=request.getParameter("Other");
String sql="insert into relation(id,name,tel,relation,Other) values("+id+","+name+","+tel+","+relation+","+Other+")";
stmt.executeUpdate(sql);
代码是:
String id=request.getParameter("id");
String name=request.getParameter("name");
String tel=request.getParameter("tel");
String relation=request.getParameter("relation");
String Other=request.getParameter("Other");
String sql="insert into relation(id,name,tel,relation,Other) values("+id+","+name+","+tel+","+relation+","+Other+")";
stmt.executeUpdate(sql);
String tmp=request.getParameter("name");
String name= new String(tmp.getBytes("ISO-8859-1"),"gb2312")
("+id+","+name+","+tel+","+relation+","+Other+")";
改成
("+id+",'"+name+"',"+tel+",'"+relation+"','"+Other+"')";
反正是有字母.或者汉字的都加上''单引号试试
页面编码GB2312活GBK
要不就你转一下型
String aa = new String(aa.getBytes(“ISO-8859-1”),”gb2312”)
用的什么数据库?Mysql的话在数据库那边也要加上编码