Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database latin1character_set_filesystem binary
character_set_results utf8
character_set_server latin1character_set_system utf8
页面使用的是UTF-8在插入数据的时候
temp.setReplycontent(new String(content.getBytes("ISO-8859-1")));
这里写什么在读取出来的时候才不会出现乱码的问题了
请大家帮帮忙啊
character_set_client utf8
character_set_connection utf8
character_set_database latin1character_set_filesystem binary
character_set_results utf8
character_set_server latin1character_set_system utf8
页面使用的是UTF-8在插入数据的时候
temp.setReplycontent(new String(content.getBytes("ISO-8859-1")));
这里写什么在读取出来的时候才不会出现乱码的问题了
请大家帮帮忙啊
解决方案 »
- 用strut2写了一个简单的login程序,但是运行时Tomcat老报错?有谁能告诉一下我啊?
- 求高手解决 中文编码问题!先谢了 急急急
- ireport调整行间距
- tepestry5.0中uploadfile如何使用?
- 这样做实际吗?头都裂了!
- 我这样设置的tomcat环境变量怎么不对?
- 关于struts的title的用法有没有例子可以让我看看。struts的教程那里有。
- 100分请教一个错误
- com.borland.primetime.util.AssertionException: gbk
- 一个比较简单的问题
- js createElement的疑惑?(在线等。。。)
- JDBC的奇怪问题,宗师请进
远程免费的MYSQL服务器 不让改
连接url也加上?useUnicode=true&characterEncoding=UTF-8
package com;import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Date;
import java.util.Map;import javax.servlet.jsp.jstl.sql.Result;
import javax.servlet.jsp.jstl.sql.ResultSupport;public class DbHelp { private static String driver = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://localhost:3306/liubei?useUnicode=true&characterEncoding=UTF-8";
private static String user = "root";
private static String pwd = "root"; /**
* 获得连接
*/
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, pwd);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
} public static void main(String[] args) throws UnsupportedEncodingException {
save(
"insert into messageboard (name,sex,content,msgdate) values(?,?,?,?) ",
new Object[] { "刘贝".getBytes("utf-8"), 1, "内容", new Date() });
Map[] map = runSelectSql("select * from messageboard ", null).getRows();
for (Map map2 : map)
// System.out.println(map2);
System.out.println(new String(map2.get("name").toString().getBytes(
"iso-8859-1"))); } public static void save(String sql, Object[] obj) {
Connection conn = getConnection();
try {
PreparedStatement pst = conn.prepareStatement(sql);
if (obj != null) {
for (int i = 0; i < obj.length; i++) {
pst.setObject(i + 1, obj[i]);
}
}
pst.execute();
} catch (Exception e) {
e.printStackTrace();
}
} /**
* 执行返回Result
*/
public static Result runSelectSql(String sql, Object[] obj) {
Result result = null;
Connection conn = null;
PreparedStatement pst = null;
try {
conn = getConnection();
pst = conn.prepareStatement(sql);
if (obj != null) {
for (int i = 0; i < obj.length; i++) {
pst.setObject(i + 1, obj[i]);
}
}
result = ResultSupport.toResult(pst.executeQuery());
} catch (Exception e) {
e.printStackTrace();
}
return result;
} /**
* 执行返回成功与否
*/
public static boolean runUpdateSql(String sql, Object[] obj) {
Connection conn = null;
PreparedStatement pst = null;
try {
conn = getConnection();
pst = conn.prepareStatement(sql);
if (obj != null) {
for (int i = 0; i < obj.length; i++) {
pst.setObject(i + 1, obj[i]);
}
}
int i = pst.executeUpdate(sql);
if (i != 0) {
return true;
}
} catch (Exception e) {
e.printStackTrace();
}
return false;
}}简单的测试 还是不行 希望有人帮忙下
`id` INTEGER(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
`sex` INTEGER(11) NOT NULL,
`content` VARCHAR(255) COLLATE utf8_general_ci NOT NULL DEFAULT '',
`msgdate` DATETIME DEFAULT NULL,
`replyid` INTEGER(11) DEFAULT NULL,
PRIMARY KEY (`id`)
)ENGINE=InnoDB
AUTO_INCREMENT=140 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='InnoDB free: 4096 kB'