epub 61-6

Size: px

Start display at page:

Download "epub 61-6"

移段
7 years ago
Views:

1 6 We b R e c o r d s e t

2 166 Dreamweaver UltraDev I I S

3 6 167 Tr a i n M i s K K 10 M 6-5 Dreamweaver UltraDev Repeat Region 6-5

4 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 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 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 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

5 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 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

6 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 O K Dreamweaver UltraDev Dreamweaver UltraDev 6-10 < %@ L A N G U A G E = " J A V A S C R I P T "% > < %

7 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 CursorTy p e 0 F o r w a r d O n l y " " 1 K e y s e t " "

8 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 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 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)

9 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 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 C o m p a n y N a m e A d d r e s s I n s e r t 4 6-1

10 174 Dreamweaver UltraDev Repeat Region 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

11 6 175 S h o w B j C o m p a n y. a s p 6-15 Repeat Region

12 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 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, 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

13 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

14 178 Dreamweaver UltraDev S E L E C T W H E R E SELECT 1, 2... FROM WHERE > > = < < = < > 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 "! % "

15 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 (4) In I n I n ( 1, 2, 3...) Company.City In(" ", " ") A n d O r A n d O r 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 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 A S C D E S C

16 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 FROM 1 LEFT JOIN 2 ON FROM 1 RIGHT JOIN 2 ON = < > < = > = < > INNER JOIN LEFT JOIN RIGHT JOIN Access Access 2000 INNER JOIN LEFT JOIN RIGHT JOIN INNER JOIN INNER JOIN

17 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 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 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 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 Next O K

18 182 Dreamweaver UltraDev

19 O K Database Item Add to SQL S Q L 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 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 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 Database Item C o m p a n y C i t y

20 184 Dreamweaver UltraDev W H E R E Address S Q L Database Item C o m p a n y C o m p a n y N a m e ORDER BY S Q L A S C D E S C 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

21 6 185 S Q L Dreamweaver UltraDev Dreamweaver UltraDev (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" )); 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

22 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" )); }

23 6 187 (6) Entered Va l u e 6-9 Enter Va l u e 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 S Q L 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 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

24 188 Dreamweaver UltraDev 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 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 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") //

25 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 Wi n d o w Server Behaviors C o p y C o p y 4 Wi n d o w Data Bindings Server Behaviors 5 P a s t e Wi n d o w s Server Behaviors R e c o r d s e t 4 E d i t

26 190 Dreamweaver UltraDev 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

epub 61-2

epub 61-2 2 Web Dreamweaver UltraDev Dreamweaver 3 We b We b We Dreamweaver UltraDev We b Dreamweaver UltraDev We b We b 2.1 Web We b We b D r e a m w e a v e r J a v a S c r i p t We b We b 2.1.1 Web We b C C +