Django and Pymssql notes

(i) Installation

Django Installation: Can be downloaded to the official website, using the new version is the trend, (below 1.8 and 1.8 above, the difference is larger) but reference less official website: https://www.djangoproject.com/

Similar to the Python third-party library installation

Installation can be consulted: http://jingyan.baidu.com/article/466506580e7d29f549e5f8b6.html

Unzip the installation file into the Python installation path ... \python\lib\site-packages, and in the command line into the extracted folder: Execute command Python setup.py install.

Pymssql installation: Download the WHL file http://www.lfd.uci.edu/~gohlke/pythonlibs/on the third library #pymssql

(ii) examples

Pymssql Connection Example:

Import pymssql
conn = Pymssql.connect (host= ", user=", password= ", database=")
cur = conn.cursor ()
Cur.execute (' SELECT TOP ' from [dbo].[ Accout] ')
row = Cur.fetchone ()
Print (ROW)
Cur.close ()
Conn.close ()

Django Static Page Development example:

http://www.open-open.com/solution/view/1435818796310/

Django and Pymssql notes