import pandas as pd
import pymysql as mysql

#1.connect to database ch09
conn = mysql.connect(host='localhost',user='root',password='',db='ch09',charset='utf8')

#2.search(query) the datatable
df = pd.read_sql_query('select * from books', con=conn)

#3.print top 5
print(df.head(5))
print(df[0:5])

#4.draw the curve from df(dataframe)
import matplotlib.pyplot as plt
df.plot(x='書籍編號',y='價格',color='green',grid=True)