mysql ssl java代码配置_MySQL配置SSL之后的JAVA连接MySQL的代码

//密码 private static String  KEYSTORE_PASSWORD = "123456"; private static String TRUSTORE_PATH = "file:/D:/myssl/truststore"; private static String  TRUSTORE_PASSWORD = "123456"; /** *

Description：

* @param args * @return void * @author LinwangFan * @time 2014-11-21 上午10:29:00 */ public static void main(String[] args) { // TODO Auto-generated method stub Statement stm = null; ResultSet res = null; Connection conn = null; MysqlDataSource mysqlDS=null; try{ mysqlDS = new MysqlDataSource(); mysqlDS.setUseSSL(true); mysqlDS.setRequireSSL(true); mysqlDS.setVerifyServerCertificate(true); mysqlDS.setLogger("com.mysql.jdbc.log.StandardLogger"); mysqlDS.setClientCertificateKeyStoreType("JKS"); mysqlDS.setClientCertificateKeyStoreUrl(KEYSTORE_PATH); mysqlDS.setClientCertificateKeyStorePassword(KEYSTORE_PASSWORD); mysqlDS.setTrustCertificateKeyStoreType("JKS"); mysqlDS.setTrustCertificateKeyStoreUrl(TRUSTORE_PATH); mysqlDS.setTrustCertificateKeyStorePassword(TRUSTORE_PASSWORD); mysqlDS.setServerName(HOST); mysqlDS.setPort(PORT); mysqlDS.setUser(USERNAME); mysqlDS.setPassword(PASSWORD); mysqlDS.setDatabaseName(DATABASE); conn = mysqlDS.getConnection(); stm = conn.createStatement(); res = stm.executeQuery("SELECT * FROM system_parameter"); while(res.next()){ System.out.println(res.getString(1)); } }catch(Exception e){ e.printStackTrace(); } finally { try { if (res != null) res.close(); if (stm != null) stm.close(); if (conn != null) conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }