def selectVideosData():
print("数据库请求视频数据")
sql = 'SELECT videos_title,videos_address FROM t_videos'
dbcursor.execute(sql)
videos_data = dbcursor.fetchall()
return videos_data
def shopping_selectall():
print("查询购物车数据")
sql = 'select shopping_car_img,shopping_car_title,shopping_car_price,shopping_car_count from t_shopping_car'
dbcursor.execute(sql)
shoppingCart_data = dbcursor.fetchall()
return shoppingCart_data
def scenic_selectall():
print("查询景点全部数据")
sql = 'select * from t_scenic'
#执行sql
dbcursor.execute(sql)
#获取数据
scenic_data = dbcursor.fetchall()
print(scenic_data)
def scenic_update():
print("更新表数据")
for i in range(len(scenic_name_Array)):
param = str(natapp_url + scenic_url + scenic_name_Array[i])
sql = 'update t_scenic set scenic_img ="{0}"'.format(param)
dbcursor.execute(sql)
conn.commit()
print(param)
def shopping_insert(goods_img_id,goods_text2_title,goods_text4_price,index):
print("插入购物车数据")
sql = "insert into t_shopping_car (shopping_car_img,shopping_car_title," \
" shopping_car_price,shopping_car_count,shopping_car_index) values(%s,%s,%s,%s,%s)"
param = (goods_img_id,goods_text2_title,goods_text4_price,1,index)
dbcursor.execute(sql,param)
print(param)
conn.commit()
def advertise_insert():
print("插入广告位数据")
for i in range(len(adv_img_Array)):
print(i)
sql = 'insert into t_advertise (adv_img,adv_name,adv_price) values(%s,%s,%s)'
param = (natapp_url + advertise_url + adv_img_Array[i],
adv_name_Array[i], adv_price_Array[i])
dbcursor.execute(sql, param)
conn.commit()
def videos_insert():
print("向商品表插入数据")
for i in range(len(videos_address_Array)):
print(i)
# 定义sql语句
sql = 'INSERT INTO t_videos ' \
'(videos_title,videos_price,videos_address)VALUE(%s,%s,%s)'
# 定义参数
param = (videos_title_Array[i], videos_price_Array[i],
server_url + videos_address_Array[i])
# 执行sql
dbcursor.execute(sql, param)
# 提交
conn.commit()
def advertise_selectall():
print("数据库查询广告位数据")
sql = 'select adv_img from t_advertise'
dbcursor.execute(sql)
advertise_data = dbcursor.fetchall()
# for i in range(len(advertise_data)):
# print(i)
# 关闭连接
# dbcursor.close()
# conn.close()
return advertise_data
# advertise_selectall()
def news_three_insert():
print("向新闻模板3表插入数据")
for i in range(len(news_three_title_Array)):
print(i)
# 定义sql语句
sql = 'INSERT INTO t_news_three ' \
'(news_three_title,news_three_img,news_three_source)VALUE(%s,%s,%s)'
# 组装参数
param = (natapp_url + scenic_url + news_three_title_Array[i],
news_three_img_Array[i], news_three_source_Array[i])
# 执行sql语句
dbcursor.execute(sql, param)
# 提交sql
conn.commit()
def goods_selectall():
print("数据库------->查询商品全部数据")
# 定义sql语句
sql = "select goods_img,goods_cart_img,goods_address,goods_name,goods_price,goods_introduce from t_goods"
# 使用了多线程，多线程共享了同一个数据库连接，但每个execute前没有加上互斥锁
# lock.acquire()
# 执行sql
dbcursor.execute(sql)
# lock.release()
# # 获取全部数据
goods_data = dbcursor.fetchall()
# 关闭连接
# dbcursor.close()
# conn.close()
# 返回数据
return goods_data
def videos_insert():
print("向视频表插入数据")
for i in range(len(videos_address_Array)):
print(i)
# 定义sql语句
sql = 'select videos_title,videos_price,videos_address from t_videos'
# 执行sql
videos_data = dbcursor.execute(sql)
return videos_data
def scenic_selectall():
# print("查询景点全部数据")
sql = 'select scenic_img,scenic_title,scenic_startdata,scenic_boarder,scenic_price from t_scenic'
# lock.acquire()
# 执行sql
dbcursor.execute(sql)
# lock.release()
# 获取数据
scenic_data = dbcursor.fetchall()
# 关闭游标对象
# dbcursor.close()
# 关闭连接对象
# conn.close()
# print(scenic_data)
# 返回景点所需要的数据
return (scenic_data)
def goods_insert():
print("向商品表插入数据")
for i in range(len(goods_img_Array)):
print(i)
# 定义sql语句
sql = 'INSERT INTO t_goods ' \
'(goods_img,goods_cart_img,goods_address,goods_name,goods_price,goods_introduce)VALUE(%s,%s,%s,%s,%s,%s)'
# 定义参数
param = (natapp_url + goods_url + goods_img_Array[i],
natapp_url + goods_url + goods_cart_img_Array[i],
goods_address_Array[i], goods_name_Array[i],
goods_price_Array[i], goods_introduce_Array[i])
# 执行sql
dbcursor.execute(sql, param)
# 提交
conn.commit()
# goods_insert()
# 遍历数据
for i in range(len(scenic_name_Array)):
# print(i)
# 定义sql语句
sql = 'INSERT INTO t_scenic ' \
'(scenic_img,scenic_title,scenic_startdata,scenic_boarder,scenic_price)VALUE(%s,%s,%s,%s,%s)'
# 组装参数
param = (natapp_url + scenic_url + scenic_name_Array[i],
scenic_title_Array[i], scenic_startdata_Array[i],
scenic_boarder_Array[i], scenic_price_Array[i])
# 执行sql语句
dbcursor.execute(sql, param)
# 提交sql
conn.commit()
# 景点表查询全部数据
def scenic_selectall():
print("查询景点全部数据")
sql = 'select * from t_scenic'
#执行sql
dbcursor.execute(sql)
#获取数据
scenic_data = dbcursor.fetchall()
