PS E:\proj\gowork\hello_work\tcp> go run .\server.go
建立tcp连接收到client端发来的数据 22
收到client端发来的数据 333

PS E:\proj\gowork> go run .\hello_work\tcp\client.go
连接tcp服务成功
22
客户端接受服务端的数据为： 这是服务端返回的数据
333
客户端接受服务端的数据为： 这

go run hello_work/http/server.go

package main

import (
	"fmt"

	"example.com/hello_work/hello_work/util" // 引用本地其他目录下的文件
	"github.com/georgehao/gomodtestc" // 引用远程项目地址
)

func main() {
	fmt.Println(gomodtestc.PrintStr("Hello", 100)) // 调用远程项目的代码
	Print_hello() // 相同文件夹内的函数直接调用，来自于代码hello.go
	util.Print_work() //util是包名
}

from tkinter import *
from tkinter import messagebox


class Application(Frame):
    """
    继承Frame容器类
    """
    def __init__(self, master=None):
        super().__init__(master)
        self.master = master
        self.pack()

        self.createWidget()

    def createWidget(self):
        # 创建组件
        self.btn01 = Button(self)
        self.btn01['text'] = '点击送花'
        self.btn01.pack()
        self.btn01['command'] = self.songhua
        # 创建一个退出按钮
        self.btnQuit = Button(self, text='退出', command=root.destroy)
        self.btnQuit.pack()

    def songhua(self):
        messagebox.showinfo('送花', '送你99朵玫瑰花')


root = Tk()
root.geometry('400x100+200+300')
root.title('一个经典的GUI程序类的测试')
app = Application(master=root)
root.mainloop()

from tkinter import *

root= Tk()
root.geometry("500x300")
root.title("布局管理 place")
root["bg"]="white"


f1= Frame(root,width=200,height=200,bg="green")
f1.place(x=30,y=30)
Button(root,text="hebut").place(relx=0.5,rely=0,x=100,y=200,relwidth=0.2,relheight=0.2)
Button(f1,text="programmer").place(relx=0.6,rely=0.7)
Button(f1,text="关关雎鸠").place(relx=0.2,rely=0.2)

root.mainloop()

pip install pyinstaller  -i https://pypi.tuna.tsinghua.edu.cn/simple

D:\project\studyTK>pyinstaller -F main.py

# 将列表转换为一个迭代器
iter_li = iter([11,22)
# 通过next对迭代器进行迭代操作，每次可以迭代出来一个数据
s1 = next(iter_li)
print('s1:',s1)
s2 = next(iter_li) # s1 :11
print('s2:',s2)  # s2 :22
s3 = next(iter_li)  # StopIteration 错误

from collections import Iterable
from collections import Iterator
import time


class Classmate(object):
    """定义一个同学类"""

    def __init__(self):
        self.name = list()
        self.name_num = 0

    def add(self, name):
        self.name.append(name)

    def __iter__(self):
        return self  # 返回本身

    def __next__(self):
        if self.name_num < len(self.name):
            ret = self.name[self.name_num]
            self.name_num += 1
            return ret

        # 抛出异常，当循环后自动结束
        else:
            print("-------StopIteration---")
            raise StopIteration


class1 = Classmate()
class1.add("张三")
class1.add("李四")
class1.add("王五")

print("判断是否是可迭代的对象：", isinstance(class1, Iterable))

print("判断是否是迭代器：", isinstance(class1, Iterator))

for name in class1:
    print(name)
    time.sleep(1)
    
# 结果为
判断是否是可迭代的对象： True
判断是否是迭代器： True
张三
李四
王五
-------StopIteration---

D:\app\dependency-check-8.2.1-release\dependency-check\bin>

  --advancedHelp              Print the advanced help message.
   --enableExperimental        Enables the experimental analyzers.
   --exclude <pattern>         指定一个排除模式。这个选项可以多次指定，它接受Ant风格的排除”
-f,--format <format>           The report format (HTML, XML, CSV, JSON,
                               JUNIT, SARIF, JENKINS, or ALL). The
                               default is HTML. Multiple format
                               parameters can be specified.
   --failOnCVSS <score>        指定如果识别到高于指定级别的CVSS评分，是否应该使构建失败。
   							默认值是11；因为CVSS评分是0-10，所以默认情况下构建永远不会失败
                              
-h,--help                      Print this message.
   --junitFailOnCVSS <score>   指定在生成junit报告时被视为失败的CVSS评分。默认值是0
-l,--log <file>                The file path to write verbose logging
                               information.
-n,--noupdate                  禁用NVD-CVE，hosted-suppressions和RetireJS数据的自动更新
-o,--out <path>                指定报告目录.
   --prettyPrint               When specified the JSON and XML report
                               formats will be pretty printed.
   --project <name>            The name of the project being scanned.
-s,--scan <path>               指定被扫描的jar文件目录
                               recommended to quote the argument value.
   --suppression <file>        The file path to the suppression XML file.
                               This can be specified more then once to
                               utilize multiple suppression files
-v,--version                   Print the version information.

dependency-check.bat --disableRetireJS --disableNodeJS -s  D:\project\checkjar  -o D:\project\report

[INFO] NVD CVE requires several updates; this could take a couple of minutes.
[INFO] Download Started for NVD CVE - 2002
[INFO] Download Complete for NVD CVE - 2002  (4454 ms)
[INFO] Processing Started for NVD CVE - 2002
[INFO] Download Started for NVD CVE - 2003
[INFO] Processing Complete for NVD CVE - 2002  (6277 ms)
[INFO] Download Complete for NVD CVE - 2003  (2566 ms)
[INFO] Processing Started for NVD CVE - 2003
[INFO] Processing Complete for NVD CVE - 2003  (1376 ms)
...
INFO] Finished Dependency Bundling Analyzer (0 seconds)
[INFO] Finished Unused Suppression Rule Analyzer (0 seconds)
[INFO] Analysis Complete (8 seconds)
[INFO] Writing report to: D:\project\report\dependency-check-report.html

