例如校验：
url: jdbc:oracle:thin:@192.168.1.1:1521/orcl username: username password: 123456
package com.msunhealth.utils; import org.springframework.jdbc.CannotGetJdbcConnectionException; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.datasource.SimpleDriverDataSource; import org.springframework.stereotype.Component; import java.net.ConnectException; import java.util.List; import java.util.Map; /** * @Description: * @Company：校验数据库连接 * @Author: KHJ * @Date: 2020/07/02 * @Version 1.0 * ip：192.168.1.1 * port:1521 * inc:orcl * username:username * password:123456 */ @Component public class DataSourceUtils { public boolean dataSourceConn (String ip,String port,String ins,String password,String username){ boolean flag =true; SimpleDriverDataSource dataSource = new SimpleDriverDataSource(); dataSource.setDriver(new oracle.jdbc.driver.OracleDriver()); dataSource.setUrl("jdbc:oracle:thin:@"+ip+":"+port+":"+ins+""); dataSource.setUsername(username); dataSource.setPassword(password); JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource); String sqlSelect = "select '1' from dual"; try { jdbcTemplate.queryForList(sqlSelect); } catch (org.springframework.dao.DataAccessException e) { System.out.println("------------数据库连接异常！请检查数据源信息------------"); flag =false; } return flag; } }