python文件读写与数据库操作

7..分离扩展名：os.path.splitext()
8.获取路径名：os.path.dirname() 9.获取文件名：os.path.basename() 10.复制文件： shutil.copy(file1,file2)
PYTHON读写文本文件1
file_object = open('test.txt','rU') try: for line in file_object: print(line) finally: file_object.close()
cursor = c.execute("SELECT id, name, address, salary from COMPANY")
for row in cursor: print "ID = ", row[0] print "NAME = ", row[1]
print "ADDRESS = ", row[2]
PYTHON读写EXCEL文件2
python读写excel文件要用到两个库：xlrd和xlwt import xlrd data = xlrd.open_workbook(excelFile) table = data.sheets()[0] nrows = table.nrows ncols = table.ncols for i in xrange(0,nrows):
PYTHON文件夹操作2
1.创建单个目录：os.mkdir(“test”) 2.列出所有文件和目录名:os.listdir() 3.检验给出的路径是否是一个文件：os.path.isfile()
4.检验给出的路径是否是一个目录：os.path.isdir()
5.函数用来删除一个文件:os.remove() 6.检验给出的路径是否真地存:os.path.exists()
PYTHON读写文本文件2
with open(‘test','w') as f: for yy in dataArr: line="" for ss in yy: f.write(line)
PYTHON读写文本文件3
read()一次性读取文件的所有内容放在一个大字符串中 readline()逐行读取文本，结果是一个list readlines()一次性读取文本的所有内容，结果是一个list file.write(str)将字符串写入文件，返回的是写入的字符长度。 file.writelines(sequence)向文件写入一个序列字符串列表，
for row in cursor:
print "NAME = ", row[1] print "ADDRESS = ", row[2] print "Operation done successfully"; conn.close()
PYTHON操作SQLITE5
import sqlite3 conn = sqlite3.connect('test.db') c = conn.cursor() print "Opened database successfully";
cursor.execute(sql)
results = cursor.fetchall() for row in results: fname = row[0]
print ("fname=%s" %(fname))
c.execute("UPDATE COMPANY set SALARY = 25000.00 where ID=1")
mit() print "Total number of rows updated :", conn.total_changes cursor = conn.execute("SELECT id, name, address, salary from COMPANY")
PYTHON读写CSV文件1
Impoer csv csv_reader = csv.reader(open('data.file', encoding='utf-8')) for row in csv_reader:
print(row)
d= (["index","a_name","b_name"])
PYTHON操作MYSQL3
db = pymysql.connect("localhost","testuser","test123","TESTDB" ) cursor = db.cursor() sql = """INSERT INTO EMPLOYEE(FIRST_NAME, try: cursor.execute(sql) LAST_NAME, AGE, SEX, INCOME) VALUES ('Mac', 'Mohan', 20, 'M', 2000)"""
VALUES (2, 'Allen', 25, 'Texas', 15000.00 )");
mit() print "Records created successfully"; conn.close()
PYTHON操作SQLITE3
import sqlite3 conn = sqlite3.connect('test.db') c = conn.cursor() print "Opened database successfully";
sql = """CREATE TABLE EMPLOYEE (
FIRST_NAME CHAR(20) NOT NULL, LAST_NAME CHAR(20), AGE INT,
SEX CHAR(1),
INCOME FLOAT )""" cursor.execute(sql) db.close()
print "SALARY = ", row[3], "\n" print "Operation done successfully"; conn.close()
PYTHON操作SQLITE4
import sqlite3 conn = sqlite3.connect('test.db') c = conn.cursor() print "Opened database successfully";
with open("test.csv","w") as csvfile:
writer = csv.writer(csvfile) writer.writerow(["index","a_name","b_name"]) writer.writerows([[0,1,3],[1,2,3],[2,3,4]])


mit()
db.rollback()
except:
PYTHON操作MYSQL4
db = pymysql.connect("localhost","testuser","test123","TESTDB" ) cursor = db.cursor() sql = "SELECT * FROM EMPLOYEE WHERE INCOME > '%d'" % (1000) try:
c.execute('''CREATE TABLE COMPANY
(ID INT PRIMARY KEY NOT NULL, NAME AGE TEXT NOT NULL, INT NOT NULL,
ห้องสมุดไป่ตู้
ADDRESS
SALARY
CHAR(50),
REAL);''')
print "Table created successfully"; mit() conn.close()
for row in cursor:
print "NAME = ", row[1] print "ADDRESS = ", row[2] print "Operation done successfully"; conn.close()
PYTHON操作MYSQL1
连接Mysql,Python3中可以用pymysql,而Python2中则使用mysqldb。 import pymysql db = pymysql.connect("localhost","testuser","test123","TESTDB" ) cursor = db.cursor() cursor.execute("SELECT VERSION()") data = cursor.fetchone() print ("Database version : %s " % data) db.close()
PYTHON操作SQLITE2
import sqlite3 conn = sqlite3.connect('test.db') c = conn.cursor() print "Opened database successfully"; c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \ VALUES (1, 'Paul', 32, 'California', 20000.00 )"); c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \