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 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 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 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)