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<String> 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();

}

}

}