operation.java~91~

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

package OperationDB;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.List;
import Dao.*;
import ActionForm.*;
import Tool.*;
import java.util.ArrayList;
public class operation {
    public operation() {
    }
    //用户注册
    public boolean reg(ConsumerActionForm caf){
     boolean bb=false;
      dao d=new dao();
      String m="普通";
        try{
            Connection con=d.getcon();
             Statement s=con.createStatement();
             String sql="insert into tb_consumer(account,password,name,sex,QQnumber,mainPage,interest,eMail,manageLevel) "+
                             " values ('"+Chinese.ToChinese(caf.getAccount())+"','"+caf.getPassword()+"','"+Chinese.ToChinese(caf.getName())+"','"+Chinese.ToChinese(caf.getSex())+"',"+
                  "'"+caf.getQQnumber()+"','"+caf.getMainPage()+"','"+Chinese.ToChinese(caf.getInterest())+"','"+caf.getE()+"','"+m+"')";
       int count =s.executeUpdate(sql);
   if(count!=0){
     return bb=true;
   }
   else{bb=false;}

        }
        catch(Exception ce){ce.printStackTrace();

        }
        return bb;

    }
    //用户登录
    public boolean log(ConsumerActionForm caf){
      dao d=new dao();
      ArrayList a=new ArrayList();
      boolean flag=false;
      try{
        Connection con=d.getcon();
        Statement s=con.createStatement();
        String sql="select * from tb_consumer where account='"+caf.getAccount()+"' and  password='"+caf.getPassword()+"'";
        ResultSet rs=s.executeQuery(sql);
       if(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));
           a.add(caf);
           return flag= true;
 }else{
   return flag=false;
 }

      }catch(Exception ce){ce.printStackTrace();}
      return flag;

    }
