话不多说，上cgi文件代码

!/usr/bin/env python

import cgi
import sqlite3

reshtml1 = '''Content-Type: text/html\n
<HTML>
<HEAD>
<TITLE>ISTG baby VOTE system</TITLE>
</HEAD>
<BODY>
Your name is %s.
You have voted %s.
</BODY>
</HTML>
'''
reshtml2 = '''Content-Type: text/html\n
<HTML>
<HEAD>
<TITLE>ISTG baby VOTE system</TITLE>
</HEAD>
<BODY>
You are not a member of ISTG group!
If you are, please check your spelling. eg: hqzhu
</BODY>
'''

get entered name and voted sex

form = cgi.FieldStorage()
person = form['person'].value
sex = form['sex'].value

get leagal names from database

conn = sqlite3.connect('/home/hqzhu/istg/web/baby.db')
cur = conn.cursor()
sql = "select name from catalog;"
cur.execute(sql)
names = cur.fetchmany(14)
cur.close()
conn.close()

if (person,) in names:
print reshtml1 % (person, sex)
else:
print reshtml2

下面是httpd的error_log内容
[Wed Jul 08 17:34:24.830482 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] AH01215: Traceback (most recent call last):, referer: http://10.180.190.12/baby.htm
[Wed Jul 08 17:34:24.830577 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] AH01215: File "/var/www/cgi-bin/baby.py", line 34, in <module>, referer: http://10.180.190.12/baby.htm
[Wed Jul 08 17:34:24.830616 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] AH01215: conn = sqlite3.connect('/home/hqzhu/istg/web/baby.db'), referer: http://10.180.190.12/baby.htm
[Wed Jul 08 17:34:24.830683 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] AH01215: sqlite3.OperationalError: unable to open database file, referer: http://10.180.190.12/baby.htm
[Wed Jul 08 17:34:24.841601 2015] [cgi:error] [pid 13304] [client 10.230.0.108:58221] End of script output before headers: baby.py, referer: http://10.180.190.12/baby.htm

前两天有个帖子说是用sys.stdout.write()去做什么的，不太懂，求教~

python cgi 连接 sqlite3 失败的问题

!/usr/bin/env python

get entered name and voted sex

get leagal names from database