package pap1;


import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;

@WebServlet("/Pap")
public class Pap extends HttpServlet {


    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        Connection con = null;
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "");
                if (!con.isClosed())
                    System.out.println("Successfully connected to MySQL server...");

                 // if you only need a few columns, specify them by name instead of using "*"
                  String query = "SELECT * FROM persons";

                  // create the java statement
                  Statement st = con.createStatement();

                  // execute the query, and get a java resultset
                  ResultSet rs = st.executeQuery(query);

                  while (rs.next())
                  {
                    int id = rs.getInt("id");
                    String firstName = rs.getString("name");
                    String age = rs.getString("age");


                    // print the results
                    System.out.format("%s, %s, %s\n", id, firstName, age);
                  }
                  st.close();

        } catch(Exception e) {
                System.err.println("Exception: " + e.getMessage());
        } finally {
        try {
                if (con != null)
                    con.close();
        } catch(SQLException e) {}
        }


    }




}