python 访问mysql 代码例子

python_ini.py

#!/usr/bin/python
mysql_host	 = "192.168.1.47"
mysql_port	 = 3306
mysql_user	 = "admin"
mysql_passwd = "123"
mysql_db	 = "my_python"
mysql_socket = "/var/lib/mysql/mysql.sock"

my_python.py

#!/usr/bin/python
#coding = utf-8
import MySQLdb
import MySQLdb.cursors
import python_ini as ini

#mysql connect
conn = MySQLdb.connect(
        host        = ini.mysql_host,
		port        = ini.mysql_port,
		user        = ini.mysql_user,
        passwd	    = ini.mysql_passwd,
        db          = ini.mysql_db,
        unix_socket = ini.mysql_socket,
        cursorclass =MySQLdb.cursors.DictCursor
		)
#connect info
cur= conn.cursor()

#insert table
def python_insert(mysql):
    return cur.execute(mysql)

#select table
def python_select(mysql):
	cur.execute(mysql)
	return cur.fetchall()

#delete table
def python_delete(mysql):
	return cur.execute(mysql)

main.py

#!/usr/bin/python
import my_python as py

mysql = "select * from student"
print py.python_select(mysql)

mysql = "insert into student value('2','xiaogang','1030','16')"
if py.python_insert(mysql)==0:
	print "insert fail!"
else:
	print "insert success!"

mysql = "select * from student"
print py.python_select(mysql)

mysql = "delete from student where id='2'"
if py.python_delete(mysql)==0:
	print "delete fail!"
else:
	print "delete success!"

mysql = "select * from student"
print py.python_select(mysql)