背景：
在使用PreparedStatement执行setString(4, "我是中文");后，通过debug发现中文变成了？？？；这个肯定是编码问题，然后通过字符串和字节码进行编码转换也没能够解决这个问题；最后在网上搜到一篇文章提到，在连接mysql数据的时候需要制定编码：?characterEncoding=utf8
解决：
代码中连接数据库的时候需要制定编码：
public String getMysqlUrl() {return "jdbc:mysql://" + ip + ":" + port + "/" + sid+"?characterEncoding=utf8";}
下面是整个测试代码：
package com.scu.tgm.test;import java.io.UnsupportedEncodingException;import java.sql.*;import java.util.*;public class TestMysql {private static final String ORACLE = "oracle";private static final String SQL_SERVER = "mssql";private static final String SYBASE = "sybase";private static final String MYSQL = "mysql";private static final String MYSQL_DRIVER_CLASS = "com.mysql.jdbc.Driver";private static final String ORACLE_DRIVER_CLASS = "oracle.jdbc.driver.OracleDriver";private static final String SQLSERVER_DRIVER_CLASS = "net.sourceforge.jtds.jdbc.Driver";private static final String SYBASE_DRIVER_CLASS = "com.sybase.jdbc3.jdbc.SybDriver";private String type="mysql"; private String ip ="localhost";private String port="3306";private String user="root";private String sid="tgmtest"; private String password ="root";private Connection connection;public static void main(String[] str) throws UnsupportedEncodingException{TestMysql testMysql=new TestMysql();String sql="Insert into sms_outbox (sismsid, extcode, destaddr, messagecontent,reqdeliveryreport,msgfmt,sendmethod,requesttime,applicationid) VALUES(?,?,?,?,?,?,?,?,?)";testMysql.createConnect();try {testMysql.executeInsert(sql,"123;44","八嘎雅路");} catch (SQLException e) {e.printStackTrace();}System.out.println();}/*** Insert into t_user* (sismsid, extcode, destaddr, messagecontent,reqdeliveryreport,msgfmt,sendmethod,requesttime,applicationid)* VALUES(?,?,?,?,?,?,?,?,?)* @param sql* @return* @throws SQLException* @throws UnsupportedEncodingException */public void executeInsert(String sql,String phNumbers,String messagecontent) throws SQLException, UnsupportedEncodingException {PreparedStatement ps = connection.prepareStatement(sql);ps.setString(1, UUID.randomUUID().toString());ps.setString(2, "");ps.setString(3, phNumbers);ps.setString(4, messagecontent);ps.setByte(5, (byte) 1);ps.setByte(6, (byte) 15);ps.setByte(7,(byte) 0);ps.setTimestamp(8, new Timestamp((new java.util.Date()).getTime()));ps.setString(9, "dxcs");ps.executeUpdate();}public void createConnect() {if (ORACLE.equalsIgnoreCase(type)) {String fornameCalss = ORACLE_DRIVER_CLASS;String url = getOracleUrl();connection= createConnection(fornameCalss, url,user,password);} else if (SQL_SERVER.equalsIgnoreCase(type)) {String fornameCalss = SQLSERVER_DRIVER_CLASS;String url = getSqlserverUrl();connection= createConnection(fornameCalss, url,user,password);} else if (SYBASE.equalsIgnoreCase(type)) {String fornameCalss = SYBASE_DRIVER_CLASS;String url = getSybaseUrl();connection= createConnection(fornameCalss, url,user,password);} else if (MYSQL.equalsIgnoreCase(type)) {String fornameCalss = MYSQL_DRIVER_CLASS;String url = getMysqlUrl();connection= createConnection(fornameCalss, url,user,password);}else {}}private Connection createConnection(String fornameCalss, String url,String user, String password) {Connection connection = null;try {Class.forName(fornameCalss);connection = DriverManager.getConnection(url, user,password);} catch (Exception e) {System.out.println(e.getMessage());}return connection;}public String getSybaseUrl() {return "jdbc:sybase:Tds:" + ip + ":" + port + "/" + sid;}public String getSqlserverUrl() {return "jdbc:jtds:sqlserver://" + ip + ":" + port + "/" + sid;}public String getOracleUrl() {return "jdbc:oracle:thin:@" + ip + ":" + port + ":" + sid;}public String getMysqlUrl() {return "jdbc:mysql://" + ip + ":" + port + "/" + sid+"?characterEncoding=utf8";}}
