Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
- pageEncoding="ISO-8859-1"%>
- <!DOCTYPE html>
- <html>
- <head>
- <link href="http://fonts.googleapis.com/icon?family=Material+Icons"
- rel="stylesheet">
- <!--Import Google Icon Font-->
- <link type="text/css" rel="stylesheet" href="css/materialize.min.css"
- media="screen,projection" />
- <!--Import materialize.css-->
- <meta name="viewport" content="width=device-width, initial-scale=1.0" />
- <!--Let browser know website is optimized for mobile-->
- <script type="text/javascript" src="jquery-2.1.1.min.js"></script>
- <style>
- header, main, footer {
- padding-left: 240px;
- }
- @media only screen and (max-width : 992px) {
- header, main, footer {
- padding-left: 0;
- }
- }
- </style>
- <%@ page import="java.sql.*"%>
- <%@ page import="javax.servlet.*"%>
- <%@ page import="java.io.IOException"%>
- <%@ page import="javax.servlet.http.Part"%>
- <%@ page import="java.io.InputStream"%>
- <%@ page import="javax.servlet.http.HttpSession"%>
- <%@ page import="java.sql.Blob"%>
- <script>
- $(document).ready(function(){
- <%Connection con = null;
- PreparedStatement statement = null;
- ResultSet result = null;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- con = DriverManager.getConnection("jdbc:mysql://localhost:3306/DBDAVIDPAOLO", "root", "root");
- } catch (Exception e) {
- System.out.println(e);
- System.exit(0);
- }
- try {
- HttpSession sessione = request.getSession();
- String utenteconnesso = (String) sessione.getAttribute("utente");
- PreparedStatement pstmt = con.prepareStatement("select * from Guide where MailUtente = ? ");
- pstmt.setString(1, utenteconnesso); //qui dovrebbe fare il matching fra l'utente attivo nella sessione e MaiUtente
- result = pstmt.executeQuery();
- while (result.next()) {
- String titologuida = result.getString("Titolo");
- String contenutoguida = result.getString("Testoguida");%>
- var titolo = "<%=titologuida%>";
- var guida = "<%=contenutoguida%>
- ";
- var bottone = '<ul class="collapsible" data-collapsible="accordion"><li><div class="collapsible-header"><i class="material-icons">filter_drama</i>'
- + titolo
- + ' </div><div class="collapsible-body"><p>'
- + guida + '</p></div></li></ul>';
- document.getElementById("angelo") = bottone;
- //document.write("<p>Stampa qui: " + bottone + "</p>");
- <%}
- result.close();
- con.close();
- pstmt.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- System.out.println("Errore nell'inserimento dati");
- }%>
- });
- </script>
- </head>
- <body>
- <!-- BARRA DI NAVIGAZIONE -->
- <ul id="dropdown1" class="dropdown-content">
- <li><a href="#!">Cucina</a></li>
- <li><a href="#!">Tecnologia</a></li>
- <li class="divider"></li>
- <li><a href="#!">Videogames</a></li>
- </ul>
- <nav>
- <div class="nav-wrapper">
- <a href="#!" class="brand-logo">Logo</a>
- <ul class="right hide-on-med-and-down">
- <li><a href="sass.html">Chi siamo</a></li>
- <li><a href="badges.html">Contatti</a></li>
- <!-- Dropdown Trigger -->
- <li><a class="dropdown-button" href="#!"
- data-activates="dropdown1">Categorie<i
- class="material-icons right">arrow_drop_down</i></a></li>
- </ul>
- </div>
- </nav>
- <div></div>
- <!-- FINE BARRA DI NAVIGAZIONE -->
- <!-- MENU' LATERALE -->
- <ul id="slide-out" class="side-nav fixed">
- <ul class="navigation">
- <!--Primary Navigation - Too much effort to use WordPress menu system-->
- <li class="user-details cyan darken-2">
- <div class="row">
- <div class="col col s8 m6 l8">
- <br></br> <img src=<%=session.getAttribute("Immagine")%> alt=""
- class="circle responsive-img valign profile-image">
- </div>
- <div class="col col s8 m8 l8">
- <a
- class="btn-flat dropdown-button waves-effect waves-light white-text profile-btn"
- href="#" data-activates="profile-dropdown"><%=session.getAttribute("utente")%><i
- class="mdi-navigation-arrow-drop-down right"></i></a>
- <p class="user-roal"></p>
- </div>
- </div>
- </li>
- <li class=""><a href="http://phandroid.com/news/"> <i
- class="material-icons">person_pin</i><span>   Profilo</span>
- </a></li>
- <li class=""><a href="http://phandroid.com/reviews/"> <i
- class="material-icons">stars</i><span>   Le tue guide</span>
- </a></li>
- <li class=""><a href="http://phandroid.com/phones/"> <i
- class="material-icons">phone_android</i><span>   Phones</span>
- </a></li>
- <li class=""><a href="http://phandroid.com/tablets/"> <i
- class="material-icons">tablet</i><span>   Tablets</span>
- </a></li>
- </ul>
- </ul>
- <a href="#" data-activates="slide-out" class="button-collapse"><i
- class="mdi-navigation-menu"></i></a>
- <!-- FINE MENU' LATERALE -->
- <!-- SEZIONE CENTRALE -->
- <div id="accordion" class="section scrollspy">
- <div class="row">
- <div class="col s12 m3">
- <h5 class="light">Accordion</h5>
- </div>
- <div id="angelo" class="col s12 m9">
- <ul class="collapsible" data-collapsible="accordion">
- <li>
- <div class="collapsible-header">
- <i class="material-icons">filter_drama</i>First
- </div>
- <div class="collapsible-body">
- <p>Lorem ipsum dolor sit amet.</p>
- </div>
- </li>
- </ul>
- </div>
- </div>
- </div>
- <br></br>
- <!-- FINE SEZIONE CENTRALE -->
- <!-- BOTTONE AGGIUNGI NOTA -->
- <br></br>
- <br></br>
- <div class="fixed-action-btn" style="bottom: 45px; right: 24px;">
- <a class="btn-floating btn-large red"> <i
- class="large material-icons">mode_edit</i>
- </a>
- <ul>
- <li><a class="btn-floating red"><i class="material-icons">insert_chart</i></a></li>
- <li><a class="btn-floating yellow darken-1"><i
- class="material-icons">format_quote</i></a></li>
- <li><a class="btn-floating green"><i class="material-icons">publish</i></a></li>
- <li><a class="btn-floating blue"><i class="material-icons">attach_file</i></a></li>
- </ul>
- </div>
- <br></br>
- <br></br>
- <!-- FINE BOTTONE AGGIUNGI NOTA -->
- <!-- FOOTER -->
- <footer class="page-footer">
- <div class="container">
- <div class="row">
- <div class="col l6 s12">
- <h5 class="white-text">Footer Content</h5>
- <p class="grey-text text-lighten-4">You can use rows and
- columns here to organize your footer content.</p>
- </div>
- <div class="col l4 offset-l2 s12">
- <h5 class="white-text">Links</h5>
- <ul>
- <li><a class="grey-text text-lighten-3" href="#!">Link 1</a></li>
- <li><a class="grey-text text-lighten-3" href="#!">Link 2</a></li>
- <li><a class="grey-text text-lighten-3" href="#!">Link 3</a></li>
- <li><a class="grey-text text-lighten-3" href="#!">Link 4</a></li>
- </ul>
- </div>
- </div>
- </div>
- <div class="footer-copyright">
- <div class="container">
- © 2014 Copyright Text <a class="grey-text text-lighten-4 right"
- href="#!">More Links</a>
- </div>
- </div>
- </footer>
- <!-- FINE FOOTER -->
- <script type="text/javascript"
- src="https://code.jquery.com/jquery-2.1.1.min.js"></script>
- <script type="text/javascript" src="js/materialize.min.js"></script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement