±¾ÈËÏëѧϰlinuxϵıà³Ì£¬µ«ÊÇÒ»Ö±ÓÐÒ»¸öÎÊÌâÀ§ÈÅ×ÅÎÒ£¬ÄǾÍÊÇÓ¦²»Ó¦¸ÃѧϰlinuxϵͳµÄÔ´´úÂ룬ÒòΪlinux±Ï¾¹ÊÇÒ»¸ö¿ªÔ´µÄ²Ù×÷ϵͳ¡£µ«ÊÇÓÉÓÚlinuxµÄÔ´´úÂë¹ýÓÚÅÓ´ó£¬Ñ§Ï°ÆðÀ´Ò²²»ÊǺÜÈÝÒ×£¬ËùÒÔÎÒ²»ÖªµÀÓÐûÓбØÒªÈ¥¿´¿´Ô´´úÂë¡£ÔÚÕâÀïÏ£Íû¸÷λ¸ßÊÖÄܸøÎÒÖ¸³öÈç¹ûѧϰÁËlinuxµÄÔ´´úÂëÓÐʲô¾ßÌåµÄ×÷ÓÃÒÔ¼°Èç¹û²»Ñ§Ï°»á¸ø½ ......
linux ÏÂÓм¯³ÉÁËphp mysql Apache µÄÈí¼þ£¿Ð»Ð»£¡£¡
ÕâÊÇʲô¶«Î÷£¿
Ò»¸öÒ»¸ö°²×°²»¾Í¿ÉÒÔÁË
°²×°linux Èç¹ûÄãûȥµôµÄ»° phpºÍApache¶¼ÊÇĬÈϰ²×°µÄ mysqlºÃÏñÒ²¿ÉÒÔÑ¡Ôñ°²×°£¨ÎÒûÊÔ¹ý£©
ÎÒÃǿͻ§ÒªµÄ£¬ËûÏë°²×°µÄ¼òµ¥Ò»µã£¬ÀàËÆappservÔÚwindow ϵݲװÈí¼þ¡£
Èç¹ûÄã»álinux   ......
ÕýÔÚѧϰÓû§Ì¬Ï̺߳ÍÄÚºË̬¶¨Ê±Æ÷µÄʹÓã¬ÓиöÎÊÌâÇë½Ì´ó¼Ò£º
ÎÒÔÚÓû§¿Õ¼ä½¨Á¢ÁËÒ»¸öỊ̈߳¬ÄÚºË×öÒ»¸ö×Ö·ûÇý¶¯Ä£¿é£¬Í¨¹ýioctlµ÷ÓÃÀ´²»¶Ï¶ÁÈ¡Äں˶¨Ê±Æ÷ÓÐûÓÐ
µ½ÆÚ¡£ÔÚÉ豸½á¹¹ÌåÀïÃæ¼ÓÁËÒ»¸öÐźÅÁ¿£¬ÔÚopenµ÷ÓõÄʱºò°ÑÐźÅÁ¿Äõ½£¬Ê¹ÓÃÒ»¸öÄں˶¨Ê±Æ÷£¬ÔÚÄÚ
ºË¶¨Ê±Æ÷µ½ÆÚµÄ´¦Àíº¯ÊýÀïÃæÊÍ·ÅÐ ......
select Inspect_name,office,IPfrom,
¼ì²é´ÎÊý=sum(case when ÊýÁ¿>120 then 1 else 0 end),
A=sum(case when A>120 then 1 else 0 end),
B=sum(case when B>120 then 1 else 0 end),
Ë«ÐÝÈÕ=sum(case when A>120 then 1 else 0 end),
×Ü·Ö=sum(case when Ë«ÐÝÈÕ>120 then 1 else 0 end) ......
±íµÄ¸ñʽÈçÏÂ
A B
ÉϺ£ 2000
Äþ²¨ 2000
ÉϺ£ 3000
º¼ÖÞ 3000
----------------
Èç¹ûÎÒÏëÈ¡³öÒÔB×Ö¶ÎΪ×飬ͬһ×éÖÐA×ֶεÄÌõ¼þΪÉϺ££¬Äþ²¨µÄÓï¾äÔõôд°¡£¬Ð»Ð»ÁË£¡
²»ÖªµÀÄãÏëҪʲô£¬ºÇºÇ£¬ÐèÇó²»Çå³þ£¬ÄãÒª×îÖÕ½á¹ûÊÇÔõÑùµÄ
ûÕûÃ÷°×
SQL code:
-------------------------------- ......
string sql = "select * from BugInfo where BugFoundDate between '" + dtp1.Value + "' and '" +dtp2.Value + "'";
if (cmbType.SelectedIndex != 0)
& ......