win32汇编实现拼接SQL语句
生活随笔
收集整理的這篇文章主要介紹了
win32汇编实现拼接SQL语句
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
字符串合并,在匯編語言,一般是用loop循環和cx寄存器,自己編程實現;
如果是win32匯編,可以使用movsb指令;
一般開發應用程序都會碰到拼接SQL語句,在C#這些語言用字符串連接的加號就可以了;在匯編中如果用上述兩種方法,要拼接出SQL語句極其麻煩;
考慮使用調用win32 API來實現;
1.asm; 使用了lstrcpy,lstrcat函數;
MessageBox是調試用的,可注釋掉;
;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ; by bobo ;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.386.model flat, stdcalloption casemap :none ;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> include windows.inc include user32.inc includelib user32.lib include kernel32.inc includelib kernel32.lib ;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ; Equ 等值定義 ;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ICO_MAIN equ 1000h ;圖標 DLG_MAIN equ 1 IDC_TXT1 equ 2001 IDC_TXT2 equ 2002 IDC_TXT3 equ 2003 IDC_TXT4 equ 2004 ;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.data? hInstance dd ? sztxt1 db 50 dup (?) sztxt2 db 50 dup (?) sztxt3 db 50 dup (?).data insstr BYTE "insert into mytable ",0h jhstr BYTE " + ",0h caption db "SQL拼接",0 sqlstr BYTE SIZEOF insstr DUP(0),0h;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.code ;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> _ProcDlgMain proc uses ebx edi esi hWnd,wMsg,wParam,lParammov eax,wMsg.if eax == WM_CLOSEinvoke EndDialog,hWnd,NULL.elseif eax == WM_INITDIALOGinvoke LoadIcon,hInstance,ICO_MAINinvoke SendMessage,hWnd,WM_SETICON,ICON_BIG,eax.elseif eax == WM_COMMANDmov eax,wParam.if ax == IDOK;invoke EndDialog,hWnd,NULLinvoke GetDlgItemText,hWnd,IDC_TXT1,addr sztxt1,sizeof sztxt1invoke GetDlgItemText,hWnd,IDC_TXT2,addr sztxt2,sizeof sztxt2invoke GetDlgItemText,hWnd,IDC_TXT3,addr sztxt3,sizeof sztxt3invoke lstrcpy, addr sqlstr, addr insstrinvoke lstrcat, addr sqlstr, addr sztxt1invoke lstrcat, addr sqlstr, addr jhstrinvoke lstrcat, addr sqlstr, addr sztxt2invoke lstrcat, addr sqlstr, addr jhstrinvoke lstrcat, addr sqlstr, addr sztxt3invoke MessageBox,NULL,addr sqlstr,addr caption,MB_OKinvoke SetDlgItemText,hWnd,IDC_TXT4,addr sqlstr.endif.elsemov eax,FALSEret.endifmov eax,TRUEret_ProcDlgMain endp ;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> start:invoke GetModuleHandle,NULLmov hInstance,eaxinvoke DialogBoxParam,hInstance,DLG_MAIN,NULL,offset _ProcDlgMain,NULLinvoke ExitProcess,NULL ;>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>end start1.rc;
#include <resource.h>#define ICO_MAIN 0x1000 //圖標 #define DLG_MAIN 1 #define IDC_TXT1 2001 #define IDC_TXT2 2002 #define IDC_TXT3 2003 #define IDC_TXT4 2004ICO_MAIN ICON "Main.ico"DLG_MAIN DIALOG 350, 250, 300, 250 STYLE DS_MODALFRAME | WS_POPUP | WS_VISIBLE | WS_CAPTION | WS_SYSMENU CAPTION "Win32匯編拼接SQL語句" FONT 9, "宋體" {EDITTEXT IDC_TXT1, 50, 15, 200, 25, ES_AUTOHSCROLL | WS_BORDER | WS_TABSTOPCTEXT "姓名:", -1, 5, 15, 40, 25EDITTEXT IDC_TXT2, 50, 60, 200, 25, ES_AUTOHSCROLL | WS_BORDER | WS_TABSTOPCTEXT "職務:", -1, 5, 60, 40, 25EDITTEXT IDC_TXT3, 50, 105, 200, 25, ES_AUTOHSCROLL | WS_BORDER | WS_TABSTOPCTEXT "部門:", -1, 5, 105, 40, 25EDITTEXT IDC_TXT4, 50, 150, 200, 25, ES_AUTOHSCROLL | WS_BORDER | WS_TABSTOPCTEXT "拼接的SQL:", -1, 5, 150, 40, 25DEFPUSHBUTTON "GO!", IDOK, 58, 210, 50, 14CONTROL "", -1, "Static", SS_ETCHEDHORZ | WS_CHILD | WS_VISIBLE, 6, 190, 103, 1 }運行如下;拼接出的內容放到最后一個文本框;
構建過程;
? ? 看上去基本可用;拼接出的SQL中的雙引號、字段名這些,可自己加、改代碼;界面可自己調rc文件;
總結
以上是生活随笔為你收集整理的win32汇编实现拼接SQL语句的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: VC++图片框控件静态和动态加载位图
- 下一篇: VC++ 给选项卡控件添加不同图标