- 在线时间
- 0 小时
- 最后登录
- 2005-5-7
- 注册时间
- 2005-5-6
- 听众数
- 2
- 收听数
- 0
- 能力
- 0 分
- 体力
- 266 点
- 威望
- 0 点
- 阅读权限
- 20
- 积分
- 23
- 相册
- 0
- 日志
- 0
- 记录
- 0
- 帖子
- 6
- 主题
- 1
- 精华
- 0
- 分享
- 0
- 好友
- 0
升级 18.95% 该用户从未签到
网络挑战赛参赛者
|
<>好的 我给你全部的代码吧</P><>unit Unit1;</P><>interface</P><>uses
5 {- T/ s3 g5 K% j Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
+ o; i' G) p& D8 u) O" e Dialogs, StdCtrls, DB, ADODB;</P><>type
0 u9 |+ _) `; k1 U$ _. k$ d6 Y# f/ ] TForm1 = class(TForm)
& o) z+ L! }: m4 I% w Edit1: TEdit;% E% h" e, e! o8 e- H0 P. l
Button1: TButton;- o+ V) h! H8 Q, B5 q
ADOConnection1: TADOConnection;
% v2 W9 t3 q9 |- v! B8 P; Y' z9 ] ADOQlinchang: TADOQuery;# Y& E% g- }" a( i. D
ADOQyinglinqu: TADOQuery;* e* `# }: C- T( Z5 d. C
ADOQzuoyequ: TADOQuery;
! _& q3 D% X9 ~* N1 r( ? ADOQlinban: TADOQuery;4 x7 |2 o" T" F. s% v) e# m6 f
ADOQxiaoban: TADOQuery;5 z4 a; v* n4 |+ }: [+ ]
ADOQs: TADOQuery;
( |/ ~' y# d' n! ?) ` procedure Button1Click(Sender: TObject);' H) D, F) b* z c: z0 @2 Q' Y; f
private0 g: Y7 c1 j- g8 n4 V0 C. `
{ Private declarations }
4 o3 j% V/ ~# I* c) p' X0 S9 l$ H public8 l: F+ m( z2 r T! `. B
{ Public declarations }
6 H9 m8 j* H+ i end;</P><>var
: W5 h6 N2 r: u1 a$ P. s5 _. Y Form1: TForm1;</P><>implementation</P><>{$R *.dfm}</P><>procedure TForm1.Button1Click(Sender: TObject);8 g/ u( S- d) z6 b$ c" P* a% k' j
var
; v& V4 q( H. C+ o4 j$ Fstrlinchang,stryinglinqu,strzuoyequ,strlinban,strxiaoban,strcodezuo,strcodeying,strcodelin,strcodexiao,strcode:string;
* O. t: L: [& u- a/ t( o: c: kbegin% f: D! z( z1 G+ g
adoqlinchang.Close ;* a% s, b) A r* N
adoqyinglinqu.Close ;
$ E9 m9 \: w% M, o9 k3 aadoqzuoyequ.Close ;
' [1 F9 M7 v# L5 R ?" Jadoqlinban.Close ;; z. d; l: M# D7 L5 t
adoqxiaoban.Close ;1 H$ r7 W& W( \
adoqs.Close ;( |1 ^5 J& ]& W* i W5 a) }4 \/ D) @
adoqlinchang.SQL.Clear ;
1 M. O5 k+ Y. h1 N9 O) ^. Q1 t9 y) x! k( eadoqlinchang.SQL.Add('select areacode from tfsareacode where areaname=:linc');
- q6 R; j% o$ m# _6 X9 z" iadoqlinchang.Parameters.ParamByName('linc').Value :=edit1.Text ;; S, l1 X+ M, B6 B/ \
adoqlinchang.Prepared ;
. b X7 V$ ^ C } I9 ^adoqlinchang.Open ;/ B% q$ R9 }3 ~
strlinchang:=trim(adoqlinchang.Fields.fieldbyname('areacode').AsString );% w" ?. `6 M4 h! t4 [
adoqyinglinqu.SQL.Clear ;7 W% X4 h% t! X9 n" G( k1 a; [
adoqyinglinqu.SQL.Add('select areaname,areacode from tfsareacode where fatherarea=:linc');
7 Z- Q7 f/ h) a0 c& ^, y9 C+ vadoqyinglinqu.Parameters.ParamByName('linc').Value :=edit1.Text ;
+ U0 J* W7 O, T$ I$ y% e2 Uadoqyinglinqu.Prepared ;
. G5 B9 v q* `- B5 Z7 Eadoqyinglinqu.Open ;1 u' L1 V2 Z0 F4 a0 d5 r
while not adoqyinglinqu.Eof
2 d H& w0 \% g2 h7 ~, w' ido
5 c- J6 L y( F+ k5 S, [# Tbegin
1 f3 G1 ~$ \; M5 p) m# p9 s stryinglinqu:=trim(adoqyinglinqu.Fields.fieldbyname('areacode').AsString );
) {5 C7 f0 }; r$ \ strcodeying:=strlinchang+'999'+stryinglinqu;0 G: T: v7 r3 ^$ _" m
ADOQZuoYeQu.SQL.Clear;
+ N# J5 Y$ c/ ]1 `2 n ADOQZuoYeQu.SQL.Add('select areaname,areacode from tfsareacode where fatherarea=:yinglq');4 ]* ^; i* N2 ~6 @* y/ p
ADOQZuoYeQu.Parameters.ParamByName('yinglq').Value:=ADOQYingLinQu.Fields.fieldbyname('areaname').Value ;
' m8 K0 ^4 j- q& i ADOQZuoYeQu.Prepared;
' l4 ~3 ^/ L/ i) T& z* U0 R$ G' Y ADOQZuoYeQu.Open ;/ A/ y) l& k! z" n: i8 b
while not adoqzuoyequ.Eof
7 D/ W& t5 m- r% `! I) N do" A" ~/ m; D0 r
begin
; C8 G1 ?$ U9 D$ I$ R" w. m strZuoyequ:=ADOQZuoYeQu.Fields.fieldbyname('areacode').AsString ; <a>file://逐</A>个作业区的代码
. ^0 m1 X* s3 K strcodezu=strlinchang+'999'+stryinglinqu+'999'+strzuoyequ;/ h' @' h& q5 B" _+ d, M9 y$ Y. _
ADOQLinBan.SQL.Clear;5 u. D% Z# P& }/ m
ADOQLinBan.SQL.Add('select areaname,areacode from tfsareacode where fatherarea=:Zuoyq');5 H+ G* G8 M0 J* E
ADOQLinBan.Parameters.ParamByName('Zuoyq').Value :=ADOQZuoYeQu.Fields.fieldbyname('areaname').Value ;
. M5 q S! ^5 `) | ADOQLinBan.Prepared;( c$ b: \8 {% a
ADOQlinBan.Open;
6 N* l8 {. B+ P& N while not adoqlinban.Eof
8 [) W- o" W7 o" x, H# _2 W$ m do
8 e! p# \7 G. T# l! x2 D begin! b( M. t2 j A. ?% |
strlinban:=trim(adoqlinban.Fields.fieldbyname('areacode').AsString );* s. p2 \9 B# z2 H
strcodelin:=strlinchang+'999'+stryinglinqu+'999'+strzuoyequ+'999'+strlinban;" p, i& k, s F! W, \ |- W
adoqxiaoban.SQL.Clear ;
7 W& D( B4 O9 T) Q8 n adoqxiaoban.SQL.Add('select areaname,areacode from tfsareacode where fatherarea=:linb');( e& @- ~5 C8 k' f1 p. U
adoqxiaoban.Parameters.ParamByName('linb').Value :=adoqlinban.Fields.fieldbyname('areaname').Value ;
0 x2 ?" P* [6 ]# P& f- Z$ I adoqxiaoban.Prepared ;
+ H* W$ C6 f9 c adoqxiaoban.Open ;3 Q& |2 u0 u, P- W8 G; F0 U7 j4 W
while not adoqxiaoban.Eof7 q* J% o1 p! L2 J% ]! v
do6 c! e# w! d/ o- E2 ]
begin
# K+ b* X$ w( n" A9 D3 y0 l7 ] strxiaoban:=trim(adoqxiaoban.Fields.fieldbyname('areacode').AsString );. g* i. C9 [$ C% X- l
strcodexia=strlinchang+'999'+stryinglinqu+'999'+strzuoyequ+'999'+strlinban+'999'+strxiaoban;! A% \, L% I y6 `1 b
strcode:=strlinban+strxiaoban;
- b( O! a) s% i6 [. W% {9 ]# m5 ^ adoqs.SQL.Clear ;
/ I& ^( [* m# I- K adoqs.SQL.Add('insert into test1 values('+strcodexiao+','+strcode+')');! S( b" w0 U/ [1 N: l! D
adoqs.Prepared ;. L( T- l8 \% ~& A- R' M
try2 o& X3 y' ^5 v7 s7 c2 U2 T
adoqs.Open ; ?3 j( ~3 {0 L: b. @- w
adoqxiaoban.Next ;2 @' V- n3 P9 T
except' ?7 v k% j; F9 P# K; ?
showmessage('出错!');! F+ A0 ~% z" D+ r }% V' Q- u
exit;+ g: m# T% S8 A# I2 h7 S
end;2 _& c) X* G# k U- q# c' s1 u
end;( t; O3 I; j( t# I; ]0 ~5 d0 \: M0 p
adoqlinban.Next ;
) h+ I# A' _& A9 b, \ end;, f( `2 Z4 `5 ^4 O/ n
adoqzuoyequ.Next;
- q( |1 p, H+ ~: |6 C- s end;
/ p& G7 T+ Y7 |$ E2 l q. o adoqyinglinqu.Next ;6 o( |( h, _) m6 d
end;5 J% L) L; \2 q* L( c$ M; P
adoqlinchang.Close ;
7 M* u# f! A+ ~& _' y6 c adoqyinglinqu.Close ;" Z& a7 B% e6 L
adoqzuoyequ.Close ;9 t7 \6 f, X! _6 t# U; k! B
adoqlinban.Close ;
& q% u% d4 m, O6 d7 Y3 c adoqxiaoban.Close ;
O1 Y7 U% i% w( u adoqs.Close ;
7 f/ N9 G& I& F1 H2 S3 R1 Pend;</P><>end.</P> |
|