package computinggraphtransformations; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class DatabaseConnection { private static final String DATABASE_URL = "jdbc:mysql://localhost:3306/Computing"; private static final String USERNAME = "root"; private static final String PASSWORD = "password"; private static Connection conn; private DatabaseConnection() { } public static PreparedStatement getStatement(String query) { PreparedStatement stmt = null; try { stmt = getConnection().prepareStatement(query); } catch (SQLException e) { e.printStackTrace(); } return stmt; } private static Connection getConnection() { try { if(conn == null || conn.isClosed() ) conn = DriverManager.getConnection(DATABASE_URL, USERNAME, PASSWORD); } catch (SQLException e) { e.printStackTrace(); } return conn; } public static void closeConnection() { if(conn == null ) return; try { if( conn.isClosed() ) return; conn.close(); } catch (SQLException e) { e.printStackTrace(); } } }