/Java/Create JDBC connection using properties file

Create JDBC connection using properties file

 
package com.javaartifacts;
 
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
 
public class TestConnection {
 
	public static Properties loadPropertiesFile() throws Exception {
 
		Properties prop = new Properties();
		InputStream in = new FileInputStream("jdbc.properties");
		prop.load(in);
		in.close();
		return prop;
	}
 
	public static void main(String[] args) {
 
		System.out.println("create jdbc connection using properties file");
		
		Connection con = null;
 
		try {
 
		Properties prop = loadPropertiesFile();
 
		String driverClass = prop.getProperty("MYSQLJDBC.driver");
		String url = prop.getProperty("MYSQLJDBC.url");
		String username = prop.getProperty("MYSQLJDBC.username");
		String password = prop.getProperty("MYSQLJDBC.password");
 
		Class.forName(driverClass);
 
		con = DriverManager.getConnection(url, username, password);
 
		if (con != null) {
		System.out.println("connection created successfully using properties file");
		}
 
		else {
		System.out.println(" unable to create connection");
		}
 
		}catch (SQLException e) {
		e.printStackTrace();
		} 
		catch (Exception e) {
		e.printStackTrace();
		} finally {
 
		try {
		if (con != null) {
		con.close();
		}
		} catch (Exception ex) {
		ex.printStackTrace();
		}
		}
	}
 
}

Source: javaartifacts.com

Similar codes

0 vote120 views1 answer
Java stream code to ignore null
Java
1 vote185 views1 answer
Android dependency 'androidx.core:core' has different version for the compile (1.0.2) and runtime (1.1.0) classpath. You should manually set the same version via DependencyResolution
Java
0 vote129 views1 answer
How to check if a person presses a button in jframe in java
Java
-2 votes134 views2 answers
Https://www.roblox.com/home
Java
0 vote127 views1 answer
Differance entre appel implcite et explicite en java
Java
0 vote133 views1 answer
>> vs >>> operators in java
Java
0 vote130 views1 answer
IntList
Java
0 vote125 views1 answer
Display double in decimal places java
Java
0 vote123 views1 answer
Codepointat java
Java
0 vote132 views4 answers
Mergesort
Java