- 创建员工信息数据表;user (已创建过了)
- 定义模型Model类;进入myobject/myadmin/models.py;由于user表中id是自增的,所以不需要再定义
from django.db import models
from datetime import datetime
class User(models.Model):
username = models.CharField(max_length=50)
nickname = models.CharField(max_length=50)
password_hash = models.CharField(max_length=100)
password_salt = models.CharField(max_length=50)
status = models.IntegerField(default=1)
create_at = models.DateTimeField(default=datetime.now)
update_at = models.DateTimeField(default=datetime.now)
def toDict(self):
return {
'id': self.id, 'username': self.username, 'nickname': self.nickname, 'password_hash': self.password_hash,' password_salt': self.password_salt, 'status': self.status, 'create_at': self.create_at.strftime('%Y-%m-%d %H:%M:%S'), 'update_at': self.update_at.strftime('%Y-%m-%d %H:%M:%S')}
class Meta:
db_table = "user"
- 将myobject/myadmin/index.py 复制一份到当前路径,名称改为user.py(每个页面的视图单独管理),添加6个函数(增删改查操作)
from django.shortcuts import render
from django.http import HttpResponse
from myadmin.models import User