Last active
October 10, 2025 02:57
-
-
Save hochun836/077c6512dba2265d05585547ad91aaa2 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # screentools.bat | |
| start C:\software\gInk_v1.1.0\gInk.exe | |
| start C:\software\ZoomIt.exe | |
| start C:\software\Snipaste-1.16.2-x64\Snipaste.exe | |
| start "" "C:\Program Files (x86)\DeskPins\deskpins.exe" | |
| #start C:\software\copyq-7.0.0\copyq.exe | |
| # mssql.bat | |
| @echo off | |
| setlocal | |
| set SERVICE_NAME=MSSQL$SQLEXPRESS | |
| sc query "%SERVICE_NAME%" | findstr /I "RUNNING" >nul | |
| IF %ERRORLEVEL% EQU 0 ( | |
| echo 服務 %SERVICE_NAME% 正在執行中，重新啟動中... | |
| net stop "%SERVICE_NAME%" | |
| net start "%SERVICE_NAME%" | |
| ) ELSE ( | |
| echo 服務 %SERVICE_NAME% 未執行，正在啟動... | |
| net start "%SERVICE_NAME%" | |
| ) | |
| endlocal | |
| pause | |
| # HotKeyMapping.ahk | |
| ; for quick | |
| !a::^Home | |
| !z::^End | |
| !s::^PgUp | |
| !x::^PgDn | |
| ^+e::F2 | |
| ^+r::F5 | |
| ; for macos | |
| !c::^c | |
| !v::^v | |
| !w::^w | |
| !n::^n | |
| # SqlAppendToggle.ahk | |
| ; SQL → Java | |
| ^t:: { ; Ctrl + T | |
| ClipWait ; 等待剪貼簿有內容 | |
| lines := StrSplit(A_Clipboard, "`n", "`r") ; 分割成行 | |
| result := "" | |
| for line in lines { | |
| if (line != "") { | |
| result .= 'sql.append(" ' line ' ");' "`n" | |
| } | |
| } | |
| ; 複製結果到剪貼簿 | |
| A_Clipboard := result | |
| ClipWait | |
| Send("^v") | |
| } | |
| ; Java → SQL | |
| ^+t:: { ; Ctrl + Shift + T | |
| ClipWait ; 等待剪貼簿有內容 | |
| lines := StrSplit(A_Clipboard, "`n", "`r") ; 分割多行 | |
| result := "" | |
| for line in lines { | |
| line := Trim(line) ; 去除首尾空白 | |
| ; 判斷是否為 sql.append("..."); 格式 | |
| if RegExMatch(line, 'i)^sql\.append\(\s*"(.+?)"\s*\);$', &match) { | |
| content := match[1] ; 取出括號內的內容 | |
| result .= content "`n" | |
| } | |
| } | |
| ; 複製結果到剪貼簿 | |
| A_Clipboard := result | |
| ClipWait | |
| Send("^v") | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment