docshowdao.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.bean;
import com.db.*;
import com.comingnet.bean.*;
import java.sql.*;

public class docShowDAO {
  docShowInfor docinfor=new docShowInfor();	
  Connection conn=null;
  PreparedStatement stmt=null;
  ResultSet rs=null;
  
  public docShowDAO()
  {
	  
  }
  
  public docShowInfor getDocInfor(int ssid,String filetype)
  {
	  try
	  {
	     conn=DBUtils.getConnection();
	     if(filetype.equals("db"))
	     {
	        stmt=conn.prepareStatement("select fwbt,fwnr,fwsjxm_js,fwfjrxm,CONVERT(varchar(20),fwfjsj,120) as fwfjsj from m_fwwz where fwid=?");
	        stmt.setInt(1,ssid);
	        rs=stmt.executeQuery();
	        if(rs.next())
	        {
	    	   docinfor.setDoctitle(rs.getString("fwbt"));
	    	   docinfor.setDocnr(rs.getString("fwnr"));
	    	   docinfor.setDocrevxm(rs.getString("fwsjxm_js"));
	    	   docinfor.setDocsendxm(rs.getString("fwfjrxm"));
	    	   docinfor.setDocsendtime(rs.getString("fwfjsj"));
            }
	      }else if(filetype.equals("zb"))
	      {
	    	stmt=conn.prepareStatement("select fwbt,fwnr,fwsjxm_js,fwfjrxm,CONVERT(varchar(20),fwfjsj,120) as fwfjsj,CONVERT(varchar(20),sjqssj,120) as sjqssj from m_fwwz a,m_fwsj b where a.fwid=b.fwid and b.sjid=?");
		    stmt.setInt(1,ssid);
		    rs=stmt.executeQuery();
		    if(rs.next())
		      {
		    	docinfor.setDoctitle(rs.getString("fwbt"));
		    	docinfor.setDocnr(rs.getString("fwnr"));
		    	docinfor.setDocrevxm(rs.getString("fwsjxm_js"));
		    	docinfor.setDocsendxm(rs.getString("fwfjrxm"));
 	    	    docinfor.setDocsendtime(rs.getString("fwfjsj"));
 	    	    docinfor.setQstime(rs.getString("sjqssj")); 
	          }
	      }else if(filetype.equals("yb"))
	      {
	    	  stmt=conn.prepareStatement("select fwbt,fwnr,fwsjxm_js,fwfjrxm,CONVERT(varchar(20),fwfjsj,120) as fwfjsj,CONVERT(varchar(20),sjqssj,120) as sjqssj,CONVERT(varchar(20),sjblsj,120) as sjblsj from m_fwwz a,m_fwsj b where a.fwid=b.fwid and b.sjid=?");
			    stmt.setInt(1,ssid);
			    rs=stmt.executeQuery();
			    if(rs.next())
			      {
			    	docinfor.setDoctitle(rs.getString("fwbt"));
			    	docinfor.setDocnr(rs.getString("fwnr"));
			    	docinfor.setDocrevxm(rs.getString("fwsjxm_js"));
			    	docinfor.setDocsendxm(rs.getString("fwfjrxm"));
	 	    	    docinfor.setDocsendtime(rs.getString("fwfjsj"));
	 	    	    docinfor.setQstime(rs.getString("sjqssj"));
	 	    	    docinfor.setBltime(rs.getString("sjblsj"));
		          }  
	      }
	  }catch(Exception e)
	  {
		 System.out.println("docShowDAO.java:"+e); 
	  }finally
	  {
		DBUtils.closeResultSet(rs);
		DBUtils.closeStatement(stmt);
		DBUtils.closeConnection(conn);
	  }
     return docinfor;	  
  }

}