python 怎么表示sqlserver null_关于Python连接SQLServer

1、通过pip在Python中安装SQLServer的驱动程序。

在cmd命令中输入：python -m pip install pymssql

2、建立数据库以及测试表。

--drop database test;

create database test;

use test;

create table app_users (

user_id int identity(1,1) not null,

user_code varchar(60) not null,

user_name varchar(256) null,

primary key(user_id)

);

insert into app_users(user_code, user_name) values('9001', 'jzh');

insert into app_users(user_code, user_name) values('9002', 'chanpinxue.cn');

insert into app_users(user_code, user_name) values('9003', 'chanpinxue.cn');

3、测试代码

#coding=utf-8

# 测试SQLServer

import pymssql

class cts_mssql():

def query():

try:

conn = pymssql.connect(host="127.0.0.1:1433", user="sa", password="", database="test", charset="utf8")

except mysql.connector.Error as e:

print('连接失败{}'.format(e))

cursor = conn.cursor()

try:

# 查询

sql_query = 'select user_code, user_name from app_users'

cursor.execute(sql_query)

for user_code, user_name in cursor:

print(user_code, user_name)

except pymssql.connector.Error as e:

print('查询异常{}'.format(e))

finally:

cursor.close()

conn.close()

# if __name__ == '__main__'的意思是：

# 当.py文件被直接运行时，if __name__ == '__main__'之下的代码块将被运行；

# 当.py文件以模块形式被导入时，if __name__ == '__main__'之下的代码块不被运行。

if __name__ == '__main__':

cts_mssql.query()