C# Asp.NET 生成GOOGLE地图和索引

来源：互联网发布：vue.js视频百度云编辑：程序博客网时间：2024/05/18 03:30

（1）首先要对内容的特殊字符进行过虑： C# 代码： public string res(string partno) { partno = partno.Replace("&", ""); partno = partno.Replace("/", ""); partno = partno.Replace("&", ""); return partno; }（2）从数据库中获得要生成地图的内容： C# 代码： public void getXMLSitemapData(StreamWriter writerFile,int minid,int maxid) { SqlConnection mycon = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); string sqlstr = "Select id,name from table where id>'" + minid + "' and id <'" + maxid + "'";//数据库内容语句 SqlCommand cmd = new SqlCommand(sqlstr, mycon); mycon.Open(); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { writerFile.WriteLine("<url>"); writerFile.WriteLine("<loc>" + "http://www.uni888.com/" + res(rdr[1].ToString())+".html" + "</loc>"); writerFile.WriteLine("<lastmod>" +"2009-04-22"+ "</lastmod>"); writerFile.WriteLine("<changefreq>weekly</changefreq>"); writerFile.WriteLine("<priority>1.0</priority>"); writerFile.WriteLine("</url>"); } } rdr.Close(); mycon.Close(); }(3)创建并写入sitemaps.xml GOOGLE地图 C# 代码： public void createXMLSitemap(int minid,int maxid,int maps) { FileInfo XMLFile = null; StreamWriter WriteXMLFile = null; string FilePath = HttpContext.Current.Server.MapPath("sitemap"+maps+".xml"); XMLFile = new FileInfo(FilePath); WriteXMLFile = XMLFile.CreateText(); //下面两句话必须写，而且不能做任何修改 WriteXMLFile.WriteLine("<?xml version=/"1.0/" encoding=/"UTF-8/"?>"); WriteXMLFile.WriteLine("<urlset xmlns=/"http://www.google.com/schemas/sitemap/0.84/">"); getXMLSitemapData(WriteXMLFile,minid ,maxid ); WriteXMLFile.WriteLine("</urlset>");// WriteXMLFile.Close(); }