pythonDjango连接MySQL数据库做增删改查

DATABASES = {
 'default': {
 'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
 'NAME': 'djangodb', # Or path to database file if using sqlite3.
 # The following settings are not used with sqlite3:
 'USER': 'root',
 'PASSWORD': 'root',
 'HOST': '127.0.0.1', # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP.
 'PORT': '3306', # Set to empty string for default.
 }
}

>>> from django.db import connection
>>> cursor = connection.cursor()

products/
 __init__.py
 models.py
 tests.py
 views.py

from django.db import models
# Create your models here.
class Company(models.Model):
 full_name = models.CharField(max_length=30)
 address = models.CharField(max_length=50)
 tel = models.CharField(max_length=15,blank=True)
class Product(models.Model):
 product_name = models.CharField(max_length=30)
 price = models.FloatField()
 stock = models.IntegerField(max_length=5)
 company = models.ForeignKey(Company)

INSTALLED_APPS = (
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 # Uncomment the next line to enable the admin:
 'django.contrib.admin',
 # Uncomment the next line to enable admin documentation:
 'django.contrib.admindocs',
 'DjangoMysqlSite.products',
)

from DjangoMysqlSite.products.models import Company
>>> c = Company(full_name='集团',address='杭州西湖',tel=889)
>>> c.save()

>>> company_list = Company.objects.all()
>>> company_list

>>> c = Company.objects.get(full_name="集团")
>>> c.tel = 123456
>>> c.save()
 
>>> c = Company.objects.get(full_name="集团")
>>> c.delete()
#删除所有
>>> Company.objects.all().delete()