java解析配置文件config.propertie 使用JDBC链接数据库

最新推荐文章于 2022-06-12 10:52:41 发布

xiao708

最新推荐文章于 2022-06-12 10:52:41 发布

阅读量720

点赞数

本文链接：https://blog.csdn.net/xiao708/article/details/40819727

版权

private static String driver;
	private static String url;
	private static String username;
	private static String password;
	private static BasicDataSource ds;
	static{
		try {
			Properties properties = new Properties();
			InputStream fis =JdbcUtil.class.getClassLoader().getResourceAsStream("config.properties");
			properties.load(fis);
			driver = properties.getProperty("driverClassName");
			url=properties.getProperty("jdbc_url");
			username=properties.getProperty("jdbc_username");
			password=properties.getProperty("jdbc_password");
			
			ds = new BasicDataSource();
			ds.setDriverClassName(driver);
			ds.setUrl(url);
			ds.setUsername(username);
			ds.setPassword(password);
			ds.setInitialSize(5);
			ds.setMaxActive(20);
			ds.setMinIdle(2);
			ds.setMaxWait(20000);
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	
	public static synchronized Connection getConnection()throws Exception{
		try {
			return ds.getConnection();
		} catch (Exception e) {
			e.printStackTrace();
			throw e;
		}
	}
	
	public static void closeConnection(Connection conn){
		try {
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}