D:\project\report\dependency-check-report.html

dependency-check.bat
--cveUrlModified 本地nvd库的url/nvdcve-1.1-modified.json.gz
--cveUrlBase本地nvd库的url/nvdcve-1.1-2020.json.gz
--project test -s D:\checkjar\ -o D:\report\

<plugin>
    <groupId>org.owasp</groupId>
    <artifactId>dependency-check-maven</artifactId>
    <version>4.0.2</version>
    <configuration>
        <autoUpdate>true</autoUpdate>
    </configuration>
    <executions>
        <execution>
            <goals>
                <goal>check</goal>
            </goals>
        </execution>
    </executions>
</plugin>

<plugin>
    <groupId>org.owasp</groupId>
    <artifactId>dependency-check-maven</artifactId>
    <version>4.0.2</version>
    <reportSets>
        <reportSet>
            <reports>
                <report>aggregate</report>
            </reports>
        </reportSet>
    </reportSets>
</plugin>

<plugin>
    <groupId>org.owasp</groupId>
    <artifactId>dependency-check-maven</artifactId>
    <version>4.0.2</version>
    <configuration>
        <failBuildOnCVSS>8</failBuildOnCVSS>
    </configuration>
    <executions>
        <execution>
            <goals>
                <goal>check</goal>
            </goals>
        </execution>
    </executions>
</plugin>

<plugin>
    <groupId>org.owasp</groupId>
    <artifactId>dependency-check-maven</artifactId>
    <version>4.0.2</version>
    <executions>
        <execution>
            <goals>
                <goal>update-only</goal>
            </goals>
        </execution>
    </executions>
</plugin>

sonar.dependencyCheck.reportPath = ${WORKSPACE}/dependency-check-report.xml
##以Jenkins为例报告.xml路径
sonar.dependencyCheck.htmlReportPath = ${WORKSPACE}/dependency-check-report.html
##以Jenkins为例报告.html路径

sonar.dependencyCheck.severity.blocker = 9.0
sonar.dependencyCheck.severity.critical = 7.0
sonar.dependencyCheck.severity.major = 4.0
sonar.dependencyCheck.severity.minor = 0.0

import time
import sqlite3

#打开数据库
def open_db():
    #创建SQLite数据库
    con=sqlite3.connect(r"D:\project\pythonSql\sample.db")
    #创建表book:包含3列，id(主键，学号),name,tel
    # con.execute("create table if not exists book(id primary key,name,tel)")
    con.execute("create table if not exists book(id INTEGER PRIMARY KEY, name TEXT, tel TEXT, timer TEXT);")

    #创建游标对象
    cur=con.cursor()
    # 涉及到修改，删除等入库的操作必须用con.commit()提交事务最终完成
    # cur 主要是进行查询
    return con,cur

#查询全部信息
def show_all_db():
    print("******通讯录现有数据******")
    cur_1=open_db()[1]
    cur_1.execute("select id,name,tel from book")
    for row in cur_1:
        print(row)
        print(row[0])



#向数据库中添加内容
def add_db(name,tel):
    print("******数据添加功能******")
    cur_1=open_db()
    # cur_1[1].execute("insert into book(id,name,tel) values(?,?,?)",(id,name,tel))
    cur_1[1].execute("insert into book(name,tel) values(?,?)",(name,tel))
    cur_1[0].commit()
    print("******数据添加成功******")

