settings.py设置了数据库连接
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.oracle',
'NAME': 'orcl',
'USER':'NCTEST',
'PASSWORD':'NCTEST',
'HOST':'192.168.0.252',
'PORT':'1521'
}
}
然后在views.py中引入
from django.db import connection
并执行语句
def get_data(req):
#从前端获取查询参数
start_date = req.GET['startdate']
end_date = req.GET['enddate']
pk_org = req.GET['orglist']
print(start_date)
print(end_date, pk_org)
# 建立游标
cur = connection.cursor()
#获取当前时间
date_now = datetime.datetime.now()
aaa = []
#获取查询SQL语句
sql_str=get_sql(start_date, end_date, pk_org)
#执行查询
cur.execute(sql_str)
print(cur.execute(sql_str))
#获取所有查询结果集
data_ye = cur.fetchall()
print(data_ye)
cur.close()
获取的结果是:
得到的结果集为空,请教一下怎么回事?