newsmanager.java~26~

新闻管理系统

package newsset;
import java.util.ArrayList;
import java.util.*;
import java.sql.*;
public class NewsManager extends DBBean {
    public News chaone(String title)
   {   ArrayList list=new ArrayList();
       News ss=new News();
       String sql="select * from messg where title 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);

                     }
     } catch (SQLException ex) {
         ex.printStackTrace();
     }

       return ss;
   }
   public News chaone1(String zuozhe)
   {
       News ss=new News();
       String sql="select * from messg where zuozhe='%"+zuozhe+"%'";
       ResultSet rs=null;
       rs=this.executeQuery(sql);
       try {
        if (rs.next()) {
             String title1=rs.getString(1);
             String zuozhe1=rs.getString(2);
             String time=rs.getString(3);
             String neirong=rs.getString(4);
             ss.setTitle(title1);
             ss.setZuozhe(zuozhe1);
             ss.setTime(time);
             ss.setNeirong(neirong);
                     }
     } catch (SQLException ex) {
         ex.printStackTrace();
     }

       return ss;
   }
   public News chaone2(String time)
   {
       News ss=new News();
       String sql="select * from time where time='%"+time+"%'";
       ResultSet rs=null;
       rs=this.executeQuery(sql);
       try {
        if (rs.next()) {
             String title1=rs.getString(1);
             String zuozhe=rs.getString(2);
             String time1=rs.getString(3);
             String neirong=rs.getString(4);
             ss.setTitle(title1);
             ss.setZuozhe(zuozhe);
             ss.setTime(time1);
             ss.setNeirong(neirong);
                     }
     } catch (SQLException ex) {
         ex.printStackTrace();
     }

       return ss;
   }
   public News chaone3(String neirong)
   {
       News ss=new News();
       String sql="select * from UserInfo where neirong='%"+neirong+"%'";
       ResultSet rs=null;
       rs=this.executeQuery(sql);
       try {
        if (rs.next()) {
             String title1=rs.getString(1);
             String zuozhe=rs.getString(2);
             String time=rs.getString(3);
             String neirong1=rs.getString(4);
             ss.setTitle(title1);
             ss.setZuozhe(zuozhe);
             ss.setTime(time);
             ss.setNeirong(neirong1);

                     }
     } catch (SQLException ex) {
         ex.printStackTrace();
     }

       return ss;
   }




    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;
    }
   public static void  main(String args[])
    {

      NewsManager sm=new NewsManager();
      News s=new News();
      ArrayList list=new ArrayList();
      list=sm.NewstALL();
      boolean flag=false;

      for(int i=0;i<list.size();i++)
      {
          News s1=(News) list.get(i);
          System.out.println("title "+" zuozhe"+" time");
          System.out.println(s1.getTitle()+" "+s1.getZuozhe()+" "+s1.getTime());
      }
      }
    }