def fetch():
conn = dbconnect.dbConnect()
cursor = conn.connect()
cursor.execute("select * from cdsjb")
result = cursor.fetchall()
conn.close()
print("success")
return result
def fetch():
conn = dbconnect.dbConnect()
cursor = conn.connect()
sql = """ select * from gcxmb """
cursor.execute(sql)
result = cursor.fetchone()
conn.close()
return result
def fetchone():
conn = dbconnect.dbConnect()
cousor = conn.connect()
sql = """SELECT gcxmbm cdbm, cdmc, cgqbm, jldw, sfqy, sjlx, sflb, lbfs, lbcs, bz FROM cdb WHERE 1 """
cousor.execute(sql)
result = cousor.fetchone()
conn.close()
return result
def insert(**kwargs):
conn = dbconnect.dbConnect()
cursor = conn.connect()
sql = """insert into cdsjb(%s) values(%s)"""
key_list = []
value_list = []
for k, v in kwargs.items():
key_list.append(k)
value_list.append('%%(%s)s' % k)
sql = sql % (','.join(key_list), ','.join(value_list))
cursor.execute(sql, kwargs)
conn.close()
def insert(gcxmbm, gcxmmc):
conn = dbconnect.dbConnect()
cursor = conn.connect()
sql = """insert into gcxmb(gcxmbm,gcxmmc) values(%s,%s)"""
cursor.execute(sql, (gcxmbm, gcxmmc))
conn.close()