operation.java~98~

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

    else{
     return b=false;
    }
  }catch(Exception e){e.printStackTrace();}
  return b;
 }
 //更新投票信息
 public boolean alertvote(voteActionForm vaf){
   dao d=new dao();
   boolean b=false;
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="update tb_vote set voteNumber=voteNumber+1 where id='"+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).toString());
     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();
  String sql;
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     if(id==null){
      sql="select * from tb_article";
     }else{
      sql="select * from tb_article where id='"+id+"' order by id desc";
     }
     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();}
   this.Add("增加",aaf);
   return aaf;
 }
//文章的增加
 public boolean Add(String operation,articleActionForm af){
     boolean flag = false;
     String sql = null;
     if(operation=="增加"){
      sql="update tb_article set number=number+1 where id='"+af.getId()+"'";
     }
     try{
       dao d=new dao();
       Connection con=d.getcon();
       Statement s=con.createStatement();
       int t=s.executeUpdate(sql);
       if(t!=0){
         return flag=true;
       }
       else{
        return flag=false;
       }
     }catch(Exception e){e.printStackTrace();}
   return flag;
 }
 //删除文章
 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;
 }
 //根据id查找用户名
 public String findName(Integer id){
   dao d=new dao();
   String name="";
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="select * from tb_consumer where id='"+id+"'";
     ResultSet rs=s.executeQuery(sql);
     while(rs.next()){
       name=rs.getString("name");
     }
   }catch(Exception e){e.printStackTrace();}
  return name;
 }
 //添加回复信息
 public boolean addrestore(restoreActionForm raf){
   dao d=new dao();
   boolean b=false;
   try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="insert into tb_restore  (articleId,reAccount,reTitle,reContent) values('"+
               Integer.parseInt(raf.getArticleId())+"','"+Integer.parseInt(raf.getReAccount())
               +"','"+Chinese.ToChinese(raf.getReTitle())+"','"+Chinese.ToChinese(raf.getReContent())+"')";
    int t=s.executeUpdate(sql);
    if(t!=0){
     return b=true;
    }
    else{
     return b=false;
    }
   }catch(Exception e){e.printStackTrace();}
   return b;
 }
}