Untitled



<%@ page import ="java.sql.*" %>
<%@ page import="java.util.List" %>
<%@ page import="java.io.*" %>


<% 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>JSP Example</title>
        <script type="text/javascript">
function rozwin(i){
var menu =document.getElementById(i);
var disp=menu.style.display;
if(disp=='none'){
menu.style.display='block';
}
else{
menu.style.display='none';
}
}
</script>
    </head>
    <body>
        <script type="text/javascript">


               </script>
       <%!
            public class Actor{
            String URL = "jdbc:mysql://localhost:3306/mysql";
             String USERNAME = "root";
            String PASSWD = "";
            public String mem = "";
            Connection connection = null;
            PreparedStatement select= null;
            PreparedStatement select1= null;
            PreparedStatement selectgen= null;
            ResultSet resultSet = null;
             int a = 0;
             public void setmem(String rec){
                mem=rec;
}
            public Actor(){
            try{
            connection = DriverManager.getConnection(URL, USERNAME,PASSWD );
            select = connection.prepareStatement("SELECT first_name FROM members WHERE first_name='admin'" );
            select1 = connection.prepareStatement("SELECT first_name FROM members");
            selectgen = connection.prepareStatement("SELECT * FROM products WHERE subcategory='"+mem+"'");
            }
            catch (SQLException e){
                 e.printStackTrace();
            }
        }
            public Actor(String rec){
            try{
             mem=rec;
            connection = DriverManager.getConnection(URL, USERNAME,PASSWD );
            select = connection.prepareStatement("SELECT first_name FROM members WHERE first_name='admin'" );
            select1 = connection.prepareStatement("SELECT first_name FROM members");
            selectgen = connection.prepareStatement("SELECT * FROM products WHERE subcategory='"+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;
    }
 public ResultSet getAll(){

            try{
                resultSet = select1.executeQuery();
            } catch (SQLException e){
            e.printStackTrace();
        }
          return resultSet;
    }
public ResultSet gen(){

            try{

                resultSet = selectgen.executeQuery();
            } catch (SQLException e){
            e.printStackTrace();
        }
          return resultSet;
    }
}
%>

        <%

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

%>
        <%! public class generate {
    public String generate(String rec ){
//Actor qwe = new Actor();

Actor actor = new Actor(rec);

ResultSet actors = actor.getActors();

actors = actor.gen();

String a="0";
try{
a="<table border=\"1\" width=\"300\" cellpadding=\"3\"><tbody><tr><td>Foto</td><td>nazwa</td><td>ilosc</td><td>Cena</td></tr>";


         while (actors.next()) {
a=a+"<tr>";

a=a+"<td>";
a+="<img src='";
                a+=actors.getString("photo");
a+="' width='100' height='100'>";
a=a+"</td>";
a=a+"<td>";
a+="<a id=\"myLink\" href=\"showproduct.jsp?parametr1="+actors.getString("id")+"\" onclick=\"\">";
a+=actors.getString("name");
a+="</a>";
a=a+"</td>";
a=a+"<td>";
                a+=actors.getString("quantity");
a=a+"</td>";

a=a+"<td>";
                a+=actors.getString("price");
a=a+"</td>";
a=a+"<td>";


a=a+"<input type=\"text\" name=\"";
a+=actors.getString("id");
a+="\" value=\"\" />";


a=a+"</td>";
a=a+"</tr>";
}

a=a+"</tbody></table>";
}catch (SQLException e){
            e.printStackTrace();
        }

return a;
}
}


%>
<%generate show = new generate();
     %>

        <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>
                     <%      if(parametr1==null)
                     {out.println("pick");
                    }else{out.println(show.generate(parametr1));}%>
		</ul>

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

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

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