Jfinal+Druid实现数据库密码加密部署

• 使用durid自带工具对数据库密码加密

 java –cp druid-1.0.29.jar com.alibaba.druid.filter.config.ConfigTools 你的密码

会得到类似下面结果

privateKey:MIIBVQIBADANBgkqhkiG9w0BAQEFAASCAT8wggE7AgEAAkEAqzYO4cW3/HmGglEzxPnRKCyE0mngrGZEmdLbxD7wb+azAqCPI5KyyxiiJ80WC3jiTqJzVIXuD3f3TSvpMbk4GwIDAQABAkEAmLe9ipHszZ4w5yk7fmY/tRAQ4gdjSyRl6Lf3JBPoMEcm73dVBopHgsxaNwx684/N33PZ7h5Ol3lRwtGRXnyawQIhAOck78e8lINxjtREYL2ESgnm3/m0yylNrKwC6SZDG4iLAiEAvZ9AJLcTAOYsRMKlamvcthfSnpxkPbG9hTw3GCs5cLECIEXQx0gKMsV9AEonGR1FHuPcw1v1+sNP/c661ldDP8a/AiEAkd/eJ6CTRQDNk4QuXwVlgMwo4o4ra269/q6JL9Wo1bECIFu5tcBeC/MmqP3HpbaaUV2CsH9jZAt5hSyiaxBu39Y9
publicKey:MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAKs2DuHFt/x5hoJRM8T50SgshNJp4KxmRJnS28Q+8G/mswKgjyOSsssYoifNFgt44k6ic1SF7g93900r6TG5OBsCAwEAAQ==
password:IaDMty79Auim4lAg+KD9IuTelU7M+t8erJ1asRCFbTE0GhopbRgoDdLG25MXQyyRQ+KAtyvAFkVZbNWNUuskiA==

• 设置jfinal 的a_little_config.txt

jdbcUrl = jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull
user = root
password = IaDMty79Auim4lAg+KD9IuTelU7M+t8erJ1asRCFbTE0GhopbRgoDdLG25MXQyyRQ+KAtyvAFkVZbNWNUuskiA==
driver = com.mysql.jdbc.Driver
filters = config
publicKey = MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAKs2DuHFt/x5hoJRM8T50SgshNJp4KxmRJnS28Q+8G/mswKgjyOSsssYoifNFgt44k6ic1SF7g93900r6TG5OBsCAwEAAQ==

• 配置 druid 数据库连接池插件

DruidPlugin druidPlugin = new DruidPlugin(PropKit.get("jdbcUrl").trim(), PropKit.get("user").trim(), PropKit.get("password").trim(), PropKit.get("driver").trim(), PropKit.get("filters").trim());
druidPlugin.setPublicKey(PropKit.get("publicKey").trim());
plugins.add(druidPlugin);