½ñÌì̸Á½¸öASPÔËÐÐʱ¿ÉÄܳöÏÖµÄÓëIISÓйصĴíÎó
-------------------------------------------------------------------
´íÎóÀàÐÍÒ»£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ²»ÄܸüС£Êý¾Ý¿â»ò¶ÔÏóΪֻ¶Á¡£
´íÎóÀàÐͶþ£º
Microsoft OLE DB Provider for ODBC Drivers ´íÎó ''80004005''
[Microsoft][ODBC Microsoft Access Driver]³£¼û´íÎó ²»ÄÜ´ò¿ª×¢²á±í¹Ø¼ü×Ö ''Temporary (volatile) Jet DSN for process 0x728 Thread 0x854 DBC 0x276fb44 Jet''¡£
-------------------------------------------------------------------
µ±ÄãʹÓÃASPÁ¬½ÓÊý¾Ý¿âʱ¿ÉÄÜ»á³öÏÖÕâÖÖÇé¿ö£¬ÎªÊ²Ã´ÄØ£¿ÒòΪÄúÊý¾Ý¿âÎļþËùÔÚµÄĿ¼ȨÏÞ¶ÔÌØ¶¨µÄÓû§Ã»ÓпªÆô×ã¹»µÄȨÏÞ£¬ÄãÖ»ÄܽøÐÐÖ»¶Á·ÃÎÊ£¬Ò»°ã³öÏÖÕâÖÖÇé¿öµÄÎļþϵͳΪNTFS£¬ÄÇÔõô½â¾öÄØ£¿
Ê×ÏÈ£¬ÄãÕÒµ½Êý¾Ý¿âËùÔÚĿ¼£¬Ò²¿ÉÒÔÊÇÉϲãĿ¼£¬È»ºóÉèÖÃÎļþ¼Ð °²È« ÊôÐÔ£¬×î¼òµ¥µÄÊǰÑeveryoneµÄȨÏÞÉèÖóÉÍêÈ«¼´¿É£¬ÄǶÔÓÚÕâ¸öÎÊÌ⣬Ӧ¸ÃʹÄĸö¶ÔÏóµÄȨÏÞÉèÖóÉÍêÈ«ÄØ£¿´ð° ......
´úÂëºÜÂÒ£¬¶øÇÒûÓÐÓõ½Ä£°å£¬°Ñhtml´úÂë¸úPython´úÂë»ìÔÚÒ»ÆðÁË£¬¶øÇÒҲûÓÐÓõ½web.py±¾ÉíÌṩµÄÊý¾Ý¿â²Ù×÷Ä£¿é£¬¾ø¶Ô´Ö³¬µÄ´úÂ룡
ѧϰÁ˺ܶණÎ÷£¬Ê×Ïȵ±È»ÊÇweb.py£¬È»ºóÊÇsqlite£¬½ÓÏÂÀ´ÊÇtimeÄ£¿é——¿´À´Ò²Î¨Óв»¶ÏµÄʵ¼ù£¬²ÅÕæÕýÄܽø²½£¡
˵ʵÔڵģ¬Å¼Ñ§htmlµ½ÏÖÔÚÕâô¾Ã£¬»¹ÊǰëͰˮ£¬±¯¾çÁË£¡
01 #!/usr/bin/env python
02 #coding=utf-8
03
04 import os,web,time
05 import sqlite3 as db
06
07 urls = (
08 '/', 'hello',
09 '/add','add'
10 )
11
12 class hello:
13 def GET(self):
14 #ʵÀý»¯sqldb£¬È»ºó»ñÈ¡ÄÚÈÝ
15 s = ""
16 sdb = sqldb()
......
È«ÎļìË÷ÊǶԴóÊý¾ÝÎı¾½øÐÐË÷Òý£¬ÔÚ½¨Á¢µÄË÷ÒýÖжÔÒª²éÕҵĵ¥´Ê½øÐнøÐÐËÑË÷£¬¶¨Î»ÄÄЩÎı¾Êý¾Ý°üÀ¨ÒªËÑË÷µÄµ¥´Ê¡£Òò´Ë£¬È«ÎļìË÷µÄÈ«²¿¹¤×÷¾ÍÊǽ¨Á¢Ë÷ÒýºÍÔÚË÷ÒýÖÐËÑË÷¶¨Î»£¬ËùÓеŤ×÷¶¼ÊÇÎ§ÈÆÕâÁ½¸öÀ´½øÐеġ£ÏÂÃæ¾ÍÖð¸ö½éÉÜ¡£
¡¡¡¡½¨Á¢È«ÎÄË÷ÒýÖÐÓÐÁ½Ïî·Ç³£ÖØÒª£¬Ò»¸öÊÇÈçºÎ¶ÔÎı¾½øÐзִʣ¬Ò»Êǽ¨Á¢Ë÷ÒýµÄÊý¾Ý½á¹¹¡£·Ö´ÊµÄ·½·¨»ù±¾ÉÏÊǶþÔª·Ö´Ê·¨¡¢×î´óÆ¥Åä·¨ºÍͳ¼Æ·½·¨¡£Ë÷ÒýµÄÊý¾Ý½á¹¹»ù±¾ÉϲÉÓõ¹ÅÅË÷ÒýµÄ½á¹¹¡£
¡¡¡¡·Ö´ÊµÄºÃ»µ¹ØÏµµ½²éѯµÄ׼ȷ³Ì¶ÈºÍÉú³ÉµÄË÷ÒýµÄ´óС¡£ÔÚÖÐÎÄ·Ö´Ê·¢Õ¹ÖУ¬ÔçÆÚ¾³£Ê¹Ó÷ִʷ½Ê½ÊǶþÔª·Ö´Ê·¨£¬¸Ã·½·¨µÄ»ù±¾ÔÀíÊǽ«°üº¬ÖÐÎĵľä×Ó½øÐжþÔª·Ö¸î£¬²»¿¼Âǵ¥´Êº¬Ò壬ֻ¶Ô¶þÔªµ¥´Ê½øÐÐË÷Òý¡£Òò´Ë¸Ã·½·¨Ëù·Ö³öµÄµ¥´ÊÊýÁ¿½Ï¶à£¬´Ó¶ø²úÉúµÄË÷ÒýÊýÁ¿¾Þ´ó£¬²éѯÖлὫÎÞÓõÄÊý¾Ý¼ìË÷³öÀ´£¬ºÃ´¦ÊÇËã·¨¼òµ¥²»»á©µô¼ìË÷µÄÊý¾Ý¡£Ö®ºóÓÖ·¢Õ¹³ö×î´óÆ¥Åä·Ö´Ê·½·¨£¬¸Ã·½·¨ÓÖ·ÖΪÕýÏò×î´ó·Ö´ÊºÍÄæÏò×î´ó·Ö´Ê¡£ÆäÔÀíºÍ²é×ÖµäÀàËÆ£¬¶Ô³£Óõ¥´ÊÉú³ÉÒ»¸ö´Êµä£¬·ÖÎö¾ä×ӵĹý³ÌÖÐ×î´óµÄÆ¥Åä×ÖµäÖеĵ¥´Ê£¬´Ó¶ø½«¾ä×Ó²ð·ÖΪÓÐÒâÒåµÄµ¥´ÊÁ´¡£×î´óÆ¥Åä·¨ÖÐÕýÏò·Ö´Ê·½·¨¶ÔÆ«Õýʽ´ÊÓïµÄ·Ö±æÈÝÒײúÉú´íÎ󣬱ÈÈç“Ê×Êκͷþ×°”»á½«“ºÍ·þ”× ......
bcpÃüÁîÊÇSQL ServerÌṩµÄÒ»¸ö¿ì½ÝµÄÊý¾Ýµ¼Èëµ¼³ö¹¤¾ß¡£Ê¹ÓÃËü²»ÐèÒªÆô¶¯ÈκÎͼÐιÜÀí¹¤¾ß¾ÍÄÜÒÔ¸ßЧµÄ·½Ê½µ¼Èëµ¼³öÊý¾Ý¡£bcpÊÇSQL ServerÖиºÔðµ¼Èëµ¼³öÊý¾ÝµÄÒ»¸öÃüÁîÐй¤¾ß£¬ËüÊÇ»ùÓÚDB-LibraryµÄ£¬²¢ÇÒÄÜÒÔ²¢Ðеķ½Ê½¸ßЧµØµ¼Èëµ¼³ö´óÅúÁ¿µÄÊý¾Ý¡£bcp¿ÉÒÔ½«Êý¾Ý¿âµÄ±í»òÊÓͼֱ½Óµ¼³ö£¬Ò²ÄÜͨ¹ýSELECT fromÓï¾ä¶Ô±í»òÊÓͼ½øÐйýÂ˺󵼳ö¡£ÔÚµ¼Èëµ¼³öÊý¾Ýʱ£¬¿ÉÒÔʹÓÃĬÈÏÖµ»òÊÇʹÓÃÒ»¸ö¸ñʽÎļþ½«ÎļþÖеÄÊý¾Ýµ¼Èëµ½Êý¾Ý¿â»ò½«Êý¾Ý¿âÖеÄÊý¾Ýµ¼³öµ½ÎļþÖÐ.
1. bcpµÄÖ÷Òª²ÎÊý½éÉÜ
bcp¹²ÓÐËĸö¶¯×÷¿ÉÒÔÑ¡Ôñ¡£
(1) µ¼Èë¡£
Õâ¸ö¶¯×÷ʹÓÃinÃüÁîÍê³É£¬ºóÃæ¸úÐèÒªµ¼ÈëµÄÎļþÃû¡£
(2) µ¼³ö¡£
Õâ¸ö¶¯×÷ʹÓÃoutÃüÁîÍê³É£¬ºóÃæ¸úÐèÒªµ¼³öµÄÎļþÃû¡£
(3) ʹÓÃSQLÓï¾äµ¼³ö¡£
Õâ¸ö¶¯×÷ʹÓÃqueryoutÃüÁîÍê³É£¬Ëü¸úoutÀàËÆ£¬Ö»ÊÇÊý¾ÝÔ´²»ÊDZí»òÊÓͼÃû£¬¶øÊÇSQLÓï¾ä¡£
(4) µ¼³ö¸ñʽÎļþ¡£
Õâ¸ö¶¯×÷ʹÓÃformatÃüÁîÍê³É£¬ºó¶ø¸ú¸ñʽÎļþÃû¡£
ÏÂÃæ½éÉÜһЩ³£ÓõÄÑ¡Ï
-f format_file
format_file±íʾ¸ñʽÎļþÃû¡£Õâ¸öÑ¡ÏîÒÀÀµÓÚÉÏÊöµÄ¶¯×÷£¬Èç¹ûʹÓõÄÊÇin»òout£¬format_file±íʾÒѾ´æÔڵĸñʽÎļþ£¬Èç¹ûʹÓõÄÊÇformatÔò±íʾÊÇÒªÉú³ÉµÄ¸ñʽÎļþ¡£
-x
Õâ¸öÑ¡ÏîÒªºÍ-f format ......
function ListFiles(Dir: String):TStrings;
var
FSearchRec: TSearchRec;
FileList: TStrings;
FindResult: Integer;
begin
if Dir[length(Dir)]<>'\' then Dir:=Dir+'\';
FileList :=TStringList.Create;
FindResult:=FindFirst(Dir+'*.*,faAnyFile+faDirectory,FSearchRec);
while FindResult = 0 do
begin
if ((FSearchRec.Attr and faDirectory) = 0) then //Îļþ
begin
FileList.Add('Îļþ:'+LowerCase(Dir+FSearchRec.Name));
end;
if ((FSearchRec.Attr and faDirectory) <> 0) then
begin
if ((FSearchRec.Name<> '.') and (FSearchRec.Name <> '..')) then //Îļþ¼Ð
begin
ListFiles(dir+FileRec.Name);
end;
end;
FindResult:=FindNext(FSearchRec);
end;
FindClose(FSearchRec);
ListFiles:=FileList;
end;
......
JavaScriptÑéÖ¤ÕýÔò±í´ïʽ´óÈ«,ËѼ¯×îÈ«µÄJavaScriptÑéÖ¤ÕýÔò±í´ïʽ,¿ªÊ¼²é¿´°É£¬ÕâÀïµÄ¶¼ÊÇÕýÔò±í´ïʽµÄÀý×Ó£¬¾ßÌåºÍº¯Êý½áºÏµÄʹÓ÷½·¨£¬»¹Çë²é¿´ÏÂÆªÎÄÕ¡¶JavaScriptʹÓÃÕýÔò±í´ïʽ½øÐÐÑéÖ¤¡·
Æ¥ÅäÖÐÎÄ×Ö·ûµÄÕýÔò±í´ïʽ£º [u4e00-u9fa5]
ÆÀ×¢£ºÆ¥ÅäÖÐÎÄ»¹ÕæÊǸöÍ·ÌÛµÄÊ£¬ÓÐÁËÕâ¸ö±í´ïʽ¾ÍºÃ°ìÁË
Æ¥ÅäË«×Ö½Ú×Ö·û(°üÀ¨ºº×ÖÔÚÄÚ)£º[^x00-xff]
ÆÀ×¢£º¿ÉÒÔÓÃÀ´¼ÆËã×Ö·û´®µÄ³¤¶È£¨Ò»¸öË«×Ö½Ú×Ö·û³¤¶È¼Æ2£¬ASCII×Ö·û¼Æ1£©
Æ¥Åä¿Õ°×ÐеÄÕýÔò±í´ïʽ£ºns*r
ÆÀ×¢£º¿ÉÒÔÓÃÀ´É¾³ý¿Õ°×ÐÐ
Æ¥ÅäHTML±ê¼ÇµÄÕýÔò±í´ïʽ£º< (S*?)[^>]*>.*?|< .*? />
ÆÀ×¢£ºÍøÉÏÁ÷´«µÄ°æ±¾Ì«Ôã¸â£¬ÉÏÃæÕâ¸öÒ²½ö½öÄÜÆ¥Å䲿·Ö£¬¶ÔÓÚ¸´ÔÓµÄǶÌ×±ê¼ÇÒÀ¾ÉÎÞÄÜΪÁ¦
Æ¥ÅäÊ×β¿Õ°××Ö·ûµÄÕýÔò±í´ïʽ£º^s*|s*$
ÆÀ×¢£º¿ÉÒÔÓÃÀ´É¾³ýÐÐÊ×ÐÐβµÄ¿Õ°××Ö·û(°üÀ¨¿Õ¸ñ¡¢ÖƱí·û¡¢»»Ò³·ûµÈµÈ)£¬·Ç³£ÓÐÓõıí´ïʽ
Æ¥ÅäEmailµØÖ·µÄÕýÔò±í´ïʽ£ºw+([-+.]w+)*@w+([-.]w+)*.w+([-.]w+)*
ÆÀ×¢£º±íµ¥Ñé֤ʱºÜʵÓÃ
Æ¥ÅäÍøÖ·URLµÄÕýÔò±í´ïʽ£º[a-zA-z]+://[^s]*
ÆÀ×¢£ºÍøÉÏÁ÷´«µÄ°æ±¾¹¦ÄܺÜÓÐÏÞ£¬ÉÏÃæÕâ¸ö»ù±¾¿ÉÒÔÂú×ãÐèÇó
Æ¥ÅäÕʺÅÊÇ·ñºÏ·¨(×Öĸ¿ªÍ·£¬ÔÊÐí5-16×Ö½Ú£¬ÔÊÐí×ÖĸÊý×ÖÏ»®Ïß)£º^[a-zA-Z][a-zA-Z0 ......