private void dodaj_do_bazy() throws SQLException {

        Pilkarz z = new Pilkarz();
        z.setImie(this.pole1.getText());
        z.setNazwisko(this.pole2.getText());
        z.setKlub(this.pole3.getText());
        z.setNarodowosc(this.pole4.getText());                                     // DODODANIE DO BAZY
        z.setPozycja(this.pole5.getText());
        z.setNumer(Integer.valueOf(this.pole6.getText()));
        z.setWiek(Integer.valueOf(this.pole7.getText()));
        z.setData_zakupu(Integer.valueOf(this.pole8.getText()));
        Object[] o = new Object[8];
        o[0] = z.getImie();
        o[3] = z.getNazwisko();
        o[1] = z.getKlub();
        o[2] = z.getNarodowosc();
        o[5] = z.getPozycja();
        o[4] = z.getNumer();
        o[6] = z.getWiek();
        o[7] = z.getData_zakupu();
        Connection dbConnection = null;
        PreparedStatement preparedStatement = null;
        PreparedStatement preparedStatement1 = null;
        String SAdd = "INSERT INTO pilkarze VALUES (null,'" + o[0] + "','" + o[1] + "','" + o[2] + "','" + o[3] + "'," + o[4] + ",'" + o[5] + "'," + o[6] + ")";
        String SAddx = "INSERT INTO zakup (data) VALUES ('" + o[7] + "')";

        try {
            dbConnection = getDBConnection();
            preparedStatement = dbConnection.prepareStatement(SAdd);
            preparedStatement1 = dbConnection.prepareStatement(SAddx);
            preparedStatement.executeUpdate();
            preparedStatement1.executeUpdate();

            System.out.println("Dodano piłkarza do bazy");
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        } finally {

            if (preparedStatement != null && preparedStatement != null) {
                preparedStatement.close();
                preparedStatement1.close();
            }

            if (dbConnection != null) {
                dbConnection.close();
            }

        }

    }