know.java

挺好的东东

    		  article.title=rs.getString("title").trim();
    		  article.id=rs.getInt("id");
    		  article.asker=rs.getString("asker");
    		  article.award=rs.getInt("award");
    		  article.answerd=rs.getInt("answerd");
    		  article.createtime=rs.getString("createtime");
    		  result.add(article);
    		  
    	  }
    	
    	}
      catch(Exception e){
    		e.printStackTrace(); 
    	}
    	finally{
    	      try{
    	        if(rs!=null)
    	          rs.close();
    	        if(stmt!=null)
    	          stmt.close();
    	        if(conn!=null)
    	          conn.close();
    	      }catch(Exception e){
    	    	  e.printStackTrace(); 
    	      }
    	    }
       return result;    	 
  }
  
  
  public Boolean Add() throws Exception{
	  Connection conn=null;
	  PreparedStatement stmt =null;
	  ResultSet rs =null;
	  String sql ="insert into know_article (asker,title,content,award,sortid,createtime) values (?,?,?,?,?,?)";
      boolean result=false;
      
      try{
    	  java.util.Date date=new java.util.Date();
		   Timestamp tt=new Timestamp(date.getTime());   
		   
    	 conn=DBConn.getConn();
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setString(1,this.asker);
    	 stmt.setString(2,this.title);
    	 stmt.setString(3,this.content);
    	 stmt.setInt(4,this.award);
    	 stmt.setInt(5,this.sortid);
    	 stmt.setTimestamp(6,tt);
    	 
    	 stmt.executeUpdate(); 
    	  
    		 result=true; 
    	
    	}
      catch(Exception e){
    		e.printStackTrace(); 
    	}
    	finally{
    	      try{
    	        if(rs!=null)
    	          rs.close();
    	        if(stmt!=null)
    	          stmt.close();
    	        if(conn!=null)
    	          conn.close();
    	      }catch(Exception e){
    	    	  e.printStackTrace(); 
    	      }
    	    }
       return result;    	 
  }   
  
   
 
  
//查看问题
  public Boolean ViewQuestion() throws Exception{
	  Connection conn=null;
	  PreparedStatement stmt =null;
	  ResultSet rs =null;
	  String sql ="select A.answerd,A.flag,B.name,A.title,A.award," +
	  		     "A.createtime,A.settletime,A.content,A.bestid,A.asker,A.add_content,A.sortid from " +
	  		     "know_article A join know_sortid B on A.sortid=B.id where A.id=?";
      boolean result=false;
      
      try{
    	 conn=DBConn.getConn();
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setInt(1,this.id);  
    	 rs = stmt.executeQuery();  
    	 if(rs.next()){
    	 answerd=rs.getInt(1);
    	 flag=rs.getInt(2);
    	 type=rs.getString(3);
    	 title=rs.getString(4).trim();
    	 award=rs.getInt(5);
    	 createtime=rs.getString(6);
    	 settletime=rs.getString(7);
    	 content=rs.getString(8);
    	 bestid=rs.getInt(9);
    	 asker=rs.getString(10).trim();
    	 add_content=rs.getString(11);
    	 sortid=rs.getInt(12);
    	 result=true;
    	 }
    	   	  
        
    	
    	}
      catch(Exception e){
    		e.printStackTrace(); 
    	}
    	finally{
    	      try{
    	        if(rs!=null)
    	          rs.close();
    	        if(stmt!=null)
    	          stmt.close();
    	        if(conn!=null)
    	          conn.close();
    	      }catch(Exception e){
    	    	  e.printStackTrace(); 
    	      }
    	    }
       return result;    	 
  }
  
  
  
//查看问题回答
  public ArrayList ViewAnswer() throws Exception{
	  Connection conn=null;
	  PreparedStatement stmt =null;
	  ResultSet rs =null;
	  String sql ="select createtime,content ,replier,id from " +
	  		     "know_answer  where articleid=?";
	   ArrayList<Know> result=new ArrayList<Know>();
      
      try{
    	 conn=DBConn.getConn();
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setInt(1,this.id);  
    	 rs = stmt.executeQuery();  
    	 while(rs.next()){
         Know kk=new Know();
    	 kk.createtime=rs.getString(1);
    	 kk.content=rs.getString(2);
    	 kk.replier=rs.getString(3);
    	 kk.id=rs.getInt(4);
    	    	 
    	 result.add(kk);
    	 }  	  
        
    	
    	}
      catch(Exception e){
    		e.printStackTrace(); 
    	}
    	finally{
    	      try{
    	        if(rs!=null)
    	          rs.close();
    	        if(stmt!=null)
    	          stmt.close();
    	        if(conn!=null)
    	          conn.close();
    	      }catch(Exception e){
    	    	  e.printStackTrace(); 
    	      }
    	    }
       return result;    	 
  }
  
  
  public Boolean AddAnswer(String userid) throws Exception{
	  Connection conn=null;
	  PreparedStatement stmt =null;
	  ResultSet rs =null;
	  String sql ="insert into know_answer (content,replier,articleid,createtime) values (?,?,?,?)";
      boolean result=false;
      
      try{
    	  java.util.Date date=new java.util.Date();
		   Timestamp tt=new Timestamp(date.getTime());   
		   
    	 conn=DBConn.getConn();
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setString(1,this.content);
    	 stmt.setString(2,this.replier);
    	 stmt.setInt(3,this.id);
    	 stmt.setTimestamp(4,tt);
    	 
    	 stmt.executeUpdate(); 
    	 
    	 //更新回答数
    	 sql="update know_article set answerd=answerd+1 where id=?";
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setInt(1,this.id);
    	 stmt.executeUpdate(); 
    	 
    	 //更新积分
    	 User uu=new User();
    	 uu.UpMark(userid, 1);
    	 
    		 result=true; 
    	
    	}
      catch(Exception e){
    		e.printStackTrace(); 
    	}
    	finally{
    	      try{
    	        if(rs!=null)
    	          rs.close();
    	        if(stmt!=null)
    	          stmt.close();
    	        if(conn!=null)
    	          conn.close();
    	      }catch(Exception e){
    	    	  e.printStackTrace(); 
    	      }
    	    }
       return result;    	 
  } 
  
  
 //问题补充 
  public Boolean AddContent() throws Exception{
	  Connection conn=null;
	  PreparedStatement stmt =null;
	  ResultSet rs =null;
	  String add="";
	  String sql ="select * from know_article where id=?";
      boolean result=false;
      
      try{
		   
    	 conn=DBConn.getConn();
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setInt(1,this.id);
        rs= stmt.executeQuery();
        
        if(rs.next()){
        	add=rs.getString("add_content");
        }
        
        if (add==null){
        	sql="update know_article set add_content=? where id=?";
        }else{
        	sql="update know_article set add_content=add_content+'<br><br>'+? where id=?";
        }
        
       stmt= conn.prepareStatement(sql); 
       stmt.setString(1, this.add_content);
   	   stmt.setInt(2,this.id);
       stmt.executeUpdate();
 
    		 result=true; 
    	
    	}
      catch(Exception e){
    		e.printStackTrace(); 
    	}
    	finally{
    	      try{
    	        if(rs!=null)
    	          rs.close();
    	        if(stmt!=null)
    	          stmt.close();
    	        if(conn!=null)
    	          conn.close();
    	      }catch(Exception e){
    	    	  e.printStackTrace(); 
    	      }
    	    }
       return result;    	 
  }      
  

