Xifeng2009

# 文档
https://beautifulsoup.readthedocs.io/zh_CN/v4.4.0/

import requests
from bs4 import BeautifulSoup
all_url = 'http://www.mzitu.com/all/'
start_html = requests.get(all_url, headers=headers)   
Soup = BeautifulSoup(start_html.text, "lxml")       # 解析器:html.parser, lxml-xml, xml, html5lib

# 获取a标签的链接

Xifeng2009

import socket
import threading


class Connection:
    def __init__(self, cid, conn, addr):
        self.cid  = cid
        self.conn = conn
        self.addr = addr
        

Xifeng2009

#!/usr/bin/python3
#!coding: utf-8

import sys
import time
import socket
import subprocess


def main():

Xifeng2009

##大写: 变量

# 查询
mysql> select * from TABLE where id=1;
# 插入
mysql> insert into TABLE (姓名, 性别, 年龄) values ('张三', '男', 33);
# 更新
mysql> update TABLE set title='母猪的产后护理' where id=3;
# 删除
mysql> delete from TABNLE where id=1;

Xifeng2009

import cx_Oracle                                          #引用模块cx_Oracle

conn=cx_Oracle.connect('load/123456@localhost/ora11g')    #连接数据库
c=conn.cursor()                                           #获取cursor
x=c.execute('select sysdate from dual')                   #使用cursor进行各种操作
x.fetchone()
c.close()                                                 #关闭cursor
conn.close()                                              #关闭连接

Xifeng2009

#!/usr/bin/python

import psycopg2

conn = psycopg2.connect(database="testdb", user="postgres", password="pass123", host="127.0.0.1", port="5432")
print "Opened database successfully"

cur = conn.cursor()
cur.execute('''CREATE TABLE COMPANY
       (ID INT PRIMARY KEY     NOT NULL,

Xifeng2009

from pymssql import connect  # @UnresolvedImport
 
conn = connect(host="127.0.0.1", user="DataClient", password="test", 
               database="TimeSeries")
cursor = conn.cursor()
cursor.execute("exec getResearchSalesAndRepurchaseByYear %s, %d", ('F000000I1F',2011))
rows = cursor.fetchall()
 
for row in rows:
    print row[0]

Xifeng2009

"""
Django settings for fastdev project.

Generated by 'django-admin startproject' using Django 1.11.12.

For more information on this file, see
https://docs.djangoproject.com/en/1.11/topics/settings/

For the full list of settings and their values, see
https://docs.djangoproject.com/en/1.11/ref/settings/

Xifeng2009

# 导入pymysql模块
import pymysql
 
# 连接database
conn = pymysql.connect(
    host=“你的数据库地址”,
    user=“用户名”,password=“密码”,
    database=“数据库名”,
    charset=“utf8”)
 

Xifeng2009

import requests

# GET请求
r = requests.get('https://api.github.com/events')
# POST请求
r = requests.post('http://httpbin.org/post', data = {'key':'value'})
# 其他
r = requests.put('http://httpbin.org/put', data = {'key':'value'})
r = requests.delete('http://httpbin.org/delete')
r = requests.head('http://httpbin.org/get')