python 从txt导数据到mysql
!/usr/bin/python
encoding:utf-8
import MySQLdb
db = MySQLdb.connect("127.0.0.1", "zhanghao", "mima", "shujuku", charset='utf8' )
cursor = db.cursor()
i=0
with open("d.txt") as f:
for line in f.readlines():
a=line.split()
i=i+1
j=0
for aa in a:
j=j+1
if j == 4:
x=aa
elif j == 5:
elif j == 7:
y=aa
elif j == 8:
y=y+" "+aa
kssj=y
elif j == 9:
z=aa
elif j == 10:
z=z+" "+aa
jssj=z
elif j == 1:
type=aa
elif j == 2:
wtms=aa
elif j == 3:
wtly=aa
elif j == 6:
clr=aa
elif j == 11:
clbf=aa
try:
if type.decode('utf-8') == '日常巡检'.decode('utf-8'):
tt=0
elif type.decode('utf-8') == '网络设备配置'.decode('utf-8'):
tt=1
elif type.decode('utf-8') == '安全设备配置'.decode('utf-8'):
tt=2
elif type.decode('utf-8') == '系统部署'.decode('utf-8'):
tt=3
elif type.decode('utf-8') == '安全运维'.decode('utf-8'):
tt=4
elif type.decode('utf-8') == '系统更新/维护'.decode('utf-8'):
tt=5
elif type.decode('utf-8') == '系统重启'.decode('utf-8'):
tt=6
elif type.decode('utf-8') == '系统迁移'.decode('utf-8'):
tt=7
elif type.decode('utf-8') == '系统扩容'.decode('utf-8'):
tt=8
else:
tt=9
print tt
sql = "INSERT INTO xxxxxxxxxxx(id,type,wtms,wtly,wtjssj,clr,kssj,jssj,clbf,memo,machinaroom_id) values(%d,%d,'%s','%s','%s','%s','%s','%s','%s','%s',%d)" % (0,tt,wtms,wtly,wtjssj,clr,kssj,jssj,clbf,"",33)
print sql
cursor.execute(sql)
db.commit()
except:
print "bbb"
db.rollback()
db.close()
低调大师中文资讯倾力打造互联网数据资讯、行业资源、电子商务、移动互联网、网络营销平台。
持续更新报道IT业界、互联网、市场资讯、驱动更新,是最及时权威的产业资讯及硬件资讯报道平台。
转载内容版权归作者及来源网站所有,本站原创内容转载请注明来源。
- 上一篇
Django 搭建CMDB系统完整[14](运维记录)
templates/search_yunweijilu.html {% extends 'base.html' %} {% block title %} <script type="text/javascript" src="/static/scripts/jquery/jquery-1.7.1.js"></script> <link href="/static/style/authority/basic_layout.css" rel="stylesheet" type="text/css"> <link href="/static/style/authority/common_style.css" rel="stylesheet" type="text/css"> <script type="text/javascript" src="/static/scripts/authority/commonAll.js"></script> <script type="text/javascript" src="...
- 下一篇
python 获取年月日
import datetime datetime.datetime.now().year datetime.datetime.now().month datetime.datetime.now().day 示例 ubuntu@ThinkCentre:~$ python3 Python 3.5.2 (default, Nov 17 2016, 17:05:23) [GCC 5.4.0 20160609] on linux Type "help", "copyright", "credits" or "license" for more information. import datetime datetime.datetime.now().year 2017 datetime.datetime.now().month 3 datetime.datetime.now().day 23
相关文章
文章评论
共有0条评论来说两句吧...
文章二维码
点击排行
推荐阅读
最新文章
- CentOS关闭SELinux安全模块
- CentOS7编译安装Gcc9.2.0,解决mysql等软件编译问题
- Windows10,CentOS7,CentOS8安装MongoDB4.0.16
- Hadoop3单机部署,实现最简伪集群
- SpringBoot2编写第一个Controller,响应你的http请求并返回结果
- CentOS6,CentOS7官方镜像安装Oracle11G
- Eclipse初始化配置,告别卡顿、闪退、编译时间过长
- SpringBoot2全家桶,快速入门学习开发网站教程
- CentOS8编译安装MySQL8.0.19
- CentOS6,7,8上安装Nginx,支持https2.0的开启