pycharm连接数据库

1、打开pycharm点击右边的database—‘+’—Data Sourse—MYSQL
在此页面下查看url连接的数据是否对应，然后点击下方的Test Connection进行安装
2、在file—settings中安装pyMYSQL
3、创建Django文件，名为goods_site
4、在Django新创建的文件夹goods中输入以下配置
goods/models.py

class user_info(models.Model):
    u_id=models.AutoField(primary_key=True,max_length=25)
    u_name=models.CharField(max_length=32)
    u_password=models.CharField(max_length=32)
    u_role=models.CharField(max_length=25)

goods/init.py

import pymysql
pymysql.install_as_MySQLdb()

goods_site/settings中DATABASES改为：

DATABASES = {
    'default': {
        # 'ENGINE': 'django.db.backends.sqlite3',
        # 'NAME': BASE_DIR / 'db.sqlite3',
        'ENGINE':'django.db.backends.mysql',
        'NAME':'mysql_django',      #SQLyog中需有此数据库
        'HOST':'localhost',
        'PORT':'3306',
        'USER':'root',
        'PASSWORD':'root',
    }
}

5、打开运行管理任务tools—Run manage.py
运行makemigrations goods
migrate goods
两个命令成功，sqlyom中对应的数据库的表中会出现内容，goods/migrations中出现0001_initias.py
6、在goods/views.py写入数据

from django.http import HttpResponse,JsonResponse
from django.views.decorators.csrf import csrf_exempt
from .models import *

#注册账号
def register(request):
    if request.method == 'POST' and request.POST:
        user=request.POST.get('user')
        pwd=request.POST.get('pwd')
        role=request.POST.get('role')
        if user and pwd and role:
            c = user_info.objects.filter(u_name=user).count()
            if c >= 1:
                return JsonResponse({'msg':'该用户已存在!','code':'300','data':{"name":user,"pwd":pwd}})
        # 把获取的参数写入数据库
        obj = user_info(u_name=user,u_password=pwd,u_role=role)
        obj.save()
        # 返回客户端
        res=({'code':'200','msg':'注册成功！','data':{"name":user,"pwd":pwd}})
        return JsonResponse(res)
    else:
        return JsonResponse({'msg':'注册失败！','code':'500'})

8、goods_site/urls.py

from django.urls import include

#在字典中加入
path('',include('goods.urls')),

9、goods/urls.py

from . import views

#在字典中加入
path('register/', views.register,name = 'register'),

10、在运行管理器执行runserver 127.0.0.1:8000
sqlyog中goods_user_info表会出现输入的内容
使用postman连接时，在body—form-data中写入参数

删除的接口

# 删除账号接口：根据姓名删除
def del_user(request):
    if request.method == "DELETE":
        try:
            user = request.GET.get('user')
            obj = user_info.objects.filter(u_name=user).count()
            if obj>=1:
                user_info.objects.filter(u_name=user).delete()
                return JsonResponse({"status":"200","msg":"删除"+user+"成功"})
            else:
                return JsonResponse({"status":"300","msg":user+"不存在！"})
        except user_info.DoesNotExist:
            return JsonResponse({"status":"400","msg":"信息错误，删除失败！"})