Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%--
- Document : edycjaprodukt
- Created on : 2016-01-18, 15:02:07
- Author : Sandrusia
- --%>
- <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
- <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
- <%@page import="org.apache.taglibs.standard.tag.common.sql.ResultImpl"%>
- <%@page contentType="text/html" pageEncoding="UTF-8"%>
- <!DOCTYPE html>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <link rel="stylesheet" type="text/css" href="style.css" lang="pl" >
- <title>zabawki</title>
- </head>
- <sql:setDataSource var="Polaczenie" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/my_app1" user="root" password=""/>
- <c:if test="${param.Sandra == null}" >
- <sql:query var="products" dataSource="${Polaczenie}" >
- SELECT nazwa FROM products WHERE id = ?
- <sql:param value="${param.sandraid}" />
- </sql:query>
- </c:if>
- <c:if test="${param.Sandra != null}" >
- <sql:update var="products" dataSource="${Polaczenie}" >
- UPDATE products SET nazwa = ? WHERE id = ?
- <sql:param value="${param.nazwa}" />
- <sql:param value="${param.Sandra}" />
- </sql:update>
- <c:redirect url="zabawki.jsp" />
- </c:if>
- <body>
- <div style="text-align: center;">
- <h1>Sklep z zabawkami </h1>
- <div id="d1">
- <a href="zabawki.jsp"> Strona 1 -Zabawki </a>
- <a href="uprawnienia.jsp"> Strona 2 Uprawnienia</a>
- <a href="obrazki.jsp"> Strona 3 obrazki</a>
- <a href="adres.jsp"> Strona 4- adresy </a>
- </div>
- <br>
- <br>
- <form mwthod="POST" action="edycjaprodukt.jsp" >
- <input type="hidden" name="Sandra" value="${param.sandraid}" />
- <br> <p> Nazwa </p>
- <input type="text" name="nazwa" value="${products.getRows()[0].get('nazwa')}"/> <br>
- <p> cena </p>
- <button type="submit" size="15" class="btn btn-info" > Edytuj</button>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement