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
 # 實例化 數據庫 連接
 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')
          

            
"""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),
]
          

            
            
            

              信息注冊
            
                        

              
  {% csrf_token %}
 用戶名：
              
              

              
 密 碼：
              
              

              
            
          

            
            
            

              您好，您已注冊成功！
            
          

            
# FileName : DBHandle.py
# Author : Adil
# DateTime : 2018/11/29 2:03 PM
# SoftWare : PyCharm
import pymysql
# username : adil
# password : helloyyj
class DataBaseHandle(object):
 ''' 定義一個 MySQL 操作類'''
 def __init__(self,host,username,password,database,port):
 '''初始化數據庫信息并創建數據庫連接'''
 # 下面的賦值其實可以省略，connect 時 直接使用形參即可
 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')
 # 這里 注釋連接的方法，是為了 實例化對象時，就創建連接。不許要單獨處理連接了。
 #
 # def connDataBase(self):
 # ''' 數據庫連接 '''
 #
 # 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):
 ''' 插入數據庫操作 '''
 self.cursor = self.db.cursor()
 try:
  # 執行sql
  self.cursor.execute(sql)
  # tt = self.cursor.execute(sql) # 返回 插入數據 條數 可以根據 返回值 判定處理結果
  # print(tt)
  self.db.commit()
  print('執行成功')
 except:
  # 發生錯誤時回滾
  self.db.rollback()
  print('執行失敗')
 finally:
  self.cursor.close()
 def deleteDB(self,sql):
 ''' 操作數據庫數據刪除 '''
 self.cursor = self.db.cursor()

 try:
  # 執行sql
  self.cursor.execute(sql)
  # tt = self.cursor.execute(sql) # 返回 刪除數據 條數 可以根據 返回值 判定處理結果
  # print(tt)
  self.db.commit()
 except:
  # 發生錯誤時回滾
  self.db.rollback()
 finally:
  self.cursor.close()

 def updateDb(self,sql):
 ''' 更新數據庫操作 '''
 self.cursor = self.db.cursor()
 try:
  # 執行sql
  self.cursor.execute(sql)
  # tt = self.cursor.execute(sql) # 返回 更新數據 條數 可以根據 返回值 判定處理結果
  # print(tt)
  self.db.commit()
 except:
  # 發生錯誤時回滾
  self.db.rollback()
 finally:
  self.cursor.close()
 def selectDb(self,sql):
 ''' 數據庫查詢 '''
 self.cursor = self.db.cursor()
 try:
  self.cursor.execute(sql) # 返回 查詢數據 條數 可以根據 返回值 判定處理結果
  data = self.cursor.fetchall() # 返回所有記錄列表
  print(data)
  # 結果遍歷
  for row in data:
  sid = row[0]
  name = row[1]
  # 遍歷打印結果
  print('sid = %s, name = %s'%(sid,name))
 except:
  print('Error: unable to fecth data')
 finally:
  self.cursor.close()
 def closeDb(self):
 ''' 數據庫連接關閉 '''
 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()