Untitled


<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import ="java.sql.*" %>
<% Class.forName("com.mysql.jdbc.Driver"); %>
<% String parametr1 = request.getParameter("parametr1");%>
<!DOCTYPE html>
<html>
    <style>
    #container
    {
    width: 1000px;
    margin-left:auto;
    margin-right:auto;
    }
    #logo
    {
        background-color: black;
        color: #ffffff;
        text-align: left;
        max-width: 11px;
        min-height:  50px;
        padding: 15px;
    }
    #logowanie
    {
        background-color: black;
        color: #ffffff;


    }
    #navigation
    {
        clear:both;
        background-color: aqua;
        color: #ffffff;
        float:left;
        width: 15%;
        min-height: 620px;
        padding: 20px;
    }
   #content
    {
        background-color: lightblue;
        color: #ffffff;
        width: 70%;
        padding: 40px;
        min-height: 580px;
        float:left;

    }
     #reklama
    {
        background-color: black;
        color: #ffffff;
        width: 120px;
        min-height: 620px;

        float:left;

    }
     #stopka
    {
        background-color: blue;
        color: #ffffff;
        color: #ffffff;
        clear:both;

    }
     ul.menu
    {
    padding: 0 20px;
    }

      ul.menu a:link, ul.menu a:visited
    {
     width:166px;
    }

    </style>
    <head>

        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Sklep</title>
        </head>
    <body>
         <%!
            public class Actor{
            String URL = "jdbc:mysql://localhost:3306/mysql";
             String USERNAME = "root";
            String PASSWD = "";
            String mem="";
            Connection connection = null;
            PreparedStatement select= null;
            ResultSet resultSet = null;
             int a = 0;
       public void setmem(String rec){
                mem=rec;
           }
            public Actor(String rec){
            try{
            mem=rec;
            connection = DriverManager.getConnection(URL, USERNAME,PASSWD );
            select = connection.prepareStatement("SELECT * FROM products WHERE id="+mem );
            }
            catch (SQLException e){
                 e.printStackTrace();
            }
        }
         public int check(){
            try{
                resultSet = select.executeQuery();

            }
            catch (SQLException e){
                 e.printStackTrace();
            }
            return a;
            }
        public ResultSet getActors(){

            try{
                resultSet = select.executeQuery();

            } catch (SQLException e){
            e.printStackTrace();
        }
          return resultSet;
    }

}
%>
        <%

            Actor actor = new Actor(parametr1);
            ResultSet actors = actor.getActors();

%>
    <form method="post" action="login.jsp">
            <div id="container"
                 <div id="logo">

                     <h1 align="center">Sklep internetowy</h1>


                </div>
                <br>
                  <div id="logwanie">
                                       <%
    if ((session.getAttribute("userid") == null) || (session.getAttribute("userid") == "")) {
%>
You are not logged in (Please Login)


<%  out.println("<table border=\"1\" width=\"100%\" cellpadding=\"3\"><thead><tr><tbody><td>User Name: <input type=\"text\" name=\"uname\" value=\"\" />   Password: <input type=\"password\" name=\"pass\" value=\"\" /><input type=\"submit\" value=\"Login\" /><input type=\"reset\" value=\"Reset\" /></td></tr><tr><td colspan=\"2\">Yet Not Registered!! <a href=\"reg.jsp\">Register Here</a></td></tr></tbody></table></div>");} else {
%>
<div id="welcome">
Welcome <%=session.getAttribute("userid")%>
<a href="shoppingcard.jsp">Shopping Card</a>
<a href='logout.jsp' align="left">Log out</a>

</div>
<%
    }
%>
  <div id="navigation"><table border ="1">


      </table>

                     <ul>
	<li><a href="#" onclick="javascript:rozwin('menu123')">Procesory</a>
            <ul id="menu123" class="menu" style="display:none;">
                <li><a href="http://localhost:8080/WebApplication3/index.jsp?parametr1=INTEL" onclick="javascript:rozwin('menu1234')">INTEL</a>

		<li><a href="http://localhost:8080/WebApplication3/index.jsp?parametr1=AMD" onclick="javascript:rozwin('menu12345')">AMD</a>

            </ul>
		</li>
	<li><a href="#" onclick="javascript:rozwin('menu2')">Dyski</a>
		<ul id="menu2" class="menu" style="display:none;">

			<li><a href="http://localhost:8080/WebApplication3/index.jsp?parametr1=SSD" onclick="javascript:rozwin('menu1234')">SSD</a>

			<li><a href="http://localhost:8080/WebApplication3/index.jsp?parametr1=HDD" onclick="javascript:rozwin('menu1234')">HDD</a>
		</ul></li>
	<li><a href="#" onclick="javascript:rozwin('menu3')">GPU</a>
		<ul id="menu3" class="menu" style="display:none;">
			<li><a href="http://localhost:8080/WebApplication3/index.jsp?parametr1=GFORCE" onclick="javascript:rozwin('menu1234')">GFORCE</a>
			<li><a href="http://localhost:8080/WebApplication3/index.jsp?parametr1=RADEON" onclick="javascript:rozwin('menu1234')">RADEON</a>

		</ul></li>
</ul>

                </div>


                 <div id="content">
                      <h1>zawartosc</h1>
                      <% while (actors.next()) {%>

<img src="photo/<%= actors.getString("name")
                 %>.jpg" width="500" height="500" border="0" align="left"/>
<br><br><br><br>
Nazwa produktu:
                <%= actors.getString("name")
                 %>
                 <br>
Cena:
            <%= actors.getString("price")
                 %>
                 zl<br>
                 Ilosc dostepnych sztuk:
            <%= actors.getString("quantity")
                 %>
                 <br>
                 Opis:
            <%= actors.getString("description")
                 %>
                 <br>
        <% } %>
                     </div>
                 <div id="reklama">

                      <h1>reklama</h1>
                     </div>
                 <div id="stopka">
                      <h1>stopka</h1>
                     </div>

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