Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

web.py+sqliteдµÄ¼òµ¥ÁôÑÔ±¾

´úÂëºÜÂÒ£¬¶øÇÒûÓÐÓõ½Ä£°å£¬°Ñ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()
17         rec = sdb.cu.execute("""select * from msgs""")
18         dbre = sdb.cu.fetchall()        
19         for i in dbre:
20             s =  "<p>"+i[2]+"  <span style=\"color: blue\">"+i[1]+' sad: '+r"</span>"+"  <span style=\"color: gray\">"+i[3]+r"</span></p>" + s 
21         
22         sh = """
23         <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML>
24         <HEAD><meta http-equiv="X-UA-Compatible" content


Ïà¹ØÎĵµ£º

SQLiteÏÂÔØÓë°²×°

SQLite
µÄ×îа汾¿ÉÒÔ´ÓÕâÀïÏÂÔØ
¡£ÏÂÃæÎÒÃÇÒÔWindows°æ±¾sqlite-3_5_1.zip
ΪÀý½éÉÜÆä°²×°·½·¨¡£
£¨´ó¼Ò¿ÉÒÔÑ¡ÔñÏÂÔØ°²×°ÊʺÏ×Ô¼ºµÄ°æ±¾£©
ÏÂÔØºó£¬½«sqlite-3_5_1.zip½âѹËõÖÁC:\sqliteĿ¼¼´Íê³É°²×°¡£
C:\sqliteĿ¼¹¹ÔìΪ£º
C:\sqlite
  |
  +--sqlite3.exe
´ò¿ªÒ»¸öCMDÃüÁî´°¿Ú
C:\ ......

AutoIt3¿ª·¢µÄ²Ù×÷SQliteÊý¾Ý¿âµÄÔ´Âë

AutoIt3¿ª·¢µÄ²Ù×÷SQliteÊý¾Ý¿âµÄÔ´ÂëÏÂÔØ
²¿·ÖÔ´Âë
_SQLite_Startup () ;¼ÓÔØ SQLite.dll
If Not FileExists($SQLite_Data_Path) Then
    SQLCreate()
EndIf
$GUI_Form = GUICreate($Title, 300, 435, -1, -1)
GUISetBkColor(0xECE9D8)  ; will change background color
$GUI_ListBox = GUIC ......

ÍêÕûµÄVCÏÂSQLiteµÄʹÓÃ


ÎÄÕ·ÖÀà:Êý¾Ý¿â



SQLiteÔÚVCϵÄʹÓã¨×ª£©http://www.sqlite.com.cn/MySqlite/4/523.Html
Ò»¡¢SQLite¼ò½é
   SQLite
ÊÇÓÃCÓïÑÔ±àдµÄ¿ªÔ´Êý¾Ý¿â£¬Ö÷ÒªÓÃÓÚǶÈëʽ£¬ÄãÒ²¿ÉÒÔ°ÑËü¼¯³ÉÔÚ×Ô¼ºµÄ×ÀÃæ³ÌÐòÖУ¬Ò²ÓÐÈ˽«ÆäÌæ´úAccess£¬ÓÃ×÷ºǫ́Êý¾Ý¿â¡£
SQLite Ö§³Ö¶àÊýSQL92 ......

sqlite´¥·¢Æ÷Ò»Àý

int column_names_printed = 0;
void print_row(int n_values, char** values)
{
    int i;
    for (i = 0; i < n_values; ++i) {
        printf("%10s", values[i]);
    }
    printf("\n& ......

SQLite°Ù¶È


[±à¼­±¾¶Î
]
SQLite¼ò½é
SQLite
µÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾ­ÓÐ10¸öÄêÍ·ÁË. SQLiteÒ²Ó­À´ÁËÒ»¸ö°æ±¾ SQLite 3ÒѾ­·¢²¼.
¡¡¡¡SQLiteÊÇÒ»¿îÇáÐ͵ÄÊý¾Ý¿â£¬ÊÇ×ñÊØACIDµÄ¹ØÁªÊ½Êý¾Ý¿â¹ÜÀíϵͳ£¬ËüµÄÉè¼ÆÄ¿±êÊÇǶÈë
ʽµÄ£¬¶øÇÒĿǰÒѾ­ÔںܶàǶÈëʽ²úÆ·ÖÐʹÓÃÁËËü£¬ËüÕ¼ÓÃ×ÊÔ´·Ç³£µÄµÍ£¬ÔÚǶÈëʽÉ豸ÖУ¬¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