#!/usr/bin/env?python
#?-*-?coding:utf-8?-*-
#?Author:HuShuangPing

from?sqlalchemy?import?create_engine
from?sqlalchemy.ext.declarative?import?declarative_base
from?sqlalchemy?import?Column?Integer?String

engine?=?create_engine（“mysql+pymysql://root:123456qwe@localhost/test?charset=utf8“
???????????????????????encoding=‘utf-8‘?echo=True）
base?=?declarative_base（）


class?Student（base）:
????__tablename__?=?‘student‘??#?表名
????name?=?Column（String（32））
????stNum?=?Column（Integer?primary_key=True）??#創建字段
????major?=?Column（String（64））
????teacher?=?Column（String（64））


base.metadata.create_all（engine）

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????298??2018-05-19?23:39??student\.idea\misc.xml

?????文件????????266??2018-05-19?23:39??student\.idea\modules.xml

?????文件????????466??2018-05-19?23:39??student\.idea\student.iml

?????文件??????11621??2018-05-19?23:56??student\.idea\workspace.xml

?????文件????????645??2018-05-18?13:00??student\db.py

?????文件????????984??2018-05-19?23:53??student\db_operate.py

?????文件???????1435??2018-05-18?13:17??student\LoginPage.py

?????文件????????207??2018-05-18?13:25??student\main.py

?????文件???????1755??2018-05-19?23:53??student\MainPage.py

?????文件?????????54??2018-05-19?23:39??student\venv\Lib\site-packages\easy-install.pth

?????文件??????????1??2018-05-19?23:45??student\venv\Lib\site-packages\inflection-0.3.1-py3.6.egg-info\dependency_links.txt

?????文件????????134??2018-05-19?23:45??student\venv\Lib\site-packages\inflection-0.3.1-py3.6.egg-info\installed-files.txt

?????文件??????????1??2012-02-25?02:41??student\venv\Lib\site-packages\inflection-0.3.1-py3.6.egg-info\not-zip-safe

?????文件???????3217??2018-05-19?23:45??student\venv\Lib\site-packages\inflection-0.3.1-py3.6.egg-info\PKG-INFO

?????文件????????263??2018-05-19?23:45??student\venv\Lib\site-packages\inflection-0.3.1-py3.6.egg-info\SOURCES.txt

?????文件?????????11??2018-05-19?23:45??student\venv\Lib\site-packages\inflection-0.3.1-py3.6.egg-info\top_level.txt

?????文件??????11082??2015-05-03?16:06??student\venv\Lib\site-packages\inflection.py

?????文件???????2257??2014-02-19?08:17??student\venv\Lib\site-packages\orm\helpers.py

?????文件???????5758??2014-02-19?08:19??student\venv\Lib\site-packages\orm\main.py

?????文件???????2833??2014-02-19?08:19??student\venv\Lib\site-packages\orm\__init__.py

?????文件???????3002??2018-05-19?23:46??student\venv\Lib\site-packages\orm\__pycache__\helpers.cpython-36.pyc

?????文件???????6282??2018-05-19?23:46??student\venv\Lib\site-packages\orm\__pycache__\main.cpython-36.pyc

?????文件???????2988??2018-05-19?23:46??student\venv\Lib\site-packages\orm\__pycache__\__init__.cpython-36.pyc

?????文件??????????1??2018-05-19?23:46??student\venv\Lib\site-packages\ORM-1.1.0-py3.6.egg-info\dependency_links.txt

?????文件????????270??2018-05-19?23:46??student\venv\Lib\site-packages\ORM-1.1.0-py3.6.egg-info\installed-files.txt

?????文件??????????1??2014-02-19?08:23??student\venv\Lib\site-packages\ORM-1.1.0-py3.6.egg-info\not-zip-safe

?????文件???????4560??2018-05-19?23:46??student\venv\Lib\site-packages\ORM-1.1.0-py3.6.egg-info\PKG-INFO

?????文件?????????34??2018-05-19?23:46??student\venv\Lib\site-packages\ORM-1.1.0-py3.6.egg-info\requires.txt

?????文件????????355??2018-05-19?23:46??student\venv\Lib\site-packages\ORM-1.1.0-py3.6.egg-info\SOURCES.txt

?????文件??????????4??2018-05-19?23:46??student\venv\Lib\site-packages\ORM-1.1.0-py3.6.egg-info\top_level.txt

............此處省略1111個文件信息