Tabella: Classe5E<\/p>\n
index.html<\/strong><\/p>\n crea.jsp<\/strong><\/p>\n Progetto NetBeans completo: Anagrafe5E.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" Tabella: Classe5E index.html Crea la tabella Cancella la tabella Inserisci un nominativo Cancella un nominativo Visualizza tutti i nominativi crea.jsp <%@page import=”java.sql.DriverManager”%> <%@page import=”java.sql.Connection”%> <%@page import=”java.sql.Statement”%> <%@page import=”java.sql.ResultSet”%> <%@page import=”java.sql.SQLException”%> <%@page contentType=”text\/html” pageEncoding=”UTF-8″%> <!DOCTYPE html> <html> <head> <meta http-equiv=”Content-Type” content=”text\/html; charset=UTF-8″> <title>Classe 5\u00aa E<\/title> <\/head> <body> <h1>Classe 5\u00aa E – Creazione tabella<\/h1> <% try { … Continua a leggere Prototipo di pagina JSP per l’accesso ad un DB<\/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-4110","post","type-post","status-publish","format-standard","hentry","category-informatica"],"_links":{"self":[{"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/posts\/4110","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=4110"}],"version-history":[{"count":0,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/posts\/4110\/revisions"}],"wp:attachment":[{"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/media?parent=4110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/categories?post=4110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/liceocuneo.it\/oddenino\/wp-json\/wp\/v2\/tags?post=4110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
<%@page import=\"java.sql.DriverManager\"%>\r\n<%@page import=\"java.sql.Connection\"%>\r\n<%@page import=\"java.sql.Statement\"%>\r\n<%@page import=\"java.sql.ResultSet\"%>\r\n<%@page import=\"java.sql.SQLException\"%>\r\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>Classe 5\u00aa E<\/title>\r\n<\/head>\r\n<body>\r\n <h1>Classe 5\u00aa E - Creazione tabella<\/h1>\r\n <%\r\n try {\r\n Class.forName(\"com.mysql.jdbc.Driver\").newInstance();\r\n Connection conn = DriverManager.getConnection(\"jdbc:mysql:\/\/didattica1.liceocuneo.it\/db1\", \"studente1\", \"topolino13\");\r\n Statement stat = conn.createStatement();\r\n stat.executeUpdate(\"CREATE TABLE Classe5E (ID_Studente INT NOT NULL AUTO_INCREMENT, Cognome VARCHAR(45) NOT NULL, Nome VARCHAR(45) NOT NULL, LuogoNascita VARCHAR(45) NOT NULL, DataNascita DATE NOT NULL, PRIMARY KEY (ID_Studente))\");\r\n stat.close();\r\n conn.close();\r\n %>\r\n <p>Tabella \"Classe5E\" creata correttamente.<\/p>\r\n <%\r\n } catch (InstantiationException | IllegalAccessException | ClassNotFoundException | SQLException ex) {\r\n %>\r\n <p><%=ex.toString()%><br\/><%=ex.getMessage()%><\/p>\r\n <%\r\n } \/\/ endcatch\r\n %>\r\n<\/body>\r\n<\/html><\/pre>\n