DAO

package it.elencohtml.utils;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class Dao {
	private Statement stm = null;

	public Dao(Connection con) throws Exception {
		stm = con.createStatement();
	}
	public ArrayList<Persona> findPersona(String cognome, String nome) throws SQLException {

        String query = "select nome, cognome, citta, data_di_nascita, nazionalita, residenza, citta_residenza, email, telefono from dynamicUtenti";
		ArrayList<Persona> persone = new ArrayList<>();
		ResultSet rs = stm.executeQuery(query);
		try {
			while (rs.next()) {
				Persona pers1 =  new Persona(rs.getString(1), rs.getString(2), rs.getString(3), rs.getDate(4), rs.getString(5), rs.getString(6), rs.getString(7), rs.getString(8), rs.getInt(9));
				persone.add(pers1);
			}
		} finally {
			if (rs != null) {
				rs.close();
			}
		}
		return persone;
	}
}