SQLAlchemy
from itemadapter import ItemAdapter
import pymysql
from sqlalchemy import create_engine
class QianChengWuYou4Pipeline :
def __init__ ( self) :
self. engine = create_engine( "mysql+pymysql://root:123456@localhost:3306/db5" )
def process_item ( self, item, spider) :
title= item[ 'title' ]
zhi_wei= item[ 'zhi_wei' ]
zhi_wei_name= item[ 'zhi_wei_name' ]
gong_si= item[ 'gong_si' ]
wei_zhi= item[ 'wei_zhi' ]
gong_zi= item[ 'gong_zi' ]
xue_li= item[ 'xue_li' ]
gong_zuo_jing_yan= item[ 'gong_zuo_jing_yan' ]
gong_si_xing_zhi= item[ 'gong_si_xing_zhi' ]
gong_si_gui_mo= item[ 'gong_si_gui_mo' ]
gang_wei_miao_shu= item[ 'gang_wei_miao_shu' ]
zhao_pin_ren_shu= item[ 'zhao_pin_ren_shu' ]
self. engine. execute(
"insert into zhao_pin(title, zhi_wei, zhi_wei_name, gong_si, wei_zhi, gong_zi, xue_li, gong_zuo_jing_yan, gong_si_xing_zhi, gong_si_gui_mo, gang_wei_miao_shu,zhao_pin_ren_shu) values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % ( title, zhi_wei, zhi_wei_name, gong_si, wei_zhi, gong_zi, xue_li, gong_zuo_jing_yan, gong_si_xing_zhi, gong_si_gui_mo, '' . join( gang_wei_miao_shu) , zhao_pin_ren_shu) )
print ( "插入成功!!!" )
return item
"""
use db5;
create table zhao_pin(
id int primary key auto_increment,
title varchar(255),
zhi_wei varchar(255),
zhi_wei_name varchar(255),
gong_si varchar(255),
wei_zhi varchar(255),
gong_zi varchar(255),
xue_li varchar(255),
gong_zuo_jing_yan varchar(255),
gong_si_xing_zhi varchar(255),
gong_si_gui_mo varchar(255),
gang_wei_miao_shu varchar(255),
zhao_pin_ren_shu varchar(255)
)
"""
pymysql
import pymysql
con = pymysql. connect( host= "127.0.0.1" , user= "root" , password= "123456" , database= "db5" , charset= "utf8" )
cur = self. con. cursor( )
cur. execute(
"insert into zhao_pin(title, zhi_wei, zhi_wei_name, gong_si, wei_zhi, gong_zi, xue_li, gong_zuo_jing_yan, gong_si_xing_zhi, gong_si_gui_mo, gang_wei_miao_shu,zhao_pin_ren_shu) values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % ( title, zhi_wei, zhi_wei_name, gong_si, wei_zhi, gong_zi, xue_li, gong_zuo_jing_yan, gong_si_xing_zhi, gong_si_gui_mo, '' . join( gang_wei_miao_shu) , zhao_pin_ren_shu) )
print ( "插入成功!!!" )
con. commit( )
cur. close( )
con. close( )
sqlalchemy
from sqlalchemy import create_engine
engine = create_engine( "mysql+pymysql://root:123456@localhost:3306/db5" )
self. engine. execute(
"insert into zhao_pin(title, zhi_wei, zhi_wei_name, gong_si, wei_zhi, gong_zi, xue_li, gong_zuo_jing_yan, gong_si_xing_zhi, gong_si_gui_mo, gang_wei_miao_shu,zhao_pin_ren_shu) values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % ( title, zhi_wei, zhi_wei_name, gong_si, wei_zhi, gong_zi, xue_li, gong_zuo_jing_yan, gong_si_xing_zhi, gong_si_gui_mo, '' . join( gang_wei_miao_shu) , zhao_pin_ren_shu) )
print ( "插入成功!!!" )