a11377815/
共49个网摘 [
1 2 ]
下一页 |
访问a11377815的个人空间
a11377815收录，时间：2008-2-13 13:09:43 | 相关网摘，我也收藏
select * from
(select *,NextBD=case when dateadd(yy,datediff(yy,birthday,getdate()),birthday)> getdate() then dateadd(yy,datediff(yy,birthday,getdate()),birthday) else dateadd(yy,datediff(yy,birthday,getdate()) 1,birthday) end from base_user) as tb
where datediff(d,getdate(),NextBD) between 0 and 10 and datepart(d,birthday)=datepart(d,NextBD)
http://topic.csdn.net/u/20070913/18/b10217c0-78b3-4281-962a-4ba6e055a56b.html
a11377815收录，时间：2008-1-23 9:25:32 | 相关网摘，我也收藏
using System; using System.Collections.Generic; using System.Text; using System.Net; using System.Text.RegularExpressions; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { string url = @"http://sh.ganji.com/piao/"; WebClient wc = new WebClient(); Console.WriteLine("正在下载文件....."); string html = wc.DownloadString(url); string pattern = @" (? (?: (?!)[\s\S] )* ) [^<>]* (? (?: (?!)[\s\S] )* ) [^<>]* (? (?: (?!)[\s\S] )* ) [^<>]* (? (?: (?!)[\s\S] )* )"; Regex reg = new Regex(pattern, RegexOptions.IgnorePatternWhitespace | RegexOptions.IgnoreCase); Regex reg_tag = new Regex(@"<[^<>]*>"); foreach (Match m in reg.Matches(html)) { Console.WriteLine(string.Format("标题:{0}",reg_tag.Replace(m.Groups["标题"].Value,""))); Console.WriteLine(string.Format("发车时间:{0}", m.Groups["发车时间"].Value)); Console.WriteLine(string.Format("起点终点:{0}", m.Groups["起点终点"].Value)); Console.WriteLine(string.Format("发布时间:{0}", m.Groups["发布时间"].Value)); } } } }
http://topic.csdn.net/u/20080121/17/facbc7f5-572a-4296-9d7f-6d18117bccfa.html
共49个网摘 [
1 2 ]
下一页