log.java

挺好的东东

package com.room;

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

import com.util.DBConn;

public class Log {
	
	public int id;
	
	public String userid;
	
	public String content;
	
	public String createtime;
	
    public Log() {
   	 
	 }
    
//查看备忘
    public Boolean View() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="select * from ts_log where userid=? and createtime=?";
        boolean result=false;
        
        try{
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setString(1,this.userid);
      	 stmt.setString(2,this.createtime);
      	 rs = stmt.executeQuery();    	 
      	     	  
      	  if (rs.next()){
  			  id=rs.getInt("id");
      		  content=rs.getString("content").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 Add() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="insert into ts_log (content,createtime,userid) values (?,?,?)";
        boolean result=false;
        
        try{

  		   
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setString(1,this.content);
      	 stmt.setString(2,this.createtime);
      	 stmt.setString(3,this.userid);
      	 
      	 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 Edit() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="update ts_log set content=? where id=?";
        boolean result=false;
        
        try{

  		   
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setString(1,this.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 Del() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="delete from ts_log where id=?";
        boolean result=false;
        
        try{
      	  
      	 conn=DBConn.getConn();
      	 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;    	 
    }   
    
    
//  按id查看备忘
    public Boolean ViewById() throws Exception{
  	  Connection conn=null;
  	  PreparedStatement stmt =null;
  	  ResultSet rs =null;
  	  String sql ="select * from ts_log where id=?";
        boolean result=false;
        
        try{
      	 conn=DBConn.getConn();
      	 stmt= conn.prepareStatement(sql); 
      	 stmt.setInt(1,this.id);
       	 rs = stmt.executeQuery();    	 
      	     	  
      	  if (rs.next()){
  			  content=rs.getString("content").trim();
      		  createtime=rs.getString("createtime").substring(0,10);
      		 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;    	 
    }

 	    
}