记所收集到的数据源连接方式

以下用Druid进行的数据源连接池
DruidDataSource dataSource = new DruidDataSource();
dataSource.setEnable(true);
dataSource.setUrl("jdbc:mysql://localhost:3306/yingcheng?useUnicode=true&characterEncoding=utf-8");
dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
dataSource.setUsername("root");
dataSource.setPassword("ying.115");
return dataSource ;

ServletRegistrationBean reg = new ServletRegistrationBean();
reg.setServlet(new StatViewServlet());
reg.addUrlMappings("/druid/*");
reg.addInitParameter("allow", ""); //白名单
return reg;

/**
 * 注册FilterRegistrationBean
 * @return
 */
@Bean(name = "filterRegistrationBean")
public FilterRegistrationBean filterRegistrationBean() {
    FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();
    filterRegistrationBean.setFilter(new WebStatFilter());
    filterRegistrationBean.addUrlPatterns("/*");
    filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
    filterRegistrationBean.addInitParameter("profileEnable", "true");
    filterRegistrationBean.addInitParameter("principalCookieName", "USER_COOKIE");
    filterRegistrationBean.addInitParameter("principalSessionName", "USER_SESSION");
    filterRegistrationBean.addInitParameter("DruidWebStatFilter", "/*");
    return filterRegistrationBean;
}

以下racle连接方式

oracle.jdbc.OracleDriver

<dependency>

      <groupId>com.oracle.ojdbc</groupId>

      <artifactId>ojdbc8</artifactId>

      <scope>runtime</scope>

</dependency>

jdbc:oracle:thin:@192.168.0.1:1521:SXT