項(xiàng)目創(chuàng)建略,可參考Python Django Vue 項(xiàng)目創(chuàng)建。
目錄結(jié)構(gòu)如下
編輯views.py
from django.shortcuts import render
# Create your views here.
from django.http import HttpResponse
from django.shortcuts import render
from common.DBHandle import DataBaseHandle
import time
def djangoHello(request):
return HttpResponse('Hello Django!')
def index(request):
return render(request,'index.html')
def login(request):
print('login_func')
usn = request.POST['username']
pwd = request.POST['password']
host = '127.0.0.1'
username = 'username'
password = 'password'
database = 'dbname'
port = 3306
# 實(shí)例化 數(shù)據(jù)庫 連接
DbHandle = DataBaseHandle(host, username, password, database, port)
localTime = time.localtime(time.time())
create_time = time.strftime("%Y-%m-%d %H:%M:%S", localTime)
sql = "insert into user(username,password,create_time) values ('%s','%s','%s')" % (usn, pwd, create_time)
DbHandle.insertDB(sql)
DbHandle.closeDb()
return render(request,'login.html')
接下來編輯urls.py
"""FirstWeb URL Configuration
The `urlpatterns` list routes URLs to views. For more information please see:
https://docs.djangoproject.com/en/2.1/topics/http/urls/
Examples:
Function views
1. Add an import: from my_app import views
2. Add a URL to urlpatterns: path('', views.home, name='home')
Class-based views
1. Add an import: from other_app.views import Home
2. Add a URL to urlpatterns: path('', Home.as_view(), name='home')
Including another URLconf
1. Import the include() function: from django.urls import include, path
2. Add a URL to urlpatterns: path('blog/', include('blog.urls'))
"""
from django.contrib import admin
from django.urls import path
from fistWeb import views
urlpatterns = [
path('admin/', admin.site.urls),
path('hello/',views.djangoHello),
path('index/',views.index),
path('login/',views.login),
]
在應(yīng)用下創(chuàng)建templates 文件夾
并創(chuàng)建html文件 index.html
FirstWeb
信息注冊(cè)
login.html
FirstWeb-登錄
您好,您已注冊(cè)成功!
介紹一下添加的common文件
添加一個(gè)數(shù)據(jù)庫封裝的類。
# FileName : DBHandle.py
# Author : Adil
# DateTime : 2018/11/29 2:03 PM
# SoftWare : PyCharm
import pymysql
# username : adil
# password : helloyyj
class DataBaseHandle(object):
''' 定義一個(gè) MySQL 操作類'''
def __init__(self,host,username,password,database,port):
'''初始化數(shù)據(jù)庫信息并創(chuàng)建數(shù)據(jù)庫連接'''
# 下面的賦值其實(shí)可以省略,connect 時(shí) 直接使用形參即可
self.host = host
self.username = username
self.password = password
self.database = database
self.port = port
self.db = pymysql.connect(self.host,self.username,self.password,self.database,self.port,charset='utf8')
# 這里 注釋連接的方法,是為了 實(shí)例化對(duì)象時(shí),就創(chuàng)建連接。不許要單獨(dú)處理連接了。
#
# def connDataBase(self):
# ''' 數(shù)據(jù)庫連接 '''
#
# self.db = pymysql.connect(self.host,self.username,self.password,self.port,self.database)
#
# # self.cursor = self.db.cursor()
#
# return self.db
def insertDB(self,sql):
''' 插入數(shù)據(jù)庫操作 '''
self.cursor = self.db.cursor()
try:
# 執(zhí)行sql
self.cursor.execute(sql)
# tt = self.cursor.execute(sql) # 返回 插入數(shù)據(jù) 條數(shù) 可以根據(jù) 返回值 判定處理結(jié)果
# print(tt)
self.db.commit()
print('執(zhí)行成功')
except:
# 發(fā)生錯(cuò)誤時(shí)回滾
self.db.rollback()
print('執(zhí)行失敗')
finally:
self.cursor.close()
def deleteDB(self,sql):
''' 操作數(shù)據(jù)庫數(shù)據(jù)刪除 '''
self.cursor = self.db.cursor()
try:
# 執(zhí)行sql
self.cursor.execute(sql)
# tt = self.cursor.execute(sql) # 返回 刪除數(shù)據(jù) 條數(shù) 可以根據(jù) 返回值 判定處理結(jié)果
# print(tt)
self.db.commit()
except:
# 發(fā)生錯(cuò)誤時(shí)回滾
self.db.rollback()
finally:
self.cursor.close()
def updateDb(self,sql):
''' 更新數(shù)據(jù)庫操作 '''
self.cursor = self.db.cursor()
try:
# 執(zhí)行sql
self.cursor.execute(sql)
# tt = self.cursor.execute(sql) # 返回 更新數(shù)據(jù) 條數(shù) 可以根據(jù) 返回值 判定處理結(jié)果
# print(tt)
self.db.commit()
except:
# 發(fā)生錯(cuò)誤時(shí)回滾
self.db.rollback()
finally:
self.cursor.close()
def selectDb(self,sql):
''' 數(shù)據(jù)庫查詢 '''
self.cursor = self.db.cursor()
try:
self.cursor.execute(sql) # 返回 查詢數(shù)據(jù) 條數(shù) 可以根據(jù) 返回值 判定處理結(jié)果
data = self.cursor.fetchall() # 返回所有記錄列表
print(data)
# 結(jié)果遍歷
for row in data:
sid = row[0]
name = row[1]
# 遍歷打印結(jié)果
print('sid = %s, name = %s'%(sid,name))
except:
print('Error: unable to fecth data')
finally:
self.cursor.close()
def closeDb(self):
''' 數(shù)據(jù)庫連接關(guān)閉 '''
self.db.close()
if __name__ == '__main__':
DbHandle = DataBaseHandle('127.0.0.1','username','password','dbname',3306)
sql = "insert into JdwSpider(image_name,image_url,Spider_time) values ('%s','%s','%s')" % (
'1', '2', '2018-12-04 15:25:21')
DbHandle.insertDB(sql)
# DbHandle.insertDB('insert into test(name) values ("%s")'%('FuHongXue'))
# DbHandle.insertDB('insert into test(name) values ("%s")'%('FuHongXue'))
# DbHandle.selectDb('select * from test')
# DbHandle.updateDb('update test set name = "%s" where sid = "%d"' %('YeKai',22))
# DbHandle.selectDb('select * from test')
# DbHandle.insertDB('insert into test(name) values ("%s")'%('LiXunHuan'))
# DbHandle.deleteDB('delete from test where sid > "%d"' %(25))
# DbHandle.selectDb('select * from test')
DbHandle.closeDb()
以上代碼實(shí)現(xiàn)了一個(gè)簡單的注冊(cè)頁面,并將注冊(cè)信息存放到數(shù)據(jù)庫表中。
啟動(dòng)項(xiàng)目演示
打開瀏覽器輸入url:http://127.0.0.1:8000/index/
點(diǎn)擊注冊(cè)提交按鈕,頁面跳轉(zhuǎn)如下
查看數(shù)據(jù)庫表,可以看到新增的用戶信息。
以上就是本文的全部內(nèi)容,希望對(duì)大家的學(xué)習(xí)有所幫助,也希望大家多多支持腳本之家。
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索:z360901061
微信掃一掃加我為好友
QQ號(hào)聯(lián)系: 360901061
您的支持是博主寫作最大的動(dòng)力,如果您喜歡我的文章,感覺我的文章對(duì)您有幫助,請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點(diǎn)擊下面給點(diǎn)支持吧,站長非常感激您!手機(jī)微信長按不能支付解決辦法:請(qǐng)將微信支付二維碼保存到相冊(cè),切換到微信,然后點(diǎn)擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對(duì)您有幫助就好】元

