关于Python链接数据库。

MySQL代码：

CREATE DATABASE PythonDB;
USE PythonDB;
CREATE TABLE users
(
uid INT PRIMARY KEY AUTO_INCREMENT COMMENT "编号",
username VARCHAR(20) NOT NULL COMMENT "用户名",
pwd VARCHAR(20) NOT NULL COMMENT "密码"
);

导入mysql模块

方式1：
win+r进入黑窗口
输入：pip3 install pymsql
方式2：
在pycharm编译器中：pycharm->File->Settings->Project Interpreter->设置。

Python—新增

import  pymysql;
try:
    conn = pymysql.connect(host="localhost", user="root", password="123456", db="Pythondb", charset="utf8");
    cur = conn.cursor();
    n=cur.execute("insert into users values(default,'admin','123456')");
    conn.commit();
    print(n);
except Exception as e:
    conn.rollback();
    print(e)
finally:
    cur.close()
    conn.close()

Python—修改

import  pymysql;
try:
    conn = pymysql.connect(host="localhost", user="root", password="123456", db="Pythondb", charset="utf8");
    cur = conn.cursor();
    n=cur.execute("update users set pwd='111111' where username='admin'");
    conn.commit();
    print(n);
except Exception as e:
    conn.rollback();
    print(e)
finally:
    cur.close()
    conn.close()

Python—删除

import  pymysql;
try:
    conn = pymysql.connect(host="localhost", user="root", password="123456", db="Pythondb", charset="utf8");
    cur = conn.cursor();
    n=cur.execute("delete from users where username='admin'");
    conn.commit();
    print(n);
except Exception as e:
    conn.rollback();
    print(e)
finally:
    cur.close()
    conn.close()

Python—查询

import  pymysql;
try:
    conn = pymysql.connect(host="localhost", user="root", password="123456", db="Pythondb", charset="utf8");
    cur = conn.cursor();
    cur.execute("select * from users");
    list1 =cur.fetchall()
    print(list1);
except Exception as e:
    conn.rollback();
    print(e)
finally:
    cur.close()
    conn.close()