index.jsp<\/p>\n
<%@page contentType=\"text\/html\" pageEncoding=\"UTF-8\"%>\r\n<!DOCTYPE html>\r\n<html>\r\n <head>\r\n <meta http-equiv=\"Content-Type\" content=\"text\/html; charset=UTF-8\">\r\n <title>Fiat Chrysler Automobiles<\/title>\r\n <\/head>\r\n <body>\r\n <h1>Fiat Chrysler Automobiles<\/h1>\r\n <form action=\"grafico\" method=\"get\">\r\n Inserisci le quotazioni in borsa della settimana:\r\n <table cellpadding=\"2\" cellspacing=\"0\" border=\"0\">\r\n <% String[] giorni = {\"Luned\u00ec\", \"Marted\u00ec\", \"Mercoled\u00ec\", \"Gioved\u00ec\", \"Venerd\u00ec\"};\r\n for (int i = 0; i < 5; i++) {\r\n %><tr><td><%=giorni[i]%><\/td><td><input name=\"g\" type=\"text\" \/><\/td><\/tr>\r\n <%\r\n }\r\n %><\/table><input type=\"submit\" value=\"Invia\" \/>\r\n <\/form>\r\n <\/body>\r\n<\/html>\r\n<\/pre>\nservlet: grafico<\/p>\n
String[] giorni = {\"Luned\u00ec\", \"Marted\u00ec\", \"Mercoled\u00ec\", \"Gioved\u00ec\", \"Venerd\u00ec\"};\r\n response.setContentType(\"image\/png\");\r\n try (OutputStream os = response.getOutputStream()) {\r\n \/\/ legge i parametri\r\n String[] v = request.getParameterValues(\"g\");\r\n \/\/ crea l'immagine\r\n BufferedImage img = new BufferedImage(600, 200, BufferedImage.TYPE_INT_RGB);\r\n Graphics g = img.createGraphics();\r\n \/\/ cancella lo sfondo\r\n g.setColor(Color.WHITE);\r\n g.fillRect(0, 0, img.getWidth(), img.getHeight());\r\n \/\/ inserice il titolo\r\n g.setColor(Color.BLACK);\r\n g.drawString(\"Fiat Chrysler Automobiles - quotazioni in borsa della settimana\", 20, 20);\r\n \/\/ disegna l'istogramma\r\n for (int i = 0; i < 5; i++) {\r\n int val = Integer.parseInt(v[i]);\r\n g.setColor(Color.ORANGE);\r\n g.fill3DRect(20 + i * 80, 180 - val, 50, val, true);\r\n g.setColor(Color.BLACK);\r\n g.drawString(\" \" + giorni[i], 20 + i * 80, 200);\r\n g.drawString(\" \" + val + \" punti\", 20 + i * 80, 170 - val);\r\n }\r\n \/\/ invia l'immagine in output\r\n ImageIO.write(img, \"png\", os);\r\n }\r\n<\/pre>\nesercizio sql<\/p>\n
CREATE TABLE clienti (IdCliente int NOT NULL PRIMARY KEY AUTO_INCREMENT, Cognome varchar[50], Nome varchar[50], Sesso char[1], LuogoNascita varchar[30], DataNascita date, Nazionalit\u00e0 char[2], CodiceFiscale char[16]);\r\nINSERT INTO clienti (Cognome, Nome, Sesso, LuogoNascita, DataNascita, Nazionalit\u00e0, CodiceFiscale VALUES (\"Cognome\", \"Nome\", \"M\", \"Citt\u00e0\", \"2000-01-01\", \"IT\", \"AAABBB01A00A000A\");\r\nSELECT * FROM clienti WHERE Sesso=\"F\";\r\nSELECT * FROM clienti WHERE DataNascita BETWEEN \"1990-00-00\" AND \"1990-12-31\";\r\nSELECT * FROM clienti WHERE Nazionalit\u00e0=\"IT\";\r\nUPDATE clienti SET Sesso=\"F\" WHERE IdCliente=384;\r\nDELETE FROM clienti WHERE Nazionalit\u00e0=\"EN\";\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"index.jsp <%@page contentType=”text\/html” pageEncoding=”UTF-8″%> <!DOCTYPE html> <html> <head> <meta http-equiv=”Content-Type” content=”text\/html; charset=UTF-8″> <title>Fiat Chrysler Automobiles<\/title> <\/head> <body> <h1>Fiat Chrysler Automobiles<\/h1> <form action=”grafico” method=”get”> Inserisci le quotazioni in borsa della settimana: <table cellpadding=”2″ cellspacing=”0″ border=”0″> <% String[] giorni = {“Luned\u00ec”, “Marted\u00ec”, “Mercoled\u00ec”, “Gioved\u00ec”, “Venerd\u00ec”}; for (int i = 0; i < 5; i++) { %><tr><td><%=giorni[i]%><\/td><td><input name=”g” … Continua a leggere Correzione della verifica di laboratorio di Informatica<\/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-1584","post","type-post","status-publish","format-standard","hentry","category-informatica"],"_links":{"self":[{"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/posts\/1584","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=1584"}],"version-history":[{"count":0,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/posts\/1584\/revisions"}],"wp:attachment":[{"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/media?parent=1584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/categories?post=1584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/tags?post=1584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}