package com.gsi.springAlumno;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class MySQLDBConnection {

    /**
     * Registra dinámicamente el driver y devuelve una conexión con la BD
     * @return una conexión con la BD
     */
	public static Connection getConnection() throws SQLException, ClassNotFoundException {

		// Cargamos el driver
		Class.forName("com.mysql.jdbc.Driver");
		// Realizamos la conexión
		Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/contabilidad","root","");

        // We want to control transactions manually. Autocommit is on by default in JDBC.
        // con.setAutoCommit(false);

		return  con;
	}

    /**
     * Cierra la conexión con la BD
     * @param conexión a cerrar
     */
	public static void closeConnection(Connection con) throws SQLException {
		con.close();
	}

	public static void getMetadata(Connection con) {
		try {
			DatabaseMetaData dbmd = con.getMetaData();
			System.out.println("Driver Name: "+dbmd.getDriverName());
			System.out.println("Driver Version: "+dbmd.getDriverVersion());

			ResultSet rs = dbmd.getTables(null, null, null, null);

			while (rs.next()) {
				String tab = rs.getString("TABLE_NAME");
				System.out.println("Tabla: "+tab);

				ResultSet cols = dbmd.getColumns(null,null,tab,null);

				while (cols.next()) {
					String col = cols.getString("COLUMN_NAME");
					String tipo = cols.getString("TYPE_NAME");
					System.out.print("       Columna: "+col);
					System.out.println(" - Tipo: "+tipo);
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}