|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
#!/usr/bin/env python
#encoding:utf-8
import
MySQLdb
print
"<html>"
print
"<body>"
print
"<h1>book</h1>"
print
"<ul>"
connection = MySQLdb.connect(user=
"root"
,
passwd
=
"123456"
, db=
"zabbix"
)
cursor = connection.cursor()
cursor.execute(
"SELECT * FROM users"
)
for
row
in
cursor.fetchall():
print
"<li>%s</li>"
% row[0]
print
"</ul>"
print
"</body></html>"
|
|
1
2
3
4
5
6
7
8
9
10
|
[root@bogon ~]
# python mysql.py
<html>
<body>
<h1>book<
/h1
>
<ul>
<li>1<
/li
>
<li>2<
/li
>
<
/ul
>
<
/body
><
/html
>
[root@bogon ~]
#
|
yum install MySQL-python
本文转自 小小三郎1 51CTO博客，原文链接：http://blog.51cto.com/wsxxsl/1954439，如需转载请自行联系原作者
