# -*- coding: utf-8 -*-
import adodbapi
import time
connectString='Provider=SQLOLEDB.1;Persist Security Info=True;' \
'Password=123;User ID=sa;Initial Catalog=IRAPDWforCIMS;'\
'Data Source=122.192.11.1'
conn = adodbapi.connect(connectString)
f = open("C:\\testdata\\target\\new2.jpg", 'rb')
b = f.read()
f.close()
#写入图片
cursor = conn.cursor()
"""cursor.execute("INSERT INTO utb_log_PWOPrint (T102LeafID,T124LeafID,StartWorkSheet,PWOStatistic) VALUES (?,?,?,?)",
(123453,10051,adodbapi.Binary(b),adodbapi.Binary(b),))
"""
cursor.execute("update utb_log_PWOPrint set PWOStatistic=? ",
(adodbapi.Binary(b),))
conn.commit();
print 'picture save.'
#读取图片
cursor.execute("SELECT TOP 1 StartWorkSheet,PWOStatistic FROM utb_log_PWOPrint ORDER BY T102LeafID DESC")
d = cursor.fetchone()[0]
cursor.close()
f = open("C:\\dst.bmp", "wb")
f.write(d)
f.close()
print 'read picture.'
import adodbapi
import time
connectString='Provider=SQLOLEDB.1;Persist Security Info=True;' \
'Password=123;User ID=sa;Initial Catalog=IRAPDWforCIMS;'\
'Data Source=122.192.11.1'
conn = adodbapi.connect(connectString)
f = open("C:\\testdata\\target\\new2.jpg", 'rb')
b = f.read()
f.close()
#写入图片
cursor = conn.cursor()
"""cursor.execute("INSERT INTO utb_log_PWOPrint (T102LeafID,T124LeafID,StartWorkSheet,PWOStatistic) VALUES (?,?,?,?)",
(123453,10051,adodbapi.Binary(b),adodbapi.Binary(b),))
"""
cursor.execute("update utb_log_PWOPrint set PWOStatistic=? ",
(adodbapi.Binary(b),))
conn.commit();
print 'picture save.'
#读取图片
cursor.execute("SELECT TOP 1 StartWorkSheet,PWOStatistic FROM utb_log_PWOPrint ORDER BY T102LeafID DESC")
d = cursor.fetchone()[0]
cursor.close()
f = open("C:\\dst.bmp", "wb")
f.write(d)
f.close()
print 'read picture.'