连接的方法有俩种:
第一种:
import pymysql
class kuwomusic(object):
def __init__(self):
self.host ='IP'
self.port =3306
self.user = '用户名'
self .passwd ='密码'
self.db ='数据库名字'
self.conn =pymysql.connect(
host =self.host,
port =self.port,
user =self.user,
passwd =self.passwd,
db =self.db,
charset='utf8'
)
def findMusicById(self,id_music):
cur = self.conn.cursor()
sql ="select * from kuwo_music where id=%s"
cur.execute(sql,id_music)
data = cur.fetchall()
print(data)
self.conn.close()
return data
def findMusicByArtist(self,artist_music):
cur = self.conn.cursor()
sql ="select * from kuwo_music where artist like %s"
cur.execute(sql,artist_music)
data = cur.fetchall()
print(len(data))
self.conn.close()
简单的测试一下:
看样子连接MySQL和方法都成功了
但是,大家也能看出来,这种连接MySQL的方法有些繁琐,于是第二种方法来了
第二种:
#导入
import pymysql
import pandas as pd
from sqlalchemy import create_engine
#连接mysql
engine = create_engine('mysql+pymysql://登录名:密码@IP:3306/数据库名')
这也太精简了吧,所以说python方便,只要导入一下库,你就可以拥有这些方法
同样,我们也来测试一下是否连接成功:
OK,看起来还不错噢