package hello;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet(name = "HelloServlet", urlPatterns = {"/HelloServlet"})
public class HelloServlet extends HttpServlet {

     protected void processRequest(HttpServletRequest request, HttpServletResponse response)
             throws ServletException, IOException, SQLException {
          Class.forName("org.apache.derby.jdbc.ClientDriver");
          Connection connection = DriverManager.getConnection("jdbc:derby://localhost:1527/IBIS", "arthur", "admin");
          Statement statement = connection.createStatement();
          ResultSet resultSet = statement.executeQuery("SELECT * FROM IBIS.cliente");
          while (resultSet.next()) {
               System.out.println(resultSet.getString("nome"));
          }
          if (resultSet != null && !resultSet.isClosed()) {
               resultSet.close();
          }
          if (connection != null && !connection.isClosed()) {
               connection.close();
          }