//更新用户
    public boolean updateConsumer(ConsumerActionForm caf){
      dao d=new dao();
      boolean b=false;
      try{
        Connection con=d.getcon();
        Statement s=con.createStatement();
        String sql="update tb_consumer set account='"+caf.getAccount()+"',password='"+caf.getPassword()+"',name='"+
                   Chinese.ToChinese(caf.getName())+"',sex='"+Chinese.ToChinese(caf.getSex())+"',QQnumber='"+caf.getQQnumber()+"',mainPage='"+
                   caf.getMainPage()+"',interest='"+Chinese.ToChinese(caf.getInterest())+"',eMail='"+caf.getE()+"' where id='"+caf.getId()+"'";
      int count=s.executeUpdate(sql);
      if(count!=0){
      return b=true;
      }
      else{b=false;}
      }catch(Exception ce){ce.printStackTrace();}
    return b;
  }
  //查找博主信息
  public  ArrayList  selectHostConsumer(String ml){
    dao d=new dao();
    ArrayList list=new ArrayList();
    try{
      Connection con=d.getcon();
      Statement s=con.createStatement();

      String sql="select name,sex,QQnumber,mainPage,interest,eMail,manageLevel from tb_consumer where manageLevel='"+ml+"'";
      ResultSet rs=s.executeQuery(sql);
      if(rs.next()){
        ConsumerActionForm caf=new ConsumerActionForm();
        caf.setName(rs.getString("name"));
        caf.setSex(rs.getString("sex"));
        caf.setQQnumber(rs.getString("QQnumber"));
        caf.setMainPage(rs.getString("mainPage"));
        caf.setInterest(rs.getString("interest"));
        caf.setE(rs.getString("eMail"));
        caf.setManageLevel(rs.getString("manageLevel"));
        list.add(caf);
      }
    }catch(Exception ce){ce.printStackTrace();}
    return list;
  }
  //添加文章类型
  public boolean insertArticleType(articleTypeActionForm ata){
   dao d=new dao() ;
   boolean bb=false;
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="insert into tb_articleType (typeName,description) values ('"+Chinese.ToChinese(ata.getTypeName())+"','"+Chinese.ToChinese(ata.getDescription())+"')";
    int t=  s.executeUpdate(sql);
  if(t!=0){
    return bb=true;
  }
  else{return bb=false;}
   }catch(Exception c){c.printStackTrace();}
   return bb;
  }
   //文章类别查询
   public ArrayList slectArticleType(){
    dao d=new dao();
    ArrayList list=new ArrayList();
    try{
      Connection con=d.getcon();
      Statement s=con.createStatement();
      String sql="select * from tb_articleType";
      ResultSet rs=s.executeQuery(sql);
      while(rs.next()){
      articleTypeActionForm ata=new articleTypeActionForm() ;
      ata.setId(rs.getString(1));
      ata.setTypeName(rs.getString(2));
      ata.setDescription(rs.getString(3));
      list.add(ata);
      }
    }catch(Exception e){e.printStackTrace();}
 return list;
}
    //删除文章类别
    public boolean deleteArticleType(String id){
      dao d=new dao() ;
      boolean bb=false;
      try{
        Connection con=d.getcon();
        Statement s=con.createStatement();
        String sql="delete  from tb_articleType where id='"+Integer.parseInt(id)+"'";
        int t=s.executeUpdate(sql);
      if(t!=0){
       return bb=true;
      }
      else{
       return bb=false;
      }
    }catch(Exception e){e.printStackTrace();}
  return bb;
}
    //添加文章
    public boolean addArticle(articleActionForm aaf){
     dao d=new dao();
      boolean bb=false;
     try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="insert into tb_article (typeID,title,content,phTime,number) values ('"+
                Integer.parseInt(aaf.getTypeID())+"','"+Chinese.ToChinese(aaf.getTitle())
                +"','"+Chinese.ToChinese(aaf.getContent())+"','"+Chinese.ToChinese(aaf.getPhTime())
                +"','"+Integer.parseInt(aaf.getNumber())+"')";
     int t=s.executeUpdate(sql);
     if(t!=0){
      return bb=true;
     }
     else{return bb=false;}
     }catch(Exception e){e.printStackTrace();}
  return bb;
 }
 //添加公告信息
 public boolean addDiscuss(discussActionForm daf){
  dao d=new dao();
  boolean bb=false;
  try{
   Connection con=d.getcon();
   Statement s=con.createStatement();
   String sql="insert into tb_discuss (discussTitle,discussContent,discussTime) values('"+
              Chinese.ToChinese(daf.getDiscussTitle())+"','"+Chinese.ToChinese(daf.getDiscussContent())
              +"','"+Chinese.ToChinese(daf.getDiscussTime())+"')";
   int t=s.executeUpdate(sql);
   if(t!=0){
    return bb=true;
   }
   else{return bb=false;}
  }catch(Exception e){e.printStackTrace();}
  return bb;
 }
 //添加投票信息
 public boolean addvote(voteActionForm vaf){
   boolean bb=false;
   dao d=new dao();
   try{
   Connection con=d.getcon();
   Statement s=con.createStatement();
   String sql="insert into tb_vote (voteName,voteNumber) values('"+
              Chinese.ToChinese(vaf.getVoteName())+"','"+Integer.parseInt(vaf.getVoteNumber())+"')";
   int t=s.executeUpdate(sql);
   if(t!=0){
    return bb=true;
   }
   else{
     return bb=false;
   }
   }catch(Exception e){e.printStackTrace();}
   return bb;
 }
 //添加朋友信息
 public boolean addfriend(friendActionForm faf){
  dao d=new dao();
  boolean bb=false;
  try{
   Connection con=d.getcon();
   Statement s=con.createStatement();
   String sql="insert into tb_friends (name,QQnumber,description) values('"+
              Chinese.ToChinese(faf.getName())+"','"+Chinese.ToChinese(faf.getQQnumber())
              +"','"+Chinese.ToChinese(faf.getDescription())+"')";
   int t=s.executeUpdate(sql);
     if(t!=0){
    return bb=true;
   }
   else{
    return bb=false;
   }
  }catch(Exception e){e.printStackTrace();}
  return bb;
 }
 //添加相片
 public boolean addphoto(photoActionForm paf){
   dao d=new dao();
   boolean bb=false;
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="insert into tb_photo (photoAddress,photoDescription,photoTime) values('"+
                Chinese.ToChinese(paf.getPhotoAddress())+"','"+paf.getPhotoDescription()
                +"','"+paf.getPhotoTime()+"')";
     int t=s.executeUpdate(sql);
     if(t!=0){
      return bb=true;
     }
     else{
      return bb=false;
     }
   }catch(Exception e){e.printStackTrace();}
  return bb;
 }
 //查找相片
 public ArrayList findphoto(){
  dao d=new dao();
   ArrayList list=new ArrayList();
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="select * from tb_photo order by id desc";
    ResultSet rs=s.executeQuery(sql);
    while(rs.next()){
       ActionForm.photoActionForm paf=new photoActionForm();
      paf.setId(rs.getString(1));
      paf.setPhotoAddress(rs.getString(2));
      paf.setPhotoDescription(rs.getString(3));
      paf.setPhotoTime(rs.getString(4));
      list.add(paf);
    }
  }catch(Exception e){e.printStackTrace();}
  return list;
 }
 //删除相片
 public boolean deletephoto(int id){
  dao d=new dao();
  boolean b=false;
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="delete from tb_photo 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 findfriend(){
  dao d=new dao();
  ArrayList list =new ArrayList();
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="select * from tb_friends";
    ResultSet rs=s.executeQuery(sql);
    while(rs.next()){
      ActionForm.friendActionForm faf=new friendActionForm();
       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 boolean deletefriend(int id){
   dao d=new dao();
   boolean bb=false;
   try{
     Connection con=d.getcon();
     Statement s=con.createStatement();
     String sql="delete from tb_friends where id='"+id+"'";
    int t=s.executeUpdate(sql);
    if(t!=0){
     return bb=true;
    }
    else{
     return bb=false;
    }
 }catch(Exception e){e.printStackTrace();}
   return bb;
 }
 //修改朋友信息
 public boolean alertfriend(friendActionForm faf){
  dao d=new dao();
  boolean b=false;
  try{
    Connection con=d.getcon();
    Statement s=con.createStatement();
    String sql="update tb_friends set name='"+Chinese.ToChinese(faf.getName())+"',QQnumber='"+Chinese.ToChinese(faf.getQQnumber())+"',description='"+Chinese.ToChinese(faf.getDescription())+"' where id='"+Integer.parseInt(faf.getId())+"'";
   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 findfriendid(int id){
 dao d=new dao();
 ArrayList list =new ArrayList();
 try{
   Connection con=d.getcon();
   Statement s=con.createStatement();
   String sql="select * from tb_friends where id='"+id+"'";
   ResultSet rs=s.executeQuery(sql);
   while(rs.next()){
     ActionForm.friendActionForm faf=new friendActionForm();