基于Django的用户管理系统

基于MVC架构。 

view代码处理url请求，并调用model代码返回数据到页面

template代码显示页面

配置urls中view和url处理关系

model代码读取数据库数据

template代码控制显示数据

 

1. models.py

#encoding: utf-8

import json

from django.db import models

from .dbutils import DBConnection

class User(object):
    SQL_LOGIN = '''
                SELECT id,name,age,tel,sex 
                FROM user2 
                where name=%s and password=%s LIMIT 1;
            '''

    SQL_LIST = '''
                    SELECT id,name,age,tel,sex
                    FROM user2
                '''
    SQL_GET_BY_ID = '''
                        SELECT id,name,age,tel,sex
                        FROM user2
                        WHERE id=%s
                   '''

    SQL_GET_BY_NAME = '''
                        SELECT id,name,age,tel,sex
                        FROM user2
                        WHERE name=%s
                    '''

    SQL_UPDATE = '''
                    UPDATE user2
                    SET name=%s,
                        age=%s,
                        tel=%s,
                        sex=%s
                    WHERE id=%s
                '''

    SQL_DELETE = '''
                    DELETE FROM user2 WHERE id=%s
                '''

    SQL_CREATE = '''
                    INSERT INTO user2(name, password, age, tel, sex)
                        VALUES(%s, %s, %s, %s, %s)
                '''

    def __init__(self, id=None, name='', age=0, tel='', sex=1, password=''):
        self.id = id
        self.name = name
        self.age = age
        self.tel = tel
        self.sex = sex
        self.password = password


    @classmeth