Nothing is true everything is permitted

@NoRepositoryBean
public interface QueryDao extends JpaRepository<UserBean, Integer> {
    public List<UserBean> getUsersByCondition(UserBean bean,String orderBy, String sc, int page, int size);
    public int countUsersByCondition(UserBean bean);
}

@NoRepositoryBean
public class QueryDaoImpl implements QueryDao {
    @Autowired
	private EntityManager em;
	
	public List<UserBean> getUsersByCondition(UserBean bean,String orderBy, String sc, int page, int size) {
	String hql = "from UserBean";
		hql += getUserCriteria(bean, orderBy, sc);
		Query q = em.createQuery(hql, UserBean.class);
		setUserPara(q, bean);
		q.setFirstResult(page);
		q.setMaxResults(size);
		return q.getResultList();
	}
	
	public int countUsersByCondition(UserBean bean) {
		String hql = "select count(1) from UserBean";
		hql += getUserCriteria(bean, "", "");
		Query q = em.createQuery(hql);
		setUserPara(q, bean);
		return new Long(q.getSingleResult().toString()).intValue();
	}
	
	private String getUserCriteria(UserBean ub,String orderBy,String sc){
		String criteria = " where 1=1";
		if(!CommonUtil.nullToEmpty(ub.getUsername()).equals("")){
			criteria += " and username like :username";
		}
		if(!CommonUtil.nullToEmpty(orderBy).equals("") && !CommonUtil.nullToEmpty(sc).equals("")){
			criteria += " order by "+orderBy+" "+sc;
		}
		return criteria;
	}
	
	private void setUserPara(Query q,UserBean ub){
		if(!CommonUtil.nullToEmpty(ub.getUsername()).equals("")){
			q.setParameter("username", "%"+ub.getUsername()+"%");
		}
	}
	
	//接口自带的方法，无需全部实现，直接返回null即可
	public List<UserBean> findAll() {return null;}
	public List<UserBean> findAll(Sort sort) {return null;}
	public List<UserBean> findAll(Iterable<Integer> ids) {return null;}
}

@Entity
@Table(name="user")
@SqlResultSetMappings(value={
  @SqlResultSetMapping(name="show_users",classes={
    @ConstructorResult(
	  targetClass=com.framework.bean.UserBean.class,
	  columns={
		@ColumnResult(name="id"),
		@ColumnResult(name="username"),
		@ColumnResult(name="createDate")
	})
  })
  //设置其他的映射
})
public class UserBean {
    private int id;
	private String username;
	private String password;
	private String createDate;
	private String timestamp;
	
	//必须提供对应的含有相同参数的构造函数
	public UserBean(int id, String username, String createDate) { 
	}
}

public long count() {
	String sql = "select count(1) from users";
	//使用原生sql查询
	Query q = em.createNativeQuery(sql);
	return new Long(q.getSingleResult().toString()).intValue();
}
public List<UserBean> getByCondition(UserBean bean,String orderBy,String sc, int start, int size){
	String sql = "select * from users";
	sql += getCriteria(bean);
	//使用原生sql查询
	Query q = em.createNativeQuery(sql,"show_users");
	setParameter(q, bean);
	//分页
	q.setFirstResult(start);
	q.setMaxResults(size);
	Pageable pageable = new PageRequest(start,size,sc.equals("asc")?Direction.ASC:Direction.DESC,orderBy);
	Page<UserBean> page = new PageImpl<UserBean>(q.getResultList(), pageable, count());
	return page.getContent();
}

public class WebInitializer implements WebApplicationInitializer {

	private static final String DISPATCHER_SERVLET_NAME = "dispatcher";
	
	public void onStartup(ServletContext servletContext) throws ServletException {
		AnnotationConfigWebApplicationContext ctx = new AnnotationConfigWebApplicationContext();
		//配置类，装载了SpringMVC的配置
		ctx.register(WebMvcConfig.class);
		ctx.setServletContext(servletContext);
		
		registerHiddenHttpMethodFilter(servletContext);
		
		Dynamic servlet = servletContext.addServlet(DISPATCHER_SERVLET_NAME, new DispatcherServlet(ctx));
        servlet.addMapping("/");
        servlet.setLoadOnStartup(1);
	}
	
	private void registerHiddenHttpMethodFilter(ServletContext servletContext) {
        FilterRegistration.Dynamic fr = servletContext
                .addFilter("hiddenHttpMethodFilter", HiddenHttpMethodFilter.class);
        fr.addMappingForServletNames(
                EnumSet.of(DispatcherType.REQUEST, DispatcherType.FORWARD),
                false,
                DISPATCHER_SERVLET_NAME);
    }

}

@Configuration
@EnableWebMvc
@ComponentScan
public class WebMvcConfig extends WebMvcConfigurerAdapter{
	@Bean 
	public ViewResolver viewResolver(){
		InternalResourceViewResolver resolver = new InternalResourceViewResolver();
		resolver.setPrefix("/WEB-INF/page/");
		resolver.setSuffix(".jsp");
		return resolver;
	}
	
	public void addResourceHandlers(ResourceHandlerRegistry registry) {
        //指定resources文件夹下任意目录,子目录的资源文件配置访问路径到resources
		registry.addResourceHandler("/resources/**").addResourceLocations("/resources/");
	}
}

//获取到resources下的config.properties文件
Resource resource = new ClassPathResource("config.properties");
File file = resource.getFile();

@RequestMapping(value="/files/{filename:.+}", produces="application/json; charset=UTF-8")
public void checkFileInfo(@PathVariable String filename) {
    //例如filename = test1.xls
}

@Configuration
@EnableWebMvc
@ComponentScan
public class WebMvcConfig extends WebMvcConfigurerAdapter{
	@Override
	public void configureMessageConverters(
			List<HttpMessageConverter<?>> converters) {
		super.configureMessageConverters(converters);
		GsonHttpMessageConverter converter = new GsonHttpMessageConverter();
		Gson gson = new GsonBuilder().setFieldNamingPolicy(FieldNamingPolicy.UPPER_CAMEL_CASE).create();
		converter.setGson(gson);
		converters.add(converter);
	}
}

public class ResourceNotFoundException extends Exception {
	public ResourceNotFoundException(String message) {
		super(message);
	}
}

@ControllerAdvice
public class WopiExceptionHandler {
	@ResponseStatus(HttpStatus.NOT_FOUND)
	@ExceptionHandler(ResourceNotFoundException.class)
	@ResponseBody
	public String handlerResourceNotFound(ResourceNotFoundException ex) {
		return ex.getMessage();
	}
}

@RequestMapping(value="/files/{fileId}", method=RequestMethod.GET, produces="application/json; charset=UTF-8")
@ResponseBody
public WopiFileInfo checkFileInfo(@PathVariable String fileId) throws Exception {
	String filePath = wopiService.getFilePath(fileId);
	if (CommonUtil.isEmptyString(filePath)) {
		throw new ResourceNotFoundException("Resource not found/user unauthorized");
	}
	...
}

@RunWith(SpringJUnit4ClassRunner.class)
@WebAppConfiguration
@ContextConfiguration(classes = { TestConfig.class })
public class TestController {
	
	@Test
	public void testCheckFileInfo() throws Exception {
		mockMvc.perform(get("/files/{fileId}", "2"))
			.andExpect(status().isNotFound())
			.andExpect(content().string("\"Resource not found/user unauthorized\""));
	}
}