BIBBIA

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnessioneDatabase {


	private static Connection conn = null;

	public static synchronized Connection getConnessione() throws ClassNotFoundException {

		try {
		    Class.forName("com.mysql.cj.jdbc.Driver");
		    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/provadatabase","root","");
		} catch (SQLException e) {
		    throw new RuntimeException(e);
		}
		return conn;


}
}


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;





public class Inserimento {

public int inserisciPersona (Utente p) throws ClassNotFoundException {

	String sql = "INSERT INTO utenti (Nome, COGNOME, Eta, Genere) VALUES (?, ?, ?, ?)";
	Connection conn = ConnessioneDatabase.getConnessione();
	int resultSet=0;
	try
	{
		PreparedStatement ps = conn.prepareStatement(sql);
		ps.setString(1,p.getNome());
		ps.setString(2, p.getCognome());
		ps.setInt(3, p.getEta());
		ps.setString(4, p.getGenere());
		resultSet = ps.executeUpdate();
		ps.close();

		System.out.println("Persona aggiunta");
	}
	catch (SQLException e)
	{
		System.out.println("Eccezione SQL");
	}
	return resultSet;




		Inserimento c = new Inserimento();

		Utente p = new Utente();

		response.setContentType("text/html;charset=UTF-8");
		try (PrintWriter out = response.getWriter()) {
			out.println("<h1> Inserimento dati! </h1>");

			String nome = request.getParameter("nome");
			p.setNome(nome);
			String cognome = request.getParameter("cognome");
			p.setCognome(cognome);
			int eta = Integer.parseInt(request.getParameter("eta"));
			p.setEta(eta);
			String Genere = request.getParameter("genere");
			p.setGenere(Genere);
			try {
				c.inserisciPersona(p);
			} catch (ClassNotFoundException e) {
				System.out.println("ERRORE");
			}




			}
	}