javaWeb向数据库写入时出现乱码以及问号问题

乱码问题

编写过滤器文件并将编码应用于全局
1.EncodingFilter.java文件

package com.book.filter;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;

public class EncodingFilter implements Filter{

	@Override
	public void destroy() {
		// TODO Auto-generated method stub
		
	}
//重新编码
	@Override
	public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain)
			throws IOException, ServletException {
		// TODO Auto-generated method stub
		HttpServletRequest req=(HttpServletRequest) request;
		req.setCharacterEncoding("utf-8");
		chain.doFilter(req, response);
	}

	@Override
	public void init(FilterConfig arg0) throws ServletException {
		// TODO Auto-generated method stub
		
	}

}

2.web.xml文件

 <filter>
  <display-name>EncodingFilter</display-name>
  <filter-name>EncodingFilter</filter-name>
  <filter-class>com.book.filter.EncodingFilter</filter-class>
  </filter>
  <filter-mapping>
  <filter-name>EncodingFilter</filter-name>
  <url-pattern>/*</url-pattern>
  </filter-mapping>

问号问题

由于数据库编码不是UTF-8所以导致设置了过滤器后仍出现？？？的乱码
在你的连接数据库语句处加入

?useUnicode=true&characterEncoding=UTF-8

如图