Ò»¸öASPµÄÅжÏÎÊÌâ
Êý¾Ý¿âÖÐÓÐÁ½¸ö±íNEWS ºÍ KEYWORD
±íNEWSÖÐÓÐ×Ö¶Î id,content£¨×Ö¶ÎcontentÊÇntextÐÍ£©
±íKEYWORDÖÐÓÐ×Ö¶Î id,title,url
ÏÖÔÚÒªÓÃASP½øÐÐÅжϣ¬ÅжÏNEWSÖеÄ×Ö¶ÎcontentÖÐÈç¹û´æÔÚijÄÚÈݵÈÓÚ±íKEYWORDÖеÄ×Ö¶Îtitle£¬ÄÇôÕâ¸öÄÚÈݵij¬¼¶Á´½ÓµØÖ·¾ÍÊÇ×Ö¶ÎURLµÄÖµ¡£
ÀýÈ磺±ínewsÖÐÓÐÒ»Ìõ¼Ç¼ÖÐcontentµÄÖµÊÇ£º¡°°ÍµÙ¶ûÓпÉÄܱ»½»Ò×Â룿¿´ÆðÀ´£¬ËûºÍ°¢ÀïÔúÊÇͬÀàµÄÇòÔ±£¬ÏÖÔÚÎÒÃDz¢·Ç¹Ú¾ü¾ºÕùÕß¡£ÎªÊ²Ã´»ð¼ý²»ÓÃËûÀ´»»È¡µ½ÆÚºÏͬ£¬È»ºóÔÙ¼ÓÉÏÂóµÙµÄµ½ÆÚºÏͬ£¬´Ó¶øÔÚ2010ÄêÕùÈ¡µÃµ½²¨Ê²£¿¡±
¶ø±íKEYWORDÖÐ:
id title url
1 °ÍµÙ¶û http://www.sohu.com
2 °¢ÀïÔú http://www.163.com
3 ÂóµÙ http://www.sina.com
µ±Êä³ö±íNEWSÖеÄcontentʱ£¬contentÀïÃæµÄ¡°°ÍµÙ¶û¡±£¬¡°°¢ÀïÔú¡±£¬¡°ÂóµÙ¡±ÕâЩ×ÖÑ۵ij¬¼¶Á´½Ó·Ö±ð¡°http://www.sohu.com ¡±£¬¡°http://www.163.com ¡±£¬¡°http://www.sina.com ¡±
ÒѾÓÐÍøÓѸø³ö´ð°¸ÈçÏ£º
tcontent=rs0("content")
¡¡
sql="select title,url from [keyword] order by id desc"
rs.open sql,conn,1,1
do while not rs.eof
tcontent=replace(tcontent,rs("title")," <a href=' <%=rs("url&
Ïà¹ØÎÊ´ð£º
ÓÖÓöµ½ÎÊÌâÀÖ¡£¡£
http://localhost/vsnet/LssearchC.aspx?searchtxt=Íõ&city1===Ñ¡ÔñÊ¡·Ý==&city2===Ñ¡ÔñÊÐ==&city3===Ñ¡ÔñÇø£¨ÏØ£©==
ÕâÊÇaspÀïÃæµÄ
<iframe src="vsne ......
´ÓAcessÊý¾Ý¿âÀï²éÕÒµ½Ä³Ò»Ìõ¼Ç¼£¬Òª±È½ÏÕâÌõ¼Ç¼ÖеÄijһÁеÄÖµÊÇ·ñ°üº¬Ä³Ò»×ֶΡ£
±ÈÈ磬Êý¾Ý¶ÔËùÓеÄÓû§²Ù×÷½øÐÐÁ˼Ǽ¡£
ÔÚÈÕÖ¾²éѯÀÏë°ÑÓû§É¾³ý¼Ç¼ÒÔºìÉ«ÐÅÏ¢ÏÔʾ¡£
ÿÌõɾ³ýµÄÈÕÖ¾¼Ç¼ÀïÓÐÒ»Á ......
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
ÏÂÃæÊÇÒ»¶ÎÒ³Ãæ´úÂë,Ò»¸öDATALISTÀïÃæÓÐRADIOBUTTON,Õâ¸ö¿Ø¼þÓ¦¸ÃÔõôÓð¡,ÎÒÒªµÄЧ¹ûÊÇ,´ÓDBÀï²é³öÀ´µÄÊý¾ÝÏÔʾÔÚDATALISTÖÐ,×îÇ°ÃæÒ»ÁÐÊÇRADIOBUTTON,¿ÉÒÔÑ¡ÖÐÆäÖÐÒ»ÐÐ.ÏÖÔÚµÄЧ¹ûÊÇ,¿ÉÒÔͬʱѡÖжàÐв¢Çҵò»µ½Ñ¡ ......
"title"Õâ¸öÖµ±£´æ²»ÁË?ÇëÎʸßÊÖ´íÎóÔÒò
<%set rs=server.createobject("adodb.recordset")
rs.open "select * from question",conn,1,3
if ......