python sqlserver 完整的例子

来源：互联网发布：mate7电信没有4g 网络编辑：程序博客网时间：2024/05/17 22:53

import pymssqlSQLSERVER = '10.19.1.50'USER = 'sa'PASSWORD = '123'DATABASE = 'GuBei_Data'g_Conn = Nonedef openDB():    global g_Conn    g_Conn = pymssql.connect(host=SQLSERVER,user=USER,password=PASSWORD,database=DATABASE)def closeDB():    global g_Conn    g_Conn.close()def query(sql):    try:        openDB()        global g_Conn        cursor = g_Conn.cursor()        cursor.execute(sql)        rows = cursor.fetchall()        return rows    except Exception,e:        print e    finally:        closeDB()def insert(sql):    try:        openDB()        global g_Conn        cursor = g_Conn.cursor()        cursor.execute(sql)        g_Conn.commit()    except Exception,e:        g_Conn.rollback()        print e    finally:        closeDB()def insert_many(sql, params):    try:        openDB()        global g_Conn        cursor = g_Conn.cursor()        for param in params:            sql_temp = sql % param            cursor.execute(sql_temp)        g_Conn.commit()        return True    except Exception,e:        g_Conn.rollback()        print e    finally:        closeDB()

import bag.sqlserver as sqlreload(bag.sqlserver)sql.insert("INSERT INTO tblComment([ID],[Number],[visitor],[comments]) VALUES(5,'view3','youke4','very done')")sqlstr="INSERT INTO tblComment([ID],[Number],[visitor],[comments]) VALUES(%d,'%s','%s','%s')"data=[(6,'view3','youke4','very done'),(7,'view3','youke4','very done')]sql.insert_many(sqlstr,data)sql.insert("delete from tblComment where id=5 or id=6 or id=7")print sql.query("select * from tblComment")

0 0