6 We b 6.1 6.1.1 R e c o r d s e t 6-1 6-1 6.1.2
166 Dreamweaver UltraDev 6-2 6-2 6-3 3 6-3 I I S
6 167 Tr a i n M i s 6-4 6-4 6.1.3 10 000 1 K 10 000K 10 M 6-5 Dreamweaver UltraDev Repeat Region 6-5
168 Dreamweaver UltraDev 6.2 Dreamweaver UltraDev A S P A D O R e c o r d s e t 5 R e c o r d s e t R e c o r d s e O p e n Dreamweaver UltraDev D r e a m w e a v e r U l t r a D e v S h o w B j C o m p a n y. a s p E m a i l 5 6.2.1 E m a i l 5 1 Dreamweaver UltraDev A S P S h o w B j C o m p a n y. a s p 2 Wi n d o w Data Bindings 3 6-6 R e c o r d s e t Q u e r y 4 Dreamweaver UltraDev Dreamweaver UltraDev S i m p l e 6-6 Recordset 6-7 5 N a m e r s r r s B j C o m p a n y 6 C o n n e c t i o n D e f i n e... 7 Ta b l e C o m p a n y 8 Ta b l e C o l u m n A l l Ta b l e
6 169 6-7 S e l e c t e d C t r l S h i f t C o m p a n y N a m e A d d r e s s P o s t a l C o d e Te l p h o n e E m a i l 5 9 F i l t e r C i t y C i t y 6-8 C i t y = 6-9 Entered Va l u e 6-8 6-9 10 S o r t C o m p a n y N a m e 11 S o r t A s c e n d i n g 0 9 A Z
170 Dreamweaver UltraDev D e s c e n d i n g 9 0 Z A A s c e n d i n g 12 6-10 O K 6-11 6-10 6-11 6.2.2 Dreamweaver UltraDev Dreamweaver UltraDev 6-10 < %@ L A N G U A G E = " J A V A S C R I P T "% > < %
6 171 var rsbjcompany MMColParam = " "; // if(string(request("mm_emptyvalue"))!= "undefined"){ rsbjcompany MMColParam = String(Request("MM_EmptyValue"));} // = % > < % var rsbjcompany = Server.CreateObject("ADODB.Recordset");// Recordset r s B j C o m p a n y ActiveConnection = "dsn=trainmisdatabase;uid=admin;pwd=1234;"; / rsbjcompany.source = "SELECT CompanyName, Address, Telephone, PostalCode, E FROM Company WHERE City = '"+ rsbjcompany MMColParam.replace(/ /g, "' ") + "' ORDER BY CompanyName ASC"; // rsbjcompany.cursortype = 0; // rsbjcompany.cursorlocation = 2; // rsbjcompany.locktype = 3; // rsbjcompany.open(); // R e c o r d s e t O p e n var rsbjcompany_numrows = 0; // Dreamweaver UltraDev % > A S P J a v a S c r i p t A S P A S P r s B j C o m p a n y R e c o r d s e t var rsbjcompany = Server.CreateObject("ADODB.Recordset"); R e c o r d s e t R e c o r d s e t A c t i v e C o n n e c t i o n R e c o r d s e t Dreamweaver UltraDev D S N Dreamweaver UltraDev rsbjcompany.activeconnection = "dsn=trainmisdatabase;uid=admin;pwd=1234;"; R e c o r d s e t S o u r c e R e c o r d s e t Command S Q L 6-10 S Q L rsbjcompany.source = "SELECT CompanyName, Address, Telephone, PostalCode, E FROM Company WHERE City = ' ORDER BY CompanyName ASC"; R e c o r d s e t C u r s o r Ty p e 6-1 6-1 CursorTy p e 0 F o r w a r d O n l y " " 1 K e y s e t " "
172 Dreamweaver UltraDev 2 D y n a m i c " " 3 S t a t i c " " A D O R R e c o r d s e t C u r s o r Ty p e 0 R e c o r d s e t C u r s o r L o c a t i o n 6-2 6-2 CursorLocation 2 S e r v e r 3 C l i e n t C u r s o r L o c a t i o n 2 R e c o r d s e t L o c k Ty p e 6-3 6-3 LockTy p e 1 R e a d O n l y R e c o r d s e t 2 P e s s i m i s t i c " " 3 O p t i m i s t i c U p d a t e " " 4 B a t c h O p t i m i s t i c C u r s o r L a c a t i o n a d U d e C l i e n t B a t c h " L o c k Ty p e 3 R e c o r d s e t O p e n R e c o r d s e t R e c o r d s e t R e c o r d s e t R e c o r d s e O p e n O p e n rsbjcompany.open(source, ActiveConnection, CursorType, LockType, Options)
6 173 O p e n O p t i o n s S o u r c e R e c o r d s e t R e c o r d s e O p e n C u r s o r L o c a t i o n C u r s o r L o c a t i o n 6.2.3 Dreamweaver UltraDev Repeat Region Repeat Region 1 Dreamweaver UltraDev S h o w B j C o m p a n y. a s p 2 D r e a m w e a v e r 2 5 6-1 6-12 3 C o m p a n y N a m e A d d r e s s 6-1 3 I n s e r t 4 6-1
174 Dreamweaver UltraDev 6-13 6-14 5 6-1 Repeat Region 6 6-16 7 R e c o r d s e t r s B j C o m p a n y S h o w All Records 8 O K 9 Vi e w Live Data 6-17
6 175 S h o w B j C o m p a n y. a s p 6-15 Repeat Region 6-16 6-17
176 Dreamweaver UltraDev 6.3 SQL R e c o r d s e t S o u r c e R e c o r d s e t. O p e n S o u r c e S Q L S Q S Q L Dreamweaver UltraDev 6.3.1 SQL S Q L S Q L Structure Query Language S Q L S Q L S e i k i u S Q L S Q L S Q L R e c o r d s e t S o u r c e S Q L R e c o r d s e t. O p e n Dreamweaver UltraDev 6-10 S Q L SELECT CompanyName, Address, Telephone, PostalCode, EMail FROM Company WHERE City = " "ORDER BY CompanyName ASC S Q L R e c o r d s e t S o u r c e D r e a m w e a v e r U l t r a D e v S Q L 6-10 S Q L S E L E C T 1. SELECT 1, 2...FROM F R O M 1 2 S Q L S Q SELECT 1, 2... FROM S Q L S Q L
6 177 S E L E C T F R O M F R O M S E L E C T F R O M S E L E C T S E L E C T F R O M S Q L SELECT CompanyName FROM Company S Q L SELECT CompanyName, Address FROM Company S Q L * SELECT * FROM Company A d d r e s s A d d r e s s S E L E C T A d d r e s s. S Q L SELECT Company.CompanyName FROM Company SELECT Company.CompanyName, Company.Address FROM Company SELECT Company. FROM Company. SELECT Company.CompanyName FROM Company
178 Dreamweaver UltraDev S E L E C T W H E R E SELECT 1, 2... FROM WHERE 6-4 6-5 6-4 > > = < < = < > 6-5 L i k e I s N o t B e t w e e n I n L i k e (1) Like L i k e C i t y Company.City = " " Company.City Like " " L i k e _ % #! Company.City Like " % " Company.City Like "! % "
6 179 L i k e [] [ 0-9 ] 0 9 [! 0-9 ] 0 9 Access *? Access SQL ADO SQL (2) Not N o t L i k e! Company.City Not " % " (3) Between B e t w e e n Between 10 And 100 10 1 00 (4) In I n I n ( 1, 2, 3...) Company.City In(" ", " ") A n d O r A n d O r 6-6 6-7 6-6 6-7 A n d Tr u e F a l s e O r Tr u e F a l s e Tr u e F a l s e Tr u e F a l s e F a l s e F a l s e Tr u e F a l s e Tr u e Tr u e Tr u e F a l s e 100102 Company.City = " " And Company.PostalCode = "100102" 3. S E L E C T ORDER BY SELECT 1, 2... FROM ORDER BY 1 ASC DESC, 2 ASC D E S C... 1 2 A S C D E S C
180 Dreamweaver UltraDev A S C D E S C Company.CompanyName ASC Company.CompanyName ASC, Company.PostalCode DESC M e m o O L E 4. I D I D INNER JOIN LEFT JOIN RIGHT JOIN S E L E C T F O R M FROM 1 INNER JOIN 2 ON 1. 2. FROM 1 LEFT JOIN 2 ON 1. 2. FROM 1 RIGHT JOIN 2 ON 1. 2. = < > < = > = < > INNER JOIN LEFT JOIN RIGHT JOIN Access 2000 6-18 6-18 Access 2000 INNER JOIN LEFT JOIN RIGHT JOIN INNER JOIN INNER JOIN
6 181 SELECT Company.CompanyName, Customer.CustomerName FROM Company INNER JOIN Customer ON Company.CompanyID = Customer.CompanyID; INNER JOIN INNER JOIN INNER JOIN INNER / S Q L SELECT Customer.CustomerName, Train.Content, Customer_Train.IsPassed FROM T INNER JOIN (Customer INNER JOIN Customer_Train ON Customer.CustomerID = Customer_Train.CustomerID) ON Train.TrainID = Customer_Train.TrainID A c c e s s 2000 S Q L Access 2000 W H E R E ORDER BY 6.3.2 S Q L Dreamweaver UltraDev 1 Dreamweaver UltraDev A S P S h o w B j C o m p a n y. a s p 2 Wi n d o w Data Bindings 3 6-6 R e c o r d s e t Q u e r y 4 Dreamweaver UltraDev 6-7 A d v a n c e d... 6-19 5 N a m e 6 C o n n e c t i o n 7 S Q L S Q 8 Te s t 6-20 Previous 25 25 25 Next 25 25 O K
182 Dreamweaver UltraDev 6-19 6-20
6 183 9 O K 6.3.3 6-19 Database Item Add to SQL S Q L 6-2 1 6-21 Database Item Ta b l e Vi e w Stored Procedures S Q L A c c e s s SQL Server S Q L 7 Access 2000 S Q L Database Item Add to SQL A S C SELECT CompanyName, Address FROM Company WHERE City=" " ORDER BY CompanyName 1 6-19 S Q L 2 Database Item 3 Database Item C o m p a n y C o m p a n y N a m e S E L E C T S Q L 6-22 6-22 CompanyName 4 Database Item C o m p a n y A d d r e s s S E L E C T S Q L 6-23 5 Database Item C o m p a n y C i t y
184 Dreamweaver UltraDev W H E R E 6-24 6-23 Address 6-24 6 S Q L 6-25 6-25 7 Database Item C o m p a n y C o m p a n y N a m e ORDER BY 6-26 6-26 8 S Q L A S C D E S C 6-27 6-27 9 O K 6-21 S Q L A c c e s s S Q L S Q L A c c e s s 6.4
6 185 S Q L Dreamweaver UltraDev Dreamweaver UltraDev 6.4.1 6-7 6-9 6-9 (1) URL Parameter U R L URL Parameter U R L Q u e r y C i t y Q u e r y C i t y 6-28 h t t p : //zhoumingtao /showbjcompany. a s p h t t p : / / z h o u m i n g t a o / s h o w b j c o m p a n y. a s p? Q u e r y C i t y = h t t p : / / z h o u m i n g t a o / s h o w b j c o m p a n y. a s p? Q u e r y C i t y = var rsbjcompany MMColParam = "0"; // // i f U R L " u n d e f i n e d " i f ( S t r i n g (R e q u e s t. Q u e r y S t r i n g( "Q u e r y C i t y"))!= "undefined") { // } rsbjcompany MMColParam = String( R e q u e s t. Q u e r y S t r i n g( "Q u e r y C i t y" )); 6-9 6-9 U R L Dreamweaver UltraDev R e q u e s t Q u e r y S t r i n g R e c o r d s e t S o u r c e W H R E R WHERE City = '"+ rsbjcompany MMColParam.replace(/ /g, "' ") + "'"; r s B j C o m p a n y M M C o l P a r a m S Q L r e p l a c e J a v a S c r i p t 6-28 URL
186 Dreamweaver UltraDev U R L G E T A c t i o n S h o w B j C o m p a n y. a s p Q u e r y C i t y Q u e r y C i t y U R L (2) Form Va r i a b l e F o r m Form Parameter F o r m U R L R e q u e s t. F o r m U R L R e q u e s t. Q u e r y S t r i n g var rsbjcompany MMColParam = "0"; i f ( S t r i n g (R e q u e s t. F o r m( "Q u e r y C i t y"))!= "undefined") { rsbjcompany MMColParam = String( R e q u e s t. F o r m( "Q u e r y C i t y" )); } Q u e r y C i t y U R L P O S T (3) Cookie C o o k i e C o o k i e R e q u e s t C o o k i e var rsbjcompany MMColParam = "0"; i f ( S t r i n g (R e q u e s t. C o o k i e( "Q u e r y C i t y"))!= "undefined") { rsbjcompany MMColParam = String(Request.Cookie("QueryCity")); } (4) Session Va r i a b l e Session Va r i a b l e S e s s i o n C o n t e n t var rsbjcompany MMColParam = "0"; i f ( S t r i n g ( S e s s i o n ("Q u e r y C i t y"))!= "undefined") { rsbjcompany MMColParam = String(Session("QueryCity")); } (5) Application Va r i a b l e Application Va r i a b l e A p p l i c a t i o n C o n t e n t var rsbjcompany MMColParam = "0"; if(string(application (" Q u e r y C i t y"))!= "undefined") { rsbjcompany MMColParam = String(Application Q u (" e r y C i t y" )); }
6 187 (6) Entered Va l u e 6-9 Enter Va l u e 6. 2. 1 6-10 var rsbjcompany MMColParam = " "; // if(string(request("mm_emptyvalue"))!= "undefined") // { } // M M _ E m p t y V a l u e r s B j C o m p a n y M M C o l P a r a m rsbjcompany MMColParam = String(Request("MM_EmptyValue")); 6-9 r s B j C o m p a n y M M C o l P a r a m i f i f S Q L 6.4.2 6-19 1 S Q L 6-29 6-21 6-29 SQL 2 S Q L Q u e r y C i t y Q u e r y P o s t a l C o d e 6-30 # C i t y P o s t a l C o d e 6-30 3 Va r i a b l e s 4 Va r i a b l e s N a m e Q u e r y C i t y Q u e r y P o s t a l C o d e 6-31 S Q L
188 Dreamweaver UltraDev 6-31 5 Default Va l u e Q u e r y C i t y Q u e r y P o s t a l C o d e 100102 6-32 6-32 6 Run-time Va l u e U R L R e q u e s t. Q u e r y S t r i n g ( Q u e r y C i t y ) R e q u e s t. Q u e r y S t r i n g ( Q u e r y P o s t a l C o d e ) 6-33 Q u e r y S t r i n g S Q L 6-33 7 O K var rsbjcompany QueryCity = " "; // if(string(request.querystring("querycity"))!= "undefined") // { rsbjcompany QueryCity = String(Request.QueryString("QueryCity")); // } var rsbjcompany QueryPostalCode = "100102"; // if(string(request.querystring("querypostalcode"))!= "undefined") //
6 189 { rsbjcompany QueryPostalCode = String (Request.QueryString ("QueryPostalCode")); // } r s B j C o m p a n y M M C o l P a r a m 6.5 Dreamweaver UltraDev 6.5.1 1 2 Wi n d o w Server Behaviors 6-34 3 6-35 C o p y C o p y 4 Wi n d o w Data Bindings Server Behaviors 5 P a s t e 6.5.2 6-34 1 Wi n d o w s Server Behaviors 6-35 2 6-36 3 R e c o r d s e t 4 E d i t
190 Dreamweaver UltraDev 6-36 5 S Q L 6 Cursor Ty p e R e c o r d s e t C u r s o r Ty p e Forward Only R e c o r d s e t C u r s o r Ty p e 0 Keyset R e c o r d s e t C u r s o r Ty p e 1 Dynamic R e c o r d s e t C u r s o r Ty p e 2 Static R e c o r d s e t C u r s o r Ty p e 3 7 Lock Ty p e Read Only R e c o r d s e t L o c k Ty p e 1 Pessimistic R e c o r d s e t L o c k Ty p e 2 Optimistic R e c o r d s e t L o c k Ty p e 3 BatchOptimistic R e c o r d s e t L o c k Ty p e 3 8 Cursor Location Server R e c o r d s e t C u r s o r L o c a t i o n 2 Client R e c o r d s e C u r s o r L o c a t i o n 3 9 6.5.3 1 2 3