1
2
import os
current_folder=os.getcwd()

1
path=current_folder+'OutputTest.mdb'

1
2
3
def __init__(self,path):
self.conn = pyodbc.connect(r"Driver={Driver do Microsoft Access (*.mdb)};DBQ=" + path + ";Uid=;Pwd=;")
self.cursor = self.conn.cursor()

1
2
def run_sql(self,sql):
self.cursor.execute(sql) 

1
2
3
4
5
6

def close(self):
#提交所有执行语句
self.conn.commit()
self.cursor.close()
self.conn.close()

1
2
3
def create_table(self,name,key):
sql="Create table "+name+"("+key+")"
self.run_sql(sql) 

1
2
3
def coppy_table(self,copy_table,new_table):
sql="select * into "+new_table+" from "+copy_table+" where 1<>1"
self.run_sql(sql)

1
2
3
def drop_table(self,name):
sql="drop table "+name
self.run_sql(sql)

1
2
3
4
5
6
def get_table_column(self,table):
colunm_list=[]
backdata=self.cursor.columns(table)
for row in backdata:
colunm_list.append(row.column_name)
return colunm_list

1
2
3
4
5
6

def select(self,table_name,key,codition):
sql="SELECT "+key+" from "+table_name+" WHERE "+ codition
self.cursor.execute(sql)
backdata=self.cursor.fetchall()
return backdata

1
2
3
4
5
6
7
8
9
10
11

def insert(self,table_name,column_list,value_list):
colunm_name_str='('
value_str='('
for index in range(0,len(column_list)):
colunm_name_str=colunm_name_str+column_list[index]+','
value_str=value_str+'''+str(value_list[index])+'','
colunm_name_str=colunm_name_str[:-1]+')'
value_str=value_str[:-1]+')'
sql='INSERT INTO %s %s VALUES %s'%(table_name,colunm_name_str,value_str)
self.run_sql(sql)