焦点广告从数据库中读数据_python scrapy object classid="clsid:d27cdb6e-ae6d--优快云博客

mysql4.0
id,pic,intro,url,orders

DROP TABLE IF EXISTS `foucs`;
CREATE TABLE `foucs` (
`id` int(11) NOT NULL auto_increment,
`pic` varchar(50) default NULL,
`intro` varchar(30) default NULL,
`url` varchar(50) default NULL,
`orders` int(11) default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

#
# Dumping data for table foucs
#

INSERT INTO `foucs` VALUES (1,'images/01.jpg','蔬菜广告创意01','http://www.admin5.com/union',4);
INSERT INTO `foucs` VALUES (2,'images/02.jpg','蔬菜广告创意02','http://www.admin5.com/union',3);
INSERT INTO `foucs` VALUES (3,'images/03.jpg','蔬菜广告创意03','http://www.admin5.com/union',2);
INSERT INTO `foucs` VALUES (4,'images/04.jpg','蔬菜广告创意04','http://www.admin5.com/union',1);
INSERT INTO `foucs` VALUES (5,'images/05.jpg','蔬菜广告创意05','http://www.admin5.com/union',0);

News.jsp

     <%
       String hqlfoucs="from foucs order by orders";
      List listfoucs= dbo.findSQLHibernate(hqlfoucs,1);
      foucs foucs1bean=new foucs();
       foucs foucs2bean=new foucs();
        foucs foucs3bean=new foucs();
         foucs foucs4bean=new foucs();
          foucs foucs5bean=new foucs();
      if(listfoucs.size()>0)
      {foucs1bean=(foucs)listfoucs.get(0);
      }
        if(listfoucs.size()>1)
      {foucs2bean=(foucs)listfoucs.get(1);
      }
        if(listfoucs.size()>2)
      {foucs3bean=(foucs)listfoucs.get(2);
      }
        if(listfoucs.size()>3)
      {foucs4bean=(foucs)listfoucs.get(3);
      }
       if(listfoucs.size()>4)
      {foucs5bean=(foucs)listfoucs.get(4);
      }


      %>
     <table width="283" height="210" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
    <td height="192" align="left">
<script type="text/javascript">
imgUrl1="<%=foucs1bean.getPic()%>";
imgtext1="<%=new String(foucs1bean.getIntro().getBytes("iso-8859-1"),"gb2312") %>";
imgLink1=escape("<%=foucs1bean.getUrl()%>");
imgUrl2="<%=foucs2bean.getPic()%>";
imgtext2="<%=new String(foucs2bean.getIntro().getBytes("iso-8859-1"),"gb2312") %>";
imgLink2=escape("<%=foucs2bean.getUrl()%>");
imgUrl3="<%=foucs3bean.getPic()%>";
imgtext3="<%=new String(foucs3bean.getIntro().getBytes("iso-8859-1"),"gb2312") %>";
imgLink3=escape("<%=foucs3bean.getUrl()%>");
imgUrl4="<%=foucs4bean.getPic()%>";
imgtext4="<%=new String(foucs4bean.getIntro().getBytes("iso-8859-1"),"gb2312") %>";
imgLink4=escape("<%=foucs4bean.getUrl()%>");
imgUrl5="<%=foucs5bean.getPic()%>";
imgtext5="<%=new String(foucs5bean.getIntro().getBytes("iso-8859-1"),"gb2312") %>";
imgLink5=escape("<%=foucs5bean.getUrl()%>");

var focus_width=283
var focus_height=192
var text_height=18
var swf_height = focus_height+text_height

var pics=imgUrl1+"|"+imgUrl2+"|"+imgUrl3+"|"+imgUrl4+"|"+imgUrl5
var links=imgLink1+"|"+imgLink2+"|"+imgLink3+"|"+imgLink4+"|"+imgLink5
var texts=imgtext1+"|"+imgtext2+"|"+imgtext3+"|"+imgtext4+"|"+imgtext5

document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">');
document.write('<param name="allowScriptAccess" value="sameDomain"><param name="movie" value="focus2.swf"><param name="quality" value="high"><param name="bgcolor" value="#f0faf5"">');
document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
document.write('<param name="FlashVars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'">');
document.write('</object>');
</script>
</td>
</tr>
</table>

添加修改文件有 foucs.java,foucs.hbm.xml,hibernate.cfg.xml images/01.jpg-05,jpg,foucs2.swf