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);
      }
       
   
      %>
    
 
   
 

 
添加修改文件有 foucs.java,foucs.hbm.xml,hibernate.cfg.xml  images/01.jpg-05,jpg,foucs2.swf 以上紫 {MOD}的那段代码,怎么用数组和循环实现,程序中尚有不足的地方欢迎提出,指导