1、创建数据库和数据表
使用数据库客户端生成一个sqlite3数据库文件,生成用户表:
create table SYS_USER (
USER_CODE VARCHAR(36) not null,
LOGIN_NAME VARCHAR(50) not null,
LOGIN_PWD VARCHAR(50) not null,
USER_NAME VARCHAR(50) not null
);
2、修改数据库配置
修改“settings.py”配置文件中的数据库参数:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
#'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
'NAME': os.path.join(BASE_DIR, 'website_python.s3db'),
}
}
3、生成 models
第一步,运行 cmd 并切换到“D:\Workspaces\Website\website_python”目录
第二步,执行如下命令:python manage.py inspectdb
第三步,将执行后生成的代码复制到 manage/models.py 中,大概如下:
class SysUser(models.Model):
user_code = models.CharField(db_column='USER_CODE', primary_key=True, max_length=36) # Field name made lowercase.
login_name = models.CharField(db_column='LOGIN_NAME', max_length=50) # Field name made lowercase.
login_pwd = models.CharField(db_column='LOGIN_PWD', max_length=50) # Field name made lowercase.
user_name = models.CharField(db_column='USER_NAME', max_length=50) # Field name made lowercase.
class Meta:
managed = False
db_table = 'SYS_USER'
4、创建视图代码
在website_python/manage下创建文件“enter.py”,内容如下:
#coding:utf-8
from django.shortcuts import render
from django.http import HttpResponse
from manage.models import SysUser
# Create your views here.
def index(request):
html = '测试结果如下:';
# 查询总数
old_count = SysUser.objects.count();
html += "<br/>操作前数据总数:" + str(old_count);
html += "<br/>--------------------------------------------------------";
# 新增数据
new_user = SysUser()
new_user.user_code = "10_" + str(old_count + 1)
new_user.login_name = "zhangsan" + str(old_count)
new_user.login_pwd = "123456"
new_user.user_name = "张三" + str(old_count)
new_user.save()
# 查询总数
new_count = SysUser.objects.count();
html += "<br/>新增后数据总数:" + str(new_count);
html += "<br/>--------------------------------------------------------";
# 读取一条数据
read_user = SysUser.objects.get(user_code = new_user.user_code)
html += "<br/>10 用户登录名:" + read_user.login_name + ",姓名:" + read_user.user_name
html += "<br/>--------------------------------------------------------";
# 读取一条数据
read_user.user_name = read_user.user_name + '_修改'
read_user.save()
update_user = SysUser.objects.get(user_code = read_user.user_code)
html += "<br/>10 用户登录名:" + update_user.login_name + ",修改后姓名:" + update_user.user_name
html += "<br/>--------------------------------------------------------";
# 删除一条数据
SysUser.objects.get(user_code = read_user.user_code).delete()
# 查询总数
delete_count = SysUser.objects.count();
html += "<br/>删除后数据总数:" + str(delete_count);
html += "<br/>--------------------------------------------------------";
return HttpResponse(html)
5、修改路由
修改website_python/website_python/urls.py,首先导入模块:
from manage.enter import index as enter_index
然后增加路由:
('^manage/enter/index/$', enter_index),
6、访问测试结果
启动服务器,访问:http://127.0.0.1:8000/manage/enter/index/,结果如下: