package org.anadyr.util.mysql;

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

import org.anadyr.util.Logging;

public class MySql {

    private Connection conn;
    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private static final String HOST = "jdbc:mysql://localhost/";
    private static final String USERNAME = "root";
    private static final String PASSWORD = "poiupoiu";
    private static final String DATABASE = "anadyrdb";


    public void connectToDataBase() {
        try {
            Class.forName(DRIVER).newInstance();
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            conn = DriverManager.getConnection(HOST + DATABASE + "?" +
             "user=" + USERNAME + "&password=" + PASSWORD);
            Logging.log(this, "SQLPooled: Localhost:"+ DATABASE + ", Polnomochiya: " + USERNAME +":"+ PASSWORD.replaceAll(".", "*"));
        } catch (SQLException ex) {
            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("SQLState: " + ex.getSQLState());
            System.exit(2);
        }
    }

    public Connection getConnection() {
        return conn;
    }
}