数据库 – Guge's blog

Python每日一题（第0002题）

2015年2月5日 by Guge Leave a Comment

题目：将 0001 题生成的 200 个激活码（或者优惠券）保存到 MySQL 关系型数据库中

#coding=utf-8
import MySQLdb
import random,string


def password(len):
	chars = string.ascii_letters.lower() + string.digits
	return ''.join(random.sample(chars,len))

def insertcdkey():
	number = 1
	for i in range (200):
		passwd = password(10)
		cur.execute('insert into jihuoma (id, cdkey) values (%s, %s)', [number, passwd])
		number += 1
		#print number,passwd

if __name__ == '__main__':
	conn = MySQLdb.connect(
		host = 'localhost',
	    port = 3306,
	    user = 'root',
	    passwd = '',
	    db = 'test')
	cur = conn.cursor()
	cur.execute("create table jihuoma(id varchar(20) primary key,cdkey varchar(20))")
	insertcdkey()
	cur.close()
	conn.commit()
	conn.close()

#coding=utf-8

import MySQLdb

import random,string

def password(len):

chars = string.ascii_letters.lower() + string.digits

return ''.join(random.sample(chars,len))

def insertcdkey():

number = 1

for i in range (200):

passwd = password(10)

cur.execute('insert into jihuoma (id, cdkey) values (%s, %s)', [number, passwd])

number += 1

#print number,passwd

if __name__ == '__main__':

conn = MySQLdb.connect(

host = 'localhost',

port = 3306,

user = 'root',

passwd = '',

db = 'test')

cur = conn.cursor()

cur.execute("create table jihuoma(id varchar(20) primary key,cdkey varchar(20))")

insertcdkey()

cur.close()

conn.commit()

conn.close()

笔记：MySQL的SQL占位符是%s；

python操作Mysql数据库

2015年1月27日 by Guge Leave a Comment

#coding=utf-8
import MySQLdb

conn= MySQLdb.connect(
        host='localhost',
        port = 3306,
        user='root',
        passwd='123456',
        db ='test',
        )
cur = conn.cursor()

#创建数据表
#cur.execute("create table student(id int ,name varchar(20),class varchar(30),age varchar(10))")

#插入一条数据
#cur.execute("insert into student values('2','Tom','3 year 2 class','9')")


#修改查询条件的数据
#cur.execute("update student set class='3 year 1 class' where name = 'Tom'")

#删除查询条件的数据
#cur.execute("delete from student where age='9'")

cur.close()
conn.commit()
conn.close()

#coding=utf-8

import MySQLdb

conn= MySQLdb.connect(

host='localhost',

port = 3306,

user='root',

passwd='123456',

db ='test',

)

cur = conn.cursor()

#创建数据表

#cur.execute("create table student(id int ,name varchar(20),class varchar(30),age varchar(10))")

#插入一条数据

#cur.execute("insert into student values('2','Tom','3 year 2 class','9')")

#修改查询条件的数据

#cur.execute("update student set class='3 year 1 class' where name = 'Tom'")

#删除查询条件的数据

#cur.execute("delete from student where age='9'")

cur.close()

conn.commit()

conn.close()

PS:由于Kali已安装了MySQL-python，故无需安装，如在Python下，输入

>>> import MySQLdb

1	>>> import MySQLdb

报错提示模块找不到，则需要安装MySQL-python：

下载地址：https://pypi.python.org/pypi/MySQL-python/

下载MySQL-python-1.2.5.zip 文件之后直接解压，然后进入目录安装即可:

>>python setup.py install