package?dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?entity.File;
import?util.JDBCUtil;

public?class?FileDao?{
	public?List?getAllFile（）?{
		List?files?=?new?ArrayList（）;
		Connection?con?=?JDBCUtil.getConnection（）;
		try?{
			Statement?st?=?con.createStatement（）;
			ResultSet?rs?=?st.executeQuery（“select?*?from?file_info?“）;
			while?（rs.next（））?{
				files.add（new?File（rs.getInt（“file_id“）?rs.getString（“file_name“）?rs.getString（“file_path“）?rs.getString（“file_day“）
						rs.getString（“file_dis“）rs.getString（“file_author“）rs.getString（“file_size“）））;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?files;
	}

	public?boolean?addFile（File?file）?{
		boolean?success?=?false;
		Connection?con?=?JDBCUtil.getConnection（）;
		PreparedStatement?ps?=?null;
		try?{
			ps?=?con.prepareStatement（
					“insert?into?file_info（file_namefile_sizefile_pathfile_dayfile_disfile_author）?values（??????）“）;
			ps.setString（1?file.getFileName（））;
			ps.setString（2?file.getFileSize（））;
			ps.setString（3?file.getFilePath（））;
			ps.setString（4?file.getFileDay（））;
			ps.setString（5?file.getFileDis（））;
			ps.setString（6?file.getFileAuthor（））;
			System.out.println（file.getFileAuthor（））;
			ps.executeUpdate（）;
			success?=?true;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
		return?success;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-30?20:06??CloudProject\
?????文件????????1186??2017-12-12?15:49??CloudProject\.classpath
?????文件??????????66??2018-06-02?21:25??CloudProject\.myumldata
?????文件????????1062??2017-12-12?14:54??CloudProject\.project
?????目錄???????????0??2018-11-30?20:06??CloudProject\.settings\
?????文件?????????564??2017-12-12?14:54??CloudProject\.settings\.jsdtscope
?????文件??????????76??2018-11-28?00:16??CloudProject\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-12-12?14:54??CloudProject\.settings\org.eclipse.jdt.core.prefs
?????文件?????????495??2017-12-12?14:54??CloudProject\.settings\org.eclipse.wst.common.component
?????文件?????????412??2017-12-12?14:54??CloudProject\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-12-12?14:54??CloudProject\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-12-12?14:54??CloudProject\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件????????2642??2018-11-27?14:50??CloudProject\clouddate.sql
?????目錄???????????0??2018-11-30?20:06??CloudProject\src\
?????目錄???????????0??2018-11-30?20:06??CloudProject\src\dao\
?????文件????????1581??2018-11-29?16:08??CloudProject\src\dao\FileDao.java
?????文件?????????743??2018-11-26?21:54??CloudProject\src\dao\UserDao.java
?????目錄???????????0??2018-11-30?20:06??CloudProject\src\entity\
?????文件????????1787??2018-11-29?16:14??CloudProject\src\entity\File.java
?????文件?????????592??2018-11-26?20:47??CloudProject\src\entity\UserInformation.java
?????目錄???????????0??2018-11-30?20:06??CloudProject\src\filter\
?????文件????????1291??2018-11-28?21:35??CloudProject\src\filter\AuthFilter.java
?????目錄???????????0??2018-11-30?20:06??CloudProject\src\manger\
?????文件????????2959??2018-11-29?16:06??CloudProject\src\manger\Manger.java
?????目錄???????????0??2018-11-30?20:06??CloudProject\src\servlet\
?????文件????????2709??2018-11-25?21:38??CloudProject\src\servlet\DownLoadServlet.java
?????文件?????????980??2018-11-28?17:54??CloudProject\src\servlet\GetFileInfoServlet.java
?????文件????????1231??2018-11-30?01:34??CloudProject\src\servlet\GetMyFileInfoServlet.java
?????文件?????????805??2017-12-12?18:58??CloudProject\src\servlet\InfoServlet.java
?????文件?????????495??2017-12-20?18:19??CloudProject\src\servlet\InitFileInfoSerlvetListener.java
?????文件????????1257??2018-11-29?19:04??CloudProject\src\servlet\ShowDetail.java
............此處省略129個文件信息