userfile.java

文件的管理

package fm;

import java.io.File;
import java.sql.ResultSet;
import java.util.Vector;

public class UserFile {
	private int owner = 0;

	private String filename = null;

	private float filesize;

	private String uploadtime = null;

	private String location = null;

	public UserFile() {

	}

	public String getFilename() {
		return filename;
	}

	public void setFilename(String filename) {
		this.filename = filename;
	}

	public float getFilesize() {
		return filesize;
	}

	public void setFilesize(float filesize) {
		this.filesize = filesize;
	}

	public String getLocation() {
		return location;
	}

	public void setLocation(String location) {
		this.location = location;
	}

	public int getOwner() {
		return owner;
	}

	public void setOwner(int owner) {
		this.owner = owner;
	}

	public String getUploadtime() {
		return uploadtime;
	}

	public void setUploadtime(String uploadtime) {
		this.uploadtime = uploadtime;
	}

	public boolean insert(DB db) throws Exception {
		String strSql = null;
		strSql = "insert into file values(" + owner + ",'" + filename + "',"
				+ filesize + ",'" + uploadtime + "','" + location + "')";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}
	}
	
	public Vector searchUserFiles(DB db, String id) throws Exception {
		Vector fileVector = new Vector();
		ResultSet rs;
		String strSql = null;

		strSql = "select * from file where owner=" + id;
		rs = db.OpenSql(strSql);

		while (rs.next()) {

			UserFile userFile = new UserFile();
			userFile.setOwner(Integer.parseInt(id));
			userFile.setFilename(rs.getString("filename"));
			userFile.setFilesize(Float.parseFloat(rs.getString("filesize")));
			userFile.setUploadtime(rs.getString("uploadtime"));
			userFile.setLocation(rs.getString("location"));
			
			fileVector.add(userFile);
		}

		return fileVector;
	}
	
	public boolean delete(DB db, int owner, String filename) throws Exception {
		String strSql;
		strSql = "delete from file where owner=" + owner + " and filename='" + filename + "'";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}
	}
	
    public boolean deleteFile(File file) {
        if (file.isDirectory()) {
            String[] files = file.list();
            for (int i = 0; i < files.length; i++) {
                deleteFile(new File(file.getPath() + "\\" + files[i]));
            }
            file.delete();
        } else {
            try {
                file.delete();
            } catch (Exception ex) {
                System.out.println(ex.getMessage());
            }
        }

        return false;
    }
}