```python
import pymssql
def connect():
# connect = pymssql.connect(database = 'private') #服务器名,账户,密码,数据库名
# 连接本地的数据库只需要一个database 即可连接成功
# connect = pymssql.connect(
# # host='(local)', # 服务器名
# # user='wubang', # 用户
# # password='xxxxxx', # 密码
# database='private', # 数据库名
# # charset='utf8'
# )
# 连接远程数据库 需要的参数有四个
# connect = pymssql.connect('192.168.0.211','hrsys','hrsystem','ERAL')
connect = pymssql.connect(
host = '192.168.0.211',
user = 'hrsys',
password = 'xxxxx',
database = 'ERAL'
)
if connect:
print("连接成功!")
return connect
if __name__ == '__main__':
sql = '''select TOP 10 * from eemployee '''
connect = connect()
cursor = connect.cursor() # 创建一个游标对象,所有的sql语句都需要通过cursor来执行
cursor.execute(sql) #此处输入sql
rows = cursor.fetchall() #返回查询的结果
print(rows)
for row in rows:
print(row)
connect.commit() # 使用连接来提交,不是使用游标提交,注意!!!
cursor.close()
connect.close()