<?xml version="1.0" encoding="UTF-8"?>
<Context path="/PBS">
  <Resource name="sql2226123"
    auth="Container" type="javax.sql.DataSource"
    maxActive="20" maxIdle="5" maxWait="10000"
    username="sql2226123" password="password!"
    driverClassName="com.mysql.jdbc.Driver"
    url="jdbc:mysql://sql2.freemysqlhosting.net"/>
</Context>

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

@Resource(name="sql2226123")
private DataSource dataSource;

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

    // Step 1: Set up printwriter
    PrintWriter out = response.getWriter();
    response.setContentType("text/plain");

    // Step 2: Get connection to the database
    Connection myConn = null;
    Statement myStmt = null;
    ResultSet myRs = null;

    try {
        myConn = dataSource.getConnection(); // getting connection

        // Step 3: Create SQL statements
        String sql = "SELECT * FROM `rezerwacje_miejsc`"; // execute sql query
        myStmt = myConn.createStatement();

        // Step 4: Execute SQL query
        myRs = myStmt.executeQuery(sql);

        // Step 5: Process the result set
        while (myRs.next()) {
            String userName = myRs.getString("IMIE_NAZWISKO");
            out.println(userName);
            }
        }
        catch (Exception exc) {
            exc.printStackTrace();
        }
    }
}