/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package databasepract;

import java.sql.*;

/**
 *
 * @author Mick
 */
public class DbManager {

    public Connection connection;

    public void openConnection() {
        try {
            Class.forName("org.postgresql.Driver");
            String url =
                    "jdbc:postgresql://192.168.56.101:5432/Voetbal";
            String user = "postgres", pass = "ww hier";
            /** Open connection */
            connection = DriverManager.getConnection(url,
                    user, pass);
        } catch (ClassNotFoundException e) {
            System.err.println("JDBC Error: " + e);
        } catch (java.sql.SQLException e) {
            System.err.println("SQL Exception: " + e);
        }
    }

    public void executeQuery(String query){
        try{
        Statement statement = connection.createStatement();
        statement.executeUpdate(query);
        }catch(Exception e){
            e.printStackTrace();
        }
    }

    public ResultSet selectQuery(String query) {
        ResultSet result = null;
        try {
            Statement statement = connection.createStatement();
            result = statement.executeQuery(query);
        } catch (java.sql.SQLException e) {
            System.err.println(e.getMessage());
        }
        return result;
    }

    public void closeConnection() {
        try {
            connection.close();
        } catch (Exception e) {
            System.err.println(e.getMessage());
        }
    }

    public int getPlayers(String teamnummer) {
        int nummers = 0;
        ResultSet result = null;
        try {
            Statement statement = connection.createStatement();
            result = statement.executeQuery("SELECT COUNT(*) as \"manny\" FROM spelers WHERE teamnr=\'"+teamnummer+"\'");
            if (result.next()) {
                nummers = Integer.parseInt(result.getString("manny"));
            }
        } catch (java.sql.SQLException e) {
            System.err.println(e.getMessage());
        }
        return nummers;
    }
}