在对mysql数据库中插入数据的时候,直接插入中文是没有问题的!但是用预编译语句时,用流对数据进行处理总报incorrect string value这个异常。问题原因应该是由于编码引起的,但是没有找到解决方法。 以下是数据库编码设定:
数据库
itresource | CREATE DATABASE `itresource` /*!40100 DEFAULT CHARACTER SET utf8
数据库 status
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
建表语句:
CREATE TABLE `i__news` (
`pk_i_newsid` int(10) NOT NULL AUTO_INCREMENT,
`v_ntitle` varchar(80) CHARACTER SET utf8 NOT NULL,
`v_nifrom` varchar(80) CHARACTER SET utf8 DEFAULT NULL,
`v_nputdate` varchar(13) CHARACTER SET utf8 NOT NULL,
`v_nauthor` varchar(20) CHARACTER SET utf8 NOT NULL,
`v_ninfo` mediumtext CHARACTER SET utf8 NOT NULL,
`v_nftype` int(2) NOT NULL,
`v_nfpath` varchar(80) CHARACTER SET utf8 DEFAULT NULL,
`v_orgname` varchar(80) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`pk_i_newsid`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 所有的编码方式都是utf8的
以下是代码处理入库
public boolean newsAlter(String ntitle,String nifrom,String nputdate,String nauthor,String ninfo,int nftype,String nfpath,String orgname,String type){
boolean b = false;
dbcon = new DBConnection();
String sql = "";
if ("in".equals(type)) {
sql = "insert into i__news(v_ntitle,v_nifrom,v_nputdate,v_nauthor,v_ninfo,v_nftype,v_nfpath,v_orgname) values(?,?,?,?,?,?,?,?)";
try {
//byte[] cpic = ninfo.getBytes("latin1");
byte[] cpic = ninfo.getBytes("utf-8");
ByteArrayInputStream baisss = new ByteArrayInputStream(cpic);
InputStreamReader bais = new InputStreamReader(baisss,"utf-8");
dbcon.prepareStatement(sql);
dbcon.setString(1, ntitle);
dbcon.setString(2, nifrom);
dbcon.setString(3, nputdate);
dbcon.setString(4, nauthor);
dbcon.setCharacterStream(5, bais, cpic.length);
dbcon.setInt(6, nftype);
dbcon.setString(7, nfpath);
dbcon.setString(8, orgname);
System.out.println(sql);
dbcon.executeUpdate();
b = true;
baisss.close();
bais.close();
dbcon.close();
} catch (Exception e) {
e.printStackTrace();
}
} else if (type.equals("up")) {
}
return b;
}
如果编码方式设为utf-8就报异常,如果设为latin1则正常插入,但是入库的中文都是乱码。其余的字段中文都是正常入库的。 急 求帮,哪位大虾遇到过?如何解决的?
数据库
itresource | CREATE DATABASE `itresource` /*!40100 DEFAULT CHARACTER SET utf8
数据库 status
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
建表语句:
CREATE TABLE `i__news` (
`pk_i_newsid` int(10) NOT NULL AUTO_INCREMENT,
`v_ntitle` varchar(80) CHARACTER SET utf8 NOT NULL,
`v_nifrom` varchar(80) CHARACTER SET utf8 DEFAULT NULL,
`v_nputdate` varchar(13) CHARACTER SET utf8 NOT NULL,
`v_nauthor` varchar(20) CHARACTER SET utf8 NOT NULL,
`v_ninfo` mediumtext CHARACTER SET utf8 NOT NULL,
`v_nftype` int(2) NOT NULL,
`v_nfpath` varchar(80) CHARACTER SET utf8 DEFAULT NULL,
`v_orgname` varchar(80) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`pk_i_newsid`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 所有的编码方式都是utf8的
以下是代码处理入库
public boolean newsAlter(String ntitle,String nifrom,String nputdate,String nauthor,String ninfo,int nftype,String nfpath,String orgname,String type){
boolean b = false;
dbcon = new DBConnection();
String sql = "";
if ("in".equals(type)) {
sql = "insert into i__news(v_ntitle,v_nifrom,v_nputdate,v_nauthor,v_ninfo,v_nftype,v_nfpath,v_orgname) values(?,?,?,?,?,?,?,?)";
try {
//byte[] cpic = ninfo.getBytes("latin1");
byte[] cpic = ninfo.getBytes("utf-8");
ByteArrayInputStream baisss = new ByteArrayInputStream(cpic);
InputStreamReader bais = new InputStreamReader(baisss,"utf-8");
dbcon.prepareStatement(sql);
dbcon.setString(1, ntitle);
dbcon.setString(2, nifrom);
dbcon.setString(3, nputdate);
dbcon.setString(4, nauthor);
dbcon.setCharacterStream(5, bais, cpic.length);
dbcon.setInt(6, nftype);
dbcon.setString(7, nfpath);
dbcon.setString(8, orgname);
System.out.println(sql);
dbcon.executeUpdate();
b = true;
baisss.close();
bais.close();
dbcon.close();
} catch (Exception e) {
e.printStackTrace();
}
} else if (type.equals("up")) {
}
return b;
}
如果编码方式设为utf-8就报异常,如果设为latin1则正常插入,但是入库的中文都是乱码。其余的字段中文都是正常入库的。 急 求帮,哪位大虾遇到过?如何解决的?
解决方案 »
- 求:如何在项目中添加spring security
- 在先等待struts2报错
- 怎么解决 commons-collections 包冲突的问题
- springMVC3.0+hibernate3.0缓存问题
- java ejb加了一个service层后在web层调用sessionBean报空指针
- QQ群6831141,欢迎热爱J2EE的朋友加入交流
- UML参考书籍
- 如何将tomcat5.0集成到jbuilder X中?
- JSP服务器可以像IIS一样建立多个站吗?如:tomcat,resin等等
- 可以反编译class文件,看到原来的java代码吗?(UP有分)
- 两系统数据实时同步
- borderLayout布局为何不能居中按钮
只要重新配置一下mysql服务就行,将编码方式改为utf-8就行了。
jdbc url参考:jdbc:mysql://localhost:3306/test?user=root&password=& useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false
DBurl=jdbc\:mysql\://localhost\:3306/itresourceuseUnicode\=true&characterEncoding\=utf8 用的是utf8依旧是那个错误。 无论流转为utf-8没有!