import java.io.IOException;
import java.sql.*;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class debugDb
 */
@WebServlet("/debugDb")
public class debugDb extends HttpServlet {
	private static final long serialVersionUID = 1L;

	private int lol = 5;
	private String stat = "nic";

	public void init(ServletConfig config) throws ServletException {
		lol = 10;
		
        String dbJdbcUrl = "jdbc:mysql://us-cdbr-iron-east-04.cleardb.net/ad_68c31f5fa0315bf?user=WPISZ_USER&password=WPISZ_HASLO";
		
        try 
        {
			Class.forName("com.mysql.jdbc.Driver");
			Connection connect = DriverManager.getConnection(dbJdbcUrl);
			
			Statement statement = connect.createStatement();
	      
			ResultSet resultSet = statement
	          .executeQuery("select * from debugtab");

			stat = "ok: ";

			while (resultSet.next()) 
			{
				stat +=  resultSet.getString("id");
			}
			
			
		} catch (Exception e) {
			stat = "dupa_4";
			e.printStackTrace();
		}
		
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html");
		response.getWriter().print("lol = " + lol + " stat = " + stat);
	}

}