ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[±Ð¾Ç] (¹ê¾Ô±MÃD) ¸ê®Æ®wÁpµ¸Ã¯ ¤W½g

[±Ð¾Ç] (¹ê¾Ô±MÃD) ¸ê®Æ®wÁpµ¸Ã¯ ¤W½g

¦b¤W¤@³¹¤¤¤p»x¤w¸g»¡©ú¡G½d¨Ò¬O¥H®Õ¶éÀ³¥Î¬°¥DÃD¡A¦]¦¹¦b¦WºÙªº©w¸q¤W³£ºÙ¬°¡uÁpµ¸Ã¯¡v¦Ó¤£¬O¡u¯d¨¥ª©¡v¡I§Æ±æ¤j®a¤£­n»~·|¤FËç¡I

¥»½d¨Ò¤¤±N§Q¥ÎSQL»yªk¹LÂo¯S©wªº®aªø¯d¨¥·N¨£¡AÅý¦Ñ®v¥i¥H°w¹ï¬Y¦ì¯S©w¾Ç¥Í®aªø©Òµoªíªº·N¨£§@¥X¿W¥ßªº¦^À³¡A¦P®É¡A®aªø¦bµoªí­Ó¤H·N¨£®É¡A­Y»{¬°·N¨£¤º®e¯A¤Î±Ó·Pªº¸ÜÃD©Î¬O·N¨£¤º®e¯A¤Î¨p¤HÁô¨p¡A³£¥i¥Î¡y®¨®¨¸Ü¡zªº¤è¦¡µo¨¥¡A³o¨Ç¡y®¨®¨¸Ü¡z±N¤£·|³QÅã¥Ü¥X¨ÓÅý¤j®a¬Ý¨ì¡A·íµM¡A¦Ñ®v¾Ö¦³ºÞ²zªº¯à¤O¡A¥u­n¥H±K½Xµn¤JºÞ²z¼Ò¦¡¡A´N¥i¥H¶i¦æ¦U­Ó¾Ç¥Í®aªøªº³æ¿W·N¨£¦^ÂСA¦Ó¥BÁÙ¯à¬Ý¨ì®aªø­Ì©Ò¯d¤Uªº¡y®¨®¨¸Ü¡z¡C

²Õ¦¨ºc³y
   ¥»½d¨Ò¤¤¨Ï¥Î¤F¦hºØASPª«¥óªº¤Þ¥Î¡A¦P®ÉÁÙÀ³¥Î¤F³\¦hºô­¶ªí³æªº³]­p§Þ¥©¡A¤£¹L¡I¦pªG±z¤w¸g¼ô±x¤F§Ú­Ì¤W¤@³¹¡y¤å¦rÀÉÁpµ¸Ã¯¡z½d¨Òªº­ì²z¡A¬Û«H¥»½d¨Ò¤¤©Ò´£¤§³]­p²z½×¹ï¦U¦ìºô¸ô¢í±Ð®v¨Ó»¡¡A²ª½´N¬O©ö¦p¤Ï´x¡C

  • §Ú­Ìªº¡y®a®xÁpµ¸Ã¯¡z¦]¬°¥²¶·¨ã³Æµo¨¥¤º®e¯A¤Î±Ó·P¸ÜÃD©Î¬O¯A¤Î¨p¤HÁô¨pªº®aªøµo¨¥¥i¥Î¡y®¨®¨¸Ü¡zªº¤è¦¡µo¨¥»PÅã¥Ü¡A¦P®É¤]§Æ±æ¦Ñ®v¯à°w¹ï¬Y¦ì¯S©w¾Ç¥Í®aªø©Òµoªíªº·N¨£§@¥X¿W¥ßªº¦^À³¡A¦]¦¹¡A§Ú­Ì¡yÅã¥Ü¯d¨¥·N¨£¡zªººô­¶´N¥²¶·¨ã³Æ¦h¶µ¥\¯à¡A·íÅã¥Ü¼Ò¦¡¦b¤@¯ë±¡ªp®É­n¯àÅã¥Ü®aªø­Ìªº¤@¯ë©Êµo¨¥¡A¦P®ÉÁÙ±o±N¡y®¨®¨¸Ü¡zªºµo¨¥ÁôÂð_¨Ó¡F¦Ó·í¦Ñ®v¥H±K½Xµn¤J¦¨¬°ºÞ²z¼Ò¦¡®É¡A«h¥²¶·±N¤@¯ë©Êµo¨¥»P®¨®¨¸Üµo¨¥ªº¸ê®Æ¥þ³¡Åã¥Ü¥X¨Ó¡A¦P®ÉÁÙ±oÅý¦Ñ®v­Ì¥i¥H°w¹ï¬Y¦ì¯S©w¾Ç¥Í®aªø©Òµoªíªº·N¨£§@¥X¿W¥ßªº¦^À³¡A¦b¥»¨Ò¤¤§Ú­Ì±N³o­Ó¡yÅã¥Ü¯d¨¥·N¨£¡zªººô­¶ÀɮצWºÙ©w¬°¡G¡yguest.asp¡z¡C

  • ·í¾Ç¥Í®aªø·Q­nµoªí·N¨£©Î¤Ï¬Mªº®É­Ô¡A²z©Ò·íµMªº§Ú­ÌÁÙ±o¦A³]­p¤@­Ó¯à°÷Åý¾Ç¥Í®aªøµoªí·N¨£ªºªí³æºô­¶¡A³o­Óªí³æºô­¶¥²¶·´£¨Ñ¦U­Ó¸ê®Æ¿é¤JªºÄæ¦ì¨ÓÅý¾Ç¥Í®aªø¶ñ¼g¡A³Ì­«­nªº¬O¥²¶·¯àÅý¾Ç¥Í®aªø¦Û¦æ¿ï¾Ü¥Lªºµo¨¥¤º®e¬O§_­n¤½¶}¡A¦pªG¤£¤½¶}¡A«h§Ú­Ì¥u¯à¦b¦Ñ®v¥H±K½Xµn¤J¦¨¬°ºÞ²z¼Ò¦¡®É¤~±N¯d¨¥¤º®eÅã¥Ü¥X¨Ó¡A³o­ÓÅý¾Ç¥Í®aªøµo¨¥ªº¡y®aªøµo¨¥ªí³æ¡zºô­¶§Ú­Ì±N¥¦ªºÀɮצWºÙ©w¬°¡G¡yaddmsg.asp¡z¡C

  • ·í¾Ç¥Í®aªø©ó¡y®aªøµo¨¥ªí³æ¡z¤¤¶ñ¼g¦n¬ÛÃö¸ê®Æ«ö¤U¡y°e¥X·N¨£¡z«ö¶s¤§«á¡A³o¨Ç¶ñ¼g¦nªº¸ê®Æ±N¥æ¥Ñ¬ö¿ý¥H¤Î³B²z®aªøµo¨¥ªºASPµ{¦¡¨Ó¼g¤J¸ê®Æ®w¡A³o­Ó¬ö¿ý¥H¤Î³B²z®aªøµo¨¥ªºASPµ{¦¡ºô­¶Àɮקڭ̱N¥¦©w¦W¬°¡G¡yadd.asp¡z¡A¦¹ASPµ{¦¡¤£¶È­n±N®aªøªºµo¨¥¼g¤J¸ê®Æ®w¡A¦P®ÉÁÙ¥²¶·±±¨î±NÂsÄýºô­¶Âà¦V¦^¡yÅã¥Ü¯d¨¥·N¨£¡zªººô­¶¡C

  • ¦]¬°§Ú­Ìªº¡y®a®xÁpµ¸Ã¯¡z¯àÅý¦Ñ®v°w¹ï¬Y¦ì¯S©w¾Ç¥Í®aªø©Òµoªíªº·N¨£§@¥X¿W¥ßªº¦^À³¡A¦]¦¹§Ú­Ì¥²¶·³]­p¤@­Ó¦Ñ®v¦^ÂбM¥Îªº¡y¦Ñ®v¦^ÂЪí³æ¡z¡A³o­ÓÅý¦Ñ®v¦^Âоǥͮaªøµo¨¥ªº¡y¦Ñ®v¦^ÂЪí³æ¡zºô­¶§Ú­Ì±N¥¦ªºÀɮצWºÙ©w¬°¡G¡yteachans.asp¡z¡C

  • ·í¦Ñ®v©ó¡y¦Ñ®v¦^ÂЪí³æ¡z¤¤¶ñ¼g¦n¦^ÂФº®e«á¸ê®Æ«ö¤U¡y°e¥X¦^ÂСz«ö¶s¤§«á¡A³o¨Ç¶ñ¼g¦nªº¸ê®Æ±N¥æ¥Ñ¬ö¿ý¥H¤Î³B²z¦Ñ®v¦^ÂФº®eªºASPµ{¦¡¨Ó¼g¤J¸ê®Æ®w¡A³o­Ó¬ö¿ý¥H¤Î³B²z¦Ñ®v¦^ÂФº®eªºASPµ{¦¡ºô­¶Àɮקڭ̱N¥¦©w¦W¬°¡G¡yanssave.asp¡z¡A¦¹ASPµ{¦¡·|±N¦^ÂФº®e¼g¤J¸ê®Æ®w¡A¦P¼Ë¤]·|±NÂsÄýºô­¶Âà¦V¦^¡yÅã¥Ü¯d¨¥·N¨£¡zªººô­¶¡C

  • ³Ì«á¡AÁÙ¦³¤@­Ó¥²­nªºÀÉ®×¥²¶·³Q«Ø¥ß¡A¨º´N¬O¡y¬ö¿ý¸ê®ÆÀɮסz¡A³o­ÓÀÉ®×­t³d¦s©ñ®aªøµo¨¥¸ê®Æ»P¦Ñ®v¦^ÂФº®eªº¸ê®Æ°O¿ý¡A¦b¥»½d¨Ò¤¤³o­Ó¬ö¿ý¸ê®ÆÀɮ׬°¤@Access«¬ºAªº¸ê®Æ®wÀɮסA§Ú­Ì±N¥¦©w¦W¬°¡G¡ymessage.mdb¡z¡C


    ¦]¬°¥»¡y®a®xÁpµ¸Ã¯¡zªº¥\¯à¤ñ¸û¦h¡A¦P®Éµ{¦¡ªº¤º®e¤]¸û¬°½ÆÂø¡A¦]¦¹§Ú­ÌÁpµ¸Ã¯ªººc¦¨¦@¤À¦¨¤»¤j³¡¤À¡G

  • ·N¨£¯d¨¥µ²ªGºô­¶¡G¥Î¨ÓÅã¥Ü®aªøµo¨¥»P¦Ñ®v¦^ÂФº®e¡A¦P®ÉÁÙ¨ã³Æ¤@¯ë¼Ò¦¡»PºÞ²z¼Ò¦¡¨âºØÅã¥Ü¤èªk¡C

  • ®aªøµo¨¥ªí³æºô­¶¡GÅý¾Ç¥Í®aªø¶ñ¼gµo¨¥¤º®e¨Ã¿ï¾Üµo¨¥©Ê½è¡C

  • ®aªøµo¨¥¸ê®Æ³B²zASPµ{¦¡¡G³B²z®aªøµoªíªº·N¨£¸ê®Æ¡A¦P®É±N³o¨Ç·N¨£¸ê®Æ¬ö¿ý°_¨Ó¨Ã±Nºô­¶Åã¥ÜÂà¦V¦Ü·N¨£¯d¨¥µ²ªGºô­¶¡C

  • ¦Ñ®v¦^ÂЪí³æºô­¶¡GÅý¦Ñ®v°w¹ï¬Y¦ì¯S©w¾Ç¥Í®aªø©Òµoªíªº·N¨£§@¥X¿W¥ßªº¦^À³¡C

  • ¦Ñ®v¦^Âиê®Æ³B²zASPµ{¦¡¡G³B²z¦Ñ®v¦^ÂЪº¸ê®Æ¤º®e¡A¦P®É±N³o¨Ç·N¨£¸ê®Æ¬ö¿ý°_¨Ó¨Ã±Nºô­¶Åã¥ÜÂà¦V¦Ü·N¨£¯d¨¥µ²ªGºô­¶¡C

  • ¬ö¿ý¸ê®ÆÀɮסG¥Î¨ÓÀx¦s®aªøµo¨¥¸ê®Æ»P¦Ñ®v¦^Âиê®ÆªºAccess«¬ºA¸ê®Æ®wÀɮסC


¤U¹Ï¬°®a®xÁpµ¸Ã¯ªº²Õ¦¨»PÃöÁp©Ê»¡©ú¹Ï¡G

11-1.png
2010-5-26 00:21
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

¸ê®Æ®w»P¯d¨¥Åã¥Üµ{¦¡ºô­¶
¦]¬°§Ú­Ì±N®aªøµo¨¥»P¦Ñ®v¦^ÂЪº¤º®e¸ê®Æ¥þ³¡Àx¦s¦b¸ê®Æ®w¤¤¡A¦]¦¹¡A­n¦bºô­¶¤¤Åã¥Ü¥Ø«eªº®aªøµo¨¥»P¦Ñ®v¦^Âиê®Æ¡A«h§Ú­Ì¥²¶·¥ý¶i¦æ¸ê®Æ®wªº³sµ²»P¶}±Ò¡A­n³sµ²¸ê®Æ®w§Ú­Ì¥²¶·¨Ï¥ÎADOª«¥ó¸sªºConnectionª«¥ó¡F¦Ó­n¶}±Ò¸ê®Æ®w«h¥²¶·¨Ï¥ÎDOª«¥ó¸sªºRecordsetª«¥ó¡A²{¦b´N½Ð±z¥ýÀ˵ø¤@¤Uµ{¦¡¤º®e¡A±µ¤U¨Ó§Ú­Ì¦A¨Ó¤ÀªR¤@¤Uµ{¦¡¤¤ªº¨C¤@­Ó°Ê§@¡C
  1. Set CN = Server.CreateObject("ADODB.Connection")
  2. CN.Open "Driver={Microsoft Access Driver (*.mdb)};_
  3. DBQ="&Server.MapPath("message.mdb")
  4. Set RS=Server.CreateObject("ADODB.Recordset")
  5. SQL="SELECT*From allmessage order by ¯d¨¥¤é´Á Desc"
  6. RS.Open SQL,CN,1,1
½Æ»s¥N½X
«Ø¥ß¤@­ÓConnectionª«¥ó¡GCN
  1. Set CN = Server.CreateObject("ADODB.Connection")
½Æ»s¥N½X
«Ø¥ß»P¸ê®Æ®wªº³s½u¬O¦s¨úºô¸ô¸ê®Æ®w²Ä¤@¥ó­n§@ªº¨Æ¡A°õ¦æ¤W¦Cªº±Ô­z¡A§Ú­Ì´N«Ø¥ß¤F¤@­Ó¦W¬°¡yCN¡zªºConnection¸ê®Æ®w³sµ²ª«¥ó¡C

¨Ï¥ÎCN.Open¤èªk¶}±Ò¡ymessage.mdb¡z¸ê®Æ®w
  1. CN.Open "Driver={Microsoft Access Driver (*.mdb)};_
  2. DBQ="&Server.MapPath("message.mdb")
½Æ»s¥N½X
´£¥Ü
·íµ{¦¡±Ô­z¤Óªø®É¡A§Ú­Ì¥i¥H§Q¥Î¡y-¡z©³½u±Nµ{¦¡±Ô­z¤À¹j¦¨¨â¦æ¡A§Ú­Ì¤W¦Cªº±Ô­z´N¦]¬°¤Óªø¤F¡Aµ§ªÌ§Q¥Î¡y-¡z©³½u±Nµ{¦¡±Ô­z¤À¹j¦¨¨â¦æ¡C



  • ¥Ñ©ó§Ú­Ì¶}±Òªº¸ê®Æ®wÃþ«¬¬°Access(*.mdb)¸ê®Æ®w¡A©Ò¥H§Ú­Ì³z¹LAccessªºODBCÅX°Êµ{¦¡¨Ó¦s¨ú¸ê®Æ®w"Driver={Microsoft Access Driver (*.mdb)}"¡C

  • °£¤FÅX°Êµ{¦¡ªºDrive°Ñ¼Æ¥~¡A§Ú­ÌÁÙ¥²¶·¨Ï¥ÎDBQ°Ñ¼Æ¨Ó«ü©w§Ú­Ì·Q­n¶}±Òªº¸ê®Æ®wÀɮסA¦Ó¥B§Ú­Ì©Ò«ü©wªº¸ê®Æ®wÀÉ®×¥²¶·µ¹¤©§¹¾ãªº¸ô®|»PÀɮצWºÙ¡A©Ò¥H§Ú­Ì³z¹LServer.MapPath¨Ó¨úªº§Ú­Ì¸ê®Æ®wÀÉ®×message.mdbªº§¹¾ã¸ô®|¡C

  • Server.MapPath¡G±Nºô§}¸ô®|Âର¯u¹êªºÀɮ׸ô®| ¦]¬°ASP³W©w¥²¶·«ü©wÀɮתº¯u¹ê¸ô®|¡A¥Îªk¦p¤U:
    1. ¯u¹êªº¸ô®|=Server.MapPath("µêÀÀ¸ô®|")
    ½Æ»s¥N½X
  • ¸ê®Æ®wÅX°Êµ{¦¡¦WºÙ­þ¸Ì¨Ó¡H
    ³sµ²¤£¦PÃþ«¬ªº¸ê®Æ®w­n¨Ï¥Î¤£¦Pªº¹ïÀ³ÅX°Êµ{¦¡¡A³o¬Oµ§ªÌ¤@¦A±j½Õªº¡A¨º»ò§Ú­Ì¦p¦ó±oª¾¸ê®Æ®wÅX°Êµ{¦¡ªº¦WºÙ©O¡H¥ý¥´¶}¡y±±¨î¥x¡z¡AµM«á¦A¶}±Ò¡yODBC ¸ê®Æ¨Ó·½¡z¶µ¥Ø¡A¶}±Ò¡yODBC ¸ê®Æ¨Ó·½¡z¶µ¥Ø«á¡A±µµÛ´N·|¥X²{¡yODBC ¸ê®Æ¨Ó·½ºÞ²z­û¡z¹ï¸Üµøµ¡¡A§Ú­Ìª½±µ¤Á´«¦Ü¡yÅX°Êµ{¦¡¡z¿ï¶µ­¶¡Aª`·N¬Ý¨ì¡y¦WºÙ¡zÄæ¦ì¡A³o¨Ç±ø¦Cªº¶µ¥Ø´N¬O¶}±Ò¬ÛÃö¸ê®Æ®wªºÅX°Êµ{¦¡¦WºÙ¡I


    11-2.png
    2010-5-26 00:27
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

TOP

«Ø¥ß¤@­ÓRecord Setª«¥ó¡GRS
  1. Set RS=Server.CreateObject("ADODB.Recordset")
½Æ»s¥N½X
Recordsetª«¥ó¬O­t³dÂsÄý»P¾Þ§@±q¸ê®Æ®w¨ú¥X¨Óªº¸ê®Æ¡AConnectionª«¥ó¥u­t³d»P¸ê®Æ®w¶i¦æ³sµ²ªº°Ê§@¡A¨Ã¤£¯à¨Ï¥Î¸ê®Æ®w¤ºªº¸ê®Æ¡A¦]¦¹§Ú­Ì¥²¶·«Ø¥ß¤@¥i¥H¦s¨ú¸ê®Æ®w¸ê®ÆªºRecordsetª«¥ó¡A°õ¦æ¤W¦Cªº±Ô­z¡A§Ú­Ì´N«Ø¥ß¤F¤@­Ó¦W¬°¡yRS¡zªºRecordset¸ê®Æ®w¦s¨úª«¥ó¡C

¨Ï¥ÎRS.Open¤èªk¦s¨ú¡ymessage.mdb¡z¸ê®Æ®w
  1. RS.Open SQL,CN,1,1
½Æ»s¥N½X
¨Ï¥Îopen¤èªk¨Ó¶}±Ò¸ê®Æªí©Î°õ¦æSelect«ü¥O°Ñ¼Æ³]©w¦p¤U¡G

  • °Ñ¼Æ¤@(Source)¡G¦¹°Ñ¼Æ¥i¬°¤@­ÓCommandª«¥ó¦WºÙ¡B¤@¬qSQL«ü¥O¡B¤@­Ó«ü©wªº¸ê®Æªí®æ¦WºÙ©Î¬O¤@­ÓStored Procedure¡F­Y«ü©w¬°¸ê®Æªí¦WºÙ«h¶}±Ò¾ã­Ó¸ê®Æªí¡A­Y¨Ï¥ÎSelect«ü¥O«h«Ø¥ßªºRecordsetª«¥ó¤º©Ò¦s©ñªº¸ê®Æ¬°¿ï¨ú¸ê®Æ¿ýªºµ²ªG¡C ¦b¥»¨Ò¤¤§Ú­Ì¨Ï¥Î¤F¤@¬qSQL»yªk¡GÃö©óSQL»yªk§Ú­Ì±N¦A¤U¤@³æ¤¸¤¤¤¶²Ð¡C
    1. SELECT*From allmessage order by ¯d¨¥¤é´Á Desc
    ½Æ»s¥N½X
  • °Ñ¼Æ¤G(ActionConnection)¡GRecordset¥i³z¹L¦¹Äݩʳsµ²Connectionª«¥ó¡A¦¹°Ñ¼Æ¥i¬°Connectionª«¥ó¦WºÙ©Î¬O¤@¦ê¥]§t¡y¸ê®Æ®w³sµ²¸ê°T(ConnectionString)¡zªº¦r¦ê°Ñ¼Æ¡C ¦b¥»¨Ò¤¤§Ú­Ì±N¦¹°Ñ¼Æ³]¬°³sµ²§Ú­Ì¤w¸g«Ø¥ß¦nªºConnectionª«¥ó¡yCN¡z¡C

  • °Ñ¼Æ¤T(CursorType)¡Gªí¥H¦óºØ´å¼Ð¶}±Ò¸ê®Æ¡A¥]§tadOpenForwardOnly¡BadOpenKeyset¡BadOpenDynamic¡BadOpenStatic¥|ºØ¤è¦¡¡C¦b¥»¨Ò¤¤§Ú­Ì¨Ï¥ÎadOpenForwardOnly¤è¦¡¶}±Ò¸ê®Æ¡C

  • °Ñ¼Æ¥|(LockType)¡Gªí±Ä¥Î¦óºØLock«¬ºA¡A¥]§tadLockReadOnly¡BadLockPessimistic¡BadLockOptimistic¡BadLockBatchOptimistic¥|ºØ«¬ºA¡C¦b¥»¨Ò¤¤§Ú­Ì¨Ï¥Î¹w³]ªºadLockReadOnly«¬ºA¡C
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

TOP

¸ê®Æ±Æ§Ç»PSQL«ü¥O
§Ú­Ì¤§«e½Í¨ì¡A¨Ï¥ÎRecordsetª«¥óªºopen¤èªk¨Ó¶}±Ò¸ê®Æªí®É§Ú­Ì¨Ï¥Î¤F¤@¬qSQL»yªk¡G
  1. SELECT*From allmessage order by ¯d¨¥¤é´Á Desc
½Æ»s¥N½X
²{¦b§Ú­Ì´N¨Ó¬Ý¬Ý¦p¦ó¼¶¼gSQL«ü¥O¡G

¥i¿z¿ï¸ê®ÆªºSelect«ü¥O

  • Select«ü¥Oªº¿z¿ï±Ô­z¡G
    ¦bSQL»y¨¥¸Ì­±¡A³Ì¸g¨å¤]³Ì¹ê¥Îªº±Ô­z´N¬O¡ySelect.... From¡z¡A¡ySelect¡z³o­Ó­^¤å³æ¦r¤j®aÀ³¸Ó³£«Ü¼ô±x¡AÅU¦W«ä¸q¥L´N¬O¿ï¾Üªº·N«ä¡A­n¿ï¤°»ò©O¡H¿ï¾Üªº¨Ó·½¸ê®Æ¡yFrom¡z¤S¦b­þ¸Ì¡H³o¼Ëªº¨â­Ó³æ¦rµ²¦X´Nºc¦¨¤FSelect«ü¥Oªº°ò¥»±Ô­z¡A¦bSQL»y¨¥¤¤¡G¡ySelect¡z¬O±q¡y¸ê®Æªí¡z¤¤¿ï¨ú¬Y¨Ç¡yÄæ¦ì¡zªº¸ê®Æ¡A¨Ò¦p¡G

    11-3.png
    2010-5-26 00:34


    ¦b¤W¨Òªº·N«ä¬O»¡¡G±q¾Ç¥Í¦¨ÁZ¸ê®Æªí¤¤¿ï¨ú¼Æ¾Ç¦¨ÁZÄæ¦ìªº¸ê®Æ¡C

  • ¦pªG§Ú­Ì­n¿ï¨úªº¸ê®Æªí¸ê®Æ¥]§t¤F¤@­Ó¥H¤WªºÄæ¦ì¡A«h§Ú­Ì¥i¥H§Q¥Î¡y¡A¡z³r¸¹¨Ó±NÄæ¦ì¦WºÙ¹j¶}¡C
    °Ñ¼Æ¨Ï¥Î»¡©ú¡G

    11-4.png
    2010-5-26 00:34


  • ¦pªG§Ú­Ì­n¿ï¨úªº¸ê®Æªí¸ê®Æ¥]§t¤F¥þ³¡ªºÄæ¦ì¡A«h§Ú­Ì¥i¥H§Q¥Î¸U¥Î¦r¤¸¡y¡¯¡z¨Ó¥Nªí¥þ³¡ªºÄæ¦ì¡C

    11-5.png
    2010-5-26 00:34




¥i±Æ§Ç¸ê®ÆªºSelect«ü¥O

  • ·í§Ú­Ì§Æ±æ³Q¿ï¨ú¥X¨Óªº¸ê®Æ¿ý¸ê®Æ¯à°÷¨Ì¾Ú¬Y­Ó©Î¬Y´X­ÓÄæ¦ìªº¤º®e¨Ó±Æ§Ç®É¡A¥u­n±N³o¨Ç±Æ§Ç¨Ì¾ÚªºÄæ¦ìÂ\©ñ¦b¡yOrder By¡z«O¯d¦r¤§«á¡AµM«á±N³o­Ó±Æ§Çªº±Ô­z³s±µ¦b¡ySelect.... From¡z«á­±´N¦æ¤F¡G

    11-6.png
    2010-5-26 00:34


  • ¦pªG§Ú­Ì§Æ±æ§Q¥Î¦h­Ó±Æ§Ç¨Ì¾ÚªºÄæ¦ì¨Ó¶i¦æ±Æ§Ç¡A«h§Ú­Ì¥i¥H§Q¥Î¡y¡A¡z³r¸¹¨Ó±NÄæ¦ì¦WºÙ¹j¶}¡G

    11-7.png
    2010-5-26 00:36


    ¤W¨Ò¤¤¡G§Ú­Ì±N¥ý«ö·Ó¡y¼Æ¾Ç¦¨ÁZ¡zÄæ¦ì±Æ§Ç¡AµM«á¦A«ö·Ó¡y°ê¤å¦¨ÁZ¡z¶i¦æ±Æ§Ç¡C
  • ¡yOrder By¡z¹w³]ªº±Æ§Ç¤è¦¡¬O¡y¥Ñ¤p±Æ¨ì¤j¡z¡A¦ý­Y¬O§Ú­Ì§Æ±æ±Æ§Ç¤è¦¡¬O¡y¥Ñ¤j±Æ¨ì¤p¡z¡A«h§Ú­Ì¥i¦bÄæ¦ì¦WºÙ«á¦A¥[¤W¡yDesc¡z«O¯d¦r¡I±N±Æ§Ç¤è¦¡§ï¬°§Ú­Ì­nªº¡y¥Ñ¤j±Æ¨ì¤p¡z¡G

    11-8.png
    2010-5-26 00:37




¤F¸Ñ¤FSQL»y¨¥ªºSelect«ü¥O¥Îªk«á¡A§Ú­Ì¦^¹LÀY¨Ó¬Ý¤@¤U§Ú­Ì¦b¡yÅã¥Ü¯d¨¥·N¨£¡zºô­¶¤¤ªº¶}±Ò¸ê®Æ®wASPµ{¦¡¤¤ªº±Ô­z¡G
  1. SELECT*From allmessage order by ¯d¨¥¤é´Á Desc
½Æ»s¥N½X
³o­Ó±Ô­zªº·N¸q¬°¡G±q¸ê®Æªí¡yallmessage¡z¤¤¨ú¥X©Ò¦³Äæ¦ìªº¸ê®Æ¡A¨Ã±N¨ú¥Xªº¸ê®Æ¿ý¤º®e¨Ì·Ó¡y¯d¨¥¤é´Á¡zÄæ¦ì¨Ï¥Îªº¡y¥Ñ¤j±Æ¨ì¤p¡z±Æ§Ç¤è¦¡¶i¦æ±Æ§Ç¡C
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD