public long inserir(Pesquisador pesquisador) throws Exception
	{
		String sql = "INSERT INTO pesquisador(nome,nome_cientifico,email,sexo,classe,titulacao,curso_vinculado,areaformacao, curriculo_lattes) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)";
		long idGerado = 0;
		
		try
		{
			PreparedStatement stmt = ConnectionFactory.getConnection().prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
			stmt.setString(1, pesquisador.getNome());
			stmt.setString(2, pesquisador.getNome_cientifico());
			stmt.setString(3, pesquisador.getEmail());
			stmt.setString(4, pesquisador.getSexo());
			stmt.setString(5, pesquisador.getClasse());
			stmt.setString(6, pesquisador.getTitulacao());
			stmt.setLong(7, pesquisador.getCursoVinculado().getId());
			stmt.setLong(8, pesquisador.getAreaformacao().getId());
			stmt.setString(9, pesquisador.getCurriculoLattes());
			stmt.executeUpdate();
				
			ResultSet rs = stmt.getGeneratedKeys();
			
			if (rs.next())
			{
				idGerado = rs.getLong(1);
			}
		}
		catch (SQLException e)
		{
			throw e;
		}
		
		return idGerado;
	}