Shulou(Shulou.com)06/02 Report--

This article will explain in detail how to integrate the Druid connection pool in Servlet. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Druid configuration (druid.properties)

# druid profile # driver driverClassName=com.mysql.jdbc.Driver#urlurl=jdbc:mysql://127.0.0.1:3306/cms?useUnicode=true&characterEncoding=utf8&useSSL=true# user name username=root# password password=root# connection Pool initialization size initialSize=10# active Link maxActive=10# minimum number of connections built-in filter used by minIdle=10# will not count SQL to execute filters=stat if not configured

JDBC connection pool

/ * Druid connection pool * @ author tangpengfei * / public class DruidUtil {static DruidDataSource dataSource; static {Properties prop = new Properties (); try {prop.load (DruidUtil.class.getClassLoader (). GetResourceAsStream ("druid.properties")); dataSource = (DruidDataSource) DruidDataSourceFactory.createDataSource (prop) / / dataSource.addFilters ("stat,log4j,wall");} catch (IOException e) {e.printStackTrace ();} catch (Exception e) {e.printStackTrace () } public static Connection getConn () {try {return dataSource.getConnection ();} catch (SQLException e) {e.printStackTrace ();} return null;}}

Web.xml configuration

So much for StatViewServlet com.alibaba.druid.support.http.StatViewServlet resetEnable true loginUsername admin loginPassword admin StatViewServlet / druid/* on how to integrate Druid connection pooling in Servlet I hope the above content can be of some help to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.