newsadmin.java

实现叫简单但是很经典的新闻发布管理系统

package news;
import java.sql.*;
public class NewsAdmin {
  public NewsAdmin(){}

  public int DeleNews(int nid){
    String sql="DELETE FROM news WHERE id="+nid;
    String sql2="DELETE FROM commentary WHERE nid="+nid;
    DBConn conn=new DBConn();
    int flag=0;
    try{
      flag=conn.update(sql);
      conn.update(sql2);
      conn.DBclose();
    }
    catch(Exception e){
      System.out.print(e.toString());
    }    
    return flag;
  }
  public int DeleComm(int cid){
    DBConn conn=new DBConn();
    String sql="DELETE FROM commentary WHERE id="+cid;
    int flag=0;
    try{
      flag=conn.update(sql);
      conn.DBclose();
    }
    catch(Exception e){
       System.out.print(e.toString());
    }
    return flag;
  }
  public boolean canAdmin(int adminid,int nid){
    DBConn conn=new DBConn();
    String sql="SELECT * FROM news WHERE id="+nid+" AND postorid="+adminid;
    boolean flag=false;
    try{
      ResultSet rs=conn.query(sql);

      if(rs.next())
        flag=true;
      rs.close();
      conn.DBclose();
    }
    catch(Exception e){
      System.out.print(e.toString());
    }
    return flag;
  }
}