Visualizza

                Never    
Java
        
Download Raw Clone Report Copy 
<%-- 
    Document   : index
    Created on : 10-mag-2019, 11.37.53
    Author     : daniele.giongo
--%>

<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Visualizza</title>
        <link type="text/css" rel="stylesheet" href="../css/style.css">
    </head>
    <body>
        <div class="topnav">
            <a href="../index.jsp">Home</a>		
            <a class='active'  href="#">Visualizza Libri</a>
            <a href="pannello.jsp">Pannello di Controllo</a>
            <a href="modificaElimina.jsp">Modifica/Elimina</a>
        </div> 
        <div class="container">		
            <h2 style="text-align: center">Visualizzazione Libri</h2>
            <%
                String url="jdbc:mysql://localhost:3306/verifica";
                String DRIVER="com.mysql.jdbc.Driver";
                String USER="root";
                String PSW="";

                Connection conn = null;
                Class.forName(DRIVER);
                ResultSet res;
                String query="SELECT * FROM libro INNER JOIN autore ON libro.id_autore=autore.id_autore";
                conn=DriverManager.getConnection(url, USER, PSW);
                Statement stat=conn.createStatement();
                res=stat.executeQuery(query);
                while(res.next()){
                    out.println("<p>"+res.getString("titolo")+"</p>");
                    out.println("<p>"+res.getString("nome")+" "+res.getString("cognome")+"</p>");
                    out.println("<p>"+res.getString("lingua")+"</p><hr>");
                }
                conn.close();
            %> 	
        </div>			
    </body>
</html>

Raw Text

Recent Public Pastes