package?com.dao;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?com.toolsbean.DB;
import?com.valuebean.FileBean;

public?class?FileDao?{
	
	private?DB?mydb=null;
	
	public?FileDao（）{
		mydb=new?DB（）;
	}
	
	public?int?addFileInfo（FileBean?file）{
		int?i=-1;		
		String?sql?=?“insert?into?tfile（tsavenametfilenametfiletypetfilesizetfileinfotuptime）?values（??????）“;
		object[]?params={file.getSaveName（）file.getFileName（）file.getFileType（）file.getFileSize（）file.getFileInfo（）file.getUptime（）};
		mydb.doPstm（sql?params）;
		try?{
			i=mydb.getCount（）;
		}?catch?（SQLException?e）?{
			i=-1;
			e.printStackTrace（）;
		}
		return?i;		
	}
	
	public?int?deleteFileInfo（String?savename）{
		int?i=-1;		
		String?sql?=?“delete?from?tfile?where?tsavename=‘“+savename+“‘“;
		mydb.doPstm（sql?null）;
		try?{
			i=mydb.getCount（）;
		}?catch?（SQLException?e）?{
			i=-1;
			e.printStackTrace（）;
		}
		return?i;		
	}
	
	public?FileBean?getFileSingle（String?savename）?throws?SQLException{
		FileBean?single=null;
		String?sql=“select?*?from?tfile?where?tsavename=?“;
		object[]?params={savename};
		List?list=getList（sqlparams）;
		if（list!=null&&list.size（）!=0）
			single=（FileBean）list.get（0）;
		return?single;
	}
	
	public?List?getFileList（String?strSQLint?iPageint?iPageSize）?throws?SQLException{
		String?sql?=?“select?*?from（select?t.*rownum?as?rown?from（“+strSQL+“）t?where?rownum<“+（iPageSize*iPage+1）+“）where?rown>“+iPageSize*（iPage-1）;
		List?list=getList（sqlnull）;
		return?list;
	}
	
	public?int?getFileCount（String?strSQL）?throws?SQLException{
		int?count?=?0;
		mydb.doPstm（strSQL?null）;
		ResultSet?rs=mydb.getRs（）;
		if（rs.next（））{
			count?=?rs.getInt（1）;
		}
		if（rs!=null）{			
			rs.close（）;
		}
		return?count;
	}
	
	public?int?getPageCount（int?RowCount?int?iPageSize）?{
		??return?（?（RowCount?+?iPageSize）?-?1）?/?iPageSize;
	}
	
	private?List?getList（String?sqlobject[]?params）?throws?SQLException{
		List?list=null;
		mydb.doPstm（sql?params）;
		ResultSet?rs=mydb.getRs（）;
		if（rs!=null）{
			list=new?ArrayList（）;
			while（rs.next（））{
				FileBean?single=new?FileBean（）;
				single.setId（rs.getInt（1））;
				single.setSaveName（rs.getString（2））;
				single.setFileName（rs.getString（3））;
				single.setFileType（rs.getString（4））;
				single.setFileSize（rs.getInt（5））;
				single.setFileInfo（rs.getString（6））;
				single.setUptime（rs.getString（7））;
				list.add（single）;
			}
			rs.close（）;
		}
		return?list;
	}
	
	public?void?closed（）{
		mydb.closed（）;
	}
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1008??2012-03-23?13:56??file\.classpath

?????文件????????282??2012-04-20?13:57??file\.mymetadata

?????文件?????????66??2012-03-26?14:45??file\.myumldata

?????文件???????1222??2012-03-23?13:20??file\.project

?????文件???????1040??2012-03-26?15:15??file\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件???????2660??2012-03-25?21:41??file\src\com\dao\FileDao.java

?????文件????????817??2012-03-23?16:47??file\src\com\filter\CharacterEncodingFilter.java

?????文件???????9499??2012-03-26?23:31??file\src\com\servlet\MyFileServlet.java

?????文件???????2645??2012-03-27?11:13??file\src\com\toolsbean\DB.java

?????文件???????2208??2012-03-24?22:14??file\src\com\toolsbean\StringHandler.java

?????文件???????1868??2012-03-25?03:04??file\src\com\valuebean\FileBean.java

?????文件???????2988??2012-03-25?22:25??file\src\com\yxq\filexload\File.java

?????文件???????7934??2012-03-26?21:22??file\src\com\yxq\filexload\FileXLoad.java

?????文件???????1022??2009-07-31?10:23??file\src\com\yxq\filexload\Parameters.java

?????文件???????2125??2012-03-26?13:34??file\WebRoot\css\style.css

?????文件???????6097??2012-03-26?21:10??file\WebRoot\downloadfile.jsp

?????文件????????879??2012-03-26?22:42??file\WebRoot\Error500.jsp

?????文件?????159821??2009-07-31?10:23??file\WebRoot\images\bk.jpg

?????文件????????146??2008-04-16?14:49??file\WebRoot\images\button_bg.gif

?????文件???????4171??2009-07-31?10:23??file\WebRoot\images\down.jpg

?????文件??????32425??2009-07-31?10:23??file\WebRoot\images\end.jpg

?????文件???????9070??2012-03-23?23:41??file\WebRoot\images\filename.bmp

?????文件???????2373??2009-07-31?10:23??file\WebRoot\images\reset.jpg

?????文件???????2267??2009-07-31?10:23??file\WebRoot\images\submit.jpg

?????文件???????6144??2009-07-31?10:23??file\WebRoot\images\Thumbs.db

?????文件???????7082??2009-07-31?10:23??file\WebRoot\images\title.jpg

?????文件??????69204??2009-07-31?10:23??file\WebRoot\images\top.jpg

?????文件???????4422??2009-07-31?10:23??file\WebRoot\images\up.jpg

?????文件????????713??2012-03-26?22:25??file\WebRoot\index.jsp

?????文件??????15080??2010-07-16?10:42??file\WebRoot\js\calendar.js

............此處省略103個文件信息