module.java

挺好的东东

package com.know;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import com.util.DBConn;

public class Module {
	
	public int id;
	
	public String name;
	
	public String adminid;
	
    public Module() {
   	 
	 }
    
  //查询所有知道吧模块  
    public ArrayList selModules() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="select * from know_sortid";
        ArrayList<Module> result=new ArrayList<Module>();
        
        try{
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 rs = stmt.executeQuery();    	 
      	     	  
      	  while (rs.next()){
      		  Module mo=new Module();
  			  mo.id=rs.getInt("id");
      		  mo.name=rs.getString("name");
      		  mo.adminid=rs.getString("adminid");
              if(rs.getString("adminid").trim().equals("")){
            	  mo.adminid="<font color=red>空缺</font>"; 
              }
      		  result.add(mo);
      		  
      	  }
      	
      	}
        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 int isUserExist() throws Exception{
	    Connection conn=null;
	    PreparedStatement stmt =null;
	    ResultSet rs =null;
	    int flag=0;
	      String sql = "select * from ts_users where userid=?";
	    try{
	      conn =DBConn.getConn();
	      stmt =conn.prepareStatement(sql); 
	      stmt.setString(1, adminid);
	      rs = stmt.executeQuery();
	      if(rs.next()){
	    	   flag=1;//存在
		       }
		   else{
		    	   flag=2;//不存在
		       }
	      
	    }catch(Exception e){
	    	e.printStackTrace();   
	    }finally{
	      try{
	        if(rs!=null)
	          rs.close();
	        if(stmt!=null)
	          stmt.close();
	        if(conn!=null)
	          conn.close();
	      }catch(Exception ee){
	    	  ee.printStackTrace();   
	      }
	    }
	   return flag;
	  }

 	
 //添加版块	
 	 public Boolean AddModule() throws Exception{
 		  Connection conn=null;
 		  PreparedStatement stmt =null;
 		  ResultSet rs =null;
 		  String sql ="insert into know_sortid (name,adminid) values (?,?)";
 	      boolean result=false;
 	      
 	      try{
 			   
 	    	 conn=DBConn.getConn();
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setString(1,this.name);
 	    	 stmt.setString(2,this.adminid);
 	    	 
 	    	 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 DelModule(int a_id) throws Exception{
 		  Connection conn=null;
 		  PreparedStatement stmt =null;
 		  ResultSet rs =null;
 		  String sql ="delete from know_sortid where id=?";
 	      boolean result=false;
 	      
 	      try{
 			   
 	    	 conn=DBConn.getConn();
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setInt(1,a_id);
             stmt.executeUpdate(); 
 	    	 
             sql="select * from know_article where sortid=?";
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setInt(1,a_id);
             rs=stmt.executeQuery();
             while(rs.next()){
            	 
            	 sql="delete from know_answer where articleid=?";
     	    	 stmt= conn.prepareStatement(sql); 
     	    	 stmt.setInt(1,rs.getInt("id"));
                 stmt.executeUpdate();  
            	 
             }
             
             sql="delete from know_article where sortid=?";
 	    	 stmt= conn.prepareStatement(sql); 
 	    	 stmt.setInt(1,a_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 viewModule() throws Exception{
   	  Connection conn=null;
   	  PreparedStatement stmt =null;
   	  ResultSet rs =null;
   	  String sql ="select * from know_sortid where id=?";
        boolean result=false;
         
         try{
       	 conn=DBConn.getConn();
       	 stmt= conn.prepareStatement(sql); 
       	 stmt.setInt(1, id);
       	 rs = stmt.executeQuery();    	 
       	     	  
       	 if (rs.next()){
       	     name=rs.getString("name").trim();
       		 adminid=rs.getString("adminid").trim();
               if(rs.getString("adminid").equals("")){
             	  adminid=""; 
               }
       		  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 editModule() throws Exception{
   	  Connection conn=null;
   	  PreparedStatement stmt =null;
   	  ResultSet rs =null;
   	  String sql ="update know_sortid set name=?,adminid=? where id=?";
        boolean result=false;
         
         try{
       	 conn=DBConn.getConn();
       	 stmt= conn.prepareStatement(sql); 
       	 stmt.setString(1, name);
       	 stmt.setString(2,adminid);
       	 stmt.setInt(3, 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;    	 
     }    
  
}