Ò»¸ö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&
Ïà¹ØÎÊ´ð£º
<%@language="vbscript"%>
<%option explicit%>
<html>
<head> <title>xxx </title> </head>
<script language=vbs>
'×¢Òâ±äÁ¿ ......
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function oo(a){
document.getEleme ......
HTML code:
dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="& ......
´ÓAcessÊý¾Ý¿âÀï²éÕÒµ½Ä³Ò»Ìõ¼Ç¼£¬Òª±È½ÏÕâÌõ¼Ç¼ÖеÄijһÁеÄÖµÊÇ·ñ°üº¬Ä³Ò»×ֶΡ£
±ÈÈ磬Êý¾Ý¶ÔËùÓеÄÓû§²Ù×÷½øÐÐÁ˼Ǽ¡£
ÔÚÈÕÖ¾²éѯÀÏë°ÑÓû§É¾³ý¼Ç¼ÒÔºìÉ«ÐÅÏ¢ÏÔʾ¡£
ÿÌõɾ³ýµÄÈÕÖ¾¼Ç¼ÀïÓÐÒ»Á ......
ÎÒÔÚ×öÒ»¸ö¸É²¿»¥ÆÀϵͳ£¬ÄѶÈÔÚÓÚ²»Í¬¼¶±ðµÄ¸É²¿£¬ËûËùÒªÆÀ¼ÛµÄÈËÊýÒÔ¼°¼¶±ðÊDz»Í¬µÄ£¬Õâ¾ÍÒª¸ù¾Ý²éѯ£¬ÏȰÑËûËùÒªÆÀ¼ÛµÄ¸É²¿±àºÅÕÒ³öÀ´£¬È»ºó¸ù¾Ý¸É²¿±àºÅµÄÊýÁ¿Éú³ÉÎı¾¿ò£¬È»ºó·ÖÊýÌîдºÃÒԺ󣬰ѷÖÊý¶ÔÓ¦²»Í¬µÄ ......