#!/usr/bin/env?python

import?MySQLdb

DATAbase_NAME?=?‘hero‘

class?HeroDB:
????#?init?class?and?create?a?database
????def?__init__（self?name?conn?cur）:
????????self.name?=?name
????????self.conn?=?conn
????????self.cur?=?cur
????????try:
????????????cur.execute（‘create?database?if?not?exists?‘?+?name）
????????????conn.select_db（name）
????????????conn.commit（）
????????except?MySQLdb.Error?e:
????????????print?“Mysql?Error?%d:?%s“?%?（e.args[0]?e.args[1]）
????????????????????????
????#?create?a?table
????def?createTable（self?name）:
????????try:
????????????ex?=?self.cur.execute
????????????if?ex（‘show?tables‘）?==?0:
????????????????ex（‘create?table?‘?+?name?+?‘（id?int?name?varchar（20）?sex?int?age?int?info?varchar（50））‘）
????????????????self.conn.commit（）
????????except?MySQLdb.Error?e:
????????????print?“Mysql?Error?%d:?%s“?%?（e.args[0]?e.args[1]）
????????????
????#?insert?single?record
????def?insert（self?name?value）:
????????try:
?????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-04-21?13:29??Summary\
?????文件????????5065??2015-04-21?13:25??Summary\heroDB.py
?????文件????????1953??2015-04-21?13:28??Summary\testHeroDB.py