python中sql server数据库基本操作

先看代码

封装sql server类

在使用时，最好将数据库的基本操作封装成一个类，避免在使用时重复写代码
下面的代码，大家应该都能看懂

# -*- coding: UTF-8 -*-
import re,uuid
class mySqlserver:
    def __init__(self, serverIp, user, password, database):
        self.serverIp = serverIp
        self.user = user
        self.password = password
        self.database = database
        self.conn = None
        self.cursor = None
    # 获取连接
    def connect(self):
        import pymssql
        self.conn = pymssql.connect(self.serverIp, self.user, self.password, self.database)
        self.cursor = self.conn.cursor()
    def close(self):
        self.conn.close()
    def getRecord(self, sql_str):
        record = ""
        try:
            self.cursor.execute(sql_str)
            records = self.cursor.fetchall()
            for record in records:
                record = record[0]
                break
            return record
        except Exception:
            print(sql_str)
    def getAllRecord(self,sql_str):
        try:
            self.cursor.execute(sql_str)
            records = self.cursor.fetchall()
            return records
        except Exception:
            print(sql_str)
    def execute(self, sql_str):
        self.cursor.execute(sql_str)
    def commit(self):
        self.conn.cursor.commit()
    def insert(self, sql_str):
        try:
            self.execute(sql_str)
            self.commit()
        except Exception as e:
            print(sql_str)

使用方法

# -*- coding: UTF-8 -*-
if __name__ == '__main__':
	serverIp = "127.0.0.1"
    user = "sa"
    password = "123"
    database = "AIS20140120174606"
    mySql = mySqlserver(serverIp=serverIp, user=user, password=password, database=database)
    mySql.connect()
    sql_str = "insert into %s(%s) values(%s)" % ('ICBOMChild', columns, values_str)
   	mySql.insert(sql_str)
   	#使用完后，注意关闭数据库
   	mySql.close()