1、使用druid对密码进行加密

java -cp druid-1.1.22.jar com.alibaba.druid.filter.config.ConfigTools pwsswprd >password.txt

2、加密后得到密钥对和加密的密码

privateKey:MIIBVgIBADANBgkqhkiG9w0BAQEFAASCAUAwggE8AgEAAkEAudOh76Y2PF9d8+W8EHAFReIggDST9kJNVn4SBQFEKB30Ya8vuDNosoVrT7V5FVTCUZXx/LqA0U+l28AwxymQrQIDAQABAkEAsBQThnQ1QgGPkfKmv+CVboF1EGZBqX9rrsAorOtlPKh/wQdF5w+T456Ik0JHTVc/iroOOI1ufq2ZGY2SKIpEwQIhAOSxK5DeJY9ZxW/QFwbW7CobojELa0owG/HIGmLHMHJ9AiEA0AQfFiy5ReXxLMAR5bPqrt4qj9ZtqV+eFpk6kIE+PfECIQDf0hpOXWyrQPP/+8wdkIlwqLzzfTaTVER1PR+93y8mTQIgAXt2CT9qVpAr5si7l+pvSq20me/KOkG/K6QN4ce5/NECIQCxilGrGjppathphdObcoRDc8PciFT1VpNQPgpZfmhc4w==
publicKey:MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBALnToe+mNjxfXfPlvBBwBUXiIIA0k/ZCTVZ+EgUBRCgd9GGvL7gzaLKFa0+1eRVUwlGV8fy6gNFPpdvAMMcpkK0CAwEAAQ==
password:nE4QhILUTniDL8v0WQwEnxkt4KYRU6CiJW8F0Cb7Tbec/DY6sWj42aOAVwPsPjIyf2tc9PQo+XQtFuxS3jtpGg==

3、数据源配置,将公钥和加密后的密码放入配置文件中

db1.dbType=mysql
db1.jdbcUrl=jdbc:mysql://192.168.8.48:3306/jh_jiaotong?characterEncoding=utf8&useSSL=false&zeroDateTimeBehavior=EXCEPTION&serverTimezone=Asia/Shanghai
db1.user=root
db1.password=YealxhV364cI87WudsyZSTkJThhG065ffTFcDb06Zx/3xZTp+EDayOSsXevab3cgSYvKg9VsSp5xNNCIs8eexw==
db1.driverClass=com.mysql.cj.jdbc.Driver
db1.publicKey=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAKOl2e8hGAT7V6XJkalqLlxCSQeFcf2DaYcYNrI0WZpQ1iUCnD8LF4xnDn4lf2u1zuQnnqtBphvac89uoS6u700CAwEAAQ==
db1.filters=config

4、代码中配置密码和公钥

DruidPlugin dbPlugin = new DruidPlugin(jdbcUrl, user, password, driverClass,filters);
		dbPlugin.setPublicKey(publicKey);

 

 

最后修改于 2020-05-29 16:36:40
如果觉得我的文章对你有用,请随意赞赏
扫一扫支付
上一篇