python 访问数据库一：添加部门

来源：互联网发布：2016淘宝818 编辑：程序博客网时间：2024/06/07 03:45

import MySQLdb
import random
import string
'''conn = MySQLdb.connect(host='192.168.*.**',
port = ****,
user='*****',
passwd='****',
db ='****'
)
cur = conn.cursor()

#一次插入多条记录 executemany
sqli="insert into t_department(ParentDepID,DepName,Status,CreateDate,CompanyId) values(%s,%s,%s,%s,%s)"
cur.executemany(sqli,[
('50020','Tom','1','2017-05-16 15:41:02','39375'),
('50020','Jack','1','2017-05-16 15:41:02','39375'),
])
print "update success"
cur.close()
conn.commit()
conn.close()'''
#################################################################插入单条操作
def addDepartment():

'conn = MySQLdb.connect(host='192.168.*.**',
port = ****,
user='*****',
passwd='****',
db ='****'
)
cur = conn.cursor()
comid = raw_input("Input your companyid: ")
times = raw_input("Input your department number to increase: ")
num = int(times)
for i in range (1,num+1):

sqli="insert into t_department(ParentDepID,DepName,Status,CreateDate,CompanyId) values(%s,%s,%s,%s,%s)"
param=('50020','name','1','2017-05-16 15:41:02',comid)

cur.execute(sqli,param)

print "update success"
cur.execute("select count(*) from t_department where CompanyId = 39375 ")
result = cur.fetchmany()

print("该公司部门总数量： %s" % (result))
cur.close()
conn.commit()
conn.close()
if __name__ == "__main__":

addDepartment()

################################################尝试用定义函数，分层

def openConn():
conn = MySQLdb.connect(host='192.168.*.**',
port = ****,
user='*****',
passwd='****',
db ='****'
)
return conn
def addDepartment():

con = openConn()
cur = con.cursor()
comid = raw_input("Input your companyid: ")
times = raw_input("Input your department number to increase: ")
num = int(times)
for i in range (1,num+1):

sqli="insert into t_department(ParentDepID,DepName,Status,CreateDate,CompanyId) values(%s,%s,%s,%s,%s)"
param=('50020','name','1','2017-05-16 15:41:02',comid)
cur.execute(sqli,param)

print "update success"
cur.execute("select count(*) from t_department where CompanyId = 39375 ")
result = cur.fetchmany()

print("该公司部门总数量： %s" % (result))
cur.close()
con.commit()
con.close()
if __name__ == "__main__":
addDepartment()

阅读全文

0 0