- def ExecSql(dbFileName,stats):
- """
- | ##@函数目的: 执行sqlite语句
- | ##@参数说明:
- | ##@返回值: sqlite数据库查询结果
- | ##@函数逻辑:
- | ##@注意:本函数只适用于查询sqlite数据库
- """
- con = sqlite3.connect(dbFileName)
- cur = con.cursor()
- stats = stats.decode("gbk")
- cur.execute(stats)
- con.commit()
- DBExecResult = cur.fetchall()
- con.close()
- return DBExecResult
- def ExecSql(sql, dbName="", host="", user="", passwd="", charset=''):
- import MySQLdb
- conn = MySQLdb.connect(host=host, user=user, passwd=passwd, charset=charset)
- conn.select_db(dbName)
- cursor = conn.cursor()
- cursor.execute(sql)
- conn.commit()
- result = cursor.fetchall()
- cursor.close()
- conn.close()
- return result
来源: http://www.phpxs.com/code/1004835/