package extendservlet;

/**
 *
 * @author dsv
 */
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class ServletDBDemo extends HttpServlet {

   static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
   static final String DATABASE_URL = "jdbc:mysql://localhost:3306/test?user=root&password=admin";
   private java.sql.Connection connection;
   private java.sql.Statement statement;

   public void doPost(HttpServletRequest request, HttpServletResponse response)
                                       throws ServletException, IOException{
      response.setContentType("text/html");
      PrintWriter out = response.getWriter();
      out.println("<h2>PERSONS</h2>");
      try{
           Class.forName(JDBC_DRIVER);
            connection = DriverManager.getConnection(DATABASE_URL);
            statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery( "SELECT * FROM person" );
            resultSet.getRow();
            int i = 0;
            while(resultSet.next()){
               {
            out.println("<br>");
            String a = resultSet.getString("name");
            out.print(a);
            String b = resultSet.getString("age");
            out.print(b);
            String c = resultSet.getString("length");
            out.println(c);
            String d = resultSet.getString("weight");
            out.println(d);
            String e = resultSet.getString("adress");
            out.println(e);
            String f = resultSet.getString("length");
            out.println(f);
         }
            }
            statement.close();
            connection.close();
            System.out.println("A lot of data retrieved");
         }catch(ClassNotFoundException cnfe){System.out.println(cnfe.toString());}
        catch(SQLException sqle){System.out.println(sqle.toString());}
   }
}