work.java

挺好的东东

package com.room;

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

import com.util.DBConn;

public class Work{
	
	public int id;
	
    public int subjectid;
    
    public int workid;
    
    public String workname;
    
    public String student;
    
    public int score;
    
    public String opinion;
    
    public int status;
    
    public String filename;
	
    public Work() {
   	 
	 }
    

//新增作业
    public Boolean Add() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="insert into t_work (subjectid,workname) values (?,?)";
        boolean result=false;
        
        try{
		   
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setInt(1,this.subjectid);
      	 stmt.setString(2,this.workname);
      	 
      	 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 ArrayList ViewAll() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="select * from t_work where subjectid=?";
        ArrayList<Work> result=new ArrayList<Work>();
        
        try{
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setInt(1,this.subjectid);     	
      	 rs = stmt.executeQuery();    	 
      	     	  
      	  while (rs.next()){
      		  Work aa=new Work();
      		  aa.id=rs.getInt("id");
      		  aa.workname=rs.getString("workname").trim();

      		  result.add(aa);
      		  
      	  }
      	
      	}
        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 Edit() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="update t_work set workname=? where id=?";
        boolean result=false;
        
        try{
		   
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setString(1,this.workname);
      	 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 Del() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="delete from t_work where id=?";
        boolean result=false;
        
        try{
      	 
        //删除作业信息	
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setInt(1,id);
         stmt.executeUpdate(); 
      	 
     		 
      	 //删除学生作业信息
      	 sql="delete from s_work where workid=?";
         stmt= conn.prepareStatement(sql); 
         stmt.setInt(1,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 isWorkExist() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="select * from s_work where workid=? and student=?";
        boolean result=false;
        
        try{
		   
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setInt(1,this.id);
      	 stmt.setString(2,this.student);
      	 
      	 rs=stmt.executeQuery(); 
      	  
      	  if(rs.next()){	
      		id=rs.getInt("id"); 
      		filename=rs.getString("filename");
      		score=rs.getInt("score");
      		opinion=rs.getString("opinion");
      		status=rs.getInt("status");
      	    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 View() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="select * from t_work where id=?";
        boolean result=false;
        
        try{
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setInt(1,this.id);     	
      	 rs = stmt.executeQuery();    	 
      	     	  
      	  if (rs.next()){
      		  
      		  id=rs.getInt("id");
      		  workname=rs.getString("workname").trim();

      		  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 uploadWork() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="insert into s_work (student,workid,filename) values (?,?,?)";
        boolean result=false;
        
        try{
		   
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setString(1,this.student);
      	 stmt.setInt(2,this.id);
      	 stmt.setString(3,this.filename);
      	 
      	 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 upWork() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="update s_work set filename=? where id=?";
        boolean result=false;
        
        try{
		   
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setString(1,this.filename);
      	 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 delWork() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="delete from s_work where id=?";
        boolean result=false;
        
        try{
      	 
         conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setInt(1,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 ViewWork() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="select * from s_work where id=?";
        boolean result=false;
        
        try{
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setInt(1,this.id);     	
      	 rs = stmt.executeQuery();    	 
      	     	  
      	  if (rs.next()){
      		  
      		  id=rs.getInt("id");
      		  workid=rs.getInt("workid");
      		  student=rs.getString("student").trim();
      		  filename=rs.getString("filename").trim();
      		  score=rs.getInt("score");
      		  opinion=rs.getString("opinion");
      		 
      		  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 pgWork() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="update s_work set score=?,opinion=?,status=1 where id=?";
        boolean result=false;
        
        try{
		   
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql);
         stmt.setInt(1,this.score);
      	 stmt.setString(2,this.opinion);
      	 stmt.setInt(3,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;    	 
    }    
}