How to use Pycharm to connect to SQL Server (detailed tutorial)

• SQL Sever
• 1433
• pycharm

create database soft2104

use master --drop database soft2104 -- 

pip install pymssql

import pymssql connect = pymssql.connect(host='localhost',server='LAPTOP-40O6HVDS', port='1433',user='yunmengze', password= '123456', database='soft2104')  # host,server, port,user, password, databaseif connect:

import pymssqlconnect = pymssql.connect(host='localhost',server='LAPTOP-40O6HVDS', port='1433',user='yunmengze', password= '123456', database='soft2104',charset="GBK")  # host,server, port,user, password, database,charsetif connect:    print("")else:    print("")

/*select @@SERVERNAME--select SERVERPROPERTY('ServerName')--*/sp_helpserver    ----oldservernamesp_dropserver 'oldservername' --newservernamesp_addserver 'newservername','local' --newservernamesp_serveroption 'newservername', 'data access', 'on'--oldservernamenewservername

bulk insert soft2110 --txtsoft2110from 'd:2104.txt'   --txtDANSIwith(fieldterminator = 't',rowterminator = 'n')         --tn

use soft2104create table soft2110(xh int,dp nchar(20),pr nchar(20),id nchar(30),nm nchar(20))

drop table soft2110

use soft2104drop table soft2110create table soft2110(xh int,dp nchar(20),pr nchar(20),id nchar(30),nm nchar(20)) bulk insert soft2110 --txt textfrom 'd:2104.txt'with(fieldterminator = 't',rowterminator = 'n')--tdelete from soft2110 where xh=71

cur = connect.cursor()sqlstr = "select * from soft2110"cur.execute(sqlstr)data = cur.fetchall()cur.close()for i in range(len(data)):    for t in range(len(data[i])):        print(str(data[i][t]).strip(), end='  ')    print('r')connect.close()

print("  2204  349849848  ")add = input('    ':')try:    cur = connect.cursor()    sqlstr = "select * from soft2110"    cur.execute(sqlstr)    data = cur.fetchall()    sqlstr = f"select * from soft2110 where id = '{add[2]}'"    cur.execute(sqlstr)    acc = cur.fetchall()    if acc:        print("")        return    try:        sqlstr =f"insert into soft2110 values ({len(data) + 1},'{add[0]}','{add[1]}','{add[2]}','{add[3]}')"        # print(sqlstr)        cur.execute(sqlstr)        connect.commit()        print("")    except:        print("")    cur.close()    connect.close()except:    print("")

sqlstr = f"select * from soft2110 where id = '{add[2]}'"

de = input(':')

sqlstr = f"delete from soft2110 where id = '{de}'"

def delete(connect, de):    cur = connect.cursor()    sqlstr = f"select * from soft2110 where id = '{de}'"    cur.execute(sqlstr)    acc = cur.fetchall()    if acc:        sqlstr = f"delete from soft2110 where id = '{de}'"        cur.execute(sqlstr)        connect.commit()        cur.close()        print("")    else:        print("")        cur.close()    returnde = input(':')try:    delete(connect, de)except Exception as e:    print(f"Error: {e}")