用python中pymssql写一个连接数据库,若链接失败则给一个默认的空值的代码
时间: 2024-05-02 15:22:43 浏览: 7
可以使用以下代码连接数据库,并在连接失败时返回空值。
```python
import pymssql
# Define the connection parameters
server = 'your_server_name'
database = 'your_database_name'
username = 'your_username'
password = 'your_password'
try:
# Connect to the database
conn = pymssql.connect(server, username, password, database)
# Perform your database operations here...
# Close the connection when done
conn.close()
except pymssql.DatabaseError:
# Handle connection failure by returning empty value
conn = None
```