public void atualizar(Pesquisador pesquisador) throws Exception
	{
		String sql = "UPDATE pesquisador SET  nome=?, nome_cientifico=?, email=?, sexo=?, classe=?, titulacao=?, curso_vinculado=?, areaformacao=?, curriculo_lattes=? WHERE id=?";

		try
		{
			PreparedStatement stmt = ConnectionFactory.getConnection().prepareStatement(sql);
			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.setLong(10, pesquisador.getId());
			stmt.executeUpdate(sql.toString());
		}
		catch (SQLException e)
		{
			throw e;
		}
	}