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