package actions;

import java.io.IOException;
import java.io.PrintWriter;
import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class DeinVadda {

    private static Log logger = LogFactory.getLog(DeinVadda.class);

    private Connection getDB()
    {

            Connection dbCon = null;
            Properties dbprops = new Properties();
            try {
                URL url = ClassLoader.getSystemResource("app.properties");
                dbprops.load(url.openStream());

                // Verbindungsparameter auslesen
                String dbdriver = dbprops.getProperty("database.driver");
                String dburl    = dbprops.getProperty("database.url");
                String username = dbprops.getProperty("database.user");
                String password = dbprops.getProperty("database.password");

                // 1. Datenbank-Treiber registrieren
                // Hier wird sichergestellt, dass der
                // benötigte JDBC-Treiber in der JVM
                // geladen wurde
                Class.forName(dbdriver);

                // 2. Verbindung zur Datenbank herstellen
                // JDBC-URL formulieren und DriverManager
                // wegen Verbindung anfragen
                try {
                    dbCon = DriverManager.getConnection(dburl, username, password);
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    logger.error("Unable to load database driver", e);
                }

            } catch (ClassNotFoundException cnfe) {
                logger.error("Unable to load database driver", cnfe);
            } catch (IOException e) {
                logger.error("Could not establish a database connection", e);
            }
            return dbCon;
    }

    public String getShit()
    {

        String BLAAAAA = "";

        try {
            Connection dbCon = getDB();
            String sqlStatement =  "SELECT * FROM benutzer";

            Statement bla2 = dbCon.createStatement();
            ResultSet digga = bla2.executeQuery(sqlStatement);

            while (digga.next())
            {
                BLAAAAA += digga.getString("vorname") +" " + digga.getString("nachname") + ";<br/>";
            }

            digga.close();
            bla2.close();

        } catch (SQLException e) {
            // TODO Auto-generated catch block
            BLAAAAA = ("DB Connection ging nicht klar!<br/>" + e);
        }
        return BLAAAAA;
    }

}