Index: src/main/resources/application.properties
===================================================================
--- src/main/resources/application.properties	(revision 24c39f958d6dc4a916ce04381e57b26a8163a342)
+++ src/main/resources/application.properties	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
@@ -1,10 +1,15 @@
+#
+spring.datasource.url=jdbc:postgresql://localhost:9090/db_202324z_va_prj_busngo
+spring.datasource.username=db_202324z_va_prj_busngo_owner
+spring.datasource.password=d9f924580e7
+spring.datasource.driver-class-name=org.postgresql.Driver
 
-spring.datasource.url=jdbc:postgresql://localhost:5432/db_202324z_va_prj_busngo
 
 spring.datasource.hikari.connection-timeout=20000
-spring.datasource.hikari.maximum-pool-size=5
+spring.datasource.hikari.maximum-pool-size=25
 
-spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
+#spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
 spring.jpa.properties.hibernate.jdbc.non_contextual_creation=true
+spring.jpa.properties.hibernate.default_schema=project 
 
 spring.jpa.hibernate.ddl-auto=validate
Index: src/main/resources/templates/fragments/footer.html
===================================================================
--- src/main/resources/templates/fragments/footer.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
+++ src/main/resources/templates/fragments/footer.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
@@ -0,0 +1,48 @@
+<footer class="text-black-50 mt-xl-5" xmlns:th="http://www.thymeleaf.org">
+    <div class="container">
+        <div class="row">
+            <div class="col-md-3 col-lg-4 col-xl-3">
+                <h5>About</h5>
+                <hr class="bg-white mb-2 mt-0 d-inline-block mx-auto w-25">
+                <p class="mb-0">
+                    Le Lorem Ipsum est simplement du faux texte employé dans la composition et la mise en page avant
+                    impression.
+                </p>
+            </div>
+
+            <div class="col-md-2 col-lg-2 col-xl-2 mx-auto">
+                <h5>Informations</h5>
+                <hr class="bg-white mb-2 mt-0 d-inline-block mx-auto w-25">
+                <ul class="list-unstyled">
+                    <li><a href="">Link 1</a></li>
+                    <li><a href="">Link 2</a></li>
+                    <li><a href="">Link 3</a></li>
+                    <li><a href="">Link 4</a></li>
+                </ul>
+            </div>
+
+            <div class="col-md-3 col-lg-2 col-xl-2 mx-auto">
+                <h5>Others links</h5>
+                <hr class="bg-white mb-2 mt-0 d-inline-block mx-auto w-25">
+                <ul class="list-unstyled">
+                    <li><a href="">Link 1</a></li>
+                    <li><a href="">Link 2</a></li>
+                    <li><a href="">Link 3</a></li>
+                    <li><a href="">Link 4</a></li>
+                </ul>
+            </div>
+
+            <div class="col-md-4 col-lg-3 col-xl-3">
+                <h5>Contact</h5>
+                <hr class="bg-white mb-2 mt-0 d-inline-block mx-auto w-25">
+                <ul class="list-unstyled">
+                    <li><i class="fa fa-home mr-2"></i> My company</li>
+                    <li><i class="fa fa-envelope mr-2"></i> email@example.com</li>
+                    <li><i class="fa fa-phone mr-2"></i> + 33 12 14 15 16</li>
+                    <li><i class="fa fa-print mr-2"></i> + 33 12 14 15 16</li>
+                </ul>
+            </div>
+        </div>
+    </div>
+</footer>
+
Index: src/main/resources/templates/fragments/header.html
===================================================================
--- src/main/resources/templates/fragments/header.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
+++ src/main/resources/templates/fragments/header.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
@@ -0,0 +1,64 @@
+<header xmlns:th="http://www.thymeleaf.org">
+  <nav class="navbar navbar-expand-md navbar-dark bg-dark">
+    <div class="container">
+      <a class="navbar-brand" href="/">Bus & GO</a>
+      <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarsExampleDefault"
+              aria-controls="navbarsExampleDefault" aria-expanded="false" aria-label="Toggle navigation">
+        <span class="navbar-toggler-icon"></span>
+      </button>
+
+      <div class="collapse navbar-collapse justify-content-end" id="navbarsExampleDefault">
+        <ul class="navbar-nav m-auto">
+          <li class="nav-item m-auto">
+            <a class="nav-link active" href="/bilet">Bileti</a>
+          </li>
+          <li class="nav-item m-auto">
+            <a class="nav-link active" href="/categories">Categories</a>
+          </li>
+          <li class="nav-item m-auto">
+            <a class="nav-link active" href="/manufacturers">Manufacturers</a>
+          </li>
+        </ul>
+
+
+        <form class="form-inline my-2 my-lg-0">
+          <div class="input-group input-group-sm">
+            <input type="text" class="form-control" aria-label="Small"
+                   aria-describedby="inputGroup-sizing-sm"
+                   placeholder="Search...">
+            <div class="input-group-append">
+              <button type="button" class="btn btn-secondary btn-number">
+                <i class="fa fa-search"></i>
+              </button>
+            </div>
+          </div>
+        </form>
+        <ul class="nav navbar-nav navbar-right">
+
+          <li class="nav-item">
+            <a class="nav-link" href="#"></a>
+          </li>
+          <li class="nav-item">
+            <a class="btn btn-success btn-sm ml-3" href="/shopping-cart">
+              <i class="fa fa-shopping-cart"></i> Cart
+            </a>
+          </li>
+          <li class="nav-item" sec:authorize="isAuthenticated()">
+            <a href="#" class="btn btn-light btn-sm ml-3" sec:authentication="name">
+            </a>
+          </li>
+          <li class="nav-item" sec:authorize="isAuthenticated()">
+            <a class="btn btn-light btn-sm ml-3" href="/logout">
+              <i class="fa-solid fa-right-from-bracket"></i> Logout
+            </a>
+          </li>
+          <li class="nav-item" sec:authorize="isAnonymous()">
+            <a class="btn btn-light btn-sm ml-3" href="/login">
+              <i class="fa-solid fa-right-to-bracket"></i> Login
+            </a>
+          </li>
+        </ul>
+      </div>
+    </div>
+  </nav>
+</header>
Index: src/main/resources/templates/kupiBilet.html
===================================================================
--- src/main/resources/templates/kupiBilet.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
+++ src/main/resources/templates/kupiBilet.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
@@ -0,0 +1,25 @@
+<div xmlns:th="http://www.thymeleaf.org">
+    <section class="jumbotron text-center">
+        <div class="container">
+            <h1 class="jumbotron-heading">WEB PROGRAMMING SHOP</h1>
+            <h3 class="jumbotron-heading">All products</h3>
+        </div>
+    </section>
+
+    <div style="width: 500px">
+        <form method="post" action="/bilet/kupi">
+
+            <p>
+                <label for="tipbilet" class="sr-only">Tip Bilet</label>
+                <select id="tipbilet" name="tipbilet" class="form-control">
+                    <option class="form-control" th:each="tip : ${tipbileti}" th:value="${tip.tbId}" th:text="${tip.tbIme}"></option>
+                </select>
+            </p>
+
+            <input type="submit" value="Kupi" class="btn btn-success">
+        </form>
+
+    </div>
+</div>
+
+
Index: src/main/resources/templates/listBileti.html
===================================================================
--- src/main/resources/templates/listBileti.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
+++ src/main/resources/templates/listBileti.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
@@ -0,0 +1,77 @@
+<div xmlns:th="http://www.thymeleaf.org">
+    <section class="jumbotron text-center">
+        <div class="container">
+            <h1 class="jumbotron-heading">WEB PROGRAMMING SHOP</h1>
+            <h3 class="jumbotron-heading">All products</h3>
+        </div>
+    </section>
+
+    <div class="container mb-4">
+        <div class="row">
+            <div class="col-12" >
+                <div class="table-responsive">
+                    <table class="table table-striped">
+                        <thead>
+                        <tr>
+                            <th scope="col">#</th>
+                            <th scope="col">Status</th>
+                            <th scope="col">Korisnik Ime</th>
+                            <th scope="col">Tip Bilet</th>
+                            <th scope="col"></th>
+                            <th scope="col"></th>
+                            <th scope="col"></th>
+                        </tr>
+                        </thead>
+                        <tbody>
+                        <tr th:each="bilet : ${bileti}" class="product">
+                            <td th:text="${bilet.bId}"></td>
+                            <td th:text="${bilet.bStatus.name()}"></td>
+                            <td th:text="${bilet.korisnikByPatnikKId.kIme}"></td>
+                            <td th:text="${bilet.tipbiletByTbId.tbIme}"></td>
+
+                            <td class="text-right">
+                                <th:block sec:authorize="hasRole('ROLE_ADMIN')">
+                                    <form th:action="@{'/products/delete/{id}' (id=${bilet.bId})}"
+                                          th:method="DELETE">
+                                        <button type="submit"
+                                                class="btn btn-sm btn-danger delete-product">
+                                            <i class="fas fa-trash-alt"></i> Delete
+                                        </button>
+                                    </form>
+                                </th:block>
+                            </td>
+                            <td>
+                                <th:block sec:authorize="hasRole('ROLE_ADMIN')">
+                                    <a th:href="@{'/products/edit-form/{id}' (id=${bilet.bId})}"
+                                       class="btn btn-sm btn-info edit-product">
+                                        <i class="fas fa-edit"></i> Edit
+                                    </a>
+                                </th:block>
+                            </td>
+                            <td>
+                                <form th:action="@{'/shopping-cart/add-product/{id}' (id=${bilet.bId})}"
+                                      th:method="POST">
+                                    <button type="submit" class="btn btn-sm btn-success add-to-cart">
+                                        <i class="fas fa-shopping-cart"></i> Add to cart
+                                    </button>
+                                </form>
+                            </td>
+                        </tr>
+                        </tbody>
+                    </table>
+                </div>
+            </div>
+            <div class="col mb-3">
+                <div class="row">
+                    <div class="col-sm-12 col-md-12">
+                        <a href="/bilet/kupi" class="btn btn-block btn-dark add-product-btn">
+                            Kupi bilet
+                        </a>
+                    </div>
+                </div>
+            </div>
+        </div>
+    </div>
+</div>
+
+
Index: src/main/resources/templates/login.html
===================================================================
--- src/main/resources/templates/login.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
+++ src/main/resources/templates/login.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
@@ -0,0 +1,27 @@
+<div class="container" xmlns:th="http://www.thymeleaf.org">
+    <form class="form-signin mt-xl-5" method="post" action="/login">
+        <h2 class="form-signin-heading">Sign in</h2>
+        <p>
+            <label for="username" class="sr-only">Username</label>
+            <input type="text" id="username" name="username" class="form-control" placeholder="Username" required=""
+                   autofocus="">
+        </p>
+        <p>
+            <label for="password" class="sr-only">Password</label>
+            <input type="password" id="password" name="password" class="form-control" placeholder="Password"
+                   required="">
+        </p>
+
+        <div th:if="${param.error}" th:text="${param.error}" class="text-danger"></div>
+
+        <div class="row">
+            <div class="col-md-3">
+                <button id="submit" class="btn btn-lg btn-primary btn-block" type="submit">Sign in</button>
+            </div>
+            <div class="col-md-3">
+                <a href="/register" class="btn btn-lg btn-block btn-light">Register here</a>
+            </div>
+        </div>
+    </form>
+</div>
+
Index: src/main/resources/templates/master-template.html
===================================================================
--- src/main/resources/templates/master-template.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
+++ src/main/resources/templates/master-template.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
@@ -0,0 +1,28 @@
+<!DOCTYPE html>
+<html lang="en" xmlns="http://www.w3.org/1999/xhtml" xmlns:th="http://www.thymeleaf.org">
+<head>
+    <meta charset="UTF-8"/>
+    <title>Products</title>
+    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"
+          integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
+    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
+            integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo"
+            crossorigin="anonymous"></script>
+    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"
+            integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1"
+            crossorigin="anonymous"></script>
+    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"
+            integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM"
+            crossorigin="anonymous"></script>
+    <script src="https://kit.fontawesome.com/e59232f0a1.js" crossorigin="anonymous"></script>
+</head>
+<body>
+<header th:replace="fragments/header"/>
+
+<section th:include="${bodyContent}">
+
+</section>
+<footer th:replace="fragments/footer"/>
+</body>
+</html>
+
Index: src/main/resources/templates/register.html
===================================================================
--- src/main/resources/templates/register.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
+++ src/main/resources/templates/register.html	(revision b101b69e1e4156497c29fa60f501b18007efeab7)
@@ -0,0 +1,48 @@
+<div xmlns:th="http://www.thymeleaf.org">
+  <section class="jumbotron text-center">
+    <div class="container">
+      <h1 class="jumbotron-heading">WEB PROGRAMMING SHOP</h1>
+      <h3 class="jumbotron-heading">All products</h3>
+    </div>
+  </section>
+
+  <div class="container mb-4">
+    <form class="form-signin mt-xl-5" method="post" action="/register">
+      <h2 class="form-signin-heading">Register</h2>
+      <p>
+        <label for="username" class="sr-only">Email</label>
+        <input type="text" id="username" name="email" class="form-control" placeholder="Email" required="" autofocus="">
+      </p>
+      <p>
+        <label for="password" class="sr-only">Password</label>
+        <input type="password" id="password" name="password" class="form-control" placeholder="Password" required="">
+      </p>
+      <p>
+        <label for="repeatedPassword" class="sr-only">Repeat Password</label>
+        <input type="password" id="repeatedPassword" name="confirmPassword" class="form-control" placeholder="Repeat Password" required="">
+      </p>
+      <p>
+        <label for="name" class="sr-only">Name</label>
+        <input type="text" id="name" name="name" class="form-control" placeholder="Name" required="" autofocus="">
+      </p>
+      <p>
+        <label for="surname" class="sr-only">Address</label>
+        <input type="text" id="surname" name="address" class="form-control" placeholder="Address" required="" autofocus="">
+      </p>
+      <p>
+        <label for="phone" class="sr-only">Phone</label>
+        <input type="text" id="phone" name="phone" class="form-control" placeholder="Phone" required="" autofocus="">
+      </p>
+
+
+
+      <th:block th:if="${hasError}">
+        <div th:text="${error}" class="text-danger"></div>
+      </th:block>
+
+      <button class="btn btn-lg btn-primary btn-block" type="submit">Sign up</button>
+    </form>
+    <a href="/login" class="btn btn-block btn-light">Already have an account? Login here!</a>
+  </div>
+
+</div>
