Untitled

<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<%--
    Document   : kategoria
    Created on : 2016-05-15, 14:36:23
    Author     : Izabela
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <link href="css/sklep.css" rel="stylesheet" type="text/css"/>
        <title>Sklep</title>
    </head>
    <body>

        <%--<sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver"
     url="jdbc:mysql://localhost:3306/mojsklep"
     user="root"  password="lila33"/>

        <sql:query var="categories" dataSource="${snapshot}">
            SELECT * FROM kategoria
        </sql:query>

        <sql:query var="selectedCategory" dataSource="${snapshot}">
            SELECT nazwa FROM kategoria WHERE idKategoria = ?
            <sql:param value="${pageContext.request.queryString}"/>
        </sql:query>

            <sql:query var="categoryProducts" dataSource="${snapshot}">
                SELECT * FROM produkt WHERE idKategoria = ?
                <sql:param value="${pageContext.request.queryString}"/>
            </sql:query>--%>

        <div id="main">

            <div id="categoryLeftColumn">
                <c:forEach var="kategoria" items="${categories}">

        <c:choose>
            <c:when test="${kategoria.idKategoria == pageContext.request.queryString}">
                <div class="categoryButton" id="selectedCategory">
                    <span class="categoryText">
                        ${kategoria.nazwa}
                    </span>
                </div>
            </c:when>
            <c:otherwise>
                <a href="kategoria?${kategoria.idKategoria}" class="categoryButton">
                    <div class="categoryText">
                        ${kategoria.nazwa}
                    </div>
                </a>
            </c:otherwise>
        </c:choose>

    </c:forEach>
            </div>

            <div id="categoryRightColumn">


                <table id="productTable">
                    <c:forEach var="produkt" items="${categoryProducts}" varStatus="iter">

        <tr class="${((iter.index % 2) == 0) ? 'lightBlue' : 'white'}">
            <td>
                <img src="${initParam.productImagePath}${produkt.nazwa}.png"
                    alt="${produkt.nazwa}">
            </td>
            <td>
                ${produkt.nazwa}
                <br>
                <span class="smallText">${produkt.opis}</span>
            </td>
            <td>
                &euro; ${produkt.cena} / unit
            </td>
            <td>
                <form action="dodajDoKoszyka" method="post">
                    <input type="hidden"
                           name="idProdukt"
                           value="${produkt.idProdukt}">
                    <input type="submit"
                           value="Dodaj do koszyka">
                </form>
            </td>
        </tr>

    </c:forEach>
                </table>
            </div>

        </div>
    </body>
</html>