<p>只需修改一下语法,我就把python打扮得更加友好(更接近python3支持,尽管原始输入不是python3的本机输入)。从那以后,你应该可以扩展。。。。你知道吗</p>
<pre><code>import sys
import sqlite3 as lite
'''
made your code more pep8 python like
note comments in python are reserved for
why not what..e.g. code is self descriptive
of what, but why is what is important
'''
print('{}'.format(sys.argv)) # debug
var = raw_input("What are you looking for: ")
print("Standby; looking for :{}".format(var))
vart = '%{}%'.format(var)
con = lite.connect('test.db')
print("\nOk. Here's what I found.\n")
with con:
cur = con.cursor()
sql_query = 'SELECT * FROM mytable WHERE type LIKE ? or count LIKE ?'
cur.execute(sql_query, ['%{0}%'.format(var), '%{0}%'.format(var)])
try:
rows = cur.fetchall()
except Exception as err:
print(err)
for row in rows:
mstr = row[0]
print('Found: {} : {}'.format(mstr.encode('ascii'), row[1]))
</code></pre>
<p><strong>输出示例</strong></p>
<pre><code>host-wifi:java user$ python /tmp/p.py
['/tmp/p.py']
What are you looking for: 99
Standby; looking for :99
Ok. Here's what I found.
Found: cat : 99
host-wifi:java user$ python /tmp/p.py
['/tmp/p.py']
What are you looking for: 3
Standby; looking for :3
Ok. Here's what I found.
Found: fox : 23
Found: dog : 34
Found: bird : 123
</code></pre>