文件上传下载PDF预览

1. 创建数据库

--创建文件对象表
CREATE TABLE sys_file (
  id bigint NOT NULL identity(1,1),
  name nvarchar(100)，--文件名称
  size nvarchar(100)，--文件大小
  type int DEFAULT NULL ,-- '文件类型',
  url varchar(200) DEFAULT NULL ,-- 'URL地址',
  create_date datetime DEFAULT NULL--'创建时间',
  PRIMARY KEY (id)
)

2. 创建文件对象

package com.lifp.common.domain;

import java.io.Serializable;
import java.util.Date;


public class FileDO implements Serializable {
    private static final long serialVersionUID = 1L;

    //
    private Long id;
    // 文件类型
    private Integer type;
    // URL地址
    private String url;
    // 创建时间
    private Date createDate;
    //文件名称
    private String name;
    //文件大小
    private String size;


    public FileDO() {
        super();
    }


    public FileDO(String name,String size, Integer type, String url, Date createDate) {
        super();
        this.name=name;
        this.size=size;
        this.type = type;
        this.url = url;
        this.createDate = createDate;
    }


    /**
     * 设置：
     */
    public void setId(Long id) {
        this.id = id;
    }

    /**
     * 获取：
     */
    public Long getId() {
        return id;
    }

    /**
     * 设置：文件类型
     */
    public void setType(Integer type) {
        this.type = type;
    }

    /**
     * 获取：文件类型
     */
    public Integer getType() {
        return type;
    }

    /**
     * 设置：URL地址
     */
    public void setUrl(String url) {
        this.url = url;
    }

    /**
     * 获取：URL地址
     */
    public String getUrl() {
        return url;
    }

    /**
     * 设置：创建时间
     */
    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }

    /**
     * 获取：创建时间
     */
    public Date getCreateDate() {
        return createDate;
    }

    public String getName() {
		return name;
	}


	public void setName(String name) {
		this.name = name;
	}


	public String getSize() {
		return size;
	}


	public void setSize(String size) {
		this.size = size;
	}


	@Override
    public String toString() {
        return "FileDO{" +
                "id=" + id +
                ", name=" + name +
                ", size=" + size +
                ", type=" + type +
                ", url='" + url + '\'' +
                ", createDate=" + createDate +
                '}';
    }
}

3. Dao

package com.lifp.common.dao;


import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;

import com.lifp.common.domain.FileDO;

@Mapper
public interface FileDao {

	FileDO get(Long id);
	
	List<FileDO> list(Map<String,Object> map);
	
	int count(Map<String,Object> map);
	
	int save(FileDO file);
	
	int update(FileDO file);
	
	int remove(Long id);
	
	int batchRemove(Long[] ids);
}

4. Mapper

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.lifp.common.dao.FileDao">

	<select id="get" resultType="com.lifp.common.domain.FileDO">
		select id,name,size,type,url,create_date from sys_file where name LIKE '%'+#{name}+'%'
	</select>

	<select id="list" resultType="com.lifp.common.domain.FileDO">
		select id,name,size,type,url,create_date from sys_file
        <where>  
		  		  <if test="id != null and id != ''"> and id = #{id} </if>
		  		  <if test="name != null and name != ''"> and name LIKE '%&