web--4.网盘

web--4.网盘

package cn.itcast.dao;

import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import cn.itcast.domain.Resource;
import cn.itcast.utils.DataSourceUtils;

public class ResourceDao {

	public void save（Resource r） throws SQLException {

		String sql = “INSERT INTO resources VALUES（NULL???NULL?）“;
		QueryRunner runner = new QueryRunner（DataSourceUtils.getDataSource（））;

		runner.update（sql r.getUuidname（） r.getRealname（） r.getSavepath（）
				r.getDescription（））;
	}

	public List findAll（） throws SQLException {
		QueryRunner runner = new QueryRunner（DataSourceUtils.getDataSource（））;

		retu

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2017-05-21 16:41  skydrive\
     文件         882  2017-05-21 08:22  skydrive\.classpath
     文件         908  2017-05-21 08:19  skydrive\.project
     目录           0  2017-05-21 16:41  skydrive\.settings\
     文件         567  2017-05-21 08:19  skydrive\.settings\.jsdtscope
     文件         364  2017-05-21 08:19  skydrive\.settings\org.eclipse.jdt.core.prefs
     文件         553  2017-05-21 08:22  skydrive\.settings\org.eclipse.wst.common.component
     文件         345  2017-05-21 08:19  skydrive\.settings\org.eclipse.wst.common.project.facet.core.xml
     文件          49  2017-05-21 08:19  skydrive\.settings\org.eclipse.wst.jsdt.ui.superType.container
     文件           6  2017-05-21 08:19  skydrive\.settings\org.eclipse.wst.jsdt.ui.superType.name
     文件         162  2017-05-21 08:24  skydrive\.tern-project
     目录           0  2017-05-21 16:41  skydrive\build\
     目录           0  2017-05-21 16:41  skydrive\build\classes\
     文件         323  2017-05-21 08:22  skydrive\build\classes\c3p0-config.xml
     目录           0  2017-05-21 16:41  skydrive\build\classes\cn\
     目录           0  2017-05-21 16:41  skydrive\build\classes\cn\itcast\
     目录           0  2017-05-21 16:41  skydrive\build\classes\cn\itcast\dao\
     文件        1965  2017-05-21 09:38  skydrive\build\classes\cn\itcast\dao\ResourceDao.class
     目录           0  2017-05-21 16:41  skydrive\build\classes\cn\itcast\domain\
     文件        1603  2017-05-21 09:27  skydrive\build\classes\cn\itcast\domain\Resource.class
     目录           0  2017-05-21 16:41  skydrive\build\classes\cn\itcast\service\
     文件         931  2017-05-21 09:27  skydrive\build\classes\cn\itcast\service\ResourceService.class
     目录           0  2017-05-21 16:41  skydrive\build\classes\cn\itcast\utils\
     文件         741  2017-05-21 09:27  skydrive\build\classes\cn\itcast\utils\DataSourceUtils.class
     文件        2646  2017-05-21 10:16  skydrive\build\classes\cn\itcast\utils\FileDownUtils.class
     文件        1641  2017-05-21 10:07  skydrive\build\classes\cn\itcast\utils\FileUploadUtils.class
     目录           0  2017-05-21 16:41  skydrive\build\classes\cn\itcast\web\
     目录           0  2017-05-21 16:41  skydrive\build\classes\cn\itcast\web\servlet\
     文件        2447  2017-05-21 15:45  skydrive\build\classes\cn\itcast\web\servlet\DownloadServlet.class
     文件        1709  2017-05-21 09:47  skydrive\build\classes\cn\itcast\web\servlet\ShowDownloadServlet.class
     文件        4712  2017-05-21 16:32  skydrive\build\classes\cn\itcast\web\servlet\UploadServlet.class
............此处省略40个文件信息