newsmanager.java

新闻管理系统

package newsset;
import java.util.ArrayList;
import java.util.*;
import java.sql.*;
public class NewsManager extends DBBean {
       public ArrayList chaone(String title,String s)
   {   ArrayList list=new ArrayList();
       News ss=new News();
       String sql="";
       if(s.equals("1")){
           sql = "select * from messg where title like '%" + title +"%'";
       }

       if(s.equals("2"))
       {
           sql="select * from messg where neirong like'%"+ title +"%'";
       }

       if(s.equals("3"))
       {
           sql="select * from messg where zuozhe like'%"+ title +"%'";
       }

       if(s.equals("4"))
       {
           sql="select * from messg where time like'%"+ title +"%'";
       }

       ResultSet rs=null;
       rs=this.executeQuery(sql);
       try {
        while (rs.next()) {
             String title1=rs.getString(1);
             String zuozhe=rs.getString(2);
             String time=rs.getString(3);
             String neirong=rs.getString(4);
             ss.setTitle(title1);
             ss.setZuozhe(zuozhe);
             ss.setTime(time);
             ss.setNeirong(neirong);
             list.add(ss);
                     }
     } catch (SQLException ex) {
         ex.printStackTrace();
     }

       return list;
   }



    public int zong(){
    String sql="select sum(depiao) from dianying";
    ResultSet rs=null;
    int sum=0;
    rs=this.executeQuery(sql);
    try {
        if (rs.next()) {
            sum = rs.getInt(1);
        }
    } catch (SQLException ex) {
    }
   return sum;
    }
    //查询方法
   public ArrayList NewstALL()
   {
        ArrayList list=new ArrayList();
        String sql="select * from messg";
        ResultSet rs=null;
        rs=this.executeQuery(sql);
        try {
            while (rs.next()) {
                String title=rs.getString(1);
                String zuozhe=rs.getString(2);
                String time=rs.getString(3);
                String neirong=rs.getString(4);
                News s=new News();
                s.setTitle(title);
                s.setZuozhe(zuozhe);
                s.setTime(time);
                s.setNeirong(neirong);
                list.add(s);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return list;}
      //删除
    public boolean deletenews(String title)
    {
      boolean flag=false;
      String sql="delete from messg where title='"+title+"'";
      int i=0;
      i=this.executeUpdate(sql);
      if(i>0)
          flag=true;
      else
          flag=false;
      return flag;
    }
    //更新
    public boolean updatenew(News sss)
   {
       boolean flag=false;
     String sql="update messg set zuozhe='"+sss.getZuozhe()+"',time='"+sss.getTime()+"',neirong='"+sss.getNeirong()+"' where title='"+sss.getTitle()+"'";
     int i=0;
     i=this.executeUpdate(sql);
     if(i>0)
         flag=true;
     else
         flag=false;
     return flag;
   }

    //插入
    public boolean Addnews(News s)
    {
    boolean flag=false;
    String sql="insert into messg values('"+s.getTitle()+"','"+s.getZuozhe()+"','"+s.getTime()+"','"+s.getNeirong()+"')";
       int i=0;
    i=this.executeUpdate(sql);
    if(i>0)
        flag=true;
    else
        flag=false;
    return flag;
    }

    }