学习笔记

摘要： Step 1 官网下载sqlite3.dll与宏文件放到同一个目录。 Step 2 新建一个xlsm的宏文件，通过API的方式调用dll 文件。 ' 需要先声明API函数 Private Declare Function sqlite3_open Lib "sqlite3.dll" (ByVal f 阅读全文

摘要： #格式化时间 def datetimeformat(value,fmt="%Y-%m-%d %H:%M"): return strftime(fmt) app =Flask(__name__) app.jinja_env.filters['datetimeformat'] = datetimefor 阅读全文

摘要： Option Explicit Private Declare Sub MoveMemory Lib "kernel32" Alias "RtlMoveMemory" _ (Destination As Long, Source As Long, ByVal Length As Long) Priv 阅读全文

摘要： Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _ (ByVal hwnd As Long, ByVal lpszOp As String, _ ByVal lpszFile As Strin 阅读全文

摘要： Sub createFolder() Dim wks As Worksheet On Error Resume Next Set wks = ThisWorkbook.Worksheets(1) basepath = ThisWorkbook.Path & "\" Max = wks.Range(" 阅读全文

摘要： app.py @app.route('/register', methods=['GET', 'POST']) def register(): if request.method == 'POST': username = request.form['username'] password = re 阅读全文

摘要： page.html <!--这个是分页展示下面的页码--> {%macro my_paginate(pagination,url)%} <nav> <ul class="pagination"> {%if pagination.has_prev%} <li class="page-item acti 阅读全文

摘要： database.py from flask_sqlalchemy import SQLAlchemy db = SQLAlchemy() config.py import os from database import db from flask import Flask basedir=os.p 阅读全文

摘要： SELECT DISTINCT 成绩表.分数 FROM 成绩表 WITH OWNERACCESS OPTION; 阅读全文

摘要： function mainMenu { $mainMenu = 'X' while($mainMenu -ne ''){ Clear-Host Write-Host "`n`t`t My Script`n" Write-Host -ForegroundColor Cyan "Main Menu" W 阅读全文