lucene.net创建海量索引问题

qq632323051 2016-05-17 10:43:04

各位大神，萌新现在有个问题不知道怎么解决，
比如说我有十张表，每个表里都有大量的数据，我怎么能将所有数据的每个字段都创建索引呢，如果说手动加的话，那岂不是非常麻烦？还有就是我怎么将这个数据库中所有表的所有数据全部抛给lucene来用于检索呢？急急急，跪求各位大神解决

目前我市这么处理的：





  public string CreatLC()

        {

            try

            {

                string sql = "SELECT * FROM Product";

                List<Product> a = new List<Product>();

                CreatLucene<Product>.PrepareIndex(new PanGuAnalyzer(), true, Config.INDEX_Product, a, sql);



                return "成功";

            }

            catch (Exception)

            {



                return "失败";

            }



        }



 public static void PrepareIndex(Analyzer analyzer, bool b, string path, List<T> list, string sql)

        {

            //根据地址创建目录

            DirectoryInfo dirInfo = Directory.CreateDirectory(path);

            //FSDirectory:指定索引库文件存放位置，是Diectory的子类

            //将索引文件存放在创建的目录dirInfo中

            LuceneIO.Directory directory = LuceneIO.FSDirectory.Open(dirInfo);

            //IndexWriter:对索引文件进行写的类

            IndexWriter writer = new IndexWriter(directory, analyzer, b, IndexWriter.MaxFieldLength.LIMITED);

            DBHelper db = DBHelper.GetInstance();



            list = db.Fetch<T>(sql);

            Type type = typeof(T);

            PropertyInfo[] ps = type.GetProperties();

            foreach (var item in list)

            {



                

                CreateIndex(writer, item);

                

            }



          

            writer.Optimize();

            writer.Close();

        }



 /// <summary>

        /// 创建索引

        /// </summary>

        /// <param name="analyzer"></param>

        /// <param name="title"></param>

        /// <param name="content"></param>

        private static void CreateIndex(IndexWriter writer, T entity)

        {

            try

            {

                Document doc = new Document();

               

                Type type = typeof(T);

                PropertyInfo[] ps = type.GetProperties();

                foreach (PropertyInfo p in ps)

                {

                    object value = p.GetValue(entity, null);

                    if (value != null)

                    {



                        //if (p.Name == "pinyin")

                        //{

                        //    doc.Add(new Field(p.Name, value.ToString(), Field.Store.YES, Field.Index.ANALYZED));//存储且索引

                        //}

                        //else

                        //{

                        doc.Add(new Field(p.Name, value.ToString(), Field.Store.YES, Field.Index.ANALYZED));//存储且索引

                        //}

                    }

                }

                writer.AddDocument(doc);

            }

            catch (FileNotFoundException fnfe)

            {

                throw fnfe;

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }