package news;
import java.sql.*;
public class SearchNews{
public SearchNews(){} 
public StringBuffer getSearchnews(String title,String content){
  StringBuffer buffer=new StringBuffer();
  DBConn conn=new DBConn();
  if(title.equals(""))
     title="_*";
  if(content.equals(""))
     content="_*";
  String sql2="SELECT * FROM news WHERE title REGEXP '"+title+"' AND content REGEXP '"+content+"'";
  try{
    ResultSet rs=conn.query(sql2);
    rs.afterLast();
    while(rs.previous()){
      String tt=rs.getString("title");
      String time=rs.getString("posttime").substring(0,16);
      buffer.append("<TR><TD width=26><img src='include/dot.gif'/></TD>");
      buffer.append("<TD><a href='shownews.jsp?nid="+rs.getInt("id")+"'>");
      buffer.append(tt+"</a></TD>");
      buffer.append("<TD>"+time+"</TD></TR>");
    }
    rs.close();
    conn.DBclose();
  }
  catch(Exception ex){
    System.out.print(ex.toString());
    buffer.append("<TR><TD colspan='3'>沒有記錄或讀取新聞失敗！</TD></TR>");
  }
  return buffer;
}
}