ÏÖÓУº
°à¼¶±ít_clazz(Ö÷¼üid£¬°à¼¶Ãû³Æ),
ѧÉú±ít_student£¨Ö÷¼üid£¬Ñ§ÉúÐÕÃû£¬ËùÊô°à¼¶id£©£»
±í½á¹¹ÈçÏ£º
=======================================================
t_clazz£¨id,clazz_name£©
t_student(id,student_name,t_clazz_id)
========================================================
ÏÖÒª²é ......
ÏÖÔÚÓÐÒ»¸ö±ítable1£¬Ö»ÓÐÒ»¸ö×ֶΣ¬varchar£¨10£©
num
111
112
113
114
ÏÖÔÚÏëҪѻ·table1ÖеÄËùÓÐÊý¾Ý£¬ÔÀ´µÄ111Éú³É111001-111999²åÈëµ½table2ÖÐ
SQL code:
Select ltrim([num])+right(1000+number,3)col
from tb a,master..spt_values b
where type='P' and number between 1 and 999
sqlÖеÄÑ»·ÒªÓà ......
//adoquery1.SQL.add('insert into ѧÉúÊé·ÑÀúÊ·¿â(°à¼¶Ãû,Êé·Ñ,ÁìÊéÊé·Ñ,½áÓàÊé·Ñ,¾°ìÈË,²Ù×÷Ô±,×îºóÐÞ¸Äʱ¼ä,˵Ã÷,°à¼¶ÈËÊý) values (:classname,:s0,0,:s1,:s2,:s3,date(),:s4,:s5)');
adoquery1.SQL.add('update ѧÉúÊé·ÑÀúÊ·¿â set °à¼¶Ãû=:classname,Êé·Ñ=:s0,½áÓàÊé·Ñ=:s1,¾°ìÈË=:s2,²Ù×÷Ô±=:s3,×îºó ......
±ÈÈç 4£¬6£¬8£¬12£¬16£¬17£¬20£¬28£¬29£¬30£¬31Õ⼸¸öÊýÖÐÈ¡8¸öÊý
ÔõôµÃ³ö Õâ×éÊý¿ÉÒÔ×é³ÉÄÄЩ×éºÏ£¿
Çî¾Ù·¨
ÒýÓÃ
±ÈÈç 4£¬6£¬8£¬12£¬16£¬17£¬20£¬28£¬29£¬30£¬31Õ⼸¸öÊýÖÐÈ¡8¸öÊý
ÔõôµÃ³ö Õâ×éÊý¿ÉÒÔ×é³ÉÄÄЩ×éºÏ£¿
ÎÊÌâ ÊÇÎÒ²»»áд°¡ Äãд¹ýÂð ¿ÉÒÔ·¢¶Î´úÂë ÎҲο¼²Î¿¼Âð
¼òµ¥µÄÓÃforÑ»·£¬Ò»¸ö¸öÈ¥ÅÅÁÐ
......
6¡¢ÔÚ²»Ö¸¶¨ÌØÊâÊôÐÔµÄÇé¿öÏ£¬Äļ¸ÖÖHTML±êÇ©¿ÉÒÔÊÖ¶¯ÊäÈëÎı¾£º£¨AB£©
A.<TEXTAREA></TEXTAREA>
B.<INPUT type=¡±text¡±/>
C.<INPUT type=¡±hidden¡±/>
D.<DIV></DIV>
7¡¢ÒÔÏÂÄÄЩÊÇjavascriptµÄÈ«¾Öº¯Êý£º£¨ABC£©
A.escape
B.parseFloat
C.eval
D.setTimeout
E.alert
8¡ ......
ÎÒÔÚÊý¾Ý¿âÀïÃæ°ÑÊý¾Ý²éѯ³öÀ´ÁË´æ·ÅÔÚsessionÀïÃæ£¬´«µ½jspºóÈçºÎÔÚ
L010101=theMenu.addChild(L0101, "Document", "È«²¿¿Í»§()", "sale/list.html", "È«²¿¿Í»§...");
È«²¿¿Í»§ºóÃæµÄ£¨£©Àï°ÉÊý¾ÝÕ¹ÏÖ³öÀ´£¬ÉÏÃæÕâÒ»ÐдúÂëÊÇÒ»¸ö½á¹¹Ê÷µÄ½Úµã£¬Çë¸ßÊÖ²»Áߴͽ̰¡£¡
ÎÒÒ²µÈ» ......