jfinal下配置druid数据库连接池

实现该功能需要druid   jar包 https://github.com/alibaba/druid 1 .web.xml中添加 <!-- Druid web监控--> <filter> <filter-name>DruidWebStatFilter</filter-name> <filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class> <init-param> <param-name>exclusions</param-name> <param-value>*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*</param-value> </init-param> </filter> <filter-mapping> <filter-name>DruidWebStatFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- Druid 数据源查看 --> <servlet> <servlet-name>DruidStatView</servlet-name> <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class> <init-param> <param-name>resetEnable</param-name> <param-value>false</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>DruidStatView</servlet-name> <url-pattern>/druid/*</url-pattern> </servlet-mapping> 注意在DruidWebStatFilter中一定要添加 /druid/*  </pre></div><div><span style="font-size:18px"></span><pre name="code" class="java">public void configPlugin(Plugins plugins) { log.info("配置Druid数据库连接池"); DruidPlugin druidPlugin = new DruidPlugin( PropKit.get(ConstantInit.mysql_jdbcUrl), PropKit.get(ConstantInit.mysql_userName), PropKit.get(ConstantInit.mysql_passWord), PropKit.get(ConstantInit.mysql_driverClass)); druidPlugin.set( PropKit.getInt(ConstantInit.db_initialSize), PropKit.getInt(ConstantInit.db_minIdle), PropKit.getInt(ConstantInit.db_maxActive)); log.info("configPlugin 配置Druid数据库连接池过滤器配制"); druidPlugin.addFilter(new StatFilter()); WallFilter wall = new WallFilter(); wall.setDbType(PropKit.get(ConstantInit.db_type_key)); WallConfig config = new WallConfig(); config.setFunctionCheck(false); // 支持数据库函数 wall.setConfig(config); druidPlugin.addFilter(wall); ActiveRecordPlugin arp = new ActiveRecordPlugin(ConstantInit.db_dataSource_main, druidPlugin); arp.setDevMode(true); arp.setShowSql(true); arp.setDialect(new MysqlDialect()); plugins.add(druidPlugin); // log.info("configPlugin 表自动扫描注册"); // new TableScan(ConstantInit.db_dataSource_main, arpMain).start(); plugins.add(arp); arp.addMapping("user", User.class); arp.addMapping("food", Food.class); arp.addMapping("orders", Orders.class); log.info("EhCachePlugin EhCache缓存"); plugins.add(new EhCachePlugin()); log.info("SqlXmlPlugin 解析并缓存 xml sql"); plugins.add(new SqlXmlPlugin()); } 输入localhost/driud 查看数据池配置信息