matplotlib画图和时间的转换

# coding:utf-8
import pymssql
import matplotlib.pyplot as plt

plt.rcParams['font.sans-serif'] = ['SimHei']
plt.rcParams['axes.unicode_minus'] = False

x = [1, 2, 3, 4]
y = [1.2, 2.5, 4.5, 7.3]

# plt.plot(x, y, color="r", linestyle="--", marker="*", linewidth=1.0)
#
# plt.show()

# 创建连接

server = "localhost"
user = "sa"
password = "123"
database = "ChaoShi"

conn = pymssql.connect(server, user, password, database)
# 打开链接
cursor = conn.cursor()

cmdText = 'select  goodsClass 名称,count(*)数量 from sales,smlGoods,Profit ' \
          'where sales.goodsID=smlGoods.goodsID and sales.orderNum=Profit.orderNum ' \
          'group by smlGoods.goodsClass '
cursor.execute(cmdText)
goodClass = []
gNum = []
for row0, row1 in cursor:
    row0 = row0.replace(' ', '')
    goodClass.append(row0)
    gNum.append(row1)

cursor.close()
conn.close()
plt.plot(goodClass, gNum, color="r", linestyle="-", marker="*", linewidth=1.0)
plt.xlabel('大类编号')
plt.ylabel('截止到当前的商品销售量')
plt.xticks([i for i in goodClass], [str(i) + "类" for i in goodClass])
plt.yticks([j for j in gNum])
plt.show()
print(goodClass)

在用pymssql连接数据库时首先要将sql server browser服务打开

然后再将TCP/IP协议启用。

哈哈哈，昨天忘写了，今天一早补上！！