python : jdbc 连接 h2数据库，pandas 绘基金净值图

# -*- coding: cp936 -*-
import os, sys
import jaydebeapi
 
if len(sys.argv)==2:
    fund1 = sys.argv[1]
else:
    print ' usage: h2_jdbc_mpl.py fundcode'
    sys.exit(4)
 
if not ( fund1.isdigit() and len(fund1)==6):
    print ' fundcode is 6 位数字.'
    sys.exit(4)
 
url ='jdbc:h2:tcp://localhost/~/test'
user ='sa'
password =''
dirver ='org.h2.Driver'
jar ='/H2/bin/h2-1.3.jar'
##jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs)
conn =jaydebeapi.connect(dirver,url,[user,password],jar)
curs = conn.cursor()
 
select ="select MC from JJMC where DM=" + fund1
curs.execute(select)
fundname = curs.fetchall()
#print(fundname)
 
import pandas as pd
import pandas.io.sql as psql
 
query ="select RQ,JZ from JJJZ where DM=%s order by 1" % (fund1)
# dataFrame
df = psql.read_sql_query(query,conn)
 
curs.close()
conn.close()
 
import matplotlib.pyplot as plt
# 加这个两句 可以显示中文
plt.rcParams['font.sans-serif'] = [u'SimHei']
plt.rcParams['axes.unicode_minus'] = False
 
fname = fund1 + fundname[0][0] # 基金代码 + 基金名称 
# 基金净值绘图
df['JZ'].plot(figsize=(12,6), grid=True, title=fname)
# 画30日移动平均线  
pd.rolling_mean(df['JZ'], 30).plot(grid=True)
plt.show()