In order to alleviate the problem of knowledge dispersion and information fragmentation in the tourism domain, an entity relation extraction model ChatGLM-ppt (ChatGLM with prompt and p-tuning) based on ChatGLM (chat generative language model) and prompt fine-tuning was proposed. The model accomplished the entity and relation extraction task in the form of dialog with the help of ChatGLM, and coped with the problems of error propagation, entity redundancy and relationship overlapping in entity and relation extraction by means of P-Tuning v2 fine-tuning and adding prompt templates. The experiments were built on the self-constructed tourism domain dataset, and the results show that the F₁ of the ChatGLM-ppt model is 92.19% in the entity and relation extraction problem in the tourism domain, and the F₁ are all greater than 90% in dealing with overlapping relationships, which is better than that of the current mainstream entity and relation extraction models, proving that the model can effectively improve the accuracy of entity and relation extraction. Further use of Neo4j graph database to construct tourism knowledge graph and integrate dispersed tourism information resources has certain reference significance for promoting the digital transformation and intelligent development of tourism.