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.
Ïà¹ØÎÊ´ð£º
Ò»°ã¶¼ÊÇÔõô½Ó»îµÄ£¿
ÊÕÈëÔõôÑù
sohu£¿soho£¿
sohu ¿ÉÄÜÊÇsmall office house unit
С°ì¹«ÊÒ£¬°Ñ¼Ò±ä³Éµ¥Î»¡£
È¥Íþ¿ÍÍø°¡,ºÜ¶à¸öÄØ,»¹ÓÐÍâ°üµÄÍøÕ¾
ѧϰѧϰ¡£
ÏÖÔÚDelphi×ö¶«Î÷²»ÐÐÁË,´¦ÓÚÌÔÌ×´ ......
ÒÔÇ°ÖмäÕ¾ÊǵçÄÔͨ¹ý´®¿Ú¿ØÖƵģ¬ÏÖÔڸijÉÁËUSB½Ó¿Ú£¬ÇëÎÊÒªÔõô×ö°¡£¿Çó¸ßÊÖÖ¸µãÒ»ÏÂ
ÊÇusbת´®¿ÚÂð£¿ÄÇÓ¦¸Ã»¹ÊÇ¿ÉÒÔ°´´®¿Ú²Ù×÷µÄ£¬Ö»ÊÇËٶȲ»ÄÜÌ«¸ß
Èç¹û²»ÊÇusbת´®¿Ú£¬Çë²éÔÄusbÇý¶¯µÄsdk˵Ã÷¡£
Õâ¸öÊDz ......
ÔÚÍøÉÏ¿´µ½ºÜ¶àÈËд³ÌÐò´úÂë,дµÄ´úÂëÿһÐж¼ÊÇҪô¾Í¿ÕÒ»¸ö¿Õ¸ñ,Ҫô¾Í¿ÕºÃ¼¸¸ö,Õâ¸öÓй涨Âð?Ôõô¿´?
ÒÔÏÂÊÇÎÒÔÚÍøÉÏÕÒµÄÒ»¶Î³ÌÐò´úÂë
===================================================================== ......
ÎÒÕâ¸öÓиö³ÌÐòÎÒÕÒ²»µ½ËûÐÄÌø°üдʲôµØ·½ÁË
Õâ¸öÎÒÒªÔõôÕÒ°¡
Çó´ó¸çÃÇÖ¸½Ì
ÐÄÌø£¿£¿£¿£¿
Timerʼþ°É£¿
Timer »òÕßÏß³Ì
ÄÜ˵¾ßÌåµãÂð
timerÎÒÒ²ÖªµÀ¾ÍÊÇÕÒ²»µ½Âð
ÕÒsendbuf£¬¿´ÄÄЩµØ·½µ÷ÓÃÁË£¬ ......
ÈçÌâ¡£
ÓÃadoconnectionÁ¬½Óoracle,²âÊÔÁ¬½Ó³É¹¦
ÓÃÒ»adotable¿Ø¼þ£¬ÉèÖÃÆäconnectionΪ¸Õ¸ÕÁ¬½Ó³É¹¦µÄadoconnection
µ«ÊÇÑ¡ÔñtablenameÊôÐÔµÄʱºòÌáʾ£¬Êý¾ÝÌṩÕß»òÆäËü·þÎñ ......