python连接plc实例_Python连接数据库MySQL与操作示例

安装pyMySQL>> pip install pyMySQL

数据连接示例#! /usr/bin/env python

# -*- coding: utf-8 -*-

"""

@author: Oscar

@file: gen_random_db

@time: 2018/11/19 14:15

"""

import string

import random

import pymysql

def gen_rand_str():

str_digits = string.digits

str_letters = string.ascii_letters

rand_str = str_digits + str_letters

rand_str = random.sample(rand_str, 10)

return ''.join(rand_str)

def db_conn():

conn = pymysql.connect("192.168.0.5", "admin", "admin", "test")

return conn

def handle_table(conn, table_name):

try:

cursor = conn.cursor() # 获取数据库游标

sql = "select id, random_code from " + table_name + " where random_code is null&#