sql.txt

OA自动化办公系统,Eclipse+Oracle开发。

String query = "select user_name from users  where user_name like '%"
					+ creatorName + "%'";
			UserVO uvo = new UserVO();
			UserImpl uimpl = new UserImpl();
			List lst = uimpl.search(query, uvo.getClass().getName());
			// Integer userId = (Integer) request.getSession().getAttribute(
			// Constant.USERINFO_LIST);
			String inSet = "(";
			if (lst.size() != 0)
				for (int i = 0; i < lst.size(); i++) {
					inSet += ((UserVO) lst.get(i)).getUserId() + ",";
				}
			String mysql = inSet.substring(0, inSet.length() - 1) + ")";

select  file_id,file_name,file_path,file_type,icon_path,user_name,delete_date "
				+ "from files left join (users,file_type)"
				+ " on (files.userid=users.id and files.file_type_di=file_type.file_type_id)"
				+ "where file_state=1";


public class FileAttributeVO extends BaseVO {
	String fileName, fileTypeName;
	Long fileLength;
	Integer fileId;
	Date createDate;

	public String getFileName() {
		return fileName;
	}

	public void setFileName(String fileName) {
		this.fileName = fileName;
	}

	public String getFileTypeName() {
		return fileTypeName;
	}

	public void setFileTypeName(String fileTypeName) {
		this.fileTypeName = fileTypeName;
	}

	public Long getFileLength() {
		return fileLength;
	}

	public void setFileLength(Long fileLength) {
		this.fileLength = fileLength;
	}

	public Integer getFileId() {
		return fileId;
	}

	public void setFileId(Integer fileId) {
		this.fileId = fileId;
	}

	public Date getCreateDate() {
		return createDate;
	}

	public void setCreateDate(Date createDate) {
		this.createDate = createDate;
	}

}