userfile.java

文件管理系统

package fm;

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

public class UserFile implements java.io.Serializable {
	private int fileId=0;
	private int owner = 0;

	private String filename = null;

	private float filesize;

	private String uploadtime = null;

	private String location = null;
	private String fileType ;

	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(owner,filename,filesize,uploadtime,location,fileType) values("+ owner + ",'" + filename + "',"+ filesize + ",'" + uploadtime + "','" + location+"/" +"','"+this.fileType+ "')";
		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.setFileId(Integer.parseInt(rs.getString("fileId")));
			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 UserFile searchUserFileByFileId(DB db, String fileId) throws Exception {
		UserFile userFile = null;
		ResultSet rs;
		String strSql = null;

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

		while (rs.next()) {

			userFile=	new UserFile();
		 	userFile.setFileId(Integer.parseInt(fileId));
		//	userFile.setOwner(Integer.parseInt(id));
			userFile.setFilename(rs.getString("filename"));
			userFile.setFileType(rs.getString("fileType"));
			//userFile.setFilesize(Float.parseFloat(rs.getString("filesize")));
		//	userFile.setUploadtime(rs.getString("uploadtime"));
			userFile.setLocation(rs.getString("location"));
			 
		}

		return userFile;
	}
	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;
    }

	public int getFileId() {
		return fileId;
	}

	public void setFileId(int fileId) {
		this.fileId = fileId;
	}
	
	private int getMaxFileId(DB db){
		
		int i=1;
		ResultSet rs;
		String strSql = null;

		strSql = "select max(fileId) as id from fileManager.file ";
		rs = db.OpenSql(strSql);
		if(rs!=null){
			try {
//				  r
			Object obj=	rs.getObject("id");
				if(obj!=null){
				i=Integer.parseInt(String.valueOf(obj))+1;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		System.out.println("iii=="+String.valueOf(i));
		return i;
		
	}

	public String getFileType() {
		return fileType;
	}

	public void setFileType(String fileType) {
		this.fileType = fileType;
	}
}