delphi ÔÚDBChartÏÔʾ - Delphi / Êý¾Ý¿âÏà¹Ø
ÎÒÏëʵÏÖ½«Ò»¸ö°àµÄ³É¼¨ °´ÕÕÁùÊ®·ÖÒÔÏ£¬ÁùÊ®µ½°ËÊ®£¬°ËÊ®ÒÔÉÏ·Ö³ÉÈý×é¡£
ÔÚDBChartµÄÌõÐÎͼÀXÖáÊÇÕâÈý¸ö·ÖÊý¶Î£¬YÖáʽ¸ö·ÖÊý¶ÎµÄÈËÊý¡£
Êý¾Ý¿âÊÇsql2000µÄ
Ê×ÏȽ¨Á¢ÁË´æ´¢¹ý³ÌÈçÏÂ
create procedure makeview
@classname varchar(10),@coursename varchar(20),@semeter varchar(5)
as
begin
create table #view
(
score varchar(50),
num int
)
insert into #view
select 'score<60',count(1) from OrigScore where ×îÖճɼ¨<60 And °à¼¶ºÅ=@classname And ¿ª¿ÎѧÆÚ=@semeter And ¿Î³ÌÃû³Æ=@coursename
group by ×îÖճɼ¨
union all
select '60<score<80',count(1) from OrigScore where ×îÖճɼ¨<80 And ×îÖճɼ¨>60 And °à¼¶ºÅ=@classname And ¿ª¿ÎѧÆÚ=@semeter And ¿Î³ÌÃû³Æ=@coursename
group by ×îÖճɼ¨
union all
select 'score>80',count(1) from OrigScore where ×îÖճɼ¨>80 And °à¼¶ºÅ=@classname And ¿ª¿ÎѧÆÚ=@semeter And ¿Î³ÌÃû³Æ=@coursename
group by ×îÖճɼ¨
select * from #view
end;
ÊÇûÓдíÎóµÄ¡£
È»ºóÔڲ鿴°´Å¥Àï´úÂëÈçÏÂ
ADOStoredProc1.Close;
ADOStoredProc1.ProcedureName:='makeview';
ADOStoredProc1.Parameters.Refresh;
ADOStoredProc1.Parameters.ParamByName('@classname').Value:=bjh1.Text ;
ADOStoredProc1.Parameters.ParamByName('@coursename').Value:=kcm1.Text;
ADOStoredProc1.
Ïà¹ØÎÊ´ð£º
ÄãÃÇÓöµ½Õâ¸öÎÊÌâÂð£¿Ê¹ÓÃdelphi µÄʱºò£¬À´ÁËÒ»·âÐÅ¡£ËµÒªÎҽ̰æÈ¨·Ñ¡£Îһ赹¡£Ôõô°ì£¿
²»ÄÜÔõô°ì,Ò»ÊÇÀíËûÃÇ 2ÊDz»ÀíËûÃÇ
Äã·Å»°½ÐËûÃÇÀ´¹«Ë¾²é¡£¡£¡£¿´ËûÃÇÓе¨Ã»£¿
²»ÀíËûÃǾÍÊÇ£¬µ±Ê±Ò²ÎÊÎÒÃǹ«Ë¾ÒªµÄ ......
ÎÒÊÇDELPHIµÄ³õѧÕߣ¬µ«ÀÏʦҪÇóÎÒÃÇ×ö¿Î³ÌÉè¼Æ£¬´ÓÊé±¾ÀïÃæ¿½ÁË´úÂë×Ô¼ºÑо¿£¬µ«ÀÏÊdzöÎÊÌ⣬ÓÐËÊÇÕâ·½ÃæµÄ¸ßÊÖ°¡£¬ÄÜ·ñÁôϸöÁªÏµµÄ·½Ê½°ï°ïæ°¡
³öʲôÎÊÌ⣬Çë¾ßÌå˵Ã÷
·¢ÏÖ¡¢½â¾öÎÊÌâµÄ¹ý³Ì¾ÍÊÇѧϰµÄ¹ý³Ì
......
ÏÖÓÐparadoxÊý¾Ý¿âʹÓÃBDEÇý¶¯£¬Äâ¸ÄΪC/S°æ£¬Ôö¼ÓÍøÂç¶ÁÈ¡Êý¾Ý¹¦ÄÜ¡£ÇëÄÄλ´óÏÀ£¬ÌṩԴÂë¡£
˵¾ä²»¿ÍÆøµÄ»°£¬ÓÃparadox×öC/SÊÇ×ÔѰËÀ·¡£
»»Ò»¸öÍøÂçÊý¾Ý¿â
ÒòΪ²»Ï붯´óÊÖÊõ£¬½öÄܹ²Ïí¼¸¸öÎļþ¼´¿É¡£
Da ......
»¹ÓÐÅóÓÑʹÓà Delphi for PHP µÄ£¿ ÔÚ´ËÂÛ̳ÉÏÕâ·½ÃæÐÅÏ¢Ï൱ÉÙ£¬Óеϰ¿ÉÒÔ½»ÏÂÅóÓÑ£¬È˶à×ßµÃÎÈ£¬×ßµÃÔ¶¡£
QQ909992998
DELPHI »¹ÊDz»´íµÄ£¬DELPHI FOR PHP Èç¹û֮ǰÊÇÓÃDELPHI ¿ª·¢¹¤¾ßµÄ»° ˼·¶¼ÊÇ˳³ ......
ÔÚÎÒµçÄÔÉÏÔËÐÐDelphiµÄʱºò¾³£³öÏîÕâÖÖÇé¿ö£º¹Ø±ÕÔËÐд°¿Úʱ£¬µçÄÔËÀ»ú£¬Êó±êÄܶ¯£¬¸è»¹ÄÜÌý£¬µ«Ê²Ã´¶¼×ö²»ÁË£¬Ö»ÄÜÖØÆô¡£ÕâÊÇʲôÎÊÌ⣿Çë¸÷λ°ï°ï棬ллÁË£¡
Ò²¿ÉÄÜÊÇÄãÔËÐеÄÎļþÓÐÎÊÌâ¡£
Äã´ò¿ªdelphi£¬Ê² ......