Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@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 name="glowny" 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' >Log out</a>
- </div>
- <%
- }
- %>
- </form>
- <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">
- <% while (actors.next()) {%>
- <img src="photo/<%= actors.getString("photo")
- %>.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>
- <br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
- <form name="kupowanie" method="post" action="buyproduct.jsp?idprod=<%= actors.getString("id")%>">
- <table border="1">
- <tr align="center">
- <td>
- Dokonaj zakupu:
- </td>
- </tr>
- <tr>
- <td>
- Ilosc sztuk: <input type="text" name="howmany" value="" />
- <input type="submit" value="Kupuje" name="dokoszyka"/>
- </td>
- </tr>
- </table>
- </form>
- </div>
- <% } %>
- <div id="reklama">
- <h1>reklama</h1>
- </div>
- <div id="stopka">
- <h1>stopka</h1>
- </div>
- </div>
- </form>
- </body>
- </html>
Add Comment
Please, Sign In to add comment