python连接MySQL(sqlserver)查询及端口检测

python连接mysql数据库

import MySQLdb##导入模块
con=MySQLdb.connect(host="172.100.4.2",user="gj",passwd="xbrother",db="historyver1",charset="utf8")
cur = con.cursor(）##获取游标
cur.execute("select device_id,descr,event_time,event_level,is_confirm FROM t_event where event_level >= '5' limit 1")##execute()执行sql语句
1L
alldata = cur.fetchone()##fetchone()获取sql查询结果
print alldata##查看获取的结果
(u'S0E222', u'\u672c\u5730\u5173\u673a\u72b6\u6001\uff1a\u5426', datetime.datetime(2018, 10, 29, 11, 5, 35), 5L, 0)

cur.execute(‘update service_jmetertask set result=%s where do_number=%s and testcase_id=%s’, (result, do_number, testcase_id))##查询引入变量

• limit的用法

SELECT * FROM table LIMIT 5,10; // 检索记录行 6-15
SELECT * FROM table LIMIT 95,-1; // 检索记录行 96-last
SELECT * FROM table LIMIT 5; //检索前 5 个记录行

python连接sqlserver

import pymssql
con = pymssql.connect(host=r'172.100.13.2',user=r'sa',password='10jqka@123',database=r'EVENT',charset="utf8")
cur=con.cursor()
cur.execute('select top 1 * from Table_1')##获取前1条数据
data = cur.fetchall()

端口检测

import socket
sk = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
sk.settimeout(1)
try:
     sk.connect((‘ip’,3306))
     print 'Server port 3306 OK!'
 except Exception:
     print 'Server port 3306 not connect!'
 sk.close()