ÓÃASPÔõôдÒÔÏ´úÂë
µ±½áÊøÊ±¼ä´óÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδÍê³É
µ±½áÊøÊ±¼äСÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδ´ïµ½ÈÎÎñ
ûÓÐʱ¼äÔòÏÔʾÕýÔÚ½øÐÐÖÐ
asp´úÂëÓ¦¸ÃÔõôд
Èç:¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä Íê³Éʱ¼ä ״̬
2009-10-10 2009-10-20 2009-10-15 Íê³É
2009-10-10 2009-10-20 2009-10-21 delay
2009-10-10 2009-10-20 ûÓÐʱ¼ä ÕýÔÚ½øÐÐÖÐ
1.Ñ»·ÅжÏßÂ
2.ÓÃÒ»¾äsqlÒ²ÄÜд³öÀ´
SQL code:
select startTime,endTime,finishTime,case when finishTime>endTime then 'delay' when endTime<finishTime then 'Íê³É' when finishTime is null then 'ÕýÔÚ½øÐÐÖÐ' end as status from table
ÎÒ¾õµÃÁÖÕÑдµÃ±È½ÏºÃ±È½Ï·ûºÏÌâÒâ
ţţ »»Ò»ÖÖ½â¾ö·½·¨ Ò²²»´í
1LµÄºÜºÃ°¡
Ïà¹ØÎÊ´ð£º
±íΪjilu
id name text
ҪдÈëµÄ²ÎÊý Ϊusername xiaoxi
username¶ÔÓ¦name
xiaoxi¶ÔÓ¦ text
²ÎÊý»ñÈ¡:request.Form("name") request.Form("text")
idΪÖ÷¼ ......
<asp:button>ĬÈÏ»áÌá½»Ò³Ãæ£¬ÈçºÎ½« <asp:button>²»Ìá½»Ò³Ãæ£¬¶øÖ´ÐÐÆäËûµÄº¯Êý£¬¼´aspÖÐµÄ <input type="button">
ÈçºÎ½« <asp:button>ÖØÖÃÒ³ÃæµÄ±íµ¥Öµ£¬¼´aspÖÐµÄ <in ......
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
ÏÂÃæÊÇÒ»¶ÎÒ³Ãæ´úÂë,Ò»¸öDATALISTÀïÃæÓÐRADIOBUTTON,Õâ¸ö¿Ø¼þÓ¦¸ÃÔõôÓð¡,ÎÒÒªµÄЧ¹ûÊÇ,´ÓDBÀï²é³öÀ´µÄÊý¾ÝÏÔʾÔÚDATALISTÖÐ,×îÇ°ÃæÒ»ÁÐÊÇRADIOBUTTON,¿ÉÒÔÑ¡ÖÐÆäÖÐÒ»ÐÐ.ÏÖÔÚµÄЧ¹ûÊÇ,¿ÉÒÔͬʱѡÖжàÐв¢Çҵò»µ½Ñ¡ ......