python-mysql

luyishisi · luyishisi · commit b8e439ebe89c · 2016-03-22T15:08:00.000+08:00
diff --git a/py_linux_jiankong/4.py b/py_linux_jiankong/4.py
@@ -5,7 +5,7 @@
 if len(sys.argv) > 1:
     INTERFACE = sys.argv[1]
 else:
-    INTERFACE = 'eth0'
+    INTERFACE = 'wlan0'
 STATS = []
 print 'Interface:',INTERFACE
 
diff --git a/python_mysql/creat-mysql-biao.py b/python_mysql/creat-mysql-biao.py
@@ -0,0 +1,28 @@
+#coding=utf-8
+import MySQLdb
+ 
+conn= MySQLdb.connect(
+        host='localhost',
+        port = 3306,
+        user='root',
+        passwd='123456',
+        db ='test',
+        )
+cur = conn.cursor()
+ 
+#创建数据表
+#cur.execute("create table student(id int ,name varchar(20),class varchar(30),age varchar(10))")
+ 
+#插入一条数据
+#cur.execute("insert into student values('2','Tom','3 year 2 class','9')")
+ 
+ 
+#修改查询条件的数据
+#cur.execute("update student set class='3 year 1 class' where name = 'Tom'")
+ 
+#删除查询条件的数据
+#cur.execute("delete from student where age='9'")
+ 
+cur.close()
+conn.commit()
+conn.close()
diff --git a/python_pachong/.getjpg.py.swp b/python_pachong/.getjpg.py.swp
diff --git a/python_pachong/getjpg.py b/python_pachong/getjpg.py
@@ -18,6 +18,5 @@ def getimg(html):
         urllib.urlretrieve(imgurl,'%s.jpg' % x)
         x+=1
 
-html = getHtml('http://tieba.baidu.com/p/4133040044')
-
+html = getHtml('http://tieba.baidu.com/p/4412785952')
 print (getimg(html))
diff --git a/python_pachong/getjpg1.py b/python_pachong/getjpg1.py
@@ -0,0 +1,23 @@
+#coding = utf-8
+import re
+import urllib
+
+def getHtml(url):
+    page = urllib.urlopen(url)
+    html = page.read()
+    return html
+
+def getimg(html):
+    reg = r"./jpg"
+    print reg
+    imgre = re.compile(reg)
+    imglist = re.findall(imgre,html)
+    print imglist
+    x = 0
+    for imgurl in imglist:
+        urllib.urlretrieve(imgurl,'%s.jpg' % x)
+        x+=1
+
+html = getHtml('http://tieba.baidu.com/p/4133040044')
+
+print (getimg(html))