#删除数据库中的内容
def delete_db(del_id):
    print("******数据删除功能******")
    cur_1=open_db()
    cur_1[1].execute("delete from book where id="+del_id)
    cur_1[0].commit()
    print("******数据删除成功******")
    show_all_db()
    #关闭游标对象
    cur_1[1].close()

#修改数据库中的内容
def alter_db(id,name,tel):
    print("******数据修改功能******")
    cur_1=open_db()
    #更新数据使用 SQL 语句中的 update
    cur_1[1].execute("update book set name = ? ,tel = ? where id ="+id,(name,tel))
    #游标事务提交
    cur_1[0].commit()
    show_all_db()
    cur_1[1].close()

#查询数据
def query_data(id):

    print("******数据查询功能******")
    cur_1=open_db()
    cur_1[1].execute("select id,name,tel from book where id ="+id)
    print("******查询结果如下******")
    for row in cur_1[1]:
        print(row)
    cur_1[1].close()



if __name__=="__main__":
    # add_db("你好", "185111")
    # show_all_db()
    # query_data("1")
    # alter_db("1", "我好", "hehe")
    # query_data("1")
    # delete_db("1")
    show_all_db()

import pymysql

dbinfo = {
    "host":"127.0.0.1",
    "user":"root",
    "password":"123456",
    "port":3306
}

class DB:
    def __init__(self,dbinfo):
        # self.db 只要修改表，必须用self.db.commit()进行事务提交，如果报错可以用self.db.rollback()进行回滚
        self.db = pymysql.connect(cursorclass = pymysql.cursors.DictCursor,
                                  **dbinfo)
        # self.cursor 用来查询
        self.cursor = self.db.cursor()

    def select(self,sql):
        self.cursor.execute(sql)
        result = self.cursor.fetchall()
        return result

    def execute(self,sql):

        self.cursor.execute(sql)
        self.db.commit()

        #     self.db.rollback()
        # try:
        #     self.cursor.execute(sql)
        #     self.db.commit()
        # except:
        #     self.db.rollback()

    def close(self):
        self.cursor.close()
        self.db.close()

if __name__ == '__main__':
    db = DB(dbinfo)
    #查询
    sql = "SELECT * from test.class"
    result = db.select(sql)
    print(result)

    #新增
    # sql2 = "INSERT into test.class(name) VALUES ('五年一班')"
    # db.execute(sql2)
    # sql = "SELECT * from test.class"
    # result = db.select(sql)
    # print(result)

    # 修改
    # sql2 = "update test.class set name='综艺一般' where id=6"
    # db.execute(sql2)
    # sql = "SELECT * from test.class"
    # result = db.select(sql)
    # print(result)

    # # 删除
    # sql2 = "delete from test.class where id=5"
    # db.execute(sql2)
    # sql = "SELECT * from test.class"
    # result = db.select(sql)
    # print(result)

# 创建应用
D:\project>django-admin startproject pysql
D:\project>cd pysql
# 创建应用下的一个项目
D:\project\mysite> python manage.py startapp myapi

# pysql\pysql\setting.py
import pymysql
pymysql.version_info = (1, 4, 13, "final", 0) #指定版本
pymysql.install_as_MySQLdb()



INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'myapi' # 注册应用
]


// 设置默认数据库为mysql
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'test',  # 数据库名字
        'USER': 'root',  # 帐号
        'PASSWORD': '123456',  # 密码
        'HOST': '127.0.0.1',  # IP
        'PORT': '3306',  # 端口
    }
}

#pysql\myapi\model.py
from django.db import models


class class1(models.Model):
    id = models.IntegerField().primary_key
    name = models.CharField(max_length=128, unique=True)
    tel = models.CharField(max_length=256)
    c_time = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.name

python manage.py makemigrations # 让model生效
python manage.py migrate # 生成表

# pysql/myapi/views.py
import json

from django.core.exceptions import ObjectDoesNotExist
from django.http import JsonResponse
from django.views.decorators.csrf import csrf_exempt

from myapi.models import *

def query_all(request):
    res = Class1.objects.all()
    resp = []
    for i in res:
        resp.append({"id": i.id, "name": i.name, "tel": i.tel})
    return JsonResponse({"code": 1, "msg": "success", "data": resp})

@csrf_exempt
def delete(request):
    data = json.loads(request.body)
    id = data.get("id")
    if not id:
        return JsonResponse({"code": -1, "msg": "id must be fill"})
    try:
        entry = Class1.objects.get(id=id)
        if not entry:
            return JsonResponse({"code": -1, "msg": "no effect row"})
        entry.delete()
        return JsonResponse({"code": 1, "msg": "success"})

    except ObjectDoesNotExist:
        return JsonResponse({"code": -1, "msg": "no effect row"})

