filemanager.java

来自「自己编写的一个spring框架下实现文件上传的例子」· Java 代码 · 共 56 行

package com.mr.UpLoad;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;





/**
 * 处理数据字典信息的类
 * 
 * @author Yaoqiang
 * @version 2008-7-9 1.0
 * 
 */
public class FileManager{
	
	
	/**
	 * 获取用户对象
	 * 
	 * @param roleId角色ID
	 * @return
	 */
	public UploadFile getById(Integer id) {

		UploadFile file = new UploadFile();
		ResultSet rs = null;
		//
		String sql = "SElECT * FROM tab_image WHERE id=?"; // #1
		//WHERE category + code=?
		Object[] params = { id };

		try {

			rs = DB.executeQuery(sql, params);
			if (rs != null && rs.next()) {
				
				file.setId(rs.getInt("id"));
				file.setTpname(rs.getString("tpname"));
				file.setPath(rs.getString("path"));
				file.setTpsize(rs.getString("tpsize"));
				file.setContents(rs.getBytes("contents"));
			}

		} catch (Exception e) {
			System.out.println(e);
		}

		return file;
	}// getById
	
}