¼±£¬sql±»×¢Èë
sqlÊý¾Ý¿âÀï´ó²¿·Ý±í±»×¢Èë" <script src=http://z360.net> </script>"Ö®À࣬³ÌÐòÒѾÔÚÐÞ¸ÄÁË.
ÊÇÓÃľÂí×¢ÈëµÄÂð?Èç¹ûÊÇľÂí×¢ÈëµÄÎÒ¸ÃÔÚÄÄÀïɱľÂí£¬¿Í»§¶Ë»¹ÊÇ·þÎñÆ÷¶Ë
¿Ï¶¨ÊÇÄã³ÌÐòûÓйýÂËSQL×¢Èë¡£
¼ì²é³ÌÐò²ÎÊý³ÌÐò¡£
ÎÒÏÖÔÚÏÞÖÆµÄÊÇÔÚget´«ÖµµÄʱºò£¬ºÍÒ»ÇÐÓû§ÓÐÊäÈëµÄµØ·½£¬»¹ÓÐÆäËûµØ·½ÐèÒªÏÞÖÆÂ𣿱ÈÈçsession,cookie
ÔÚ¿Í»§¶ËºÍ·þÎñÆ÷¶¼Òª·À»¤£¬Êý¾Ý¿â²Ù×÷ʹÓòÎÊý£¬½ûֹһЩÃüÁî
http://topic.csdn.net/u/20090729/14/26381958-0d6e-4b90-bc90-d275e9621f93.html
http://topic.csdn.net/u/20090708/09/b78444ee-9081-4ff7-8aa5-ba6f9b1d9fdc.html
cookieҲҪעÒâ°¡£¬
ÅжÏÓû§ÓÐû¿ÉÄÜÐÞ¸Äcookie´ïµ½ÆÆ»µ×÷Óá£
session¾Í²»ÓÃÁË¡£
²ÎÊý£¬¹ýÂË.ÎÒÖªµÀ£¬ÎÒÊÇÓýӱðÈ˵ÄÍøÕ¾
ÎÒÏëÖªµÀËû×¢ÈëÊÇÓÃľÂíÂð£¿
±ÈÈç˵¿Í»§¶ËÓÐľÂí£¬×Ô¶¯´óÅúÁ¿×¢Èë <script src=http://z360.net> </script>
ÊÇÕâÑùÂ𣿳ÌÐòÈç¹û¹æ·¶ºÃ£¬»¹ÐèÒª×öʲô
Óû§ÊäÈëµÄµØ·½Ò»¶¨Òª¹ýÂ˵ô¹Ø¼ü×Ö
Èçjs½Å±¾¡¢sql¹Ø¼ü×Ö
±ÈÈç˵¿Í»§¶ËÓÐľÂí£¬×Ô¶¯´óÅúÁ¿×¢Èë <script src=http://z360.net> </script>
ÊÇÕâÑùÂ𣿳ÌÐòÈç¹û¹æ·¶ºÃ£¬»¹ÐèÒª×öʲô
´ó¼Ò¶¼ÖªµÀÊÇÈçºÎ×¢ÈëµÄ£¬ÎÒÏëÖªµÀµÄÊÇÈçºÎÅúÀí×¢È룬ľÂí£¿ÎÒÊDz»ÊǵÃɱÏÂľÂí
Èç¹ûÒ³ÃæÓÐÕâ¶Î´úÂë»á³öÏÖÏÂÃæµÄ´íÎóÌáʾ¡£
ºÚ¿ÍÊÇÔõôעÈëµÄ£¬ÎÒºÜÏëÖªµÀ¡£
¡°/WebSite1¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó¡£
--------------------------------------------------------------------------------
´
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
ÓÐÁ½ÌõSQLÓï¾ä£¨Ò»¸ö¿ªÊ¼Ò»¸ö½áÊø£©£¬ÎÒÏëÔÚ×ÀÃæÉÏÖ´ÐУ¬¹âÌý˵Ҫ×ö¸ö´°Ì廹ÊǿؼþµÄ£¬ÕâÔõô×ö£¿ÇóÀÏʦÃǰïæ£¬ÏÈлл£¡£¡£¡£¡
ʲôÒâ˼£¬Â¥Ö÷˵Çå³þЩ
...ÊÇѽ£¬ÏÈ˵Çå³þÂï
£¿
ÎÒµÄÒâ˼ÊÇ˵ÔÚ×ÀÃæÉÏ×ö¸ö ......
ÏÖÔÚÑо¿¼òµ¥µÄ¶«Î÷£º
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
SQL code:
1¡¢²éѯ¡°001¡±¿Î³Ì±È¡°0 ......
select a.fyear,b.fname,
'1ÔÂ'=case when fperiod=1 then sum(a.fendbal) else 0 end ,
'2ÔÂ'=case when fperiod=2 then sum(a.fendbal) else 0 end ,
'3ÔÂ'=case when fperi ......