mlzboy 发表于 2013-1-13 00:55:14

[已解决]请教sqlite在dotnet中如何使用正则表达式

查看了sqlite的文档,它提供了regexp(a,b) match(a,b)函数,但未实现,如何在.net中应用,搜索了半天,没找到相关的资料,不知道园子时原朋友做过相关的事情,提点一下,困了一天了

几经波折,总算是解决了,呵呵,如下:
这可是我不传人的秘技哦,

<div style="border-right: #cccccc 1px solid; padding-right: 5px; border-top: #cccccc 1px solid; padding-left: 4px; font-size: 13px; padding-bottom: 4px; border-left: #cccccc 1px solid; width: 98%; padding-top: 4px; border-bottom: #cccccc 1px solid; background-color: #eeeeee;"> 1http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System;
 2http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Collections.Generic;
 3http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Text;
 4http://www.cnblogs.com/Images/OutliningIndicators/None.gif
 5http://www.cnblogs.com/Images/OutliningIndicators/None.gifusing System.Data.SQLite;
 6http://www.cnblogs.com/Images/OutliningIndicators/None.gifnamespace DBSchema2Doc.OP
 7http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gifhttp://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gifhttp://www.cnblogs.com/Images/dot.gif{
 8http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif    class MyRegExp:SQLiteFunction
 9http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif    http://www.cnblogs.com/Images/dot.gif{
10http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif        public override object Invoke(object[] args)
11http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif        http://www.cnblogs.com/Images/dot.gif{
12http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif            return System.Text.RegularExpressions.Regex.IsMatch(Convert.ToString(args[1]), Convert.ToString(args[0]));
13http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif        }
14http://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif    }
15http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif}
页: [1]
查看完整版本: [已解决]请教sqlite在dotnet中如何使用正则表达式