fileentity.java

JSP常用模块源代码之用户管理模块的全部源代码

package entity;

import java.util.ArrayList;
import java.util.List;

import service.DBManager;

/**
 * @author myte
 * 
 * 实体类：文件
 */
public class FileEntity {
	private Integer intFID;//文件编号
	private Integer intTID;//类型编号
	private String strTitle="";//上传标题
	private String strFileName="";//文件名
	private String strPreview="";//预览文件名
	private String strFileMemo="";//上传备注
	private String strAuthor="";//上传作者
	private Integer intSize;//文件大小
	/**
	 * @return 返回变量 intFID.
	 */
	public Integer getIntFID() {
		return intFID;
	}
	/**
	 * @param 设置变量 intFID.
	 */
	public void setIntFID(Integer intFID) {
		this.intFID = intFID;
	}
	public Integer getIntSize() {
		return intSize;
	}
	public void setIntSize(Integer intSize) {
		this.intSize = intSize;
	}
	public Integer getIntTID() {
		return intTID;
	}
	public void setIntTID(Integer intTID) {
		this.intTID = intTID;
	}
	public String getStrAuthor() {
		return strAuthor;
	}
	public void setStrAuthor(String strAuthor) {
		this.strAuthor = strAuthor;
	}
	public String getStrFileMemo() {
		return strFileMemo;
	}
	public void setStrFileMemo(String strFileMemo) {
		this.strFileMemo = strFileMemo;
	}
	public String getStrFileName() {
		return strFileName;
	}
	public void setStrFileName(String strFileName) {
		this.strFileName = strFileName;
	}
	public String getStrPreview() {
		return strPreview;
	}
	public void setStrPreview(String strPreview) {
		this.strPreview = strPreview;
	}
	public String getStrTitle() {
		return strTitle;
	}
	public void setStrTitle(String strTitle) {
		this.strTitle = strTitle;
	}
	private static class FilesDB extends DBManager {

		private String tableName="Files";
		private FilesDB() {
		}

		protected String getTableName() {
			return tableName;
		}

		protected String[] getFields() {
			return new String[] { "FID","TID","strTitle","strFileName","strPreview",
					"strFileMemo","strAuthor","intSize"};
		}

		protected Object[] getFieldValues(Object o) {
			FileEntity u = (FileEntity) o;
			return new Object[] {u.getIntFID(),u.getIntTID(),u.getStrTitle(),
					u.getStrFileName(),u.getStrPreview(),u.getStrFileMemo(),
					u.getStrAuthor(),u.getIntSize()};
		}

		protected String getKeyFields() {
			return KEY_FIELD_NAME;
		}

		protected Object[] getKeyValues(Object o) {
			return new Object[] { ((FileEntity) o).getIntFID() };
		}
	}
	private static final String KEY_FIELD_NAME = "FID";
	private static FilesDB entityDB = new FilesDB();
	public void addDownTimes(String intID) throws Exception{
		String sql="update Files set intDownTimes=intDownTimes+1 where FID=?";
		Object[] params=new Object[]{intID};
		entityDB.executeUpdate(sql,params);
	}
	public void insert(){
		try {
			entityDB.insert(this);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public void update(){
		try {
			entityDB.update(this);			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public void delete(){
		try {
			entityDB.delete(this);			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public List select(String sql){
		try {
			return entityDB.executeSelect(sql);			
		} catch (Exception e) {
			e.printStackTrace();
		}
		return new ArrayList();
	}
}