newsinfo.java

：一个用JavaScript开发的新闻管理系统。

package news;
import java.sql.*;
public class NewsInfo {
  private int nid;
  private int shownum;
  private String title;
  private String style;
  private int postorid;
  private String from;
  private String content;
  private String posttime;
  private int clicktime;
  DBConn conn=new DBConn();
  public NewsInfo(){}
  public void setNid(int id){
    this.nid=id;
  }
  public void setShownum(int num){
  this.shownum=num;
}
public String getTitle(){
  String sql="SELECT * FROM news WHERE id="+nid;
  try{
    ResultSet rs = conn.query(sql);
    if (rs.next()) {
       title=rs.getString("title");
       style=rs.getString("style");
       from=rs.getString("pfrom");
       postorid=rs.getInt("postorid");
       content=rs.getString("content");
       clicktime=rs.getInt("clicktime");
       posttime=rs.getString("posttime").substring(0,16);
    }
   rs.close();
   conn.DBclose();
  }
  catch(Exception e){
    System.out.print(e.toString());
    title="";
  }
  return title;
}
public String getStyle(){
  return style;
}
public String getFrom(){
  return from;
}
public int getPostorid(){
  return postorid;
}
public String getContent(){
  return content;
}
public String getPosttime(){
  return posttime;
}
public int getClicktime(){
  return clicktime;
}
public StringBuffer getLastnews(int page){
  StringBuffer buffer=new StringBuffer();
  String sql2="SELECT * FROM news";
  try{
    ResultSet rs=conn.query(sql2);
    rs.afterLast();
    int i=1;
    rs.relative(-(page-1)*shownum);
    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>");
      i++;
      if(i>=shownum)
        break;
    }
    rs.close();
   conn.DBclose();
  }
  catch(Exception ex){
    System.out.print(ex.toString());
    buffer.append("读取最近新闻失败！");
  }
  return buffer;
}
public int getTotal(){
  int total=0;
  DBConn con=new DBConn();
  String sql="SELECT * FROM news";
  try{
    ResultSet rs = con.query(sql);
    rs.last();
    total=rs.getRow();
    rs.close();
    con.DBclose();
  }
  catch(Exception e){
    System.out.print(e.toString());
  }
  return total;
}
public void setClicktime(int nid){
  DBConn con=new DBConn();
  String sql="UPDATE news SET clicktime=clicktime+1 WHERE id="+nid;
  try{
    con.update(sql);    
    con.DBclose();
  }
  catch(Exception e){
    System.out.print(e.toString());
  } 
}


}