[root@yyjk DATABASE]# cat DBI.py
# -*- coding: utf-8 -*-
import cx_Oracle
import time
import datetime
class DBI (object):
def LoadDB(self,a,b):
print self
conn = cx_Oracle.connect('tlcbuser/tlcbuser@1.1.1.1/tlyy')
cursor = conn.cursor()
#coding:UTF-8
#获取当前时间
time_now = int(time.time())
#转换成localtime
#time_local = time.localtime(time_now)
#print time_local
#dt = time.strftime("%Y-%m-%d %H:%M:%S",time_local)
dt=datetime.datetime.now()
print dt
param={'stime':dt,'message':a,'phone':b}
print param;
cursor.execute('insert into tlcb_python_sms values(:stime,:message,:phone)',param)
conn.commit()
cursor.close
python 插入时间到oracle
SQL> desc tlcb_python_sms
Name Null? Type
----------------------------------------- -------- ----------------------------
STIME
python 插入日期数据到Oracle
最新推荐文章于 2024-05-06 11:33:47 发布