package cars;import java.sql.*;/** * <p>Title: 華奧汽車銷售集團網站</p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2005</p> * <p>Company: 明日科技有限公司</p> * @author not attributable * @version 1.0 */public class NewsShow {  String sql;  String show;  ResultSet rs;  int i=0;  public NewsShow() {    Bean1 data=new Bean1();    sql="select * from tb_News where Type='新聞報道' or Type='集團動向' or Type='新車報道' order by IssueDate";    try{      rs=data.getrs(sql);      rs.beforeFirst();      sql="";      while (rs.next()&&(i<10)){        sql=sql+"<tr><td height='20'>&nbsp;&nbsp;&nbsp;&nbsp;<a href='#'onClick=javascript:window.open('News_Particular.jsp?id="+rs.getInt("ID")+"','','width=500,height=560,toolbar=no,location=no,status=no,menubar=no') style='color:#000000'>"+rs.getString("Title")+"</a></td></tr>";      }    }    catch(SQLException ex){      ex.printStackTrace();    }    show="<table width='160' border='0' cellspacing='0' cellpadding='0'><tr>";    show=show+sql+"</table>";  }  public String getstring(){    return show;  }}