{"id":1579,"date":"2016-04-10T22:15:20","date_gmt":"2016-04-10T20:15:20","guid":{"rendered":"http:\/\/liceocuneo.it\/oddenino\/?p=1579"},"modified":"2016-04-11T11:44:09","modified_gmt":"2016-04-11T09:44:09","slug":"esempio-di-servlet-con-una-query-su-un-database","status":"publish","type":"post","link":"https:\/\/liceocuneo.it\/oddenino\/esempio-di-servlet-con-una-query-su-un-database\/","title":{"rendered":"Esempio di servlet con una query su un database"},"content":{"rendered":"
import java.io.IOException;\r\nimport java.io.PrintWriter;\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\nimport java.sql.Statement;\r\nimport javax.servlet.ServletException;\r\nimport javax.servlet.http.HttpServlet;\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\n<\/pre>\n
response.setContentType(\"<\/span>text\/html;charset=UTF-8<\/span>\"<\/span>);\r\nPrintWriter out = response.getWriter();\r\nout.println(\"<\/span><!DOCTYPE html><\/span>\"<\/span>);\r\nout.println(\"<\/span><html><\/span>\"<\/span>);\r\nout.println(\"<\/span><head><\/span>\"<\/span>);\r\nout.println(\"<\/span><title>My CD - Elenco<\/title><\/span>\"<\/span>);\r\nout.println(\"<\/span><\/head><\/span>\"<\/span>);\r\nout.println(\"<\/span><body><\/span>\"<\/span>);\r\nout.println(\"<\/span><h1>My CD - Elenco<\/h1><\/span>\"<\/span>);\r\n\r\ntry<\/span> {\r\n    Class.forName<\/span>(\"<\/span>com.mysql.jdbc.Driver<\/span>\"<\/span>).newInstance();\r\n    Connection conn = DriverManager.getConnection<\/span>(\"<\/span>jdbc:mysql:\/\/urlhost\/nomedb<\/span>\"<\/span>, \"utente<\/span>\"<\/span>, \"password\"<\/span>);\r\n    Statement stat = conn.createStatement();\r\n    ResultSet rs = stat.executeQuery(\"<\/span>SELECT * FROM cd<\/span>\"<\/span>);\r\n    while<\/span> (rs.next()) {\r\n        if<\/span> (rs.isFirst()) {\r\n            out.println(\"<\/span><table border=<\/span>\\\"<\/span>1<\/span>\\\"<\/span> cellpadding=<\/span>\\\"<\/span>2<\/span>\\\"<\/span> cellspacing=<\/span>\\\"<\/span>0<\/span>\\\"<\/span>><\/span>\"<\/span>);\r\n            out.println(\"<\/span><caption>Tabella dei miei CD musicali<\/caption><\/span>\"<\/span>);\r\n            out.println(\"<\/span><thead><\/span>\"<\/span>);\r\n            out.println(\"<\/span><tr><th>Id<\/th><th>Titolo<\/th><th>Interprete<\/th><th>Anno<\/th><\/tr><\/span>\"<\/span>);\r\n            out.println(\"<\/span><\/thead><\/span>\"<\/span>);\r\n            out.println(\"<\/span><tbody><\/span>\"<\/span>);\r\n        }\r\n        out.print(\"<\/span><tr><\/span>\"<\/span>);\r\n        out.print(\"<\/span><td><\/span>\"<\/span> + rs.getInt(\"<\/span>id<\/span>\"<\/span>) + \"<\/span><\/td><\/span>\"<\/span>);\r\n        out.print(\"<\/span><td><\/span>\"<\/span> + rs.getString(\"<\/span>titolo<\/span>\"<\/span>) + \"<\/span><\/td><\/span>\"<\/span>);\r\n        out.print(\"<\/span><td><\/span>\"<\/span> + rs.getString(\"autore<\/span>\"<\/span>) + \"<\/span><\/td><\/span>\"<\/span>);\r\n        out.print(\"<\/span><td><\/span>\"<\/span> + rs.getString(\"anno<\/span>\"<\/span>) + \"<\/span><\/td><\/span>\"<\/span>);\r\n        out.println(\"<\/span><\/tr><\/span>\"<\/span>);\r\n        if<\/span> (rs.isLast()) {\r\n            out.println(\"<\/span><\/tbody><\/span>\"<\/span>);\r\n            out.println(\"<\/span><\/table><\/span>\"<\/span>);\r\n        }\r\n    }\r\n    conn.close();\r\n} catch<\/span> (InstantiationException | IllegalAccessException | ClassNotFoundException | SQLException ex) {\r\n    out.println(\"<\/span><p><\/span>\"<\/span> + ex.toString() + \"<\/span><br\/><\/span>\"<\/span> + ex.getMessage() + \"<\/span><\/p><\/span>\"<\/span>);\r\n}\r\n\r\nout.println(\"<\/span><\/body><\/span>\"<\/span>);\r\nout.println(\"<\/span><\/html><\/span>\"<\/span>);<\/pre>\n","protected":false},"excerpt":{"rendered":"
import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; response.setContentType(“text\/html;charset=UTF-8”); PrintWriter out = response.getWriter(); out.println(“<!DOCTYPE html>”); out.println(“<html>”); out.println(“<head>”); out.println(“<title>My CD – Elenco<\/title>”); out.println(“<\/head>”); out.println(“<body>”); out.println(“<h1>My CD – Elenco<\/h1>”); try { Class.forName(“com.mysql.jdbc.Driver”).newInstance(); Connection conn = DriverManager.getConnection(“jdbc:mysql:\/\/urlhost\/nomedb”, “utente”, “password”); Statement stat = conn.createStatement(); ResultSet … Continua a leggere Esempio di servlet con una query su un database<\/span><\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-1579","post","type-post","status-publish","format-standard","hentry","category-informatica"],"_links":{"self":[{"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/posts\/1579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/comments?post=1579"}],"version-history":[{"count":0,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/posts\/1579\/revisions"}],"wp:attachment":[{"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/media?parent=1579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/categories?post=1579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/tags?post=1579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}