求python执行sqlite 数据库的接口函数。

wide288

谢谢. thanks

nbxmedia

google search python sqlite

jhuangjiahua

In [2]: import sqlite

In [3]: dir sqlite
------> dir(sqlite)
Out[3]:
['BINARY',
'Binary',
'Connection',
'Cursor',
'DATE',
'DBAPITypeObject',
'DataError',
'DatabaseError',
'Error',
'INT',
'IntegrityError',
'InterfaceError',
'InternalError',
'NUMBER',
'NotSupportedError',
'OperationalError',
'PgResultSet',
'ProgrammingError',
'ROWID',
'STRING',
'TIME',
'TIMESTAMP',
'UNICODESTRING',
'Warning',
'__all__',
'__builtins__',
'__doc__',
'__file__',
'__name__',
'__path__',
'__revision__',
'_sqlite',
'apilevel',
'connect',
'decode',
'encode',
'main',
'paramstyle',
'threadsafety',
'version',
'version_info']

In [4]:
In [4]: help sqlite
------> help(sqlite)

1. 
   
2. Help on package sqlite:
   
3. 
   
4. NAME
   
5.     sqlite
   
6. 
   
7. FILE
   
8.     /usr/lib/python2.3/site-packages/sqlite/__init__.py
   
9. 
   
10. PACKAGE CONTENTS
    
11.     main
    
12. 
    
13. FUNCTIONS
    
14.     Binary = encode(...)
    
15.         encode(s) -> encoded binary string.
    
16.         Encode binary string 's' for storage in SQLite.
    
17. 
    
18.     connect(*args, **kwargs)
    
19. 
    
20.     decode(...)
    
21.         decode(s) -> decoded binary string.
    
22.         Decode encoded binary string retrieved from SQLite.
    
23. 
    
24.     encode(...)
    
25.         encode(s) -> encoded binary string.
    
26.         Encode binary string 's' for storage in SQLite.
    
27. 
    
28. DATA
    
29.     BINARY = <sqlite.main.DBAPITypeObject instance>
    
30.     DATE = <sqlite.main.DBAPITypeObject instance>
    
31.     INT = <sqlite.main.DBAPITypeObject instance>
    
32.     NUMBER = <sqlite.main.DBAPITypeObject instance>
    
33.     ROWID = <sqlite.main.DBAPITypeObject instance>
    
34.     STRING = <sqlite.main.DBAPITypeObject instance>
    
35.     TIME = <sqlite.main.DBAPITypeObject instance>
    
36.     TIMESTAMP = <sqlite.main.DBAPITypeObject instance>
    
37.     UNICODESTRING = <sqlite.main.DBAPITypeObject instance>
    
38.     __all__ = ['connect', 'IntegrityError', 'InterfaceError', 'InternalErr...
    
39.     __revision__ = '1.22'
    
40.     apilevel = '2.0'
    
41.     paramstyle = 'pyformat'
    
42.     threadsafety = 1
    
43.     version = '1.0.1'
    
44.     version_info = (1, 0, 1)
    

复制代码

duotaiya

http://www.osprg.org/modules/new ... _id=135&forum=3