operation.java~91~

一、数据库登录名：blog 密码：blog 二、首页应该运行log.jsp页面。其用户名：aa 密码：aaaa

      faf.setId(rs.getString(1));
    faf.setName(rs.getString(2));
    faf.setQQnumber(rs.getString(3));
    faf.setDescription(rs.getString(4));
   list.add(faf);
}
 }catch(Exception e){e.printStackTrace();}
return list;
}
//查找投票信息
    public ArrayList findvote(){
     dao d=new dao();
     ArrayList list=new ArrayList();
     try{
       Connection con=d.getcon();
       Statement s=con.createStatement();
       String sql="select * from tb_vote";
       ResultSet rs=s.executeQuery(sql);
       while(rs.next()){
        ActionForm.voteActionForm  vaf=new voteActionForm();
        vaf.setId(rs.getString(1));
        vaf.setVoteName(rs.getString(2));
        vaf.setVoteNumber(rs.getString(3));
        list.add(vaf);
       }
     }catch(Exception e){e.printStackTrace();}
  return list;
 }
 //删除投票信息
 public boolean deletevote(voteActionForm vaf){
  dao d=new dao();
  boolean b=false;
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="delete from tb_vote where id='"+Integer.parseInt(vaf.getId())+"'";
    int t=s.executeUpdate(sql);
    if(t!=0){
     return b=true;
    }
    else{
     return b=false;
    }
  }catch(Exception e){e.printStackTrace();}
  return b;
 }
 //查看公告信息
 public ArrayList finddiscuss(){
  dao d=new dao() ;
  ArrayList list=new ArrayList() ;
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="select * from tb_discuss order by id desc";
    ResultSet rs=s.executeQuery(sql);
    while(rs.next()){
     discussActionForm daf=new discussActionForm();
     daf.setId(rs.getString(1));
     daf.setDiscussTitle(rs.getString(2));
     daf.setDiscussContent(rs.getString(3)) ;
     daf.setDiscussTime(rs.getString(4));
     list.add(daf);
    }
  }catch(Exception e){e.printStackTrace();}
  return list;
 }
 //修改公告信息
 public boolean alertdiscuss(discussActionForm daf){
  dao d=new dao();
  boolean b=false;
  try{
   Connection con=d.getcon();
   Statement s=con.createStatement();
   String sql="update tb_discuss set  discussTitle='"+Chinese.ToChinese(daf.getDiscussTitle())
              +"',discussContent='"+Chinese.ToChinese(daf.getDiscussContent())
              +"',discussTime='"+Chinese.ToChinese(daf.getDiscussTime())
              +"' where id='"+Integer.parseInt(daf.getId())+"'";
    int t=s.executeUpdate(sql);
    if(t!=0){
      return b=true;
    }
    else{
     return b=false;
    }
  }catch(Exception e){e.printStackTrace();}
  return b;
 }
 //删除公告信息
 public boolean deletediscuss(int id){
  dao d=new dao();
  boolean b=false;
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="delete from tb_discuss where id='"+id+"'";
    int t=s.executeUpdate(sql);
    if(t!=0){
      return b=true;
    }
    else{
     return b=false;
    }
  }catch(Exception e){e.printStackTrace();}
   return b;
 }
 //根据id查找公告
 public ArrayList finddiscussid(int id){
  dao d=new dao();
  ArrayList list=new ArrayList();
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="select * from tb_discuss where id='"+id+"'";
    ResultSet rs=s.executeQuery(sql);
    while(rs.next()){
     discussActionForm daf=new discussActionForm();
     daf.setId(rs.getString(1));
     daf.setDiscussTitle(rs.getString(2));
     daf.setDiscussContent(rs.getString(3));
     daf.setDiscussTime(rs.getString(4));
    list.add(daf);
 }
  }catch(Exception e){e.printStackTrace();}
  return list;
 }
 //文章查看
 public ArrayList findarticle(Integer typeid){
  dao d=new dao();
  String sql;
  ArrayList list=new ArrayList();
  try{
   Connection con=d.getcon();
   Statement s=con.createStatement();
   if(typeid==null){ sql="select * from tb_article";}
  else{sql="select * from tb_article where typeID='"+typeid+"' order by id desc";}
   ResultSet rs=s.executeQuery(sql);
   while(rs.next()){
     articleActionForm af=new articleActionForm();
     af.setId(rs.getString("id"));
     af.setTypeID(rs.getString("typeID"));
     af.setTitle(rs.getString("title"));
     af.setContent(rs.getString("content"));
     af.setPhTime(rs.getString("phTime"));
     af.setNumber(rs.getString("number"));
     list.add(af);

 }
  }catch(Exception e){e.printStackTrace();}
  return list;
 }
 //查找回复内容
 public ArrayList findRestore(Integer articleid){
   dao d=new dao();
   ArrayList list=new ArrayList();
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="select * from tb_restore where articleId='"+articleid+"'";
     ResultSet rs=s.executeQuery(sql);
     while(rs.next()){
  ActionForm.restoreActionForm raf=new ActionForm.restoreActionForm();
  raf.setId(rs.getString(1));
  raf.setArticleId(rs.getString(2));
  raf.setReAccount(rs.getString(3));
  raf.setReTitle(rs.getString(4));
  raf.setReContent(rs.getString(5));
     list.add(raf);
     }
   }catch(Exception e){e.printStackTrace();}
   return list;
 }
 //根据id查找文章类别
 public String findarticleType(Integer  id){
  dao d=new dao();
 String na=null;
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="select typeName from tb_articleType where id='"+id+"'";
    ResultSet rs=s.executeQuery(sql);
    while(rs.next()){

     na=rs.getString("typeName");

    }
  }catch(Exception e){e.printStackTrace();}
 return na;
 }
 //修改文章信息
 public boolean alertArticle(articleActionForm aaf){
  dao d=new dao();
  boolean b=false;
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="update tb_article set typeID='"+Integer.parseInt(aaf.getTypeID())+"',title='"+Chinese.ToChinese(aaf.getTitle())
               +"',content='"+Chinese.ToChinese(aaf.getContent())+"',phTime='"+Chinese.ToChinese(aaf.getPhTime())+"',number='"+Integer.parseInt(aaf.getNumber())
               +"' where id='"+Integer.parseInt(aaf.getId())+"'";
    int t=s.executeUpdate(sql);
    if(t!=0){
      return b=true;
    }
    else{
      return b=false;
    }
  }catch(Exception e){e.printStackTrace();}
 return b;
 }
 //单篇文章查询
 public ArrayList findArticle(Integer id){
   dao d=new dao();
   ArrayList list=new ArrayList();
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="select * from tb_article where id='"+id+"'";
     ResultSet rs=s.executeQuery(sql);
     while(rs.next()){
       articleActionForm aaf=new articleActionForm();
       aaf.setId(rs.getString(1));
       aaf.setTypeID(rs.getString(2));
       aaf.setTitle(rs.getString(3));
       aaf.setContent(rs.getString(4));
       aaf.setPhTime(rs.getString(5));
       aaf.setNumber(rs.getString(6));
       list.add(aaf);
     }
   }catch(Exception e){e.printStackTrace();}
 return list;
 }
 //文章查询2
 public articleActionForm findArticle2(Integer id){
   dao d=new dao();
     articleActionForm aaf=new articleActionForm();
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="select * from tb_article where id='"+id+"'";
     ResultSet rs=s.executeQuery(sql);
     while(rs.next()){

       aaf.setId(rs.getString(1));
       aaf.setTypeID(rs.getString(2));
       aaf.setTitle(rs.getString(3));
       aaf.setContent(rs.getString(4));
       aaf.setPhTime(rs.getString(5));
       aaf.setNumber(rs.getString(6));

     }
   }catch(Exception e){e.printStackTrace();}
 return aaf;
 }

 //删除文章
 public boolean deteleArticle(Integer id){
  dao d=new dao();
  boolean b=false;
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="delete from tb_article where id='"+id+"'";
    int t=s.executeUpdate(sql);
    if(t!=0){
     return b=true;
    }
    else{
     return b=false;
    }
  }catch(Exception e){e.printStackTrace();}
   return b;
 }
 //删除回复信息
 public boolean deleteRestore(Integer id){
  dao d=new dao();
  boolean b=false;
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="delete from tb_restore where id='"+id+"'";
    int t=s.executeUpdate(sql);
    if(t!=0){
      return b=true;
    }
    else{
     return b=false;
    }

  }catch(Exception e){e.printStackTrace();}
  return b;
 }
 //查找用户信息
 public ArrayList findconsumer(){
   dao d=new dao();
   ArrayList list=new ArrayList();
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="select * from tb_consumer";
     ResultSet rs=s.executeQuery(sql);
     while(rs.next()){
      ConsumerActionForm caf=new ConsumerActionForm();
       caf.setId(rs.getString(1));
       caf.setAccount(rs.getString(2));
       caf.setPassword(rs.getString(3));
       caf.setName(rs.getString(4));
       caf.setSex(rs.getString(5));
       caf.setQQnumber(rs.getString(6));
       caf.setMainPage(rs.getString(7));
       caf.setInterest(rs.getString(8));
       caf.setE(rs.getString(9));
       caf.setManageLevel(rs.getString(10));
     list.add(caf);
   }
   }catch(Exception e){e.printStackTrace();}
  return list;
 }
 //根据id查找用户信息
 public ConsumerActionForm findconsumerid(String account){
     dao d=new dao();
     ConsumerActionForm caf=new ConsumerActionForm();
      try{
        Connection con=d.getcon();
        Statement s=con.createStatement();
        String sql="select * from tb_consumer where account='"+account+"'";
        ResultSet rs=s.executeQuery(sql);
        while(rs.next()){

          caf.setId(rs.getString(1));
          caf.setAccount(rs.getString(2));
          caf.setPassword(rs.getString(3));
          caf.setName(rs.getString(4));
          caf.setSex(rs.getString(5));
          caf.setQQnumber(rs.getString(6));
          caf.setMainPage(rs.getString(7));
          caf.setInterest(rs.getString(8));
          caf.setE(rs.getString(9));
          caf.setManageLevel(rs.getString(10));

      }
      }catch(Exception e){e.printStackTrace();}
     return caf;

 }
 //删除用户信息
 public boolean deleteConsumer(String account){
  dao d=new dao();
  boolean b=false;
  try{
   Connection con=d.getcon();
   Statement s=con.createStatement();
   String sql="delete from tb_consumer where account='"+account+"'";
   int t=s.executeUpdate(sql);
   if(t!=0){
    return b=true;
   }
   else{
     return b=false;
   }
  }catch(Exception e){e.printStackTrace();}
  return b;
 }
}