鏂颁汉瀹炰綔甯哥敤鍑芥暟浠嬬粛
锛堟湰妗ｆ鎵�涓句緥瀛愶紝浠呬緵鍙傝�冿紝濡傛湁涓嶆伆褰撶殑鍦版柟璇锋寚姝ｏ級
AcceptText()
锛氳蹇嗘柟娉?/p>
Accept
璇戯細鎺ュ彈锛?/p>
Text
璇戯細鏂囨湰銆?/p>
浣滅敤灏嗛娴湪
DW
缂栬緫妗嗕腑鐨勮祫鏂欏啓鍏ュ埌
DW
鐨勭紦鍐插尯涓�傜被浼间簬鍦?/p>
Word
鏂囨。涓紪杈戞枃瀛楋紝琛ㄩ潰涓婇潰鐪嬭捣鏉ュソ鍍忓凡
缁忓啓鍒?/p>
Word
涓紝瀹為檯涓婂苟鏈病鏈変繚瀛橈紝鎴戜滑杩樿鎸変繚瀛樻寜閽�傞娴湪
DW
缂栬緫妗嗕腑鐨勫唴瀹癸紝绫讳技浜庝竴涓毊鐞冮鍦ㄦ按闈笂
闈紝浣嗘病鏈夊埌姘撮噷鍘伙紝杩欎釜鏃跺�欐垜浠敤
AcceptText()
灏嗚祫鏂欏啓鍒扮紦鍐插尯閲岄潰锛岀被浼间簬鎶婄毊鐞冪敤鎵嬫墜宸ョ殑鎸夊埌姘撮噷闈€�?/p>
AccetpText()
鏈夎繑鍥炲�硷紝姣斿鎶娾�?/p>
abcd
鈥濆啓鍒版暟瀛楀瀷鏍忎綅鐨勭紦鍐插尯涓紝杩欒偗瀹氭槸閿欒鐨勶紝鍒?/p>
AcceptText()
杩斿洖
-1
锛屽け
璐ャ�?/p>
姝ゅ嚱鏁板湪鏍忎綅璺宠浆鐨勬椂鍊欙紝绯荤粺涔熶細鑷姩瑙﹀彂銆?/p>
GetItemString()
锛氳蹇嗘柟娉?/p>
Get
璇戯細寰楀埌锛?/p>
Item
璇戯細
鏍忎綅锛?/p>
String
璇戯細瀛楃涓?/p>
浣滅敤锛氬彇瀛楃鍨嬫爮浣嶇殑鍊笺�?/p>
鍚岀悊
GetItemNumber()
鍙栨暟瀛楀瀷锛?/p>
GetItemDate()
鍙栨棩鏈熷瀷锛涚瓑绛?/p>
銆?/p>
涓嬮潰浠?/p>
GetItemString()
鏉ヨ繘琛岃瑙?/p>
:
DW
涓殑璧勬枡涓?/p>
1 ,
2 ,
3
4 ,
5 ,
6
7 ,
8 ,
9
鍒?/p>
GetItemString(2, 3 )
鍙栫殑鍊间负
6
锛?/p>
GetItemString(3 , 2 )
鍙栫殑鍊间负
8
锛?/p>
閭ｄ箞
GetItemString()
涓や釜鍙傛暟鐩稿綋浜庢垜浠殑
X/Y
鍧愭爣绯伙紙浣嗘槸鏄�掔珛鐨勫潗鏍囩郴锛?/p>
;
鍏朵腑绗簩涓弬鏁扮殑鍙栧�兼槸
鏍规嵁
DW
鐨勫悗绔暟鎹簮
SQL
璇硶鏉ュ喅瀹氬彇閭ｄ釜鍊肩殑銆傛瘮濡傦細
SELECT "m_user"."user_id",
"m_user"."user_pass",
"m_user"."user_name",
"m_user"."user_company",
"m_user"."user_factory",
"m_user"."user_lim_id",
"m_user"."user_time",
"m_user"."user_login"
FROM "m_user"
濡傛灉
GetItemstring(
* , 2 )
鍒欏彇绗?/p>
*
琛岋紝
user_pass
鐨勫�硷紱
濡傛灉鏄?/p>
GetItemString(*, 5 )
鐨勫�硷紝鍒欏彇绗?/p>
*
琛?/p>
,user_factory
鐨勫�笺�備篃灏辨槸璇达紝鍙栭偅涓爮浣嶇殑鍊煎彧鍜岃鏁板強鍚庣
Sql
鏁版嵁婧愮殑鏍忎綅鎺掑垪椤哄簭鏈夊叧绯汇�傝�屼笌鍦?/p>
DW
杩愯鏃堕偅涓殑鍏蜂綋浣嶇疆
鏄病鏈夊叧绯伙紝
锛堣澶у鎯虫兂鍦ㄨ璁?/p>
DW
鐨勬椂鍊欙紝
鎴戜滑鐨勬爮浣嶆槸涓嶆槸鍙互鎷栨潵鎷栧幓锛?/p>
闅鹃亾瀹冧細褰卞搷鍒?/p>
GetItemString()
鍑芥暟鍚楋紵锛?/p>
涓轰簡缂栫▼娓呮櫚锛屾垜浠�氬父寤鸿绗簩涓弬鏁颁负鏍忎綅鍚嶆潵浠ｆ浛銆傚
GetItemString(* ,
鈥?/p>
user_name
鈥?/p>
)
IsNull()
璁板繂鏂规硶锛?/p>
IS
锛氳瘧
鏄惁涓猴紱
Null
璇戯細
Null
鍊笺�?/p>
杩欎釜鍑芥暟鎴戜滑鍦ㄧ鍥涜妭璇捐鐨?/p>
NULL
鍊兼湁鍏崇郴銆傚畠鐢ㄦ潵鍒ゆ柇姝ゅ�兼槸鍚︿负
NULL
鍊硷紝鏄垯杩斿洖
True
锛屽惁杩斿洖
False
Trim()
鍘荤┖鏍硷紱濡傗�?/p>
ABC
鈥?/p>
锛屽垯
Trim(
鈥?/p>
ABC
鈥?/p>
) =
鈥?/p>
ABC
鈥濅簡锛屽幓浜嗙┖鏍?/p>
GetRow()
璁板繂鏂规硶锛?/p>
Get
璇?/p>
寰楀埌
锛?/p>
Row
璇?/p>
琛?/p>
寰楀埌
DW
涓殑琛岀劍鐐圭幇鍦ㄩ偅琛屼笂闈€�傚洜涓?/p>
DW
涓細鏄剧ず澶氳璧勬枡锛岄偅涔堟垜浠緱鍒版鏃?/p>
DW
鐨勮鐒︾偣鍦ㄩ偅琛屼笂闈紝鍒欏彲浠?/p>
姝ゅ嚱鏁版潵寰楀埌銆?/p>
(
闄よ鐒︾偣鐨勬蹇靛锛屾垜浠繕鏈夎鐒︾偣锛屾爮浣嶇劍鐐圭殑姒傚康
)
SetFocus()
璁板繂鏂规硶锛?/p>
Set
璇?/p>
璁剧疆
锛?/p>
Focus
璇?/p>
鐒︾偣
灏嗙劍鐐硅缃湪閭ｄ釜
DW
涓婇潰锛屼竴涓?/p>
Window
涓婇潰鍙兘鏈夊涓劍鐐癸紝浼楁墍鍛ㄧ煡锛屽鏋滀竴涓枃鏈濡傛灉瑕佺紪杈戝畠锛岄偅涔堥鍏?/p>
搴旇璁╁畠鑾峰緱鐒︾偣锛屽垯浣犺缂栬緫
DW
锛屽垯搴旇璁?/p>
DW
棣栧厛寰楀埌鐒︾偣锛堜篃灏辫鏄寰楀埌鍏夋爣锛?/p>
SetColumn()
璁板繂鏂规硶锛?/p>
Set
璇?/p>
璁剧疆
; Column
璇?/p>
鏍忎綅
鍜?/p>
SetFocus()
涓�鏍风殑鍘熺悊锛屼綘瑕佷慨鏀?/p>
DW
涓煇涓爮浣嶇殑璧勬枡锛岄偅浣犲氨闇�瑕佽閭ｄ釜鏍忎綅鑾峰緱璧勬枡銆傚垯棣栧厛璁╂爮浣嶈幏寰楃劍鐐癸紝
鑾峰緱鍏夋爣銆傚垯
SetColumn()
灏辨槸璧疯繖涓綔鐢ㄣ�?/p>