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.
Ïà¹ØÎÊ´ð£º
Çë½Ì¸÷·¸ßÊÖ¡£ÎäÁÖǰ±²¡£ÎÒ½«B.EXE×ö³É×ÊÔ´Îļþ£¬È»ºó¼Óµ½123.dllÖС£ÓÃA.EXEÀ´µ÷ÓÃ123.dllÖеÄB.EXE
Çë¸÷λǰ±²°ïæָ½ÌÏ¡£A.exeÈçºÎÀ´µ÷ÓÃdllÖеÄexe£¿´úÂëÓÖ¸ÃÈçºÎд£¿
ÎÞÈ˻شð£¿
×ö³É×ÊÔ´Î ......
hongqi162¡¢windindance
´Ë2È˳¤ÆÚ²»ÔÚÏߣ¬ÌرðÊÇwindindance
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
hongqi162»¹ÊǾ³£ÉÏÀ´×ª×ªµÄ
ÒýÓÃ
¸ü»»ÓÐÄÜÁ¦µÄÈËÉÏ
ÆäʵҲ²»ÊÇʲôÄÜÁ¦µÄÔÒò£¬Ö÷Òª¿ÉÄÜÊÇʱ¼äÎÊÌâ°É
¹¤×÷µÄ»¹ÒªÉÏ°à£¬Ñ§Ï ......
³ÌÐòʹÓõÄÊÇOrcalÊý¾Ý¿â£¬Ï붨ÆÚ£¨Ã¿¼¾¶È£©¶ÔÊý¾Ý¿â½øÐб¸·Ý£¬Ã»É¶Í·Ð÷£¬ÇëÎÊÓ¦¸ÃÔõôŪ£¿
ÓÐÊ²Ã´ÌØÊâÒªÇóÂ𣬱ÈÈçҪǰ¶Ë½çÃæ£¿
Ò»°ãÓÃÊý¾Ý¿â×Ô´øµÄ¡°¼Æ»®ÈÎÎñ¡±ÅäÖÃһϾ͹»ÁË
ûÓÐÊ²Ã´ÌØÊâÒªÇó¡£ÀýÈ磬ֻҪµ ......
1.ÎÒ²»»áÓ¢Óï,ÏÂÔØÁ˸ödelphi2010,´ò¿ªÒÔºóÀïÃæÈ«²¿ÊÇÓ¢Óï,Á¬°ïÖúÎļþÒ²ÊÇÓ¢Óï,ÓÐûÓкº»¯°æµÄ?
2.ÏÂÃæÊÇ×°delphi2010µÄʱºò×°½øÀ´µÄ,Âé·³½âÊÍÕâЩÊÂʲô
Embarcadero Delphi and C++ Builder 2010 Database Pack ......
ÈçÌâ¡£
ÓÃadoconnectionÁ¬½Óoracle,²âÊÔÁ¬½Ó³É¹¦
ÓÃÒ»adotable¿Ø¼þ£¬ÉèÖÃÆäconnectionΪ¸Õ¸ÕÁ¬½Ó³É¹¦µÄadoconnection
µ«ÊÇÑ¡ÔñtablenameÊôÐÔµÄʱºòÌáʾ£¬Êý¾ÝÌṩÕß»òÆäËü·þÎñ ......