package web;


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

/**
 *
 * @author Filip Valenta
 */
public class Database {

    private Connection connection;
    private Statement statement;

    public Database() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch(Exception ex) {
            ex.printStackTrace();
        }
        try {
            connection = DriverManager.getConnection("jdbc:mysql://server.kalgul.eu:3306/","","");
            statement = connection.createStatement();
        } catch(SQLException ex) {
            ex.printStackTrace();
        }
    }

    public void executeUpdate(String command) {
        try {
            statement.executeUpdate(command);
        } catch(SQLException ex) {
            ex.printStackTrace();
        }
    }

    public ResultSet executeQuery(String command) {
        ResultSet resultset = null;
        try {
           resultset = statement.executeQuery(command);
        } catch(SQLException ex) {
            ex.printStackTrace();
        }
        return resultset;
    }

    protected void Disconnect() {
        try {
            statement.close();
            connection.close();
        } catch(SQLException ex) {
            ex.printStackTrace();
        }
    }
}