//采纳为最佳答案
  public Boolean SelBestid() throws Exception{
	  Connection conn=null;
	  PreparedStatement stmt =null;
	  ResultSet rs =null;
	  String sql ="update know_article set bestid=?,replier=?,flag=?,settletime=? where id=?";
      boolean result=false;
      
      try{
    	  
    	  java.util.Date date=new java.util.Date();
		   Timestamp tt=new Timestamp(date.getTime()); 
		   
    	 conn=DBConn.getConn();
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setInt(1,this.bestid);
    	 stmt.setString(2, this.replier);
    	 stmt.setInt(3, 2);
    	 stmt.setTimestamp(4,tt);
    	 stmt.setInt(5,this.id);
    	
    	 stmt.executeUpdate();	 
    	     	  
    		 result=true; 
    	    	
    	}
      catch(Exception e){
    		e.printStackTrace(); 
    	}
    	finally{
    	      try{
    	        if(rs!=null)
    	          rs.close();
    	        if(stmt!=null)
    	          stmt.close();
    	        if(conn!=null)
    	          conn.close();
    	      }catch(Exception e){
    	    	  e.printStackTrace(); 
    	      }
    	    }
       return result;    	 
  }    
  
 
 //删除问题 
  public Boolean delAsk() throws Exception{
	  Connection conn=null;
	  PreparedStatement stmt =null;
	  ResultSet rs =null;
	  String sql ="delete from know_article where id=?";
      boolean result=false;
      
      try{
 
    	  //减少提问者积分
    	  User user=new User();
		  user.getAskerInfo(id);
		  user.UpMark(user.userid, -10);
		   
		 //删除此问题 
    	 conn=DBConn.getConn();
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setInt(1,this.id);
         stmt.executeUpdate(); 
    	 
    	 //删除此问题相关回答
    	 sql="delete from know_answer where articleid=?";
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setInt(1,this.id);
    	 stmt.executeUpdate(); 
    	 
   		 result=true; 
    	
    	}
      catch(Exception e){
    		e.printStackTrace(); 
    	}
    	finally{
    	      try{
    	        if(rs!=null)
    	          rs.close();
    	        if(stmt!=null)
    	          stmt.close();
    	        if(conn!=null)
    	          conn.close();
    	      }catch(Exception e){
    	    	  e.printStackTrace(); 
    	      }
    	    }
       return result;    	 
  } 
    
//删除回答
  public Boolean delAnswer(int a_id) throws Exception{
	  Connection conn=null;
	  PreparedStatement stmt =null;
	  ResultSet rs =null;
	  String sql ="delete from know_answer where id=?";
      boolean result=false;
      
      try{
 
    	  //减少回答者积分
    	  User user=new User();
		  user.getAnswerInfo(a_id);
		  user.UpMark(user.userid, -5);
		   
		 //删除此回答 
    	 conn=DBConn.getConn();
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setInt(1,a_id);
         stmt.executeUpdate(); 
    	 
    	 //更新回答数
    	 sql="update know_article set answerd=answerd-1 where id=?";
    	 stmt= conn.prepareStatement(sql); 
    	 stmt.setInt(1,this.id);
    	 stmt.executeUpdate(); 
    	 
   		 result=true; 
    	
    	}
      catch(Exception e){
    		e.printStackTrace(); 
    	}
    	finally{
    	      try{
    	        if(rs!=null)
    	          rs.close();
    	        if(stmt!=null)
    	          stmt.close();
    	        if(conn!=null)
    	          conn.close();
    	      }catch(Exception e){
    	    	  e.printStackTrace(); 
    	      }
    	    }
       return result;    	 
  }  
  
}