python mysql

import pymysql

# 打开数据库连接

conn = pymysql.connect(
    host="98.159..",user="sa",password="sa",database="mysjk", charset="utf8")

print(conn)
print(type(conn))
cursor_test = conn.cursor()

# 使用 execute() 方法执行 SQL，如果表存在则删除
#cursor_test.execute("DROP TABLE IF EXISTS EMPLOYEE")

# 使用预处理语句创建表
sql = """CREATE TABLE user1 (
         FIRST_NAME  CHAR(20) NOT NULL,
         LAST_NAME  CHAR(20),
         AGE INT,  
         SEX CHAR(1),
         INCOME FLOAT )"""
def charu():
    #cursor_test.execute(sql)
    sql = """INSERT INTO user1(FIRST_NAME,
             LAST_NAME, AGE, SEX, INCOME)
             VALUES ('Feia', 'Feia', 20, 'M', 1000)"""

    try:
       # 执行sql语句
       cursor_test.execute(sql)
       # 提交到数据库执行
       conn.commit()
    except:
       # 如果发生错误则回滚
       conn.rollback()
# 关闭数据库连接

def xianshi():
    sql = """
    select * from user1"""

    try:
        # 执行 sql 语句
        cursor_test.execute(sql)
        # 显示出所有数据
        data_result = cursor_test.fetchall()
        for row in data_result:
            fname = row[0]
            lname = row[1]
            age = row[2]
            sex = row[3]
            income = row[4]
            # 打印结果
            print("fname=%s,lname=%s,age=%s,sex=%s,income=%s" % \
                  (fname, lname, age, sex, income))
    except:
        print("Error: unable to fetch data")
def xiugai():
    sql = "UPDATE user1 SET AGE = AGE + 1 WHERE SEX = '%c'" % ('M')

    try:
        # 执行SQL语句
        cursor_test.execute(sql)
        # 提交到数据库执行
        conn.commit()
    except:
        # 发生错误时回滚
        conn.rollback()
        
def shanchu():
    sql = "DELETE FROM user1"

    try:
        # 执行SQL语句
        cursor_test.execute(sql)
        # 提交到数据库执行
        conn.commit()
    except:
        # 发生错误时回滚
        conn.rollback()
        
xianshi()
conn.close()