@csrf_exempt
def update(request):
    data = json.loads(request.body)
    name = data.get('name').strip()
    tel = data.get('tel').strip()
    ids = data.get("id")
    if not name and not ids:
        return JsonResponse({"code": -1, "msg": "error"})
    try:
        entry = Class1.objects.get(id=ids)
        if not entry:
            return JsonResponse({"code": -1, "msg": "no effect row"})
        entry.tel = tel
        entry.name = name
        entry.save()

        return JsonResponse({"code": 1, "msg": "success"})

    except ObjectDoesNotExist:
        return JsonResponse({"code": -1, "msg": "no effect row"})


def get_class(request, id):
    try:
        # entry = Class1.objects.filter(id=id)
        entry = Class1.objects.get(id=id)
        if not entry:
            result = {'code': -1, 'msg': 'data is null'}
            return JsonResponse(result)
        return JsonResponse({"code": 1, "msg": "success", "data": {"name": entry.name, "tel": entry.tel}})

    except ObjectDoesNotExist:
        result = {'code': -1, 'msg': 'no effect row'}
        return JsonResponse(result)

@csrf_exempt
def add(request):
    data = json.loads(request.body)
    name = data.get("name")
    tel = data.get("tel")
    if not name or not tel:
        res = {'code': -1, 'msg': 'name,tel must be fill'}
        return JsonResponse(res)
    Class1(name=name, tel=tel).save()
    res = {'code': 1, 'msg': 'success'}
    return JsonResponse(res)

# pysql/myapi/urls.py

from django.conf.urls import url
from django.urls import path
from myapi import views

urlpatterns = [
    url(r'^query_all/', views.query_all),
    url(r'^delete/', views.delete),
    url(r'^update/', views.update),
    url(r'^add/', views.add),
    path('get_class/<int:id>/', views.get_class)
]

#pysql/pysql/urls.py
from django.conf.urls import url
from django.urls import path

from myapi import views

urlpatterns = [
    url(r'^query_all/', views.query_all),
    url(r'^delete/', views.delete),
    url(r'^update/', views.update),
    url(r'^add/', views.add),
    path('get_class/<int:id>/', views.get_class)
]

D:\project\pysql>python manage.py runserver
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
December 09, 2022 - 19:15:56
Django version 3.1.3, using settings 'pysql.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CTRL-BREAK.

import requests

resp = requests.post("http://127.0.0.1:8000/myapi/add/", json={"name": "admin1", "tel": "123456"})
print(resp.text)
resp1 = requests.post("http://127.0.0.1:8000/myapi/update/", json={"id": 1,"name": "test", "tel": "7999"})
print(resp1.text)
resp2= requests.post("http://127.0.0.1:8000/myapi/update/", json={"id": 1,"name": "test", "tel": "1111"})
print(resp2.text)
resp3 = requests.post("http://127.0.0.1:8000/myapi/delete/", json={"id": 1})
print(resp3.text)

resp4 = requests.get("http://127.0.0.1:8000/myapi/get_class/1/")
print(resp4.text)

resp4 = requests.get("http://127.0.0.1:8000/myapi/query_all")
print(resp4.text)

D:\app\Python37\python.exe D:/project/pysql/test1.py
{"code": 1, "msg": "success", "data": [{"id": 5, "name": "admin1", "tel": "123456"}]}

# pysql/pysql/setting.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

python manage.py makemigrations # 让model生效
python manage.py migrate # 生成表

D:\project\pysql>python manage.py runserver

import requests

resp = requests.post("http://127.0.0.1:8000/myapi/add/", json={"name": "admin1", "tel": "123456"})
print(resp.text)

C:\Users\Administrator>mitmdump --version
Mitmproxy: 5.3.0
Python:    3.7.9
OpenSSL:   OpenSSL 1.1.1h  22 Sep 2020
Platform:  Windows-10-10.0.19041-SP0

C:\Users\Administrator>

mitmweb

"C:\Users\Administrator\AppData\Local\Google\Chrome\Application\chrome.exe " --proxy-server=127.0.0.1:8080 --ignore-certificate-errors

# counter.py

import mitmproxy.http
from mitmproxy import ctx


class Counter:
    def __init__(self):
        self.num = 0

    def request(self, flow: mitmproxy.http.HTTPFlow):
        self.num = self.num + 1
        ctx.log.info("We've seen %d flows" % self.num)

import counter
import joker

addons = [
    counter.Counter(),
    joker.Joker(),
]

mitmweb -s addons.py