python 数据库的增删改查_python 数据库的增删改查

import pymysql

#查找数据库

def findFromDB( query_id):

db = pymysql.connect(host='localhost', user='root', passwd='', db='test', port=3306, charset='utf8')

cursor = db.cursor()

sql = ' select * from amazon_aces where asin = %s '

cursor.execute(sql, (query_id))

db.commit()

cursor.close()

db.close()

return cursor.fetchone() is not None

#插入数据库

def insertIntoDB( asin, checked):

db = pymysql.connect(host='localhost', user='root', passwd='', db='test', port=3306, charset='utf8')

cursor = db.cursor()

sql = " insert into amazon_aces(asin , checked) values(%s , %s) "

cursor.execute(sql, (asin, checked))

db.commit()

cursor.close()

db.close()

def createTable():

'''创建表'''

db = pymysql.connect(host='localhost', user='root', passwd='', db='test', port=3306, charset='utf8')

cursor = db.cursor()

cursor.execute('''

CREATE TABLE `amazon_aces` (

`asin` varchar(200) NOT NULL ,

`checked` varchar(200) ,

PRIMARY KEY (`asin`)

)

''')

db.commit()

cursor.close()

db.close()

#删除数据库表

def dropTable():

db = pymysql.connect(host='localhost', user='root', passwd='', db='test', port=3306, charset='utf8')

cursor = db.cursor()

cursor.execute('''

DROP TABLE IF EXISTS `amazon_aces`

''')

db.commit()

cursor.close()

db.close()

if __name__ == '__main__':

dropTable()

createTable()

insertIntoDB("1","aaa")

insertIntoDB("2","bb")