package order;
import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
public class JDBCConnection {
public static Connection getJDBCConnection() {
FileReader reader = null;
BufferedReader bufferedReader = null;
try {
reader = new FileReader("config/ConectionConfig.txt");
bufferedReader = new BufferedReader(reader);
String line;
ArrayList list = new ArrayList<>();
while ((line = bufferedReader.readLine()) != null) {
list.add(line.trim());
}
final String url = list.get(0);
final String user = list.get(1);
final String password = list.get(2);
return DriverManager.getConnection(url, user, password);
} catch (FileNotFoundException ex) {
Logger.getLogger(JDBCConnection.class.getName()).log(Level.SEVERE, null, ex);
} catch (IOException ex) {
Logger.getLogger(JDBCConnection.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
if (bufferedReader != null) {
try {
bufferedReader.close();
} catch (IOException ex) {
Logger.getLogger(JDBCConnection.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
return null;
}
public static void closeConnection(Connection c) {
try {
if (c != null) {
c.close();
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
}